From d734833a8520aad070ea4ad9fe7f768c2effe7f1 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 09 二月 2023 21:54:51 +0800
Subject: [PATCH] 采购订单删除判断是否生成到货单
---
VueWebApi/DLL/DAL/PurchaseOrderDAL.cs | 46 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 45 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs b/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
index e811852..b18c257 100644
--- a/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
+++ b/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
@@ -80,12 +80,44 @@
left join TOrganization T on A.departmentcode=T.org_code
left join TCustomer C on A.customercode=C.code
left join TUser U on A.auditorusercode=U.usercode
- where T.description='D' and C.mtype='WG' " + search;
+ where 1=1 " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[閲囪喘璁㈠崟鏄庣粏]
+ public static ToMessage PurchaseOrderSubSearch(string purodercode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鑾峰彇閲囪喘璁㈠崟鐗╂枡淇℃伅
+ sql = @"select M.partcode,M.partname,M.partspec,T.name as uomname,A.quantity,A.countarrivalquantity,A.countInquantity,
+ A.acceptdate,S.name as housename,M.is_incheck
+ from T_PurchaseOrder_sub A
+ left join TMateriel_Info M on A.materiel_code=M.partcode
+ left join TUom T on M.uom_code=T.code
+ left join T_Sec_Stck S on A.warehousecode=S.code
+ where A.purchaesorder_code=@purodercode";
+ dynamicParams.Add("@purodercode", purodercode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
}
catch (Exception e)
{
@@ -106,6 +138,18 @@
var dynamicParams = new DynamicParameters();
try
{
+ //鍒ゆ柇鏄惁鐢熸垚浜嗛噰璐埌璐у崟
+ sql = @"select * from T_PurchaseArrivalOrder where hsourcebillno=@po";
+ dynamicParams.Add("@po", po);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "褰撳墠閲囪喘璁㈠崟宸茬敓鎴愬埌璐у崟!";
+ mes.data = null;
+ return mes;
+ }
//鍒犻櫎閲囪喘璁㈠崟涓昏〃
sql = @"delete T_PurchaseOrder where ordercode=@po";
list.Add(new { str = sql, parm = new { po = po } });
--
Gitblit v1.9.3