|  |  |  | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | string sql= $@"update Cg_POInStockBillMain  set " + | 
|---|
|  |  |  | "HRemark='" + HRemark + "', HUpDater ='" + HMaker + "', HUpDateDate=getdate()"+ ",HBillNo='" + HBillNo + "'" + | 
|---|
|  |  |  | ",HSupID=" + HSupID + ",HCurID=" + HCurID | 
|---|
|  |  |  | + ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID | 
|---|
|  |  |  | + ",HAddress='" + HAddress + "',HInnerBillNo='" + HInnerBillNo + "',HProjectID="+ HProjectID + ",HInvoiceBillNo='"+ HInvoiceBillNo + "' where HInterID=" + HInterID; | 
|---|
|  |  |  | "HRemark='" + HRemark + "'" + | 
|---|
|  |  |  | ", HUpDater ='" + HMaker + "'" + | 
|---|
|  |  |  | ", HUpDateDate=getdate()"+ "" + | 
|---|
|  |  |  | ",HBillNo='" + HBillNo + "'" + | 
|---|
|  |  |  | ",HWHID=" + HWHID + "" + | 
|---|
|  |  |  | ",HSupID=" + HSupID + "" + | 
|---|
|  |  |  | ",HCurID=" + HCurID + "" + | 
|---|
|  |  |  | ",HExRate=" + HExRate + "" + | 
|---|
|  |  |  | ",HEmpID=" + HEmpID + "" + | 
|---|
|  |  |  | ",HManagerID=" + HManagerID + "" + | 
|---|
|  |  |  | ",HDeptID=" + HDeptID + "" + | 
|---|
|  |  |  | ",HAddress='" + HAddress + "'" + | 
|---|
|  |  |  | ",HInnerBillNo='" + HInnerBillNo + "'" + | 
|---|
|  |  |  | ",HProjectID="+ HProjectID + "" + | 
|---|
|  |  |  | ",HInvoiceBillNo='"+ HInvoiceBillNo + "' " + | 
|---|
|  |  |  | " where HInterID=" + HInterID; | 
|---|
|  |  |  |  | 
|---|
|  |  |  | oCN.RunProc(sql); | 
|---|
|  |  |  |  | 
|---|
|  |  |  | 
|---|
|  |  |  | foreach (ClsCg_POInStockBillSub oSub in DetailColl) | 
|---|
|  |  |  | { | 
|---|
|  |  |  | i++; | 
|---|
|  |  |  | if (oSub.HQty <= 0 || oSub.HQty == null) | 
|---|
|  |  |  | { | 
|---|
|  |  |  | objJsonResult.code = "0"; | 
|---|
|  |  |  | objJsonResult.count = 0; | 
|---|
|  |  |  | objJsonResult.Message = "第" + i + "行,数量不能为0或者小于0"; | 
|---|
|  |  |  | objJsonResult.data = null; | 
|---|
|  |  |  | return objJsonResult; | 
|---|
|  |  |  | } | 
|---|
|  |  |  | //if (oSub.HQty <= 0 || oSub.HQty == null) | 
|---|
|  |  |  | //{ | 
|---|
|  |  |  | //    objJsonResult.code = "0"; | 
|---|
|  |  |  | //    objJsonResult.count = 0; | 
|---|
|  |  |  | //    objJsonResult.Message = "第" + i + "行,数量不能为0或者小于0"; | 
|---|
|  |  |  | //    objJsonResult.data = null; | 
|---|
|  |  |  | //    return objJsonResult; | 
|---|
|  |  |  | //} | 
|---|
|  |  |  |  | 
|---|
|  |  |  | if (oSub.HMaterID == 0) | 
|---|
|  |  |  | { | 
|---|