protected void Button_c_Click(object sender, EventArgs e)
{
Panel1.Visible = false;
UpdatePanel1.Update();
GridView2.SelectedIndex = -1;
UpdatePanel_PT.Update();
}
protected void GridView_ProType_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
GridView_ProType.SelectedIndex = -1;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = GridView_ProType.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox");
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1;
}
}
else
{
newPageIndex = e.NewPageIndex;
}
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= GridView_ProType.PageCount ? GridView_ProType.PageCount - 1 : newPageIndex;
GridView_ProType.PageIndex = newPageIndex;
datebind3();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
GridView_ProType.SelectedIndex = -1;
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
datebind1();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
}
protected void Btn_CloseS_Click(object sender, EventArgs e)
{
GridView1.SelectedIndex = -1;
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
UpdatePanel_PS.Update();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{ // when click the "GO" Button
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = GridView1.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); // refer to the TextBox with the NewPageIndex value
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex
}
}
else
{ // when click the first, last, previous and next Button
newPageIndex = e.NewPageIndex;
}
// check to prevent form the NewPageIndex out of the range
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();
} //绑定数据源
//bindgridview1();
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= GridView1.PageCount ? GridView1.PageCount - 1 : newPageIndex;
// specify the NewPageIndex
GridView1.PageIndex = newPageIndex;
GridView1.PageIndex = newPageIndex;
GridView1.DataBind();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
GridView1.SelectedIndex = -1;
GridView1.EditIndex = -1;
}
} //行分页
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();
}
} //行链接按钮命令
public void databind2()
{
string condition;
string PT_Name = TextBox_PT.Text.Trim() == "" ? " and 1=1 " : " and PT_Name like '%" + TextBox_PT.Text.Trim() + "%' ";
condition = PT_Name;
GridView_PT.DataSource = csl.S_CSName_ProType(label_CSN_ID.Text.Trim(), condition);
GridView_PT.DataBind();
UpdatePanel_PT.Update();
}
protected void Button_Add_Click(object sender, EventArgs e)
{
Panel_AddPS.Visible = true;
UpdatePanel_AddPS.Update();
Panel_Product.Visible = false;
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
UpdatePanel_Product.Update();
GridView1.SelectedIndex = -1;
UpdatePanel_PS.Update();
}
public void databind()
{
string condition;
string TmpUpload_ID = " TmpUpload_ID='" + Label_TmpID.Text.Trim() + "'";
string PT_Name = Txt_PT_Search.Text.Trim() == "" ? " and 1=1 " : " and PT_Name like '%" + Txt_PT_Search.Text.Trim() + "%' ";
string PT_Code = Txt_PT_Search0.Text.Trim() == "" ? " and 1=1 " : " and PT_Code like '%" + Txt_PT_Search0.Text.Trim() + "%' ";
condition = TmpUpload_ID + PT_Name + PT_Code;
GridView2.DataSource = upload.S_TemplatUpload_ProType(condition);
GridView2.DataBind();
UpdatePanel_PT.Update();
}
protected void Button_ClosePT_Click(object sender, EventArgs e)
{
TextBox_PT.Text = "";
TextBox_Series.Text = "";
TextBox_ProductName.Text = "";
Panel_Add.Visible = false;
UpdatePanel_Add.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
}
public void databind()
{
string condition;
string PS_ID = " PS_ID='" + Label_PS.Text.Trim() + "'";
string PT_Name = Txt_PT_Search.Text.Trim() == "" ? " and 1=1 " : " and PT_Name like '%" + Txt_PT_Search.Text.Trim() + "%' ";
string PT_Code = Txt_PT_Search0.Text.Trim() == "" ? " and 1=1 " : " and PT_Code like '%" + Txt_PT_Search0.Text.Trim() + "%' ";
condition = PS_ID + PT_Name + PT_Code;
GridView2.DataSource = ppl.S_ProSeries_ProType(condition);
GridView2.DataBind();
UpdatePanel_PT.Update();
}
protected void Button_Add_Click(object sender, EventArgs e)
{
GridView1.SelectedIndex = -1;
Panel_Product.Visible = true;
GridView_ProType.PageIndex = 0;
GridView1.PageIndex = 0;
GridView1.SelectedIndex = 0;
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
datebind3();
UpdatePanel_PS.Update();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete1")//
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
string id = e.CommandArgument.ToString().Trim();
try
{
Guid guid = new Guid(id);
cs.D_CSUser(guid);
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('删除成功！')", true);
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('删除失败！，请您再核对！')", true);
return;
}
datebind1();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
CheckBox2.Checked = false;
Checkfanxuan2.Checked = false;
}
if (e.CommandName == "CheckProType")//
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
GridView1.SelectedIndex = row.RowIndex;
string[] al = e.CommandArgument.ToString().Split(new char[] { ',' });
Label_HRDD_ID.Text = al[0];
Label_PS.Text = al[1];
Panel_PT.Visible = true;
DropDownList1.DataSource = cs.S_CSUser_PBCName(new Guid(al[0].Trim()));
DropDownList1.DataTextField = "PBC_Name";
DropDownList1.DataValueField = "PBC_ID";
DropDownList1.DataBind();
datebind2();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
CheckBox2.Checked = false;
Checkfanxuan2.Checked = false;
}
}
protected void Button_Cancel_Click(object sender, EventArgs e)
{
Txt_search.Text = "";
TextBox1.Text = "";
TextBox2.Text = "";
datebind1();
GridView1.PageIndex = 0;
GridView1.SelectedIndex = -1;
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
}
protected void Button_Add_Click(object sender, EventArgs e)
{
GridView1.EditIndex = -1;
GridView1.SelectedIndex = -1;
GridView1.DataSource = ppl.SList_WorkOrderCode();
GridView1.DataBind();
UpdatePanel_PS.Update();
Panel_AddPS.Visible = true;
UpdatePanel_AddPS.Update();
Panel_Product.Visible = false;
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
UpdatePanel_Product.Update();
}
protected void GridView_PT_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
GridView_PT.SelectedIndex = -1;
if (-1 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = GridView_PT.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox");
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1;
}
}
else
{
newPageIndex = e.NewPageIndex;
}
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= GridView_PT.PageCount ? GridView_PT.PageCount - 1 : newPageIndex;
GridView_PT.PageIndex = newPageIndex;
GridView_PT.PageIndex = newPageIndex;
databind2();
GridView_PT.SelectedIndex = -1;
GridView_PT.EditIndex = -1;
//各种pannel隐藏
// TextBox_PT.Text = "";
TextBox_Series.Text = "";
TextBox_ProductName.Text = "";
Panel_Add.Visible = false;
UpdatePanel_Add.Update();
Panel_PT.Visible = true;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_Basic.Visible = false;
TextBox_PBC.Text = "";
UpdatePanel_Basic.Update();
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
GridView_CS.EditIndex = -1;
databind1();
Panel_Add.Visible = false;
UpdatePanel_Add.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_Basic.Visible = false;
UpdatePanel_Basic.Update();
Panel1.Visible = false;
UpdatePanel1.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();
}
protected void Button_Cancel_Click(object sender, EventArgs e)
{
GridView_CS.EditIndex = -1;
TextBox_CS_Search.Text = "";
databind1();
Panel_Add.Visible = false;
UpdatePanel_Add.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_Basic.Visible = false;
UpdatePanel_Basic.Update();
Panel1.Visible = false;
UpdatePanel1.Update();
}
protected void GridView_CS_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (((TextBox)(GridView_CS.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim() != label_CSN_Name.Text.Trim())
{
string condition = " and CSN_Name='" + ((TextBox)(GridView_CS.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim() + "'";
DataSet ds = csl.S_CSName(condition);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('系统中已有该产能核定系列名称，请您再次核对！')", true);
// GridView_CS.SelectedIndex = -1;
// GridView_CS.EditIndex = -1;
// return;
}
else
{
try
{
csl.U_CSName(new Guid(GridView_CS.DataKeys[e.RowIndex].Values["CSN_ID"].ToString().Trim()), ((TextBox)(GridView_CS.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim());
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('应输入日期格式！')", true);
return;
}
}
}
GridView_CS.SelectedIndex = -1;
GridView_CS.EditIndex = -1;
//panel 各种隐藏
TextBox_PT.Text = "";
TextBox_Series.Text = "";
TextBox_ProductName.Text = "";
Panel_Add.Visible = false;
UpdatePanel_Add.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
databind1();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_Basic.Visible = false;
TextBox_PBC.Text = "";
UpdatePanel_Basic.Update();
}
protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
GridView2.SelectedIndex = -1;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = GridView2.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox");
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1;
}
}
else
{
newPageIndex = e.NewPageIndex;
}
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= GridView2.PageCount ? GridView2.PageCount - 1 : newPageIndex;
GridView2.PageIndex = newPageIndex;
GridView2.PageIndex = newPageIndex;
databind();
Panel_AddPS.Visible = false;
UpdatePanel_AddPS.Update();
Panel_PT.Visible = true;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
CheckBoxAll.Checked = false;
CheckBoxfanxuan.Checked = false;
CheckBox2.Checked = false;
Checkfanxuan2.Checked = false;
}
protected void Button_AddPTToSeries_Click(object sender, EventArgs e)
{
int sum = 0;
try
{
for (int i = 0; i <= GridView_ProType.Rows.Count - 1; i++)
{
CheckBox CheckBox = (CheckBox)GridView_ProType.Rows[i].FindControl("CheckBox2");
if (CheckBox.Checked == true)
{
ppl.U_Protype_ProSeries(new Guid(Label_PS.Text.Trim()), new Guid(GridView_ProType.DataKeys[i].Values["PT_ID"].ToString().Trim()));
sum++;
}
}
if (sum == 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('您没选择任何要添加的产品型号！请您再核对！')", true);
return;
}
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('添加成功！')", true);
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('添加失败！，请您再核对！')", true);
}
TextBox_ProductName.Text = "";
TextBox_Series.Text = "";
databind();
Panel_AddPS.Visible = false;
UpdatePanel_AddPS.Update();
DataBind();
GridView2.PageIndex = 0;
GridView2.SelectedIndex = -1;
Panel_PT.Visible = true;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
CheckBoxAll.Checked = false;
CheckBoxfanxuan.Checked = false;
CheckBox2.Checked = false;
Checkfanxuan2.Checked = false;
}
protected void GridView_CS_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView_CS.SelectedIndex = -1;
GridView_CS.EditIndex = -1;
databind1();
//panel 各种隐藏
TextBox_PT.Text = "";
TextBox_Series.Text = "";
TextBox_ProductName.Text = "";
Panel_Add.Visible = false;
UpdatePanel_Add.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_Basic.Visible = false;
TextBox_PBC.Text = "";
UpdatePanel_Basic.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 GridView_CS_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView_CS.EditIndex = e.NewEditIndex;
databind1();
label_CSN_Name.Text = GridView_CS.DataKeys[e.NewEditIndex].Values["CSN_Name"].ToString();
//panel 各种隐藏
TextBox_PT.Text = "";
TextBox_Series.Text = "";
TextBox_ProductName.Text = "";
Panel_Add.Visible = false;
UpdatePanel_Add.Update();
Panel_PT.Visible = false;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
Panel_Basic.Visible = false;
TextBox_PBC.Text = "";
UpdatePanel_Basic.Update();
Panel1.Visible = false;
UpdatePanel1.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_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 Btn_deleting_Click(object sender, EventArgs e)
{
int sum = 0;
try
{
for (int i = 0; i <= GridView2.Rows.Count - 1; i++)
{
CheckBox CheckBox = (CheckBox)GridView2.Rows[i].FindControl("CheckBox1");
if (CheckBox.Checked == true)
{
ppl.D_Protype_ProSeries(new Guid(GridView2.DataKeys[i].Values["PT_ID"].ToString().Trim()));
sum++;
}
}
if (sum == 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('您没选择任何要删除的产品型号！请您再核对！')", true);
return;
}
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('删除成功！')", true);
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('删除失败！，请您再核对！')", true);
}
databind();
Panel_AddPS.Visible = false;
UpdatePanel_AddPS.Update();
Panel_PT.Visible = true;
UpdatePanel_PT.Update();
Panel_Product.Visible = false;
UpdatePanel_Product.Update();
CheckBoxAll.Checked = false;
CheckBoxfanxuan.Checked = false;
CheckBox2.Checked = false;
Checkfanxuan2.Checked = false;
}
