工资结算单(个人)

王 垚

2021-12-06 b386a0c4ce29a5ae61ee900fdb2522d8e6b52ca2

 WebAPI/DLL/ClsPay_SingleBalBill.cs

@@ -3,12 +3,12 @@
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()
        {
@@ -61,7 +61,7 @@
                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" +
@@ -125,7 +125,7 @@
                ", " + 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" +
@@ -224,7 +224,7 @@
                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"]);