//Gridview编辑设备类型 protected void Grid_EquipType_RowUpdating(object sender, GridViewUpdateEventArgs e) { Guid eTT_ID = new Guid(Grid_EquipType.DataKeys[e.RowIndex].Value.ToString()); //类型不为空 if (((TextBox)(Grid_EquipType.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim().ToString() == "") { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('设备类型不能为空!')", true); return; } string eTT_Type = Convert.ToString(((TextBox)(Grid_EquipType.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim().ToString()); DataSet ds = equipTypeL.Search_EquipTypeTableInfo("and ETT_Type = '" + eTT_Type + " '"); DataTable dt = ds.Tables[0]; if (dt.Rows.Count != 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('系统中已有该设备类型名称,不能重名!')", true); return; } Grid_EquipType.EditIndex = -1; eMEquipTypeTableInfo.ETT_ID = eTT_ID; eMEquipTypeTableInfo.ETT_Type = eTT_Type; equipTypeL.Update_EquipTypeTableInfo(eMEquipTypeTableInfo); BindGrid_EquipType(""); Txtname.Text = ""; UpdatePanel_Search.Update(); UpdatePanel_TypeItem.Update(); }
//取消编辑 protected void Grid_EquipType_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { Grid_EquipType.EditIndex = -1; Txtname.Text = ""; UpdatePanel_Search.Update(); BindGrid_EquipType(""); }
//取消编辑 protected void Grid_EquipUpkeepItem_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { Grid_EquipUpkeepItem.EditIndex = -1; Textname.Text = ""; Textitems.Text = ""; Textperiod.Text = ""; UpdatePanel_Search.Update(); BindGrid_EquipUpkeepItem(""); }
protected void Btn_Clear_Click(object sender, EventArgs e) { Grid_EquipType.EditIndex = -1; Txtname.Text = ""; UpdatePanel_Search.Update(); BindGrid_EquipType(""); UpdatePanel_TypeItem.Update(); Panel_NewType.Visible = false; UpdatePanel_NewType.Update(); }
protected void BtnReset_Click(object sender, EventArgs e) { startime.Text = ""; endtime.Text = ""; textno.Text = ""; textname.Text = ""; UpdatePanel_Search.Update(); Panel_Grid.Visible = false; UpdatePanel_Grid.Update(); }
//检索物料类别 protected void SelectMaterialType(object sender, EventArgs e) { label_Mattypesource.Text = "search"; BindGridView_MatType(); UpdatePanel_MatType.Update(); Panel_Search.Visible = false; UpdatePanel_Search.Update(); Panel_MaterBasicData.Visible = false; UpdatePanel_MaterBasicData.Update(); }
//打开统计数据维护 protected void Senior_DetailOPEN_Click(object sender, EventArgs e) { Panel_Grid.Visible = false; UpdatePanel_Grid.Update(); Senior_DetailOPEN.Visible = false; Senior_DetailCLOSE.Visible = true; Panel1.Visible = true; UpdatePanel1.Update(); BindGridView1(" and EN_Output is not null and EN_WorkTime is not null and EN_Output!=-1 and EN_WorkTime!=-1"); UpdatePanel_Search.Update(); }
//打开统计数据维护 protected void Senior_DetailOPEN_Click(object sender, EventArgs e) { Panel_Grid.Visible = false; this.UpdatePanel_Grid.Update(); Senior_DetailOPEN.Visible = false; Senior_DetailCLOSE.Visible = true; Panel1.Visible = true; UpdatePanel1.Update(); BindGridView1(" and EN_OperationTime is not null and EN_Limit is not null and EN_OperationTime!=-1 and EN_Limit!=-1"); UpdatePanel_Search.Update(); panelGraph.Visible = false; UpdatepanelGraph.Update(); }
protected void Btn_Clear_Click(object sender, EventArgs e) { Grid_EquipUpkeepItem.EditIndex = -1; Textname.Text = ""; Textitems.Text = ""; Textperiod.Text = ""; UpdatePanel_Search.Update(); BindGrid_EquipUpkeepItem(""); UpdatePanel_Item.Update(); Panel_searchname.Visible = false; Panel_New.Visible = false; UpdatePanel_New.Update(); }
//检索设备台账 protected void Btn_Search_Click(object sender, EventArgs e) { string condition = GetCondition(); BindGrid_EquipInfo(condition); Panel_InfoItem.Visible = true; UpdatePanel_InfoItem.Update(); UpdatePanel_Search.Update(); Panel_EditInfo.Visible = false; UpdatePanel_EditInfo.Update(); Panel_searchname.Visible = false; Panel_NewInfo.Visible = false; UpdatePanel_NewInfo.Update(); }
protected void Button_SearchReset_Click(object sender, EventArgs e) { Label_Grid1_State.Text = "默认数据源"; Txt_search.Text = ""; GridView1.DataSource = upload.SList_TemplateUpload(); GridView1.DataBind(); UpdatePanel_Temp.Update(); UpdatePanel_Search.Update(); GridView1.SelectedIndex = -1; Panel_PT.Visible = false; UpdatePanel_PT.Update(); Panel_Product.Visible = false; UpdatePanel_Product.Update(); }
//Gridview编辑 protected void Grid_EquipUpkeepItem_RowUpdating(object sender, GridViewUpdateEventArgs e) { Guid eUI_ID = new Guid(Grid_EquipUpkeepItem.DataKeys[e.RowIndex]["EUI_ID"].ToString()); Guid eN_ID = new Guid(Grid_EquipUpkeepItem.DataKeys[e.RowIndex]["EN_ID"].ToString()); //项目不为空 if (((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim().ToString() == "") { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('保养项目不能为空!')", true); return; } string eUI_Items = Convert.ToString(((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim().ToString()); //周期不为空 if (((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[4].Controls[0])).Text.Trim().ToString() == "") { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('保养周期不能为空!')", true); return; } decimal m2; if (!(Decimal.TryParse(((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[4].Controls[0])).Text, out m2))) { ScriptManager.RegisterClientScriptBlock(UpdatePanel_New, GetType(), "alert", "alert('保养周期只能为两位小数!')", true); return; } decimal eUI_Period = m2; //short eUI_Period = Convert.ToInt16 (((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[4].Controls[0])).Text.Trim().ToString()); //判断重复 DataSet ds = equipUpkeepItemL.Search_EquipUpkeepItemInfo("and EUI_Items = '" + eUI_Items + " ' and b.EN_ID='" + eN_ID + " ' and EUI_Period='" + eUI_Period + " '"); DataTable dt = ds.Tables[0]; if (dt.Rows.Count != 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('该保养项目未做任何改变!')", true); return; } Grid_EquipUpkeepItem.EditIndex = -1; equipUpkeepItemL.Update_EquipUpkeepItemInfo(eUI_ID, eN_ID, eUI_Items, eUI_Period); BindGrid_EquipUpkeepItem(""); Textname.Text = ""; Textitems.Text = ""; Textperiod.Text = ""; UpdatePanel_Search.Update(); UpdatePanel_Item.Update(); }
//GridView1相关 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { Panel_Name.Visible = false; UpdatePanel_Name.Update(); if (e.CommandName == "Delete_Name")//取消统计 { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; Grid_EquipName.EditIndex = -1; Guid EN_ID = new Guid(Convert.ToString(e.CommandArgument)); sd.Update_EquipmentName_Output(EN_ID, -1, -1); BindGrid_EquipName(" and (EN_Output is null or EN_Output=-1) and (EN_WorkTime is null or EN_WorkTime=-1)"); UpdatePanel_Name.Update(); BindGridView1(" and EN_Output is not null and EN_WorkTime is not null and EN_Output!=-1 and EN_WorkTime!=-1"); UpdatePanel_Search.Update(); } }
//重置 protected void Clear(object sender, EventArgs e) //sender是动作,EventArgs是具体的参数 { try { DropDownList1.Items.Insert(0, new ListItem("选择物料类别", "选择物料类别")); BindDropDownList1(); MatName.Text = ""; Model.Text = ""; SafeStock.Text = ""; StockDay.Text = ""; UpdatePanel_Search.Update(); } catch (Exception) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('you make some mistakes ');</script>"); } }
protected void Btn_Clear_Click(object sender, EventArgs e) { DropDownList1.Items.Insert(0, new ListItem("请选择", "")); BindDropDownList1(); Textname.Text = ""; Textmodel.Text = ""; Textno.Text = ""; TextLocation.Text = ""; TextProvidor.Text = ""; DropDownList2.SelectedIndex = 0; TextAcceptDate.Text = ""; DropDownList7.SelectedIndex = 0; UpdatePanel_Search.Update(); BindGrid_EquipInfo(""); UpdatePanel_InfoItem.Update(); Panel_EditInfo.Visible = false; UpdatePanel_EditInfo.Update(); Panel_searchname.Visible = false; Panel_NewInfo.Visible = false; UpdatePanel_NewInfo.Update(); }
protected void Button_Cancel_Click(object sender, EventArgs e) { Label_Grid1_State.Text = "默认数据源"; Txt_search.Text = ""; GridView1.DataSource = ppl.SList_ProSeries(); GridView1.DataBind(); UpdatePanel_PS.Update(); UpdatePanel_Search.Update(); UpdatePanel_AddPS.Update(); //无关信息隐藏 Panel_AddPS.Visible = false; UpdatePanel_AddPS.Update(); GridView1.SelectedIndex = -1; UpdatePanel_PS.Update(); Panel_PT.Visible = false; UpdatePanel_PT.Update(); Panel_Product.Visible = false; UpdatePanel_Product.Update(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownList1.Items.Insert(0, new ListItem("请选择", "请选择")); BindDropDownList1(); DropDownList3.Items.Insert(0, new ListItem("请选择", "请选择")); BindDropDownList3(); Panel_Search.Visible = true; UpdatePanel_Search.Update(); Panel_InfoItem.Visible = true; UpdatePanel_InfoItem.Update(); string condition = ""; BindGrid_EquipInfo(condition); try { if (Request.QueryString["status"].ToString() != "") { Lab_Status.Text = Request.QueryString["status"].ToString(); } if (Lab_Status.Text == "EMInf" && Session["UserRole"].ToString().Contains("设备台账管理")) { Title = "设备台账管理"; } if (Lab_Status.Text == "EMLookInf" && Session["UserRole"].ToString().Contains("设备台账查看")) { Title = "设备台账查看"; Btn_New.Visible = false; Grid_EquipInfo.Columns[14].Visible = false; //编辑 Grid_EquipInfo.Columns[15].Visible = false; //删除 } } catch (Exception) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('可能您没有权限操作和查看本页面,请退出选择其他账号登陆,或联系管理员!')", true); Response.Redirect("~/Default.aspx"); } } }
protected void Button_Cancel_Click(object sender, EventArgs e) //取消搜索产品系列 { Label_Grid1_State.Text = "默认数据源"; Txt_search.Text = ""; GridView1.DataSource = ppl.SList_ProSeries(); GridView1.DataBind(); UpdatePanel_PS.Update(); UpdatePanel_Search.Update(); UpdatePanel_AddPS.Update(); //无关信息隐藏 Panel_PT.Visible = false; Panel_AddPS.Visible = false; Panel_AddPT.Visible = false; Panel_CheckParameter.Visible = false; Panel_Parameter.Visible = false; UpdatePanel_PT.Update(); UpdatePanel_AddPS.Update(); UpdatePanel_AddPT.Update(); UpdatePanel_CheckParameter.Update(); UpdatePanel_Parameter.Update(); }
//新建物料类型-确认 protected void ConfirmMatTypeNew(object sender, EventArgs e) { //try //{ string mattypename = TextBox_NewTypeName.Text.ToString(); string comment = TextArea1.InnerText.ToString(); if (TextBox_NewTypeName.Text.ToString() == "") { ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatTypeNew, GetType(), "alert", "alert('必须填写物料名称')", true); return; } int temp = mat.Select_IMMaterialTypeRepeat(mattypename); if (temp != 0) { ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatTypeNew, GetType(), "alert", "alert('物料类型名称重复,不可以添加!')", true); return; } mat.Insert_MaterialType(mattypename, comment); BindGridView_MatType(); UpdatePanel_MatType.Update(); TextBox_NewTypeName.Text = ""; TextArea1.InnerText = ""; Panel_MatTypeNew.Visible = false; UpdatePanel_MatTypeNew.Update(); BindDropDownList1(); BindDropDownList2(); UpdatePanel_Search.Update(); UpdatePanel_MatBasicDataNew.Update(); ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatTypeNew, GetType(), "alert", "alert('提交成功!')", true); //} //catch (Exception) //{ // Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('you make some mistakes ');</script>"); //} }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Title = "设备保养项目管理"; Panel_Search.Visible = true; UpdatePanel_Search.Update(); string condition = ""; BindGrid_EquipUpkeepItem(condition); try { if (!((Session["UserRole"].ToString().Contains("设备保养项目管理")))) { Response.Redirect("~/Default.aspx"); } } catch (Exception) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('可能您没有权限操作和查看本页面,请退出选择其他账号登陆,或联系管理员!')", true); Response.Redirect("~/Default.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindDropDownList1(); BindDropDownList11(); BindDropDownList111(); BindPlanMain(); BindOrder(); BindMatPlan_Add(); BindMatPlan_Original(); BindMatPlan_Week(); #region 权限 if (Request.QueryString["status"] == "PurchasingPlanLook")//采购计划查看 { Title = "采购计划查看"; Button6.Visible = false; UpdatePanel_Search.Update(); Gridview_MonthPlan.Columns[9].Visible = false; Gridview_MonthPlan.Columns[10].Visible = false; Gridview_MonthPlan.Columns[11].Visible = false; UpdatePanel_MonthPlan.Update(); Gridview_DetailPlan.Columns[11].Visible = false; Gridview_DetailPlan.Columns[12].Visible = false; Gridview_DetailPlan.Columns[13].Visible = false; Button31.Visible = false; Button2.Visible = false; Button33.Visible = false; UpdatePanel_Detail.Update(); } if (Request.QueryString["status"] == "PurchasingPlanEdit")//采购计划维护 { Title = "采购计划维护"; Button6.Visible = true; ButtonPro.Visible = true; Cbx2_SelectAll.Visible = true; Button8.Visible = true; CheckBox1.Visible = true; UpdatePanel_Search.Update(); Gridview_MonthPlan.Columns[9].Visible = true; Gridview_MonthPlan.Columns[10].Visible = false; Gridview_MonthPlan.Columns[11].Visible = true; UpdatePanel_MonthPlan.Update(); Gridview_DetailPlan.Columns[11].Visible = true; Gridview_DetailPlan.Columns[12].Visible = true; Gridview_DetailPlan.Columns[13].Visible = true; Button31.Visible = true; Button2.Visible = false; Button33.Visible = true; UpdatePanel_Detail.Update(); } if (Request.QueryString["status"] == "PurchasingPlanCheck")//采购计划审核 { Title = "采购计划审核"; Button6.Visible = false; UpdatePanel_Search.Update(); Gridview_MonthPlan.Columns[9].Visible = false; Gridview_MonthPlan.Columns[10].Visible = true; Gridview_MonthPlan.Columns[11].Visible = false; UpdatePanel_MonthPlan.Update(); Gridview_DetailPlan.Columns[11].Visible = false; Gridview_DetailPlan.Columns[12].Visible = false; Gridview_DetailPlan.Columns[13].Visible = false; Button31.Visible = false; Button2.Visible = false; Button33.Visible = false; UpdatePanel_Detail.Update(); } if (Request.QueryString["status"] == "PurchasingPlanBuy")//采购计划执行 { Title = "采购计划执行"; ButtonPro.Visible = true; Button8.Visible = true; Button17.Visible = true; Cbx2_SelectAll.Visible = true; CheckBox1.Visible = true; CheckBox3.Visible = true; Button6.Visible = false; UpdatePanel_Search.Update(); Gridview_MonthPlan.Columns[9].Visible = false; Gridview_MonthPlan.Columns[10].Visible = false; Gridview_MonthPlan.Columns[11].Visible = false; UpdatePanel_MonthPlan.Update(); Gridview_DetailPlan.Columns[0].Visible = true; Gridview_DetailPlan.Columns[11].Visible = false; Gridview_DetailPlan.Columns[12].Visible = false; Gridview_DetailPlan.Columns[13].Visible = false; Button31.Visible = false; Button2.Visible = true; Button33.Visible = false; UpdatePanel_Detail.Update(); } if (Request.QueryString["status"] == "PurchasingPlanMatBuy")//材料周计划执行 { Title = "材料周计划执行"; Panel_PMPurchaseOrder.Visible = false; UpdatePanel_PMPurchaseOrder.Update(); Button17.Visible = true; CheckBox3.Visible = true; Panel_Search.Visible = false; UpdatePanel_Search.Update(); Panel_MonthPlan.Visible = false; UpdatePanel_MonthPlan.Update(); Panel_Choose.Visible = true; Button10.Visible = false; Button11.Visible = false; UpdatePanel_Choose.Update(); //this.Label6.Text = "6CFEB693-4DE7-49F9-A0C3-2A89A5B990FB"; BindOrder(); Panel_PMPurchaseOrder.Visible = false; UpdatePanel_PMPurchaseOrder.Update(); } #endregion } }
//重置按钮 protected void BtnReset_Click(object sender, EventArgs e) { startime.Text = ""; endtime.Text = ""; UpdatePanel_Search.Update(); }
//关闭检索栏 protected void ColseMaterialBasicSearch(object sender, EventArgs e) { Panel_Search.Visible = false; UpdatePanel_Search.Update(); }
//打开检索栏 protected void SelectMatBasicData_open(object sender, EventArgs e) { Panel_Search.Visible = true; UpdatePanel_Search.Update(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownList1.Items.Insert(0, new ListItem("选择物料类别", "选择物料类别")); BindDropDownList1(); DropDownList2.Items.Insert(0, new ListItem("选择物料类别", "选择物料类别")); BindDropDownList2(); UpdatePanel_MatType.Visible = true; BindGridView_MatType(); UpdatePanel_MatType.Update(); UpdatePanel_MaterBasicData.Update(); BindDropdownList(); } #region 权限 try { if (!((Session["UserRole"].ToString().Contains("物料基础数据维护")) || (Session["UserRole"].ToString().Contains("物料基础数据查看")))) { Response.Redirect("~/Default.aspx"); } } catch (Exception) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('可能您没有权限操作和查看本页面,请退出选择其他账号登陆,或联系管理员!')", true); Response.Redirect("~/Default.aspx"); } //if (Session["UserRole"].ToString().Contains("物料基础数据查看")) if (Request.QueryString["status"] == "IMMaterialBasicSearch") { { Title = "物料基础数据查看"; Gridview_MatType.Columns[4].Visible = false; Gridview_MatType.Columns[5].Visible = false; Button2.Visible = false; GridView_MaterialBasicData.Columns[11].Visible = false; GridView_MaterialBasicData.Columns[12].Visible = false; Button8.Visible = false; UpdatePanel_Search.Update(); UpdatePanel_MatType.Update(); UpdatePanel_MaterBasicData.Update(); Button12.Visible = false; UpdatePanel1.Update(); } //if (Session["UserRole"].ToString().Contains("物料基础数据维护")) if (Request.QueryString["status"] == "IMMaterialBasicEdit") { Title = "物料基础数据维护"; Gridview_MatType.Columns[4].Visible = true; Gridview_MatType.Columns[5].Visible = true; Button2.Visible = true; GridView_MaterialBasicData.Columns[11].Visible = true; GridView_MaterialBasicData.Columns[12].Visible = true; Button8.Visible = true; UpdatePanel_Search.Update(); UpdatePanel_MatType.Update(); UpdatePanel_MaterBasicData.Update(); Button12.Visible = true; UpdatePanel1.Update(); } #endregion } }