1

duhe

2024-03-12 e47895acbaa55346e02d536ab2da4134058bd3a5

1

 DAL/Ó¦ÊÕ¹ÜÀí/ClsYS_ReceiveOtherBill.cs

@@ -71,24 +71,26 @@
                foreach (Model.ClsYS_ReceiveOtherBillSub oSub in DetailColl)
                {
                    string subSql = "insert into YS_ReceiveOtherBillSub" +
                         "" +
                         "" +
                         "" +
                         "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                         ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney) " +
                         " values(" +
                         "" + omodel.HInterID.ToString() +
                         "," + oSub.HEntryID.ToString() +
                         "," + oSub.HSourceInterID +
                         "," + oSub.HSourceEntryID +
                         ",'" + oSub.HSourceBillNo +
                         "','" + oSub.HSourceBillType +
                         "','" + oSub.HProjectMoneyID +
                         "','" + oSub.HTypeSub +
                         "','" + oSub.HMoney +
                         "','" + oSub.HTaxRate +
                         "','" + oSub.HSumMoney +
                         "')";
                        "" +
                        "" +
                        "" +
                        "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                        ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney,HQty,HPrice) " +
                        " values(" +
                        "" + omodel.HInterID.ToString() +
                        "," + oSub.HEntryID.ToString() +
                        "," + oSub.HSourceInterID +
                        "," + oSub.HSourceEntryID +
                        ",'" + oSub.HSourceBillNo +
                        "','" + oSub.HSourceBillType +
                        "','" + oSub.HProjectMoneyID +
                        "','" + oSub.HTypeSub +
                        "','" + oSub.HMoney +
                        "','" + oSub.HTaxRate +
                        "','" + oSub.HSumMoney +
                         "','" + oSub.HQty +
                          "','" + oSub.HPrice +
                        "')";
                    oCn.RunProc(subSql);
                }
                sReturn = "修改单据成功！";
@@ -131,7 +133,7 @@
                         "" +
                         "" +
                         "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                         ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney) " +
                         ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney,HQty,HPrice) " +
                         " values(" +
                         "" + omodel.HInterID.ToString() +
                         "," + oSub.HEntryID.ToString() +
@@ -144,6 +146,8 @@
                         "','" + oSub.HMoney +
                         "','" + oSub.HTaxRate +
                         "','" + oSub.HSumMoney +
                          "','" + oSub.HQty +
                           "','" + oSub.HPrice +
                         "')";
                    oCn.RunProc(subSql);
                }

 Model/Ó¦ÊÕ¹ÜÀí/ClsYS_ReceiveOtherBillSub.cs

@@ -13,5 +13,7 @@
        public double HMoney;//  dec(18,8) //单据金额
        public double HTaxRate;//  dec(18,8) //税率
        public double HSumMoney;//  dec(18,8) //总金额
        public double HQty;//  dec(18,8) //税率
        public double HPrice;//  dec(18,8) //总金额
    }
}