From fd8ca33bacb87dbe74e0fb9eaa302ff9bd36f523 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 05 一月 2023 10:29:07 +0800
Subject: [PATCH] 采购订单删除、审核接口开发 系统设置编码规则查询增加(是否开放字段) 过滤条件
---
VueWebApi/DLL/DAL/PurchaseOrderDAL.cs | 123 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 123 insertions(+), 0 deletions(-)
diff --git a/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs b/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
index b5719ed..e811852 100644
--- a/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
+++ b/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
@@ -97,5 +97,128 @@
return mes;
}
#endregion
+
+ #region[閲囪喘璁㈠崟鍒犻櫎]
+ public static ToMessage DeletePurchaseOrder(string po)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鍒犻櫎閲囪喘璁㈠崟涓昏〃
+ sql = @"delete T_PurchaseOrder where ordercode=@po";
+ list.Add(new { str = sql, parm = new { po = po } });
+
+ //鍒犻櫎閲囪喘璁㈠崟瀛愯〃
+ sql = @"delete T_PurchaseOrder_sub where purchaseorder_code=@po";
+ list.Add(new { str = sql, parm = new { po = po } });
+
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍒犻櫎鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍒犻櫎澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[閲囪喘璁㈠崟瀹℃牳]
+ public static ToMessage VerifyPurchaseOrder(string po,string username)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鏇存柊閲囪喘璁㈠崟涓昏〃瀹℃牳浜恒�佸鏍告椂闂�
+ sql = @"update T_PurchaseOrder set auditorusercode=@username,auditordate=@lm_date where ordercode=@po";
+ list.Add(new { str = sql, parm = new { username= username,po = po, lm_date = DateTime.Now.ToString() } });
+
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "瀹℃牳鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "瀹℃牳澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[閲囪喘璁㈠崟鍙嶅鏍竇
+ public static ToMessage ReversVerifyPurchaseOrder(string po, string username)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鍒ゆ柇鏄惁鐢熸垚閲囪喘鍒拌揣鍗�
+
+ //鏇存柊閲囪喘璁㈠崟涓昏〃瀹℃牳浜恒�佸鏍告椂闂�
+ sql = @"update T_PurchaseOrder set auditorusercode=@username,auditordate=@lm_date where ordercode=@po";
+ list.Add(new { str = sql, parm = new { username="",po = po, lm_date ="" } });
+
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍙嶅鏍告垚鍔�!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍙嶅鏍稿け璐�!";
+ mes.data = null;
+ }
+ }
+ 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