From fef5abcd1181cff38715599beceb5e46a32c014f Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期一, 11 十月 2021 17:59:57 +0800 Subject: [PATCH] 器具档案和器具分类的查看删除权限 --- WebAPI/DLL/ClsSc_MouldProdInBill.cs | 9 +++++---- 1 files changed, 5 insertions(+), 4 deletions(-) diff --git a/WebAPI/DLL/ClsSc_MouldProdInBill.cs b/WebAPI/DLL/ClsSc_MouldProdInBill.cs index e099528..49cd166 100644 --- a/WebAPI/DLL/ClsSc_MouldProdInBill.cs +++ b/WebAPI/DLL/ClsSc_MouldProdInBill.cs @@ -41,19 +41,20 @@ omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCn.BeginTran(); - //涓昏〃 - oCn.RunProc("Insert Into Sc_MouldStockBillMain " + + string sql = "Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HRemark,HMaker,HMakeDate" + /*"HYear, HPeriod,"*/ ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + ") " + " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + - ", " + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + /*omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" +*/ + ", '" + omodel.HRemark.ToString() + "','" + omodel.HMaker + "',getdate()" + /*omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" +*/ ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + - ") "); + ") "; + //涓昏〃 + oCn.RunProc(sql); //鎻掑叆瀛愯〃 foreach (Models.ClsSc_MouldProdBillSub oSub in DetailColl) { -- Gitblit v1.9.1