//检索栏检索按钮
protected void Btn_SearchStandard_Click(object sender, EventArgs e)
{
Grid3Cond = ""; //表示grid3绑定模糊查询数据
cond3 = TxtStandard.Text;
cond3R = TxtRemarks.Text;
BindGrid3M(id3, cond3, cond3R);
UpdatePanel_SearchStandard.Update();
}
//检索栏关闭按钮
protected void Btn_ClsStandard_Click(object sender, EventArgs e)
{
TxtStandard.Text = "";
TxtRemarks.Text = "";
Panel_SearchStandard.Visible = false;
UpdatePanel_SearchStandard.Update();
Txt_EditStandard.Text = "";
Txt_EditNote.Text = "";
Panel_EditStandard.Visible = false;
UpdatePanel_EditStandard.Update();
}
//重置
protected void Btn_ResetStandard_Click(object sender, EventArgs e)
{
edit3 = "";
TxtStandard.Text = "";
TxtRemarks.Text = "";
Grid3Cond = "";
cond3 = "";
cond3R = "";
BindGrid3M(id3, cond3, cond3R);
UpdatePanel_SearchStandard.Update();
}
//检索栏关闭按钮
protected void Btn_ClsIQCItems_Click(object sender, EventArgs e)
{
TxtIQCItems.Text = "";
DdlstNeedValue.ClearSelection();
Panel_IQCItemsMgt.Visible = false;
UpdatePanel_IQCItemsMgt.Update();
TxtStandard.Text = "";
TxtRemarks.Text = "";
Panel_SearchStandard.Visible = false;
UpdatePanel_SearchStandard.Update();
Txt_EditItems.Text = "";
Ddl_EditValues.ClearSelection();
Panel_EditItems.Visible = false;
UpdatePanel_EditItems.Update();
Panel_EditStandard.Visible = false;
UpdatePanel_EditStandard.Update();
}
//操作Gridview的命令行
protected void Grid_ItemsValue_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edt_ItemValue")
{
edit3 = "edit";//用“edit”表示处于编辑状态：可以重置、提交、关闭（不能检索、新增），用空表示非编辑状态：可以检索、新增、重置、关闭（不能提交）
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_ItemsValue.SelectedIndex = row.RowIndex;
GridViewRow gvr = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent));
Guid guid = new Guid(e.CommandArgument.ToString());
iQCBasicDataInfo = iQCBasicDataL.Search_IQCStandardTable_ID(guid)[0];
Txt_EditStandard.Text = iQCBasicDataInfo.IQCIT_Standard;
id3 = iQCBasicDataInfo.IQCIT_ID;
idValue = iQCBasicDataInfo.IQCST_ID;
Txt_EditNote.Text = iQCBasicDataInfo.IQCIT_Remarks;
Panel_EditStandard.Visible = true;
UpdatePanel_EditStandard.Update();
}
if (e.CommandName == "Delete_ItemValue")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_ItemsValue.SelectedIndex = row.RowIndex;
Guid guid = new Guid(e.CommandArgument.ToString());
try
{
iQCBasicDataL.Delete_IQCStandardTable(guid);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除成功！')", true);
Grid3Cond = "";
cond3 = "";
cond3R = "";
BindGrid3M(id3, cond3, cond3R);
UpdatePanel_SearchStandard.Update();
}
}
protected void Btn_EditSubmitStandard_Click(object sender, EventArgs e)
{
if (edit3 == "")
{
if (Txt_EditStandard.Text == "")
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('标记*的为必填项，请填写完整！')", true);
return;
}
IQCBasicDataInfo IQC = new IQCBasicDataInfo();
IQC.IQCIT_ID = id3;
IQC.IQCIT_Standard = Txt_EditStandard.Text;
IQC.IQCIT_Remarks = Txt_EditNote.Text;
try
{
if (iQCBasicDataL.Insert_IQCStandardTable(IQC) <= 0)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('该检验标准已经存在！')", true);
return;
}
//expTestL.Insert_ExpSampleType(expSampleType_ExpItems);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('新增失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('新增成功！')", true);
Txt_EditStandard.Text = "";
Txt_EditNote.Text = "";
Grid3Cond = "";
cond3 = "";
cond3R = "";
BindGrid3M(id3, cond3, cond3R);
UpdatePanel_SearchStandard.Update();
}
if (edit3 != "")
{
if (Txt_EditStandard.Text == "")
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('标记*的为必填项，请填写完整！')", true);
return;
}
iQCBasicDataInfo.IQCST_ID = idValue;
iQCBasicDataInfo.IQCIT_ID = id3;
iQCBasicDataInfo.IQCIT_Standard = Txt_EditStandard.Text;
iQCBasicDataInfo.IQCIT_Remarks = Txt_EditNote.Text;
try
{
if (iQCBasicDataL.Update_IQCStandardTable(iQCBasicDataInfo) <= 0)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('该检验标准已经存在！')", true);
return;
}
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('编辑失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('编辑成功！')", true);
edit3 = "";
Txt_EditStandard.Text = "";
Txt_EditNote.Text = "";
Grid3Cond = "";
cond3 = "";
cond3R = "";
BindGrid3M(id3, cond3, cond3R);
UpdatePanel_SearchStandard.Update();
Panel_EditStandard.Visible = false;
}
UpdatePanel_EditStandard.Update();
}
//操作Gridview的命令行
protected void Grid_IQCItems_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edt_ItemValue")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_IQCItems.SelectedIndex = row.RowIndex;
GridViewRow gvr = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent));
id3 = new Guid(e.CommandArgument.ToString());
BindGrid3(id3);
Grid3Cond = "id";//用id表示grid3绑定id检索，用空表示grid3绑定模糊检索
Panel_SearchStandard.Visible = true;
UpdatePanel_SearchStandard.Update();
}
if (e.CommandName == "Edt_Item")
{
edit2 = "edit";
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_IQCItems.SelectedIndex = row.RowIndex;
GridViewRow gvr = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent));
Guid guid = new Guid(e.CommandArgument.ToString());
iQCBasicDataInfo = iQCBasicDataL.Search_IQCItemsTable_ID(guid)[0];
Txt_EditItems.Text = iQCBasicDataInfo.IQCIT_Items;
id2 = iQCBasicDataInfo.IMMBD_MaterialID;
idItem = iQCBasicDataInfo.IQCIT_ID;
if (iQCBasicDataInfo.IQCIT_NeedValue == "是")
{
Ddl_EditValues.SelectedValue = "1";
}
else if (iQCBasicDataInfo.IQCIT_NeedValue == "否")
{
Ddl_EditValues.SelectedValue = "2";
}
Panel_EditItems.Visible = true;
UpdatePanel_EditItems.Update();
}
if (e.CommandName == "Delete_Item")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_IQCItems.SelectedIndex = row.RowIndex;
Guid guid = new Guid(e.CommandArgument.ToString());
try
{
iQCBasicDataL.Delete_IQCItemsTable(guid);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除成功！')", true);
if (guid == id3)//若删除的检验项目打开了子级检验标准，则关闭子级窗口
{
TxtStandard.Text = "";
TxtRemarks.Text = "";
Panel_SearchStandard.Visible = false;
UpdatePanel_SearchStandard.Update();
}
Grid2Cond = "";
cond2 = " IMMBD_MaterialID='" + Convert.ToString(id2) + "' ";
BindGrid2M(cond2);
UpdatePanel_IQCItemsMgt.Update();
}
}
//操作Gridview的命令行
protected void Grid_Material_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edt_Item")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_Material.SelectedIndex = row.RowIndex;
GridViewRow gvr = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent));
id2 = new Guid(e.CommandArgument.ToString());
BindGrid2(id2);
Grid2Cond = "id";//用id表示grid2绑定id检索，用空表示grid2绑定模糊检索
TxtIQCItems.Text = "";
DdlstNeedValue.ClearSelection();
Panel_IQCItemsMgt.Visible = true;
UpdatePanel_IQCItemsMgt.Update();
}
if (e.CommandName == "Delete_Item")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_Material.SelectedIndex = row.RowIndex;
Guid guid = new Guid(e.CommandArgument.ToString());
try
{
if (iQCBasicDataL.Delete_IMMaterialBasicData_IQC(guid) <= 0)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('该物料不属于检验物料，无法删除！')", true);
return;
}
//expTestL.Insert_ExpSampleType(expSampleType_ExpItems);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除成功！')", true);
if (guid == id2)//如果点击的检验项目维护与所删除的是同一列，则关闭子级窗口
{
TxtIQCItems.Text = "";
DdlstNeedValue.ClearSelection();
Panel_IQCItemsMgt.Visible = false;
UpdatePanel_IQCItemsMgt.Update();
TxtStandard.Text = "";
TxtRemarks.Text = "";
Panel_SearchStandard.Visible = false;
UpdatePanel_SearchStandard.Update();
}
BindGrid1(cond1);
UpdatePanel_GridMaterial.Update();
}
if (e.CommandName == "Chs_Item")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_Material.SelectedIndex = row.RowIndex;
Guid guid = new Guid(e.CommandArgument.ToString());
try
{
if (iQCBasicDataL.Insert_IMMaterialBasicData_IQC(guid) <= 0)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('该物料已经属于检验物料！')", true);
return;
}
//expTestL.Insert_ExpSampleType(expSampleType_ExpItems);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('新增失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('新增成功！')", true);
BindGrid1(cond1);
UpdatePanel_GridMaterial.Update();
}
}
