| | |
| | | { |
| | | string subSql = "insert into Cg_POStockInChangeBillSub " + |
| | | "(HInterID,HEntryID,HBillNo_bak,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HMaterID,HUnitID,HQty,HTaxPrice_Old,HTaxPrice_New,HMoney_New) " + |
| | | ",HMaterID,HUnitID,HQty,HTaxPrice_Old,HTaxPrice_New,HMoney_New,HTaxRate_Old,HTaxRate_New) " + |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + |
| | | "," + oSub.HEntryID.ToString() + |
| | |
| | | "," + oSub.HTaxPrice_Old + "" + |
| | | "," + oSub.HTaxPrice_New + "" + |
| | | "," + oSub.HMoney_New + "" + |
| | | "," + oSub.HTaxRate_Old + "" + |
| | | "," + oSub.HTaxRate_New + "" + |
| | | ")"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | |
| | | { |
| | | string subSql = "insert into Cg_POStockInChangeBillSub " + |
| | | "(HInterID,HEntryID,HBillNo_bak,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HMaterID,HUnitID,HQty,HTaxPrice_Old,HTaxPrice_New,HMoney_New) " + |
| | | ",HMaterID,HUnitID,HQty,HTaxPrice_Old,HTaxPrice_New,HMoney_New,HTaxRate_Old,HTaxRate_New) " + |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + |
| | | "," + oSub.HEntryID.ToString() + |
| | |
| | | "," + oSub.HTaxPrice_Old + "" + |
| | | "," + oSub.HTaxPrice_New + "" + |
| | | "," + oSub.HMoney_New + "" + |
| | | "," + oSub.HTaxRate_Old + "" + |
| | | "," + oSub.HTaxRate_New + "" + |
| | | ")"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | |
| | | oSub.HTaxPrice_Old = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HTaxPrice_Old"]); |
| | | oSub.HTaxPrice_New = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HTaxPrice_New"]); |
| | | oSub.HMoney_New = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HMoney_New"]); |
| | | oSub.HTaxRate_Old = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HTaxRate_Old"]); |
| | | oSub.HTaxRate_New = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HTaxRate_New"]); |
| | | |
| | | DetailColl.Add(oSub); |
| | | } |