From 872225fc23dd916d1e483c0b7ad0620732af653f Mon Sep 17 00:00:00 2001 From: jingh <jingh@LAPTOP-I53VDLOO> Date: 星期六, 07 八月 2021 00:31:58 +0800 Subject: [PATCH] 模具增加方法 --- DAL/生产管理/模具管理/ClsSc_MouldProdOutBill.cs | 36 ++++++++++++++++++++++++++++++++++++ 1 files changed, 36 insertions(+), 0 deletions(-) diff --git "a/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/\346\250\241\345\205\267\347\256\241\347\220\206/ClsSc_MouldProdOutBill.cs" "b/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/\346\250\241\345\205\267\347\256\241\347\220\206/ClsSc_MouldProdOutBill.cs" index 2be5b3a..990a8a7 100644 --- "a/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/\346\250\241\345\205\267\347\256\241\347\220\206/ClsSc_MouldProdOutBill.cs" +++ "b/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/\346\250\241\345\205\267\347\256\241\347\220\206/ClsSc_MouldProdOutBill.cs" @@ -177,6 +177,42 @@ throw (e); } } + + ////鏉$爜鎵弿璁板綍,鏂板鍒颁骇鍝佸叆搴� + //public bool AddBill_PDA(ref string sReturn) + //{ + // try + // { + // DataSet Ds; + // oCn.BeginTran(); + // //鍒犻櫎涓昏〃 + // oCn.RunProc("Delete From Sc_MouldStockBillMain where HInterID=" + omodel.HInterID.ToString()); + // //鎻掑叆瀛愯〃 + // oCn.RunProc("EXEC h_p_Sc_MouldProdOutBillSub_Insert " + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'"); + // //鎻掑叆涓昏〃 + // oCn.RunProc("Insert Into Sc_MouldStockBillMain " + + // "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + + // ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + + // ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + + // ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + + // ") " + + // " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "',convert(varchar(10),getdate(),120)" + + // ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + + // ", " + 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) + + // ") "); + // sReturn = "鏂板鍗曟嵁鎴愬姛锛�"; + // oCn.Commit(); + // return true; + // } + // catch (Exception e) + // { + // sReturn = e.Message; + // oCn.RollBack(); + // throw (e); + // } + //} + //鏄剧ず鍗曟嵁 public override bool ShowBill(Int64 lngBillKey, ref string sReturn) { -- Gitblit v1.9.1