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); }