| | |
| | | List<ClsSc_StationOutBillSub_Emp> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg2); |
| | | List<ClsSc_StationOutBillSub_Emp> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg3); |
| | | |
| | | long HInterID = mainList[0].HInterID; |
| | | long HWorkEmpID = subList[0].HWorkEmpID; |
| | | long HWorkSourceID = subList[0].HWorkSourceID; |
| | | decimal HQty = subList[0].HQty; |
| | |
| | | decimal HProcPrice = subList[0].HProcPrice; |
| | | decimal HMoney = subList[0].HMoney; |
| | | long HWorkProcID = mainList[0].HWorkProcID; |
| | | |
| | | var EntryID = 0; |
| | | foreach (ClsSc_StationOutBillSub_Emp oSub in subList) |
| | | { |
| | | //ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_IF_ICMOBillList"); |
| | | |
| | | if ((OperationType == 1 || OperationType == 2))//新增 && ds.Tables[0].Rows.Count == 0 |
| | | { |
| | | EntryID++; |
| | | |
| | | string sql = string.Empty; |
| | | sql = $@" |
| | | Insert into Sc_StationOutBillSub_Emp |
| | | (HInterID,HEntryID,HBillNo_bak ,HRemark ,HSourceInterID |
| | | ,HSourceEntryID ,HSourceBillNo ,HSourceBillType ,HRelationQty ,HRelationMoney |
| | | ,HWorkEmpID ,HWorkSourceID ,HQty ,HRate ,HProcPrice ,HMoney ,HWorkProcID) |
| | | values(" + 1 + "," + 2 + "," + "'" + mainList[0].HBillNo_bak + "','" + "HRemark" + "'," + 0 + "," + 0 + ",'" + " " + "','" + "HSource" + "'," + |
| | | "0" + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + ")"; |
| | | values(" + HInterID + "," + EntryID + "," + "'" + mainList[0].HBillNo_bak + "','" + mainList[0].HRemark + "'," + 0 + "," + 0 + ",'" + " " + "','" + " " + "'," + |
| | | "0" + "," + 0 + "," + oSub.HWorkEmpID + "," + oSub.HWorkSourceID + "," + oSub.HQty + "," + oSub.HRate + "," + oSub.HProcPrice + "," + oSub.HMoney + "," + HWorkProcID + ")"; |
| | | |
| | | oCN.RunProc(sql); |
| | | } |