| | |
|---|
| | | long HProcID = list[0].HProcID;//宸ュ簭ID |
|---|
| | | long HPRDORGID = list[0].HPRDORGID;//缁勭粐ID |
|---|
| | | bool HLastResult = list[0].HLastResult;//璇曟牱缁撹 |
|---|
| | | Int64 HProcExchInterID = list[0].HProcExchInterID;//鎸囧紩鍗D |
|---|
| | | Int64 HProcExchEntryID = list[0].HProcExchEntryID;//鎸囧紩鍗″瓙ID |
|---|
| | | |
|---|
| | | //琛ㄤ綋鏁版嵁 |
|---|
| | | List<Model.ClsQC_ProcessCheckBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_ProcessCheckBillSub>>(msg_entry); |
|---|
| | |
|---|
| | | oCN.RunProc("Insert Into QC_ProcessCheckBillMain " + |
|---|
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + |
|---|
| | | ",HYear,HPeriod,HMaterID,HSourceID,HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchBillNo" + |
|---|
| | | ",HPRDORGID,HLastResult)" + |
|---|
| | | ",HPRDORGID,HLastResult,HProcExchInterID,HProcExchEntryID,HProcID)" + |
|---|
| | | " values('" + BillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" + |
|---|
| | | "," + HYear + "," + HPeriod + ",'" + HMaterID + "','" + HSourceID + "'," + HICMOInterID + "," + HICMOEntryID + ",'" + HICMOBillNo + "','" + HProcExchBillNo + "'" + |
|---|
| | | "," + HPRDORGID + ",'" + HLastResult + "') "); |
|---|
| | | "," + HPRDORGID + ",'" + HLastResult + "'," + HProcExchInterID + "," + HProcExchEntryID + "," + HProcID + ") "); |
|---|
| | | |
|---|
| | | //鎻掑叆瀛愯〃 |
|---|
| | | foreach (Model.ClsQC_ProcessCheckBillSub oSub in BillNew.DetailColl) |
|---|
