斯莫尔钉钉同步：修改

duhe

2025-09-24 1a3d8206fbd346b8e5d3248486b358c832bce132

 DAL/¹¤×ʹÜÀí/ClsPay_PayMentBill.cs

@@ -136,13 +136,13 @@
                      "," + oSub.HPayTotal.ToString() + "," + oSub.HSubsidyTotal.ToString() + "," + oSub.HDeuctTotal.ToString() + "," + oSub.HShoudPay.ToString() + "," + oSub.HInsurance.ToString() + "," + oSub.HTaxBefore.ToString() + "," + oSub.HTax.ToString() + "," + oSub.HRelPay.ToString() +
                      "," + Convert.ToString(oSub.HPayStatus ? 1 : 0) + ",'" + oSub.HPayRemark + "','" + oSub.HUnPayRemark + "'" +
                      " ";
                    foreach (Model.ClsGy_SelfEntryValue oSelfValue in oSub.oSelfValue)
                    {
                        sInsertSubBill = sInsertSubBill + "," + oSelfValue.HSQLColumnName;
                        DBUtility.Xt_BaseBillFun.Sub_GetSelfInsertSQL(ref sInsertSubBillValue, oSelfValue.HDataType, oSelfValue.HValue);
                    }
                    sInsertSubBillValue = sInsertSubBillValue + ")";
                    oCn.RunProc(sInsertSubBill + sInsertSubBillValue);
                    //foreach (Model.ClsGy_SelfEntryValue oSelfValue in oSub.oSelfValue)
                    //{
                    //    sInsertSubBill = sInsertSubBill + "," + oSelfValue.HSQLColumnName;
                    //    DBUtility.Xt_BaseBillFun.Sub_GetSelfInsertSQL(ref sInsertSubBillValue, oSelfValue.HDataType, oSelfValue.HValue);
                    //}
                    //sInsertSubBillValue = sInsertSubBillValue + ")";
                    //oCn.RunProc(sInsertSubBill + sInsertSubBillValue);
                    //自定义列 æ–°å¢ž  å¹»
                }
                //
@@ -247,17 +247,17 @@
                    oSub.HPayRemark = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HPayRemark"]);
                    oSub.HUnPayRemark = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HUnPayRemark"]);
                    //====自定义列 æ˜¾ç¤º  å¹»
                    oSub.oSelfValue.Clear();
                    foreach (Model.ClsGy_SelfEntry oEntry in omodel.oSelf)
                    {
                        Model.ClsGy_SelfEntryValue oSubValue = new Model.ClsGy_SelfEntryValue();
                        oSubValue.HInterID = oSub.HInterID;
                        oSubValue.HEntryID = oSub.HEntryID;
                        oSubValue.HSQLColumnName = oEntry.HSQLColumnName;
                        oSubValue.HCaption = oEntry.HCaption;
                        oSubValue.HValue =  DsSub.Tables[0].Rows[i][oEntry.HSQLColumnName];
                        oSub.oSelfValue.Add(oSubValue);
                    }
                    //oSub.oSelfValue.Clear();
                    //foreach (Model.ClsGy_SelfEntry oEntry in omodel.oSelf)
                    //{
                    //    Model.ClsGy_SelfEntryValue oSubValue = new Model.ClsGy_SelfEntryValue();
                    //    oSubValue.HInterID = oSub.HInterID;
                    //    oSubValue.HEntryID = oSub.HEntryID;
                    //    oSubValue.HSQLColumnName = oEntry.HSQLColumnName;
                    //    oSubValue.HCaption = oEntry.HCaption;
                    //    oSubValue.HValue =  DsSub.Tables[0].Rows[i][oEntry.HSQLColumnName];
                    //    oSub.oSelfValue.Add(oSubValue);
                    //}
                    //==============
                    DetailColl.Add(oSub);
                }