示例#1
0
        private void tsbtnUpdate_Click(object sender, EventArgs e)
        {
            if (txtcInvCode.Value == null || string.IsNullOrEmpty(txtcInvCode.Value.ToString()))
            {
                MessageBox.Show(@"产品编码必输");
                return;
            }
            if (!WmsFunction.IsNumAndEnCh(tstxtLotNo.Text))
            {
                MessageBox.Show(@"请输入正确的批次格式,只允许有数字与字母");
                return;
            }
            var cmd = new SqlCommand("update Bar_Product_Box_SerialNumber set cLotNo='" + tstxtLotNo.Text + "' where cSerialNumber in " +
                                     "(select cSerialNumber from View_Bar_Product_Box_SerialNumber where " + pageChange.WhereStr + ")");

            var wf = new WmsFunction(BaseStructure.WmsCon);

            wf.ExecSqlCmd(cmd);
            pageChange.GetRecord();
            DllWmsMain.RecordLogAction(@"周转箱更新批号", BaseStructure.LoginName + " 更新了" + pageChange.WhereStr + "范围的批号  " + tstxtLotNo.Text);
        }