protected void btnSave_Click(object sender, EventArgs e)
{
#region 检查
if (nbxAmount.Text == "0")
{
Alert.ShowInTop("数量不能为0！", "错误", MessageBoxIcon.Error);
nbxAmount.Focus();
return;
}
#endregion
#region 保存
Model.tb_JC_BOMSub modelBOMSub = new Model.tb_JC_BOMSub();
modelBOMSub.ID = Request.QueryString["id"].ToString();
modelBOMSub.MaterialNO = txbMaterialNO.Text;
modelBOMSub.MaterialType = hdfPropertyNO.Text;
modelBOMSub.ParentNO = Request.QueryString["parentNO"].ToString();
modelBOMSub.Amount = decimal.Parse(nbxAmount.Text);
modelBOMSub.BackFlush = ddlBackFlush.SelectedValue;
modelBOMSub.LeadTimeOffset = decimal.Parse(nbxLeadTimeOffset.Text + ".00");
BLL.tb_JC_BOMSub bllBOMSub = new BLL.tb_JC_BOMSub();
bool result = bllBOMSub.Update(modelBOMSub);
if (result)
{
if (result)
{
Alert.ShowInTop("更新成功！", "信息", MessageBoxIcon.Information, ActiveWindow.GetHidePostBackReference("Sub_Modify_Success"));
}
else
{
Alert.ShowInTop("更新失败！", "错误", MessageBoxIcon.Error, ActiveWindow.GetHidePostBackReference("Sub_Modify_Fail"));
}
}
#endregion
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region 检查
//重复查询
StringBuilder strwhere = new StringBuilder();
strwhere.AppendFormat("ParentNO='{0}' and MaterialNO = '{1}'", Request.QueryString["parentNO"], tgbMaterialNO.Text);
BLL.tb_JC_BOMSub bllBOMSub = new BLL.tb_JC_BOMSub();
DataTable dtBOMSub = bllBOMSub.GetList(strwhere.ToString()).Tables[0];
if (dtBOMSub.Rows.Count > 0)
{
Alert.ShowInTop("该项已存在！", "错误", MessageBoxIcon.Error);
return;
}
if (nbxAmount.Text == "0")
{
Alert.ShowInTop("数量不能为0！", "错误", MessageBoxIcon.Error);
nbxAmount.Focus();
return;
}
//嵌套查询
BLL.proc_BOM bllBOM_proc = new BLL.proc_BOM();
int exit = bllBOM_proc.isNesting(Request.QueryString["parentNO"], tgbMaterialNO.Text);
if (Request.QueryString["parentNO"].Equals(tgbMaterialNO.Text))
{
exit = 1;
}
if (exit == 1)
{
Alert.ShowInTop("存在嵌套,不能添加此物料！", "错误", MessageBoxIcon.Error);
return;
}
#endregion
#region 保存
Model.tb_JC_BOMSub modelBOMSub = new Model.tb_JC_BOMSub();
modelBOMSub.ID = Guid.NewGuid().ToString();
modelBOMSub.MaterialNO = tgbMaterialNO.Text;
modelBOMSub.MaterialType = hdfPropertyNO.Text;
modelBOMSub.ParentNO = Request.QueryString["parentNO"].ToString();
modelBOMSub.Amount = decimal.Parse(nbxAmount.Text);
modelBOMSub.BackFlush = ddlBackFlush.SelectedValue;
modelBOMSub.LeadTimeOffset = decimal.Parse(nbxLeadTimeOffset.Text + ".00");
bool result = bllBOMSub.Add(modelBOMSub);
if (result)
{
if (result)
{
Alert.ShowInTop("添加成功！", "信息", MessageBoxIcon.Information, ActiveWindow.GetHidePostBackReference("Sub_Add_Success"));
}
else
{
Alert.ShowInTop("添加失败！", "错误", MessageBoxIcon.Error, ActiveWindow.GetHidePostBackReference("Sub_Add_Fail"));
}
}
#endregion
}
//删除事件
protected void btnDelete_Click(object sender, EventArgs e)
{
FineUI.Button btn = (FineUI.Button)sender;
#region 除主表记录
if (btn.ID == "btnDelete")
{
if (gridBOMSub.RecordCount > 0)
{
Alert.ShowInTop("在删除该项前,请删除所有子项", "错误", MessageBoxIcon.Error);
return;
}
else
{
BLL.tb_JC_BOM bllBOM = new BLL.tb_JC_BOM();
string id = gridBOMParent.DataKeys[gridBOMParent.SelectedRowIndex][0].ToString();
bool result = bllBOM.Delete(id);
if (result)
{
Alert.ShowInTop("删除成功", "信息", MessageBoxIcon.Information);
BindGrid();
}
else
{
Alert.ShowInTop("删除失败", "错误", MessageBoxIcon.Error);
}
return;
}
}
#endregion
#region 除子表记录
if (btn.ID == "btnDeleteSub")
{
BLL.tb_JC_BOMSub bllBOMSub = new BLL.tb_JC_BOMSub();
string id = gridBOMSub.DataKeys[gridBOMSub.SelectedRowIndex][0].ToString();
bool result = bllBOMSub.Delete(id);
if (result)
{
Alert.ShowInTop("删除成功", "信息", MessageBoxIcon.Information);
BindGridSub(gridBOMParent.Rows[gridBOMParent.SelectedRowIndex].Values[1].ToString());
}
else
{
Alert.ShowInTop("删除失败", "错误", MessageBoxIcon.Error);
}
return;
}
#endregion
}
