/// <summary>
/// 新增BOM物料明细
/// </summary>
/// <param name="model">BOM物料明细MODEL实体类</param>
/// <returns></returns>
public int com_HY_BomDetailslist(HY_Model.HY_BomDetails model)
{
try
{
string sql = "insert into HY_BomDetails(d_SKID,d_CID,d_PID,d_PName,d_Model,d_Specifications,d_Amount,d_Heat,d_Notes,d_SPerson,d_ModClass) values('" + model.D_SKID + "','" + model.D_CID + "','" + model.D_PID + "','" + model.D_PName + "','" + model.D_Model + "','" + model.D_Specifications + "','" + model.D_Amount + "','" + model.D_Heat + "','" + model.D_Notes + "','" + model.D_SPerson + "','" + model.ModClass + "')";
HY_DbSqlHelp.DBsqlHelp hy_help = new DBsqlHelp();
int res = hy_help.insertEx(sql);
return(res);
}
catch (Exception EX)
{
throw EX;
}
}
private void toolStripSave_Click(object sender, EventArgs e)
{
#region 数据验证部分
if (!valid.validateNull(this.d_SKID.Text.Trim()))
{
MessageBoxEx.Show("所属物料单号不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_SKID.Focus();
return;
}
if (!valid.validateNull(this.d_Name.Text.Trim()))
{
MessageBoxEx.Show("品名不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Name.Focus();
return;
}
if (!valid.validateNull(this.d_Model.Text.Trim()))
{
MessageBoxEx.Show("材料型号不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Model.Focus();
return;
}
if (!valid.validateNull(this.d_Model.Text.Trim()))
{
MessageBoxEx.Show("材料规格不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Model.Focus();
return;
}
if (!valid.validateNull(this.d_Amount.Text.Trim()))
{
MessageBoxEx.Show("材料数量不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Amount.Focus();
return;
}
else if (!valid.validateNum(this.d_Amount.Text.Trim()))
{
MessageBoxEx.Show("材料数量只能填写数字类型！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Amount.Focus();
return;
}
if (!valid.validateNull(this.d_Heat.Text.Trim()))
{
MessageBoxEx.Show("热处理不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Heat.Focus();
return;
}
#endregion
#region 实体类
HY_Model.HY_BomDetails hybommodel = new HY_Model.HY_BomDetails();
hybommodel.D_SKID = this.d_SKID.Text.Trim();
hybommodel.D_CID = this.d_CID.Text.Trim();
hybommodel.D_PID = this.d_PID.Text.Trim();
hybommodel.D_PName = this.d_Name.Text.Trim();
hybommodel.D_Model = this.d_Model.Text.Trim();
hybommodel.D_Specifications = this.d_Specifications.Text.Trim();
hybommodel.D_Amount = this.d_Amount.Text.Trim();
hybommodel.D_Heat = this.d_Heat.Text.Trim();
hybommodel.D_Notes = this.d_Notes.Text.Trim();
hybommodel.D_SPerson = this.d_SPerson.Text.Trim();
hybommodel.ModClass = this.label1.Text;
#endregion
//保存动作
if (intFalg == 1)
{
//实例化BOM明细
int res = hybombll.com_HY_BomDetailslist(hybommodel);
if (res > 0)
{
MessageBoxEx.Show("BOM明细添加成功，确定后可继续添加明细", "操作提示", MessageBoxButtons.OK);
b_PID();//绑定品号
this.d_Name.Text = "";
this.d_Model.Text = "";
this.d_Specifications.Text = "";
this.d_Amount.Text = "";
this.d_Heat.Text = "";
this.d_Notes.Text = "";
requistionDate();//绑定BOM明细
}
}
//修改动作
if (intFalg == 2)
{
//实例化BOM明细
string sql = "Update HY_BomDetails set d_PID='" + hybommodel.D_PID + "',d_PName='" + hybommodel.D_PName + "',d_Model='" + hybommodel.D_Model + "',d_Specifications='" + hybommodel.D_Specifications + "',d_Amount='" + hybommodel.D_Amount + "',d_Heat='" + hybommodel.D_Heat + "',d_Notes='" + hybommodel.D_Notes + "',d_SPerson='" + hybommodel.D_SPerson + "',d_ModClass='" + hybommodel.ModClass + "' where d_PID='" + hybommodel.D_PID + "'";
int res = hybombll.f_HYBomDetailslist(sql);
if (res > 0)
{
MessageBoxEx.Show("BOM明细信息修改成功！", "操作提示", MessageBoxButtons.OK);
this.groupBoxA.Enabled = false;
this.groupBoxB.Enabled = false;
this.groupBoxC.Enabled = true;
this.d_Name.Text = "";
this.d_Model.Text = "";
this.d_Specifications.Text = "";
this.d_Amount.Text = "";
this.d_Heat.Text = "";
this.d_Notes.Text = "";
requistionDate();//绑定BOM明细
}
}
}
private void toolStripSave_Click(object sender, EventArgs e)
{
#region 数据验证部分
if (!valid.validateNull(this.d_SKID.Text.Trim()))
{
MessageBoxEx.Show("所属物料单号不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_SKID.Focus();
return;
}
if (!valid.validateNull(this.d_Name.Text.Trim()))
{
MessageBoxEx.Show("品名不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Name.Focus();
return;
}
if (!valid.validateNull(this.d_Model.Text.Trim()))
{
MessageBoxEx.Show("材料型号不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Model.Focus();
return;
}
if (!valid.validateNull(this.d_Model.Text.Trim()))
{
MessageBoxEx.Show("材料规格不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Model.Focus();
return;
}
if (!valid.validateNull(this.d_Amount.Text.Trim()))
{
MessageBoxEx.Show("材料数量不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Amount.Focus();
return;
}
else if (!valid.validateNum(this.d_Amount.Text.Trim()))
{
MessageBoxEx.Show("材料数量只能填写数字类型！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Amount.Focus();
return;
}
if (!valid.validateNull(this.d_Heat.Text.Trim()))
{
MessageBoxEx.Show("热处理不能为空！", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.d_Heat.Focus();
return;
}
#endregion
#region 实体类
HY_Model.HY_BomDetails hybommodel = new HY_Model.HY_BomDetails();
hybommodel.D_SKID = this.d_SKID.Text.Trim();
hybommodel.D_CID = this.d_CID.Text.Trim();
hybommodel.D_PID = this.d_PID.Text.Trim();
hybommodel.D_PName = this.d_Name.Text.Trim();
hybommodel.D_Model = this.d_Model.Text.Trim();
hybommodel.D_Specifications = this.d_Specifications.Text.Trim();
hybommodel.D_Amount = this.d_Amount.Text.Trim();
hybommodel.D_Heat = this.d_Heat.Text.Trim();
hybommodel.D_Notes = this.d_Notes.Text.Trim();
hybommodel.D_SPerson = this.d_SPerson.Text.Trim();
hybommodel.ModClass = this.label1.Text;
#endregion
//保存动作
if (intFalg==1)
{
//实例化BOM明细
int res = hybombll.com_HY_BomDetailslist(hybommodel);
if (res > 0)
{
MessageBoxEx.Show("BOM明细添加成功，确定后可继续添加明细","操作提示",MessageBoxButtons.OK);
b_PID();//绑定品号
this.d_Name.Text = "";
this.d_Model.Text = "";
this.d_Specifications.Text = "";
this.d_Amount.Text = "";
this.d_Heat.Text = "";
this.d_Notes.Text = "";
requistionDate();//绑定BOM明细
}
}
//修改动作
if (intFalg == 2)
{
//实例化BOM明细
string sql = "Update HY_BomDetails set d_PID='" + hybommodel.D_PID + "',d_PName='" + hybommodel.D_PName + "',d_Model='" + hybommodel.D_Model + "',d_Specifications='" + hybommodel.D_Specifications + "',d_Amount='" + hybommodel.D_Amount + "',d_Heat='" + hybommodel.D_Heat + "',d_Notes='" + hybommodel.D_Notes + "',d_SPerson='" + hybommodel.D_SPerson + "',d_ModClass='" + hybommodel.ModClass + "' where d_PID='" + hybommodel.D_PID + "'";
int res = hybombll.f_HYBomDetailslist(sql);
if (res > 0)
{
MessageBoxEx.Show("BOM明细信息修改成功！", "操作提示", MessageBoxButtons.OK);
this.groupBoxA.Enabled = false;
this.groupBoxB.Enabled = false;
this.groupBoxC.Enabled = true;
this.d_Name.Text = "";
this.d_Model.Text = "";
this.d_Specifications.Text = "";
this.d_Amount.Text = "";
this.d_Heat.Text = "";
this.d_Notes.Text = "";
requistionDate();//绑定BOM明细
}
}
}
/// <summary>
/// 新增BOM物料明细
/// </summary>
/// <param name="model">BOM物料明细MODEL实体类</param>
/// <returns></returns>
public int com_HY_BomDetailslist(HY_Model.HY_BomDetails model)
{
return(hybomdetal.com_HY_BomDetailslist(model));
}