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); }
private void biSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //判断什么未填写 var nullstr = CheckNull(); if (!string.IsNullOrEmpty(nullstr)) { MessageBox.Show(nullstr + @"必填,请填写完成!", @"必填", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (!WmsFunction.IsNumAndEnCh(txtcLotNo.Text)) { MessageBox.Show(@"请输入正确的批次格式,只允许有数字与字母"); return; } var cmdInvCode = new SqlCommand("select * from iT_Product where cInvCode=@cInvCode"); cmdInvCode.Parameters.AddWithValue("@cInvCode", txtcInvCode.Value); var wfun = new WmsFunction(BaseStructure.WmsCon); if (!wfun.BoolExistTable(cmdInvCode)) { MessageBox.Show(@"产品不正确,请填写完成!", @"必填", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } using (var con = new SqlConnection(BaseStructure.WmsCon)) { using (var cmd = new SqlCommand { CommandType = CommandType.StoredProcedure, Connection = con, CommandTimeout = 180 }) { if (string.IsNullOrEmpty(lblTitleMain.lblAutoID.Text)) { int iSerialQty; if (!int.TryParse(beiSerialQty.EditValue.ToString(), out iSerialQty)) { MessageBox.Show(@"输入的列序数不正确,请输入正整数"); return; } if (iSerialQty < 1 || iSerialQty > 100000) { MessageBox.Show(@"输入的列序数不能小于1,并且不能大于10万"); return; } _cGuid = Guid.NewGuid().ToString(); cmd.CommandText = "proc_Bar_ProductInsert"; var idParameter = new SqlParameter("@AutoID", SqlDbType.Int) { Direction = ParameterDirection.Output }; var cBoNoParameter = new SqlParameter("@cSerialNumber", SqlDbType.NVarChar, 50) { Direction = ParameterDirection.Output }; //获取id的返回值和采购订单号的返回值 cmd.Parameters.Add(idParameter); cmd.Parameters.Add(cBoNoParameter); cmd.Parameters.AddWithValue("@cGuid", _cGuid); cmd.Parameters.AddWithValue("@iSerialQty", iSerialQty); } else { cmd.CommandText = "proc_Bar_ProductUpdate"; cmd.Parameters.AddWithValue("@AutoID", lblTitleMain.lblAutoID.Text); } //赋参数 cmd.Parameters.AddWithValue("@cLotNo", txtcLotNo.Text); cmd.Parameters.AddWithValue("@iQuantity", uneiQuantity.Value); cmd.Parameters.AddWithValue("@dDate", dtpdDate.Value); cmd.Parameters.AddWithValue("@cInvCode", txtcInvCode.Text); cmd.Parameters.AddWithValue("@cInvName", utecInvName.Text); cmd.Parameters.AddWithValue("@cInvPackStd", txtcInvPackStd.Text); cmd.Parameters.AddWithValue("@cInvStd", txtcInvStd.Text); cmd.Parameters.AddWithValue("@cInvPackStyle", txtcInvPackStyle.Text); cmd.Parameters.AddWithValue("@cDefaultVendor", txtcVendor.Text); cmd.Parameters.AddWithValue("@cMassUnit", lblcMassUnit.Text); cmd.Parameters.AddWithValue("@iMassDate", uneiMassDate.Value); cmd.Parameters.AddWithValue("@cKeepRequire", txtcKeepRequire.Text); cmd.Parameters.AddWithValue("@cProperty", ""); cmd.Parameters.AddWithValue("@cMemo", txtcMemo.Text); con.Open(); try { var ieffect = cmd.ExecuteNonQuery(); //判断是否是真的完成了主表的写入 if (ieffect > 0) { if (string.IsNullOrEmpty(lblTitleMain.lblAutoID.Text)) { lblTitleMain.lblAutoID.Text = cmd.Parameters["@AutoID"].Value.ToString(); lblTitleMain.lblcSerialNumber.Text = cmd.Parameters["@cSerialNumber"].Value.ToString(); } } MessageBox.Show(@"保存成功", @"成功", MessageBoxButtons.OK, MessageBoxIcon.Information); SetControlDisable(); SetPanelVlaue(lblTitleMain.lblAutoID.Text); var bPrint = MessageBox.Show(@"是否立即打印", @"是否", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes; if (bPrint) { PrinterDone(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void biSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //判断什么为填写 var nullstr = CheckNull(); if (!string.IsNullOrEmpty(nullstr)) { MessageBox.Show(nullstr + @"必填,请填写完成!", @"必填", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (!WmsFunction.IsNumAndEnCh(txtcLotNo.Text)) { MessageBox.Show(@"请输入正确的批次格式,只允许有数字与字母"); return; } using (var con = new SqlConnection(BaseStructure.WmsCon)) { using (var cmd = new SqlCommand { CommandType = CommandType.StoredProcedure, Connection = con }) { if (string.IsNullOrEmpty(lblTitleMain.lblAutoID.Text)) { cmd.CommandText = "proc_Bar_SemiInsert"; var idParameter = new SqlParameter("@AutoID", SqlDbType.Int) { Direction = ParameterDirection.Output }; var cBoNoParameter = new SqlParameter("@cSerialNumber", SqlDbType.NVarChar, 50) { Direction = ParameterDirection.Output }; //获取id的返回值和采购订单号的返回值 cmd.Parameters.Add(idParameter); cmd.Parameters.Add(cBoNoParameter); } else { cmd.CommandText = "proc_Bar_SemiUpdate"; cmd.Parameters.AddWithValue("@AutoID", lblTitleMain.lblAutoID.Text); } //赋参数 cmd.Parameters.AddWithValue("@cLotNo", txtcLotNo.Text); cmd.Parameters.AddWithValue("@iQuantity", uneiQuantity.Value); cmd.Parameters.AddWithValue("@dDate", dtpdDate.Value); cmd.Parameters.AddWithValue("@cInvCode", txtcInvCode.Text); cmd.Parameters.AddWithValue("@cInvName", utecInvName.Text); cmd.Parameters.AddWithValue("@cInvPackStd", txtcInvPackStd.Text); cmd.Parameters.AddWithValue("@cDefaultSource", txtcDefaultSource.Text); cmd.Parameters.AddWithValue("@cMassUnit", lblcMassUnit.Text); cmd.Parameters.AddWithValue("@iMassDate", uneiMassDate.Value); cmd.Parameters.AddWithValue("@cKeepRequire", txtcKeepRequire.Text); cmd.Parameters.AddWithValue("@cProperty", ""); cmd.Parameters.AddWithValue("@cMemo", txtcMemo.Text); cmd.Parameters.AddWithValue("@dMassDate", dtpdMassDate.Value.Date); con.Open(); try { var ieffect = cmd.ExecuteNonQuery(); //判断是否是真的完成了主表的写入 if (ieffect > 0) { if (string.IsNullOrEmpty(lblTitleMain.lblAutoID.Text)) { lblTitleMain.lblAutoID.Text = cmd.Parameters["@AutoID"].Value.ToString(); lblTitleMain.lblcSerialNumber.Text = cmd.Parameters["@cSerialNumber"].Value.ToString(); } } MessageBox.Show(@"保存成功", @"成功", MessageBoxButtons.OK, MessageBoxIcon.Information); SetControlDisable(); pageChange.GetRecord(); var bPrint = MessageBox.Show(@"是否立即打印", @"是否", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes; if (bPrint) { PrinterDone(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }