| | |
| | | public class ClsCg_PayableBill : DBUtility.ClsXt_BaseBill |
| | | { |
| | | public Model.ClsCg_PayableBillMain omodel = new Model.ClsCg_PayableBillMain(); |
| | | public List<Model.ClsCg_PayableBillSub> DetailColl = new List<Model.ClsCg_PayableBillSub>(); |
| | | public List<Model.ClsCg_PayableSub> DetailColl = new List<Model.ClsCg_PayableSub>(); |
| | | |
| | | public ClsCg_PayableBill() |
| | | { |
| | | base.MvarItemKeySub = "Cg_PayableBillSub"; |
| | | base.MvarItemKeySub = "Cg_PayableSub"; |
| | | base.MvarItemKeySub2 = ""; |
| | | base.MvarItemKeySub3 = ""; |
| | | base.MvarItemKeySub4 = ""; |
| | |
| | | ",HCurID = " + omodel.HCurID + "" + |
| | | ",HExRate = " + omodel.HExRate + "" + |
| | | ",HEmpID = " + omodel.HEmpID + "" + |
| | | ",HMangerID = " + omodel.HMangerID + "" + |
| | | ",HManagerID = " + omodel.HManagerID + "" + |
| | | ",HDeptID = " + omodel.HDeptID + "" + |
| | | ",HExplanation = '" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo = '" + omodel.HInnerBillNo + "'" + |
| | |
| | | //æå
¥å表 |
| | | omodel.HInterID = lngBillKey; |
| | | //æå
¥å表 |
| | | foreach (Model.ClsCg_PayableBillSub oSub in DetailColl) |
| | | foreach (Model.ClsCg_PayableSub oSub in DetailColl) |
| | | { |
| | | string subSql = "insert into Cg_PayableSub" + |
| | | "(HInterID,HEntryID,HBillNo_bak,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney" + |
| | |
| | | string mainSql = "insert into Cg_PayableBillMain" + |
| | | "(HInterID,HBillNo,HDate,HYear,HPeriod,HBillType,HBillSubType" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" + |
| | | ",HMaker,HMakeDate,HSSID,HPSStyleID,HReceiveDate,HSupID,HCurID,HExRate,HEmpID,HMangerID,HDeptID,HExplanation,HInnerBillNo,HRemark) " + |
| | | ",HMaker,HMakeDate,HSSID,HPSStyleID,HReceiveDate,HSupID,HCurID,HExRate,HEmpID,HManagerID,HDeptID,HExplanation,HInnerBillNo,HRemark) " + |
| | | "values(" + |
| | | "" + omodel.HInterID + "" + |
| | | ",'" + omodel.HBillNo + "'" + |
| | |
| | | "," + omodel.HCurID + "" + |
| | | "," + omodel.HExRate + "" + |
| | | "," + omodel.HEmpID + "" + |
| | | "," + omodel.HMangerID + "" + |
| | | "," + omodel.HManagerID + "" + |
| | | "," + omodel.HDeptID + "" + |
| | | ",'" + omodel.HExplanation + "'" + |
| | | ",'" + omodel.HInnerBillNo + "'" + |
| | |
| | | oCn.RunProc(mainSql); |
| | | |
| | | //æå
¥å表 |
| | | foreach (Model.ClsCg_PayableBillSub oSub in DetailColl) |
| | | foreach (Model.ClsCg_PayableSub oSub in DetailColl) |
| | | { |
| | | string subSql = "insert into Cg_PayableSub" + |
| | | "(HInterID,HEntryID,HBillNo_bak,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney" + |
| | |
| | | omodel.HCurID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCurID"]); |
| | | omodel.HExRate = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HExRate"]); |
| | | omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]); |
| | | omodel.HMangerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMangerID"]); |
| | | omodel.HManagerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HManagerID"]); |
| | | omodel.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"]); |
| | | |
| | | omodel.HExplanation = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HExplanation"]); |
| | |
| | | DetailColl.Clear();//æ¸
空 |
| | | for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) |
| | | { |
| | | Model.ClsCg_PayableBillSub oSub = new Model.ClsCg_PayableBillSub(); |
| | | Model.ClsCg_PayableSub oSub = new Model.ClsCg_PayableSub(); |
| | | // åºå®èµå¼=============================================== |
| | | oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); |
| | | oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); |