From da6350d73fdd6b168756a2986b1e5cb0a2da00ed Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 29 三月 2023 10:59:13 +0800
Subject: [PATCH] 订单下达生成工单语句修改、手工创建生产工单生成单据号接口
---
VueWebApi/DLL/DAL/GridReportDAL.cs | 40 +++++++++++++++++++++++++++++++++++++++-
1 files changed, 39 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/GridReportDAL.cs b/VueWebApi/DLL/DAL/GridReportDAL.cs
index 1e1df48..4556ffa 100644
--- a/VueWebApi/DLL/DAL/GridReportDAL.cs
+++ b/VueWebApi/DLL/DAL/GridReportDAL.cs
@@ -17,6 +17,7 @@
public static GridMessage gidmes = new GridMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
public static string strProcName = ""; //瀹氫箟鍏ㄥ眬sql鍙橀噺
public static List<SqlParameter> listStr = new List<SqlParameter>(); //瀹氫箟鍏ㄥ眬鍙傛暟闆嗗悎
+
public static SqlParameter[] parameters; //瀹氫箟鍏ㄥ眬SqlParameter鍙傛暟鏁扮粍
@@ -27,7 +28,7 @@
var dynamicParams = new DynamicParameters();
//鑾峰彇璁惧绫诲瀷鏁版嵁
- sql = @"select A.seq,A.wo_code,P.partcode,P.partname,P.partspec,R.name as routename,M.plan_qty as orderqty,@username as lm_user,@createdate as lm_date,
+ sql = @"select A.seq,A.wo_code,M.m_po,P.partcode,P.partname,P.partspec,R.name as routename,M.plan_qty as orderqty,@username as lm_user,@createdate as lm_date,
B.stepcode,B.stepname,A.plan_qty,(case when A.good_qty=0 then '' end) as good_qty,(case when A.ng_qty=0 then '' end) as ng_qty,A.wo_code+';'+B.stepcode as stepqrcode
from TK_Wrk_Step A
left join TK_Wrk_Man M on A.wo_code=M.wo_code
@@ -58,5 +59,42 @@
return mes;
}
#endregion
+
+ #region[FastReport鎵撳嵃]
+ public static PrintMessage MesOrderFastReportPrintSearch(string username, string mesordercode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ PrintMessage ms = new PrintMessage();
+ //鑾峰彇宸ュ崟宸ュ簭浠诲姟鏁版嵁
+ sql = @"select A.seq,A.wo_code,P.partcode,P.partname,P.partspec,R.name as routename,M.plan_qty as orderqty,@username as lm_user,@createdate as lm_date,
+ B.stepcode,B.stepname,A.plan_qty,(case when A.good_qty=0 then '' end) as good_qty,(case when A.ng_qty=0 then '' end) as ng_qty,A.wo_code+';'+B.stepcode as stepqrcode
+ from TK_Wrk_Step A
+ left join TK_Wrk_Man M on A.wo_code=M.wo_code
+ left join TFlw_Rout R on A.route_code=R.code
+ left join TMateriel_Info P on M.materiel_code=P.partcode
+ left join TStep B on A.step_code=B.stepcode
+ where A.wo_code=@mesordercode ";
+ dynamicParams.Add("@username", username);
+ dynamicParams.Add("@createdate", DateTime.Now.ToString());
+ dynamicParams.Add("@mesordercode", mesordercode);
+ DataTable data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ ms.code = "200";
+ ms.Message = "鏌ヨ鎴愬姛锛�";
+ ms.data = data;
+ }
+ else
+ {
+ ms.code = "300";
+ ms.Message = "鏃犵敓浜т换鍔℃暟鎹紒";
+ ms.data = null;
+ }
+
+ return ms;
+ }
+ #endregion
+
}
}
\ No newline at end of file
--
Gitblit v1.9.3