//模糊查询物料名称
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>");
}
}
