File was renamed from WebAPI/DLL/ClsPay_SingleBalBill.cs |
| | |
| | | using System.Text; |
| | | using System.Data; |
| | | |
| | | namespace DAL |
| | | namespace WebAPI.DLL |
| | | { |
| | | public class ClsPay_SingleBalBill : DBUtility.ClsXt_BaseBill |
| | | { |
| | | public Model.ClsPay_SingleBalBillMain omodel = new Model.ClsPay_SingleBalBillMain(); |
| | | public List<Model.ClsPay_SingleBalBillSub> DetailColl = new List<Model.ClsPay_SingleBalBillSub>(); |
| | | public Models.ClsPay_SingleBalBillMain omodel = new Models.ClsPay_SingleBalBillMain(); |
| | | public List<Models.ClsPay_SingleBalBillSub> DetailColl = new List<Models.ClsPay_SingleBalBillSub>(); |
| | | |
| | | public ClsPay_SingleBalBill() |
| | | { |
| | |
| | | DeleteBillSub(lngBillKey); |
| | | //æå
¥å表 |
| | | omodel.HInterID = lngBillKey; |
| | | foreach (Model.ClsPay_SingleBalBillSub oSub in DetailColl) |
| | | foreach (Models.ClsPay_SingleBalBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Pay_SingleBalBillSub " + |
| | | " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + |
| | |
| | | ", " + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HPayType.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsPay_SingleBalBillSub oSub in DetailColl) |
| | | foreach (Models.ClsPay_SingleBalBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Pay_SingleBalBillSub " + |
| | | " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + |
| | |
| | | DetailColl.Clear();//æ¸
空 |
| | | for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) |
| | | { |
| | | Model.ClsPay_SingleBalBillSub oSub = new Model.ClsPay_SingleBalBillSub(); |
| | | Models.ClsPay_SingleBalBillSub oSub = new Models.ClsPay_SingleBalBillSub(); |
| | | // åºå®èµå¼=============================================== |
| | | oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); |
| | | oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); |