| | |
| | | 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; |
| | |
| | | //主表 |
| | | oCN.RunProc(" Insert Into Pay_SingleBalBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker" + |
| | | ",HGroupID,HDeptID,HEmpID,HPayType,HExplanation,HInnerBillNo" + ")" + |
| | | "values('" + HBillType + "'" + HBillSubType + "," + HInterID + ",'" + HBillNo + "','" + HDate + |
| | | "',"+ HDeptID + "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "'," + HGroupID + |
| | | "," + HEmpID + ","+ HPayType +",'" + HInnerBillNo + "'" + HExplanation + |
| | | ",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 + |
| | | ") "); |
| | | |
| | | //保存子表 |