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