销售出库添加字段（申请出库数量、库存数量、申请采购数量）

yusijie

2025-03-31 ebf11be449b2c91d4158d1d8917e521a04ed59c9

销售出库添加字段（申请出库数量、库存数量、申请采购数量）

 DAL/仓库管理/ClsKf_SellOutBillForLayUI.cs

@@ -220,7 +220,7 @@
                     ",HSPID,HSCWHID,HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" +
                     ",HQty_Full,HQty_Empty,HQty_Back,HCostPrice,HCostMoney,HSalePrice" +
                     ",HPropertyID,HSecUnitID,HSecUnitRate" +
                     ",HEngineNum,HUnderPanNum,HLeaveFactCard" +
                     ",HEngineNum,HUnderPanNum,HLeaveFactCard,HReqBuyQty,HReqOutQty,HCurrentInventory" +
                     ") values(" +
                     "" + omodel.HInterID.ToString() + "" +
                     "," + (HEntryID++) + "" +
@@ -275,6 +275,9 @@
                     ",'" + oSub.HEngineNum + "'" +
                     ",'" + oSub.HUnderPanNum + "'" +
                     ",'" + oSub.HLeaveFactCard + "'" +
                     "," + oSub.HReqBuyQty +
                     "," + oSub.HReqOutQty +
                     "," + oSub.HCurrentInventory +
                     ") ";

                    oCn.RunProc(subSql);
@@ -465,7 +468,7 @@
                      ",HSPID,HSCWHID,HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" +
                      ",HQty_Full,HQty_Empty,HQty_Back,HCostPrice,HCostMoney,HSalePrice" +
                      ",HPropertyID,HSecUnitID,HSecUnitRate" +
                      ",HEngineNum,HUnderPanNum,HLeaveFactCard" +
                      ",HEngineNum,HUnderPanNum,HLeaveFactCard,HReqBuyQty,HReqOutQty,HCurrentInventory" +
                      ") values(" +
                      "" + omodel.HInterID.ToString() + "" +
                      "," + (HEntryID++) + "" +
@@ -520,6 +523,9 @@
                      ",'" + oSub.HEngineNum + "'" +
                      ",'" + oSub.HUnderPanNum + "'" +
                      ",'" + oSub.HLeaveFactCard + "'" +
                      "," + oSub.HReqBuyQty +
                      "," + oSub.HReqOutQty + 
                      "," + oSub.HCurrentInventory +
                      ") ";

                    oCn.RunProc(subSql);

 Model/仓库管理/ClsKf_SellOutBillSub.cs

@@ -43,5 +43,8 @@
        public double HQty_Full;  //婊¤溅閲嶉噺
        public double HQty_Empty;  //绌鸿溅閲嶉噺
        public double HQty_Back;  //鍥炶溅閲嶉噺
        public double HReqBuyQty;  //鐢宠閲囪喘鏁伴噺
        public double HReqOutQty;  //鐢宠鍑哄簱鏁伴噺
        public double HCurrentInventory;  //褰撳墠搴撳瓨
    }
}