| | |
| | | string HUpDater = mainList[0].HUpDater; |
| | | string HMaterNumber = mainList[0].HMaterNumber; |
| | | string HSupNumber = mainList[0].HSupNumber; |
| | | long HPrintQty = mainList[0].HPrintQty; |
| | | string HMouldOWNER = mainList[0].HMouldOWNER; |
| | | string HSaveLife = mainList[0].HSaveLife; |
| | | int HCaveQty = mainList[0].HCaveQty; |
| | |
| | | } |
| | | //========================================================= |
| | | |
| | | //主表 |
| | | //主表 |
| | | oCN.RunProc("UpDate Gy_MouldFileMain set " + |
| | | " HBillNo='" + HBillNo + "'" + //固定赋值=============== |
| | | ",HDate='" + HDate + "'" + |
| | |
| | | ",HDeptID=" + HDeptID.ToString() + |
| | | ",HSupID=" + HSupID.ToString() + |
| | | ",HSupNumber='" + HSupNumber + "'" + |
| | | ",HPrintQty=" + HPrintQty.ToString() + |
| | | ",HMouldStatus='" + HMouldStatus + "'" + |
| | | ",HSaveLife='" + HSaveLife + "'" + |
| | | ",HWhID=" + HWHID.ToString() + |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn($"select * from Gy_BarCodeBill where HBarCode='{HbarCode}' ", "Gy_Material"); |
| | | ds = oCN.RunProcReturn($"select *,b.hnumber HMaterNumber,b.hname HMaterName_m from Gy_BarCodeBill a with(nolock) left join Gy_Material b with(nolock) on a.HMaterID=b.HItemID where HBarCode='{HbarCode}' ", "Gy_Material"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |