//模糊查询物料名称 protected void SelectMatBasicData(object sender, EventArgs e) { try { Label_BasicData_Source.Text = "模糊查询数据源"; string condition = GetCondition(); BindGridView_MatBasicData_Serarch(condition); if (DropDownList1.SelectedValue != "") { Label17.Text = Gridview_MatType.Rows[0].Cells[1].Text.ToString(); Gridview_MatType.DataSource = mat.Select_MaterialTypeCondition("and IMMt_MaterialTypeID='" + DropDownList1.SelectedValue.ToString() + "'"); Gridview_MatType.DataBind(); UpdatePanel_MatType.Update(); } else { Label17.Text = "检索的"; UpdatePanel_MatType.Update(); } Panel_MaterBasicData.Visible = true; UpdatePanel_MaterBasicData.Update(); //this.MatName.Text = ""; //this.Model.Text = ""; //this.SafeStock.Text = ""; //this.StockDay.Text = ""; } catch (Exception) { //throw; ScriptManager.RegisterClientScriptBlock(UpdatePanel_Search, GetType(), "alert", "alert('you make some mistakes')", true); } }
//检索物料类别 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(); }
//Gridview编辑物料类型 protected void Gridview_MatType_RowUpdating(object sender, GridViewUpdateEventArgs e) { Guid mattypeid = new Guid(Gridview_MatType.DataKeys[e.RowIndex].Value.ToString()); string mattypename = Convert.ToString(((TextBox)(Gridview_MatType.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim().ToString()); string comment = Convert.ToString(((TextBox)(Gridview_MatType.Rows[e.RowIndex].Cells[2].Controls[0])).Text.Trim().ToString()); //BindGridView_MatType(); mat.Update_MaterialType(mattypeid, mattypename, comment); Gridview_MatType.EditIndex = -1; BindGridView_MatType(); UpdatePanel_MatType.Update(); Panel_MatTypeNew.Visible = false; UpdatePanel_MatTypeNew.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>"); //} }
//根据条件控制gridview每列的显示 protected void Gridview_MatType_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Look1") //点击查看物料名称 { GridViewRow gvr = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent)); //first parent :rows,second parent:gridview; label_mattypeid.Text = Convert.ToString(gvr.RowIndex); label_mattypeid.Text = Convert.ToString(e.CommandArgument); Label_BasicData_Source.Text = "Gridview数据源"; string iid = e.CommandArgument.ToString(); Panel_MaterBasicData.Visible = true; BindGridView_MatBasicData_Gridview(iid); Label17.Text = Gridview_MatType.Rows[gvr.RowIndex].Cells[1].Text.ToString() + "的"; Panel_MaterBasicData.Visible = true; UpdatePanel_MaterBasicData.Update(); } if (e.CommandName == "Delete1") { Guid mattypeid = new Guid(Convert.ToString(e.CommandArgument)); mat.Delete_MaterialType(mattypeid); BindGridView_MatType(); UpdatePanel_MatType.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 } }