条码生成模块，按库存生成条码时增加写入生产日期、有效期至等

yxj

2023-11-02 5cdd75c0b3a95e96d380a12692e6464113efc96b

 BLL/ϵͳ¹«ÓÃCLS/Cls_S_KF_ICInventoryList_IF.cs

@@ -31,7 +31,7 @@
        public bool Refresh(string sWhere)
        {
            string sErr = "";
            int MainIDCol, SubIDCol, SPIDCol, BatchNoCol, AuxPropIDCol, MTONoCol;
            int MainIDCol, SubIDCol, SPIDCol, BatchNoCol, AuxPropIDCol, MTONoCol, HProduceDateCol, HExpiryDateCol;
            string stmp;
            string tSQL;
            try
@@ -46,6 +46,8 @@
                BatchNoCol = oFrm.Fun_GetCol("批次");
                AuxPropIDCol = oFrm.Fun_GetCol("HAuxPropID");
                MTONoCol = oFrm.Fun_GetCol("计划跟踪号");
                HProduceDateCol = oFrm.Fun_GetCol("生产日期");
                HExpiryDateCol = oFrm.Fun_GetCol("有效期至");
                //
                //循环 é€‰ä¸­è¡Œ
                if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
@@ -59,6 +61,8 @@
                        oSelect.BatchNo = DBUtility.ClsPub.isStrNull(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[BatchNoCol].Value);
                        oSelect.HAuxPropID = DBUtility.ClsPub.isLong(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[AuxPropIDCol].Value);
                        oSelect.BillNo = DBUtility.ClsPub.isStrNull(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[MTONoCol].Value);
                        oSelect.HProduceDate = DBUtility.ClsPub.isDate(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[HProduceDateCol].Value);
                        oSelect.HExpiryDate = DBUtility.ClsPub.isDate(oFrm.grdMain.Rows[oFrm.grdMain.SelectedRows[i].Index].Cells[HExpiryDateCol].Value);
                        oSelect.BillTitle = mvarReportTitle;
                        oSelect.BillType = mvarItemKey;
                        oBillSelectColl.Add(oSelect);