protected void Btn_U_parameter_Click(object sender, EventArgs e) { DataSet ds = ppl.S_ProProcessParameter(new Guid(Label_PT_ID.Text.Trim()), new Guid(Label_PBCID.Text.Trim())); DataTable dt = ds.Tables[0]; DataView dv = ds.Tables[0].DefaultView; if (dt.Rows.Count == 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('修改失败!您尚未制定工艺参数或合格率标准,您需要先制定!')", true); return; } if (Convert.ToDecimal(Txt_PassRate.Text) > 1 || Convert.ToDecimal(Txt_PassRate.Text) <= 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('合格率标准应该是0至1之间的小数形式')", true); return; } pplinfo.PPP_Parameter = Txt_parameter.Text; pplinfo.PT_ID = new Guid(Label_PT_ID.Text.Trim()); pplinfo.PBC_ID = new Guid(Label_PBCID.Text.Trim()); pplinfo.PPP_Note = TextBox_Note.Text; pplinfo.PPP_PassRate = Convert.ToDecimal(Txt_PassRate.Text); ppl.U_ProProcessParameter(pplinfo); ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('修改成功')", true); Panel_CheckParameter.Visible = false; UpdatePanel_CheckParameter.Update(); Txt_parameter.Text = ""; Txt_PassRate.Text = ""; TextBox_Note.Text = ""; }
protected void Btn_Close_Parameter_Click(object sender, EventArgs e) { Panel_Parameter.Visible = false; Panel_CheckParameter.Visible = false; UpdatePanel_CheckParameter.Update(); GridView_Parameter.SelectedIndex = -1; }
} //行链接按钮命令 protected void Gridview_PS_Editing(object sender, GridViewEditEventArgs e)//显示编辑产品系列状态 { GridView1.SelectedIndex = e.NewEditIndex; GridView1.EditIndex = e.NewEditIndex; if (Label_Grid1_State.Text == "默认数据源") { GridView1.DataSource = ppl.SList_ProSeries(); GridView1.DataBind(); } if (Label_Grid1_State.Text == "模糊搜索数据源") { GridView1.DataSource = ppl.S_ProSeries(Txt_search.Text.Trim()); GridView1.DataBind(); } //绑定数据源 //无关信息隐藏 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 Button_Close_CheckParameter_Click(object sender, EventArgs e) { Panel_CheckParameter.Visible = false; Panel_CheckParameter.Visible = false; UpdatePanel_CheckParameter.Update(); Txt_parameter.Text = ""; Txt_PassRate.Text = ""; }
} //行分页 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Delete1") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; GridView1.SelectedIndex = -1; // this.Lab_State.Text = "Delete1"; string id = e.CommandArgument.ToString(); Guid guid_id = new Guid(id); ppl.D_ProSeries(guid_id); GridView1.DataSource = ppl.SList_ProSeries(); GridView1.DataBind(); UpdatePanel_PS.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(); } if (e.CommandName == "CheckProType") { Panel_PT.Visible = true; GridView2.SelectedIndex = -1; GridView_Parameter.SelectedIndex = -1; GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView1.SelectedIndex = row.RowIndex; string[] al = e.CommandArgument.ToString().Split(new char[] { ',' }); string id = al[0]; Label_PsName.Text = al[1] + " 所属"; Label_PS.Text = id; Guid guid_id = new Guid(id); string condition = " PS_ID='" + id + "'"; GridView2.DataSource = ppl.S_ProSeries_ProType(condition); GridView2.DataBind(); UpdatePanel_PT.Update(); //无关信息隐藏 Panel_AddPS.Visible = false; Panel_AddPT.Visible = false; Panel_CheckParameter.Visible = false; Panel_Parameter.Visible = false; UpdatePanel_AddPS.Update(); UpdatePanel_AddPT.Update(); UpdatePanel_CheckParameter.Update(); UpdatePanel_Parameter.Update(); } } //行链接按钮命令
protected void Button_Close_PT_Click(object sender, EventArgs e) { GridView2.SelectedIndex = -1; GridView_Parameter.SelectedIndex = -1; Panel_PT.Visible = false; Panel_AddPT.Visible = false; UpdatePanel_AddPT.Update(); Panel_Parameter.Visible = false; UpdatePanel_Parameter.Update(); Panel_CheckParameter.Visible = false; UpdatePanel_CheckParameter.Update(); Txt_PT_Search.Text = ""; }
protected void Btn_I_parameter_Click(object sender, EventArgs e) { try { decimal a = Convert.ToDecimal(Txt_PassRate.Text); } catch (Exception) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('合格率标准必须是小数形式')", true); return; } if (Convert.ToDecimal(Txt_PassRate.Text) > 1 || Convert.ToDecimal(Txt_PassRate.Text) < 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('合格率标准应该是0至1之间的小数形式')", true); return; } DataSet ds = ppl.S_ProProcessParameter(new Guid(Label_PT_ID.Text.Trim()), new Guid(Label_PBCID.Text.Trim())); DataTable dt = ds.Tables[0]; DataView dv = ds.Tables[0].DefaultView; if (dt.Rows.Count != 0) { //ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "alert", "alert('已经制定过了工艺参数或合格率标准,您只能修改')", true); //return; pplinfo.PPP_Parameter = Txt_parameter.Text; pplinfo.PT_ID = new Guid(Label_PT_ID.Text.Trim()); pplinfo.PBC_ID = new Guid(Label_PBCID.Text.Trim()); pplinfo.PPP_Note = TextBox_Note.Text; pplinfo.PPP_PassRate = Convert.ToDecimal(Txt_PassRate.Text); ppl.U_ProProcessParameter(pplinfo); } else { pplinfo.PPP_Parameter = Txt_parameter.Text; pplinfo.PT_ID = new Guid(Label_PT_ID.Text.Trim()); pplinfo.PBC_ID = new Guid(Label_PBCID.Text.Trim()); pplinfo.PPP_Note = TextBox_Note.Text; pplinfo.PPP_PassRate = Convert.ToDecimal(Txt_PassRate.Text); ppl.I_ProProcessParameter(pplinfo); } ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('提交成功')", true); Panel_CheckParameter.Visible = false; UpdatePanel_CheckParameter.Update(); Txt_parameter.Text = ""; Txt_PassRate.Text = ""; TextBox_Note.Text = ""; }
protected void GridView_Parameter_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Check_PT_Parameter") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView_Parameter.SelectedIndex = row.RowIndex; string[] a = e.CommandArgument.ToString().Split(new char[] { ',' }); string pbcid = a[0]; Label_PBCID.Text = pbcid; Panel_CheckParameter.Visible = true; UpdatePanel_CheckParameter.Update(); Guid guid_id = new Guid(pbcid); DataSet ds = ppl.S_ProProcessParameter(new Guid(Label_PT_ID.Text.Trim()), guid_id); DataTable dt = ds.Tables[0]; DataView dv = ds.Tables[0].DefaultView; if (dt.Rows.Count == 0) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('您尚未制定工艺参数或合格率标准,请先输入相关参数并制定!您将看到参考的工艺参数和合格率标准')", true); DataSet ds2 = ppl.S_PBCraftInfo(new Guid(Label_PBCID.Text)); DataTable dt2 = ds2.Tables[0]; DataView dv2 = ds2.Tables[0].DefaultView; foreach (DataRowView datav in dv2) { Txt_parameter.Text = datav["PBC_Parameter"].ToString().Trim(); Txt_PassRate.Text = datav["PBC_PassRate"].ToString().Trim(); } // this.Txt_parameter.Text = ""; // this.Txt_PassRate.Text = ""; TextBox_Note.Text = ""; if (!Session["UserRole"].ToString().Contains("产品基础信息维护")) { Panel_CheckParameter.Visible = false; UpdatePanel_CheckParameter.Update(); } return; } foreach (DataRowView datav in dv) { Txt_parameter.Text = datav["PPP_Parameter"].ToString().Trim(); Txt_PassRate.Text = datav["PPP_PassRate"].ToString().Trim(); TextBox_Note.Text = datav["PPP_Note"].ToString().Trim(); } Label_PT2.Text = Label_PTP.Text + " " + a[1] + " "; } }
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 GridView2_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Check_Parameter") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView2.SelectedIndex = row.RowIndex; //无关信息隐藏 Panel_AddPS.Visible = false; Panel_AddPT.Visible = false; Panel_CheckParameter.Visible = false; UpdatePanel_AddPS.Update(); UpdatePanel_AddPT.Update(); UpdatePanel_CheckParameter.Update(); GridView_Parameter.SelectedIndex = -1; string[] al = e.CommandArgument.ToString().Split(new char[] { ',' }); string prid = al[0]; Label_PRID.Text = prid; string ptname = al[1]; string ptid = al[2]; Label_PTP.Text = ptname; Label_PT_ID.Text = ptid; Panel_Parameter.Visible = true; if (prid == "") { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('该产品尚未制定工艺路线!')", true); return; } Guid guid_id = new Guid(prid); GridView_Parameter.DataSource = ppl.S_ProType_ProcessRoute(guid_id); GridView_Parameter.DataBind(); UpdatePanel_Parameter.Update(); } if (e.CommandName == "Delete_PT") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView2.SelectedIndex = row.RowIndex; GridView2.SelectedIndex = -1; //无关信息隐藏 Panel_AddPS.Visible = false; Panel_AddPT.Visible = false; Panel_Parameter.Visible = false; Panel_CheckParameter.Visible = false; UpdatePanel_Parameter.Update(); UpdatePanel_AddPS.Update(); UpdatePanel_AddPT.Update(); UpdatePanel_CheckParameter.Update(); string id = e.CommandArgument.ToString(); Guid guid_id = new Guid(id); ppl.D_ProType(guid_id); string condition; string psid = " PS_ID='" + Label_PS.Text.Trim() + "'"; string pt_name = Txt_PT_Search.Text.Trim() == "" ? "1=1" : "PT_Name like '%" + Txt_PT_Search.Text.Trim() + "%'"; condition = psid + " and " + pt_name; GridView2.DataSource = ppl.S_ProSeries_ProType(condition); GridView2.DataBind(); UpdatePanel_PT.Update(); ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('删除成功!')", true); } if (e.CommandName == "Edit_PT") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; GridView2.SelectedIndex = row.RowIndex; //无关信息隐藏 Panel_AddPS.Visible = false; // this.Panel_AddPT.Visible = false; Panel_Parameter.Visible = false; Panel_CheckParameter.Visible = false; UpdatePanel_Parameter.Update(); UpdatePanel_AddPS.Update(); // this.UpdatePanel_AddPT.Update(); UpdatePanel_CheckParameter.Update(); DropDownList_BOM.DataSource = ppl.S_BOM_Name(); DropDownList_BOM.DataTextField = "BOM_Name"; DropDownList_BOM.DataValueField = "BOM_ID"; DropDownList_BOM.DataBind(); DropDownList_BOM.Items.Insert(0, new ListItem("请选择", "")); DropDownList_PR.DataSource = ppl.S_PR_Name(); DropDownList_PR.DataTextField = "PR_Name"; DropDownList_PR.DataValueField = "PR_ID"; DropDownList_PR.DataBind(); DropDownList_PR.Items.Insert(0, new ListItem("请选择", "")); string[] a = e.CommandArgument.ToString().Split(new char[] { ',' }); string ptname = a[0]; string ptspecial = a[1]; string prid = a[2]; string bomid = a[3]; Label_PT_ID.Text = a[4]; Txt_PT.Text = ptname; Label_ptname.Text = ptname; DropDownList_Special.SelectedValue = ptspecial; DropDownList_PR.Items.FindByValue(prid.ToString().Trim()).Selected = true; DropDownList_BOM.Items.FindByValue(bomid.ToString().Trim()).Selected = true; Label_submitState.Text = "编辑"; Panel_AddPT.Visible = true; UpdatePanel_AddPT.Update(); } }