//检索栏检索按钮 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(); } }