nothing

zzr99

2021-12-06 19886bc3674e116fa7a26e12e11d5300732389d2

 WebAPI/DLL/¹¤×ʹÜÀí/ClsPay_OtherBalBill.cs

File was renamed from WebAPI/DLL/ClsPay_OtherBalBill.cs
@@ -3,12 +3,12 @@
using System.Text;
using System.Data;

namespace DAL
namespace WebAPI.DLL
{
    public class ClsPay_OtherBalBill : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsPay_OtherBalBillMain omodel = new Model.ClsPay_OtherBalBillMain();
        public List<Model.ClsPay_OtherBalBillSub> DetailColl = new List<Model.ClsPay_OtherBalBillSub>();
        public Models.ClsPay_OtherBalBillMain omodel = new Models.ClsPay_OtherBalBillMain();
        public List<Models.ClsPay_OtherBalBillSub> DetailColl = new List<Models.ClsPay_OtherBalBillSub>();

        public ClsPay_OtherBalBill()
        {
@@ -61,7 +61,7 @@
                DeleteBillSub(lngBillKey);
                //插入子表
                omodel.HInterID = lngBillKey;
                foreach (Model.ClsPay_OtherBalBillSub oSub in DetailColl)
                foreach (Models.ClsPay_OtherBalBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Pay_OtherBalBillSub " +
                      " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
@@ -83,7 +83,7 @@
                      ") ");
                }
                //
                //foreach (Model.ClsPay_SingleBalBillSub oSub in DetailColl)
                //foreach (Models.ClsPay_SingleBalBillSub oSub in DetailColl)
                //{
                //    Ds = oCn.RunProcReturn("exec h_p_Pay_SingleBalBill_Qty " + oSub.HICMOInterID, "");
                //    if (Ds.Tables[0].Rows.Count == 0)
@@ -117,15 +117,15 @@
                //主表
                oCn.RunProc("Insert Into Pay_OtherBalBillMain   " +
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate,HSaveFlag" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HGroupID,HDeptID,HEmpID,HPayType,HExplanation,HInnerBillNo" +
                ") " +
                " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()," + 
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + 
                ", " + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HPayType.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'" +
                ") ");
                //插入子表
                foreach (Model.ClsPay_OtherBalBillSub oSub in DetailColl)
                foreach (Models.ClsPay_OtherBalBillSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Pay_OtherBalBillSub " +
                      " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
@@ -147,7 +147,7 @@
                      ") ");
                }
                //
                //foreach (Model.ClsPay_SingleBalBillSub oSub in DetailColl)
                //foreach (Models.ClsPay_SingleBalBillSub oSub in DetailColl)
                //{
                //    Ds = oCn.RunProcReturn("exec h_p_Pay_SingleBalBill_Qty " + oSub.HICMOInterID, "");
                //    if (Ds.Tables[0].Rows.Count == 0)
@@ -224,7 +224,7 @@
                DetailColl.Clear();//清空
                for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                {
                    Model.ClsPay_OtherBalBillSub oSub = new Model.ClsPay_OtherBalBillSub();
                    Models.ClsPay_OtherBalBillSub oSub = new Models.ClsPay_OtherBalBillSub();
                    // å›ºå®šèµ‹å€¼===============================================
                    oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
                    oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);