| | |
| | | int HYear = 2021; |
| | | double HPeriod = 1; |
| | | string HRemark = mainList[0].HRemark;//备注 |
| | | string HBillSubType = mainList[0].HBillSubType; |
| | | string HBillSubType = "2205"; |
| | | string HMaker = mainList[0].HMaker; |
| | | string HExplanation = mainList[0].HExplanation; |
| | | string HInnerBillNo = mainList[0].HInnerBillNo; |
| | | string HExplanation = "0"; |
| | | string HInnerBillNo = "0"; |
| | | long HMaterID = mainList[0].HMaterID;//产品ID |
| | | long HGroupID = mainList[0].HGroupID; |
| | | long HDeptID = mainList[0].HDeptID; |
| | |
| | | int HPRDORGID = mainList[0].HPRDORGID; //组织 |
| | | |
| | | //主表 |
| | | oCN.RunProc("Insert Into Pay_SingleBalBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
| | | ",HGroupID,HDeptID,HEmpID,HPayType,HExplanation,HInnerBillNo" + |
| | | ") " + |
| | | " values('" + HBillType + "'," + HBillSubType + ",'" + HInterID + "','" + HBillNo + "','" + HDate + "'" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HGroupID + "," + HDeptID + "," + HEmpID + ","+ |
| | | "," + HPayType + "," + HExplanation + ",'" + HInnerBillNo + "'," + |
| | | ") "); |
| | | oCN.RunProc(" Insert Into Pay_SingleBalBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker" + |
| | | ",HGroupID,HDeptID,HEmpID,HPayType,HInnerBillNo,HExplanation" + ")" + |
| | | "values('" + HBillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + |
| | | "','" + HYear + "'," + HPeriod + ",'" + HRemark + "','" + HMaker + "'," + HGroupID + ", " + HDeptID + |
| | | "," + HEmpID + ",'"+ HPayType +"','" + HInnerBillNo + "'," + HExplanation + |
| | | ") "); |
| | | |
| | | //保存子表 |
| | | objJsonResult = AddBillSub(msg3, HInterID); |