From 6b91eea8f3a54269a61d0626efb879cc7da5b4bf Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 25 四月 2023 09:39:57 +0800
Subject: [PATCH] 物流检验报表接口开发
---
VueWebApi/DLL/DAL/BaseDateDAL.cs | 50 +++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 49 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BaseDateDAL.cs b/VueWebApi/DLL/DAL/BaseDateDAL.cs
index 3ec5ccf..f49b050 100644
--- a/VueWebApi/DLL/DAL/BaseDateDAL.cs
+++ b/VueWebApi/DLL/DAL/BaseDateDAL.cs
@@ -26,7 +26,7 @@
try
{
sql = @"select code,name from TCustomer
- where type in('226','228') and is_delete='0'";
+ where type in('211','228') and is_delete='0'";
var data = DapperHelper.selecttable(sql);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
@@ -149,5 +149,53 @@
return mes;
}
#endregion
+
+ #region[鍗曚綅淇℃伅鏌ヨ]
+ public static ToMessage UnitSerch()
+ {
+ string sql = "";
+ try
+ {
+ sql = @"select code,name from TUom
+ where is_delete='0'";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[璐ㄦ鏂规淇℃伅]
+ public static ToMessage QualityScheme()
+ {
+ string sql = "";
+ try
+ {
+ sql = @"select code,name,sampmethod,sampscare from TStepCheckStandard
+ where status='Y' and checktype='InCheck'";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.3