//模糊查询物料名称 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); } }
//点击gridview链接的操作。 protected void GridView_MatBasicData_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Edit2") //编辑 { Panel_MatBasicDataNew.Visible = true; label1_PanelMatBasicState.Text = "修改"; Label19.Text = "修改"; UpdatePanel_MatBasicDataNew.Update(); label1_BasicID.Text = e.CommandArgument.ToString(); Guid id = new Guid(label1_BasicID.Text.ToString()); DataSet ds = mat.Select_IMMaterialBasicData_One(id); DataTable dt = ds.Tables[0]; BindDropDownList2(); BindDropdownList(); //this.DropDownList2.SelectedItem.Text = dt.Rows[0][0].ToString(); DropDownList2.SelectedValue = dt.Rows[0][0].ToString(); TextBox14.Text = "1"; TextBox14.Enabled = true; TextBox_matnamenew.Text = dt.Rows[0][1].ToString(); TextBox_matmodelnew.Text = dt.Rows[0][2].ToString(); TextBox_safenew.Text = dt.Rows[0][3].ToString(); DropDownList4.SelectedValue = dt.Rows[0][9].ToString(); TextBox3.Text = dt.Rows[0][5].ToString(); TextBox5.Text = dt.Rows[0][10].ToString(); TextBox8.Text = dt.Rows[0][13].ToString(); TextBox6.Text = dt.Rows[0][11].ToString(); TextBox7.Text = dt.Rows[0][12].ToString(); //this.DropDownList3.SelectedItem.Text = dt.Rows[0][6].ToString(); if (dt.Rows[0][6].ToString() == "") { DropDownList3.SelectedValue = "否"; } else { DropDownList3.SelectedValue = dt.Rows[0][6].ToString(); } TextBox1.Text = dt.Rows[0][7].ToString(); TextBox4.Text = dt.Rows[0][8].ToString(); label1_BasicID.Text = e.CommandArgument.ToString(); //ScriptManager.RegisterClientScriptBlock(this.UpdatePanel_MatBasicDataNew, this.GetType(), "alert", "alert('必须重新选择物料类型和有害物质选项!')", true); } if (e.CommandName == "Delete2") //删除物料明细 { string iid = e.CommandArgument.ToString(); Guid id = new Guid(iid); mat.Delete_MaterialBasicData(id); if (Label_BasicData_Source.Text == "Gridview数据源") { BindGridView_MatBasicData_Gridview(label_mattypeid.ToString()); } if (Label_BasicData_Source.Text == "模糊查询数据源") { BindGridView_MatBasicData_Serarch(GetCondition()); } UpdatePanel_MaterBasicData.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 CanelMatBasicData(object sender, EventArgs e) { try { Panel_MaterBasicData.Visible = false; UpdatePanel_MaterBasicData.Update(); Panel_MatBasicDataNew.Visible = false; UpdatePanel_MatBasicDataNew.Update(); } 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 } }
//新建物料名称-确认 protected void ConfirmMatBasicDataNew(object sender, EventArgs e) { try { string id = label1_BasicID.Text.ToString(); Guid matid; if (DropDownList2.SelectedItem.Text == "选择物料类型") { ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatBasicDataNew, GetType(), "alert", "alert('请选择对应的物料类别!')", true); return; } if (TextBox_matnamenew.Text.ToString() == "") { ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatBasicDataNew, GetType(), "alert", "alert('请填写物料名称!')", true); return; } Guid mattypeid = new Guid(DropDownList2.SelectedValue.ToString()); string matname = TextBox_matnamenew.Text.ToString(); string model = TextBox_matmodelnew.Text.ToString(); decimal safe; if (TextBox_safenew.Text == "") { safe = Convert.ToDecimal(0); } else { safe = Convert.ToDecimal(TextBox_safenew.Text.ToString()); } int storageday; if (TextBox3.Text.ToString() == "") { storageday = Convert.ToInt32(null); } else { storageday = Convert.ToInt32(TextBox3.Text.ToString()); } int pianshu; if (TextBox8.Text == "") { pianshu = 0; } else { pianshu = Convert.ToInt32(TextBox8.Text.ToString()); } decimal zhuanrate; if (TextBox6.Text == "") { zhuanrate = 0; } else { zhuanrate = Convert.ToDecimal(TextBox6.Text.ToString()); } decimal peiweight; if (TextBox7.Text == "") { peiweight = 0; } else { peiweight = Convert.ToDecimal(TextBox7.Text.ToString()); } string harm = DropDownList3.SelectedItem.ToString(); Guid unit = new Guid(DropDownList4.SelectedValue.ToString()); string comment = TextBox4.Text.ToString(); string para = TextBox1.Text.ToString(); decimal rate = Convert.ToDecimal(TextBox14.Text.ToString()); string code = TextBox5.Text.ToString(); if (label1_PanelMatBasicState.Text == "新建") { int temp = mat.Select_IMMaterialBasicRepeat(matname, model); if (temp != 0) { ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatBasicDataNew, GetType(), "alert", "alert('物料名称和规格型号重复,不可以添加!')", true); return; } } if (label1_PanelMatBasicState.Text == "新建") { mat.Insert_MaterialBasicData(mattypeid, matname, model, safe, storageday, harm, unit, comment, para, code, pianshu, zhuanrate, peiweight); } if (label1_PanelMatBasicState.Text == "修改") { matid = new Guid(label1_BasicID.Text.ToString()); mat.Update_MaterialBasicData(matid, mattypeid, matname, model, safe, storageday, harm, unit, comment, para, rate, code, pianshu, zhuanrate, peiweight); } if (Label_BasicData_Source.Text == "Gridview数据源") { BindGridView_MatBasicData_Gridview(label_mattypeid.Text.ToString()); } if (Label_BasicData_Source.Text == "模糊查询数据源") { BindGridView_MatBasicData_Serarch(labelcodition.Text.ToString()); } UpdatePanel_MaterBasicData.Update(); Panel_MatBasicDataNew.Visible = false; TextBox_matnamenew.Text = ""; TextBox_matmodelnew.Text = ""; TextBox_safenew.Text = ""; TextBox3.Text = ""; TextBox1.Text = ""; TextBox4.Text = ""; UpdatePanel_MatBasicDataNew.Update(); ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatBasicDataNew, GetType(), "alert", "alert('提交成功!')", true); } catch (Exception) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('you make some mistakes ');</script>"); } }