//追加补货信息
private void btnADDOK_Click(object sender, EventArgs e)
{
if (this.s_Specifications.Text.Trim() == string.Empty)
{
MessageBoxEx.Show("产品规格不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Specifications.Focus();
return;
}
if (this.s_Price.Text.Trim() == string.Empty)
{
MessageBoxEx.Show("产品单价不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Price.Focus();
return;
}
if (!IsNumber(this.s_Price.Text.Trim()))
{
MessageBoxEx.Show("产品单价只能为数字,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Price.Focus();
return;
}
if (this.s_Amount.Text.Trim() == string.Empty)
{
MessageBoxEx.Show("产品数量不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Amount.Focus();
return;
}
if (!IsNumber(this.s_Amount.Text.Trim()))
{
MessageBoxEx.Show("产品数量只能为数字,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Amount.Focus();
return;
}
HY_Model.HY_Storage hystormodel = new HY_Model.HY_Storage();
hystormodel.S_DID = this.s_DID.Text;
hystormodel.S_CID = this.s_CID.Text;
hystormodel.S_Person = this.s_Person.Text;
hystormodel.S_Class = this.s_Class.Text;
hystormodel.S_Warehouse = this.s_Warehouse.Text;
hystormodel.S_XDate = Convert.ToDateTime(this.s_XDate.Value);
hystormodel.S_DDate = Convert.ToDateTime(this.s_DDate.Value);
hystormodel.S_PID = this.s_PID.Text;
hystormodel.S_Pname = this.s_Pname.Text.Trim();
hystormodel.S_Specifications = this.s_Specifications.Text.Trim();
hystormodel.S_Amount = int.Parse(this.s_Amount.Text.Trim());
hystormodel.S_Price = int.Parse(this.s_Price.Text.Trim());
hystormodel.S_Notes = this.s_Notes.Text.Trim();
string str_DID = this.listView1.SelectedItems[0].SubItems[0].Text;
HY_BLL.HY_StorageBLL hystorbll = new HY_StorageBLL();
string sql = "update HY_Storage set s_Amount=s_Amount+'" + hystormodel.S_Amount + "',s_Price='" + hystormodel.S_Price + "' where s_PID='" + str_DID + "'";
int res = hystorbll.com_HY_HY_Storagelslist(sql);
if (res > 0)
{
//写入log库存表
string sqllog = "insert into HY_StorageLog(s_DID,s_CID,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Specifications,s_Amount,s_Price,s_Notes,s_State) values('" + hystormodel.S_DID + "','" + hystormodel.S_CID + "','" + hystormodel.S_Person + "','" + hystormodel.S_Class + "','" + hystormodel.S_Warehouse + "','" + hystormodel.S_XDate + "','" + hystormodel.S_DDate + "','" + hystormodel.S_PID + "','" + hystormodel.S_Pname + "','" + hystormodel.S_Specifications + "','" + hystormodel.S_Amount + "','" + hystormodel.S_Price + "','" + hystormodel.S_Notes + "','添加补货')";
hystorbll.com_HY_HY_Storagelslist(sqllog);
MessageBoxEx.Show("预警产品追加成功,确认后继续追加！", "操作提示", MessageBoxButtons.OK);
string sql4 = "select * from HY_Storage order by s_ID desc";
requistionDate(sql4);
}
}
private void toolStripSave_Click(object sender, EventArgs e)
{
if (this.s_Person.Text == string.Empty)
{
MessageBoxEx.Show("入库人姓名不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_Person.Focus();
return;
}
if (this.s_CID.Text == string.Empty)
{
MessageBoxEx.Show("厂内编号不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_CID.Focus();
return;
}
if (this.s_Supplier.Text == string.Empty)
{
MessageBoxEx.Show("供应商名称不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_Supplier.Focus();
return;
}
if (this.s_DDate.Text == "")
{
MessageBoxEx.Show("到货日期不能为空！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_DDate.Focus();
return;
}
if (this.s_XDate.Text == "")
{
MessageBoxEx.Show("入库日期不能为空！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_XDate.Focus();
return;
}
if (this.s_Price.Text == string.Empty)
{
MessageBoxEx.Show("产品单价不能为空", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_Price.Focus();
return;
}
HY_Model.HY_Storage hystormodel = new HY_Model.HY_Storage();
hystormodel.S_DID = this.s_DID.Text;
hystormodel.S_CID = this.s_CID.Text.Trim();
hystormodel.S_Person = this.s_Person.Text.Trim();
hystormodel.S_Class = this.s_Class.Text;
hystormodel.S_Warehouse = this.s_Warehouse.Text;
hystormodel.S_XDate = Convert.ToDateTime(this.s_XDate.Value);
hystormodel.S_DDate = Convert.ToDateTime(this.s_DDate.Value);
hystormodel.S_PID = this.s_PID.Text;
hystormodel.S_Pname = this.s_Pname.Text.Trim();
hystormodel.S_Specifications = this.s_Specifications.Text.Trim();
hystormodel.S_Units = this.s_Units.Text.Trim();
hystormodel.S_Amount = int.Parse(this.s_Amount.Text.Trim());
hystormodel.S_Price = float.Parse(this.s_Price.Text.Trim());
hystormodel.S_Notes = this.s_Notes.Text.Trim();
hystormodel.S_Origin = this.s_Origin.Text.Trim();
hystormodel.S_Supplier = this.s_Supplier.Text.Trim();
if (intFalg == 1)
{
string sql = "insert into HY_Storage(s_DID,s_CID,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Specifications,s_Units,s_Amount,s_Price,s_Notes,s_Origin,s_Supplier) values('" + hystormodel.S_DID + "','" + hystormodel.S_CID + "','" + hystormodel.S_Person + "','" + hystormodel.S_Class + "','" + hystormodel.S_Warehouse + "','" + hystormodel.S_XDate + "','" + hystormodel.S_DDate + "','" + hystormodel.S_PID + "','" + hystormodel.S_Pname + "','" + hystormodel.S_Specifications + "','" + hystormodel.S_Units + "','" + hystormodel.S_Amount + "','" + hystormodel.S_Price + "','" + hystormodel.S_Notes + "','" + hystormodel.S_Origin + "','" + hystormodel.S_Supplier + "')";
int res = hystorbll.com_HY_HY_Storagelslist(sql);
if (res > 0)
{
//写入log库存表
string sqllog = "insert into HY_StorageLog(s_DID,s_CID,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Specifications,s_Units,s_Amount,s_Price,s_Notes,s_Origin,s_Supplier) values('" + hystormodel.S_DID + "','" + hystormodel.S_CID + "','" + hystormodel.S_Person + "','" + hystormodel.S_Class + "','" + hystormodel.S_Warehouse + "','" + hystormodel.S_XDate + "','" + hystormodel.S_DDate + "','" + hystormodel.S_PID + "','" + hystormodel.S_Pname + "','" + hystormodel.S_Specifications + "','" + hystormodel.S_Units + "','" + hystormodel.S_Amount + "','" + hystormodel.S_Price + "','" + hystormodel.S_Notes + "','" + hystormodel.S_Origin + "','" + hystormodel.S_Supplier + "')";
hystorbll.com_HY_HY_Storagelslist(sqllog);
MessageBoxEx.Show("产品入库成功，确定后可继续添加", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.None);
requistionDate();
f_PID(); //品号
f_CID(); //单号
this.s_CID.Focus();
this.s_CID.Text = "";
this.s_Person.Text = "";
this.s_Class.Text = "";
this.s_Warehouse.Text = "";
this.s_Pname.Text = "";
this.s_Specifications.Text = "";
this.s_Amount.Text = "";
this.s_Price.Text = "";
this.s_Notes.Text = "";
}
}
if (intFalg == 2)
{
string sql = "Update HY_Storage set s_DID='" + hystormodel.S_DID + "',s_CID='" + hystormodel.S_CID + "',s_Person='" + hystormodel.S_Person + "',s_Class='" + hystormodel.S_Class + "',s_Warehouse='" + hystormodel.S_Warehouse + "',s_XDate='" + Convert.ToDateTime(this.s_XDate.Value) + "',s_DDate='" + Convert.ToDateTime(this.s_DDate.Value) + "',s_Pname='" + hystormodel.S_Pname + "',s_Specifications='" + hystormodel.S_Specifications + "',s_Amount='" + hystormodel.S_Amount + "',s_Price='" + hystormodel.S_Price + "',s_Notes='" + hystormodel.S_Notes + "' where s_PID='" + hystormodel.S_PID + "'";
int res = hystorbll.com_HY_HY_Storagelslist(sql);
if (res > 0)
{
//写入log库存表
//string sqllog = "insert into HY_StorageLog(s_DID,s_CID,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Specifications,s_Amount,s_Price,s_Notes) values('" + hystormodel.S_DID + "','" + hystormodel.S_CID + "','" + hystormodel.S_Person + "','" + hystormodel.S_Class + "','" + hystormodel.S_Warehouse + "','" + hystormodel.S_XDate + "','" + hystormodel.S_DDate + "','" + hystormodel.S_PID + "','" + hystormodel.S_Pname + "','" + hystormodel.S_Specifications + "','" + hystormodel.S_Amount + "','" + hystormodel.S_Price + "','" + hystormodel.S_Notes + "')";
//hystorbll.com_HY_HY_Storagelslist(sqllog);
MessageBoxEx.Show("产品修改成功，确定后可继续操作", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.None);
f_Back();
requistionDate();
this.s_CID.Text = "";
this.s_Person.Text = "";
this.s_Class.Text = "";
this.s_Warehouse.Text = "";
this.s_Pname.Text = "";
this.s_Specifications.Text = "";
this.s_Amount.Text = "";
this.s_Price.Text = "";
this.s_Notes.Text = "";
this.groupBox1.Enabled = false;
this.groupBox2.Enabled = false;
this.groupBox3.Enabled = true;
}
}
}
private void toolStripSave_Click(object sender, EventArgs e)
{
if (this.s_Person.Text == string.Empty)
{
MessageBoxEx.Show("入库人姓名不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_Person.Focus();
return;
}
if (this.s_CID.Text == string.Empty)
{
MessageBoxEx.Show("厂内编号不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_CID.Focus();
return;
}
if (this.s_Supplier.Text == string.Empty)
{
MessageBoxEx.Show("供应商名称不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_Supplier.Focus();
return;
}
if (this.s_DDate.Text == "")
{
MessageBoxEx.Show("到货日期不能为空！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_DDate.Focus();
return;
}
if (this.s_XDate.Text == "")
{
MessageBoxEx.Show("入库日期不能为空！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_XDate.Focus();
return;
}
if (this.s_Price.Text == string.Empty)
{
MessageBoxEx.Show("产品单价不能为空", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.s_Price.Focus();
return;
}
HY_Model.HY_Storage hystormodel = new HY_Model.HY_Storage();
hystormodel.S_DID = this.s_DID.Text;
hystormodel.S_CID = this.s_CID.Text.Trim();
hystormodel.S_Person = this.s_Person.Text.Trim();
hystormodel.S_Class = this.s_Class.Text;
hystormodel.S_Warehouse = this.s_Warehouse.Text;
hystormodel.S_XDate = Convert.ToDateTime(this.s_XDate.Value);
hystormodel.S_DDate = Convert.ToDateTime(this.s_DDate.Value);
hystormodel.S_PID = this.s_PID.Text;
hystormodel.S_Pname = this.s_Pname.Text.Trim();
hystormodel.S_Specifications = this.s_Specifications.Text.Trim();
hystormodel.S_Units = this.s_Units.Text.Trim();
hystormodel.S_Amount = int.Parse(this.s_Amount.Text.Trim());
hystormodel.S_Price = float.Parse(this.s_Price.Text.Trim());
hystormodel.S_Notes = this.s_Notes.Text.Trim();
hystormodel.S_Origin = this.s_Origin.Text.Trim();
hystormodel.S_Supplier = this.s_Supplier.Text.Trim();
if (intFalg == 1)
{
string sql = "insert into HY_Storage(s_DID,s_CID,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Specifications,s_Units,s_Amount,s_Price,s_Notes,s_Origin,s_Supplier) values('" + hystormodel.S_DID + "','" + hystormodel.S_CID + "','" + hystormodel.S_Person + "','" + hystormodel.S_Class + "','" + hystormodel.S_Warehouse + "','" + hystormodel.S_XDate + "','" + hystormodel.S_DDate + "','" + hystormodel.S_PID + "','" + hystormodel.S_Pname + "','" + hystormodel.S_Specifications + "','" + hystormodel.S_Units+ "','" + hystormodel.S_Amount + "','" + hystormodel.S_Price + "','" + hystormodel.S_Notes + "','" + hystormodel.S_Origin + "','" + hystormodel.S_Supplier + "')";
int res = hystorbll.com_HY_HY_Storagelslist(sql);
if (res > 0)
{
//写入log库存表
string sqllog = "insert into HY_StorageLog(s_DID,s_CID,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Specifications,s_Units,s_Amount,s_Price,s_Notes,s_Origin,s_Supplier) values('" + hystormodel.S_DID + "','" + hystormodel.S_CID + "','" + hystormodel.S_Person + "','" + hystormodel.S_Class + "','" + hystormodel.S_Warehouse + "','" + hystormodel.S_XDate + "','" + hystormodel.S_DDate + "','" + hystormodel.S_PID + "','" + hystormodel.S_Pname + "','" + hystormodel.S_Specifications + "','" + hystormodel.S_Units+ "','" + hystormodel.S_Amount + "','" + hystormodel.S_Price + "','" + hystormodel.S_Notes + "','" + hystormodel.S_Origin + "','" + hystormodel.S_Supplier + "')";
hystorbll.com_HY_HY_Storagelslist(sqllog);
MessageBoxEx.Show("产品入库成功，确定后可继续添加", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.None);
requistionDate();
f_PID();//品号
f_CID();//单号
this.s_CID.Focus();
this.s_CID.Text = "";
this.s_Person.Text = "";
this.s_Class.Text = "";
this.s_Warehouse.Text = "";
this.s_Pname.Text = "";
this.s_Specifications.Text = "";
this.s_Amount.Text = "";
this.s_Price.Text = "";
this.s_Notes.Text = "";
}
}
if (intFalg == 2)
{
string sql = "Update HY_Storage set s_DID='" + hystormodel.S_DID + "',s_CID='" + hystormodel.S_CID + "',s_Person='" + hystormodel.S_Person + "',s_Class='" + hystormodel.S_Class + "',s_Warehouse='" + hystormodel.S_Warehouse + "',s_XDate='" + Convert.ToDateTime(this.s_XDate.Value) + "',s_DDate='" + Convert.ToDateTime(this.s_DDate.Value) + "',s_Pname='" + hystormodel.S_Pname + "',s_Specifications='" + hystormodel.S_Specifications + "',s_Amount='" + hystormodel.S_Amount + "',s_Price='" + hystormodel.S_Price + "',s_Notes='" + hystormodel.S_Notes + "' where s_PID='" + hystormodel.S_PID + "'";
int res = hystorbll.com_HY_HY_Storagelslist(sql);
if (res > 0)
{
//写入log库存表
//string sqllog = "insert into HY_StorageLog(s_DID,s_CID,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Specifications,s_Amount,s_Price,s_Notes) values('" + hystormodel.S_DID + "','" + hystormodel.S_CID + "','" + hystormodel.S_Person + "','" + hystormodel.S_Class + "','" + hystormodel.S_Warehouse + "','" + hystormodel.S_XDate + "','" + hystormodel.S_DDate + "','" + hystormodel.S_PID + "','" + hystormodel.S_Pname + "','" + hystormodel.S_Specifications + "','" + hystormodel.S_Amount + "','" + hystormodel.S_Price + "','" + hystormodel.S_Notes + "')";
//hystorbll.com_HY_HY_Storagelslist(sqllog);
MessageBoxEx.Show("产品修改成功，确定后可继续操作", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.None);
f_Back();
requistionDate();
this.s_CID.Text = "";
this.s_Person.Text = "";
this.s_Class.Text = "";
this.s_Warehouse.Text = "";
this.s_Pname.Text = "";
this.s_Specifications.Text = "";
this.s_Amount.Text = "";
this.s_Price.Text = "";
this.s_Notes.Text = "";
this.groupBox1.Enabled = false;
this.groupBox2.Enabled = false;
this.groupBox3.Enabled = true;
}
}
}
//追加补货信息
private void btnADDOK_Click(object sender, EventArgs e)
{
if (this.s_Specifications.Text.Trim() == string.Empty)
{
MessageBoxEx.Show("产品规格不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Specifications.Focus();
return;
}
if (this.s_Price.Text.Trim() == string.Empty)
{
MessageBoxEx.Show("产品单价不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Price.Focus();
return;
}
if (!IsNumber(this.s_Price.Text.Trim()))
{
MessageBoxEx.Show("产品单价只能为数字,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Price.Focus();
return;
}
if (this.s_Amount.Text.Trim() == string.Empty)
{
MessageBoxEx.Show("产品数量不能为空,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Amount.Focus();
return;
}
if (!IsNumber(this.s_Amount.Text.Trim()))
{
MessageBoxEx.Show("产品数量只能为数字,请正确填写", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.s_Amount.Focus();
return;
}
HY_Model.HY_Storage hystormodel = new HY_Model.HY_Storage();
hystormodel.S_DID = this.s_DID.Text;
hystormodel.S_CID = this.s_CID.Text;
hystormodel.S_Person = this.s_Person.Text;
hystormodel.S_Class = this.s_Class.Text;
hystormodel.S_Warehouse = this.s_Warehouse.Text;
hystormodel.S_XDate = Convert.ToDateTime(this.s_XDate.Value);
hystormodel.S_DDate = Convert.ToDateTime(this.s_DDate.Value);
hystormodel.S_PID = this.s_PID.Text;
hystormodel.S_Pname = this.s_Pname.Text.Trim();
hystormodel.S_Specifications = this.s_Specifications.Text.Trim();
hystormodel.S_Amount = int.Parse(this.s_Amount.Text.Trim());
hystormodel.S_Price = int.Parse(this.s_Price.Text.Trim());
hystormodel.S_Notes = this.s_Notes.Text.Trim();
string str_DID = this.listView1.SelectedItems[0].SubItems[0].Text;
HY_BLL.HY_StorageBLL hystorbll = new HY_StorageBLL();
string sql = "update HY_Storage set s_Amount=s_Amount+'" + hystormodel.S_Amount + "',s_Price='" + hystormodel.S_Price + "' where s_PID='" + str_DID + "'";
int res = hystorbll.com_HY_HY_Storagelslist(sql);
if (res > 0)
{
//写入log库存表
string sqllog = "insert into HY_StorageLog(s_DID,s_CID,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Specifications,s_Amount,s_Price,s_Notes,s_State) values('" + hystormodel.S_DID + "','" + hystormodel.S_CID + "','" + hystormodel.S_Person + "','" + hystormodel.S_Class + "','" + hystormodel.S_Warehouse + "','" + hystormodel.S_XDate + "','" + hystormodel.S_DDate + "','" + hystormodel.S_PID + "','" + hystormodel.S_Pname + "','" + hystormodel.S_Specifications + "','" + hystormodel.S_Amount + "','" + hystormodel.S_Price + "','" + hystormodel.S_Notes + "','添加补货')";
hystorbll.com_HY_HY_Storagelslist(sqllog);
MessageBoxEx.Show("预警产品追加成功,确认后继续追加！", "操作提示", MessageBoxButtons.OK);
string sql4 = "select * from HY_Storage order by s_ID desc";
requistionDate(sql4);
}
}
