//取消
protected void GridView_Craft_CancelingEdit(object sender, GridViewCancelEditEventArgs e)//取消编辑
{
Grid_Craft.SelectedIndex = -1;
Grid_Craft.EditIndex = -1;
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
//新增
protected void Btn_NewCFCFRoute_Click(object sender, EventArgs e)
{
condSearch4 = "";
LblState.Text = "工艺"; //用“认证”标识grid4处于认证工序检索，“工艺”标识处于认证工艺路线检索
LblGongxuState.Text = "工艺"; //用“认证”标识grid4处于认证工序编辑，“工艺”标识处于认证工艺路线编辑
((BoundField)Grid_Craft.Columns[1]).ReadOnly = true; //注意类型转换，你所操作的列的类型是BoundField
((BoundField)Grid_Craft.Columns[2]).ReadOnly = false;
//TxtOrder.Text = "";
//TxtName.Text = "";
id4 = id3;
IQCBasicDataInfo IQC = new IQCBasicDataInfo();
IQC = iQCBasicDataL.Search_ProType_ID(id3)[0];
LblSCState.Text = IQC.PT_Name;
BindGrid4(id4);
Panel_SearchCraft.Visible = true;
UpdatePanel_SearchCraft.Update();
}
//操作Gridview的命令行
protected void Grid_CFRoute_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete_CFRoute")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_CFCraft.SelectedIndex = row.RowIndex;
Guid guid = new Guid(e.CommandArgument.ToString());
try
{
iQCBasicDataL.Delete_PRDetail_RZR(guid);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除成功！')", true);
BindGrid2(id3);
UpdatePanel_CFRoute.Update();
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
}
//关闭
protected void Btn_ClsCFCFRoute_Click(object sender, EventArgs e)
{
Panel_CFRoute.Visible = false;
UpdatePanel_CFRoute.Update();
if (Panel_GridCFCraft.Visible == false)
{
Panel_SearchCraft.Visible = false;
UpdatePanel_SearchCraft.Update();
}
else if (Panel_GridCFCraft.Visible == true)
{
((BoundField)Grid_Craft.Columns[1]).ReadOnly = false;
((BoundField)Grid_Craft.Columns[2]).ReadOnly = true;
LblState.Text = "认证";
//TxtOrder.Text = "";
//TxtName.Text = "";
id4 = id2;
IQCBasicDataInfo IQC = new IQCBasicDataInfo();
IQC = iQCBasicDataL.Search_ProType_ID(id2)[0];
LblSCState.Text = IQC.PT_Name;
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
}
//更新
protected void GridView_Craft_Updating(object sender, GridViewUpdateEventArgs e)
{
if (LblGongxuState.Text == "认证")
{
Guid id = new Guid(Grid_Craft.DataKeys[e.RowIndex].Values["PRD_ID"].ToString());
int PRD_RenZhengOrder, m1;
if (((TextBox)(Grid_Craft.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim().ToString() == "")
{
try
{
if (iQCBasicDataL.Insert_PRDetail_RZ(id) <= 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('请输入工序或者确认认证工艺路线工序中没有该工序！')", true);
return;
}
// ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "alert", "alert('编辑成功！')", true);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('编辑失败！" + exc + "')", true);
}
}
else
{
if (int.TryParse(((TextBox)(Grid_Craft.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim().ToString(), out m1))
{
PRD_RenZhengOrder = m1;
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('序号请输入整数！')", true);
return;
}
try
{
if (iQCBasicDataL.Update_PRDetail_RZ(id, PRD_RenZhengOrder) <= 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);
return;
}
}
BindGrid2(id2);
UpdatePanel_GridCFCraft.Update();
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
else if (LblGongxuState.Text == "工艺")
{
Guid id = new Guid(Grid_Craft.DataKeys[e.RowIndex].Values["PRD_ID"].ToString());
int PRD_RouteOrder, m1;
if (((TextBox)(Grid_Craft.Rows[e.RowIndex].Cells[2].Controls[0])).Text.Trim().ToString() == "")
{
try
{
if (iQCBasicDataL.Insert_PRDetail_RZR(id) <= 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('请输入工序或者确认认证工序中没有该工序！')", true);
return;
}
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('编辑成功！')", true);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('编辑失败！" + exc + "')", true);
}
}
else
{
if (int.TryParse(((TextBox)(Grid_Craft.Rows[e.RowIndex].Cells[2].Controls[0])).Text.Trim().ToString(), out m1))
{
PRD_RouteOrder = m1;
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('序号请输入整数！')", true);
return;
}
try
{
if (iQCBasicDataL.Update_PRDetail_RZR(id, PRD_RouteOrder) <= 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);
return;
}
}
BindGrid3(id3);
UpdatePanel_CFRoute.Update();
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
Grid_Craft.SelectedIndex = -1;
Grid_Craft.EditIndex = -1;
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
//检索栏检索按钮
//protected void Btn_SearchCraft_Click(object sender, EventArgs e)
//{
// condSearch4 = "search";//用空表示绑定id，用“search”表示绑定检索条件
// if (TxtOrder.Text != "")
// {
// cond = " and PRD_Order like '%' + Ltrim(Rtrim('" + TxtOrder.Text + "'))+'%'";
// }
// if (TxtName.Text != "")
// {
// cond = cond + " and PRD_Order like '%' + Ltrim(Rtrim('" + TxtName.Text + "'))+'%'";
// }
// if (LblState.Text == "认证")
// {
// id4M=Convert.ToString( id2);
// }
// else if (LblState.Text == "工艺")
// {
// id4M = Convert.ToString(id3);
// }
// BindGrid4M(id4M, cond);
// this.UpdatePanel_SearchCraft.Update();
//}
//重置
//protected void Btn_ResetCraft_Click(object sender, EventArgs e)
//{
// condSearch4 = "search";
// TxtOrder.Text = "";
// TxtName.Text = "";
// cond = "";
// if (LblState.Text == "认证")
// {
// id4M = Convert.ToString(id2);
// }
// else if (LblState.Text == "工艺")
// {
// id4M = Convert.ToString(id3);
// }
// BindGrid4M(id4M, cond);
// this.UpdatePanel_SearchCraft.Update();
// UpdatePanel_SearchCraft.Update();
//}
//关闭
//protected void Btn_ClsCraft_Click(object sender, EventArgs e)
//{
// TxtOrder.Text = "";
// TxtName.Text = "";
// Panel_SearchCraft.Visible = false;
// UpdatePanel_SearchCraft.Update();
//}
#endregion
#region 实际工艺路线表Grid4
//操作Gridview的命令行
//protected void Grid_Craft_RowCommand(object sender, GridViewCommandEventArgs e)
//{
// if (e.CommandName == "Edt_Craft")
// {
// GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
// Grid_Craft.SelectedIndex = row.RowIndex;
// Guid guid = new Guid(e.CommandArgument.ToString());
// if (LblState.Text == "认证")
// {
// try
// {
// iQCBasicDataL.Insert_PRDetail_RZ(guid);
// }
// catch (Exception exc)
// {
// ScriptManager.RegisterClientScriptBlock(this.Page, typeof(Page), "alert", "alert('新增失败！" + exc + "')", true);
// }
// BindGrid2(id2);
// UpdatePanel_GridCFCraft.Update();
// BindGrid4(id4);
// UpdatePanel_Craft.Update();
// }
// else if (LblState.Text == "工艺")
// {
// try
// {
// iQCBasicDataL.Insert_PRDetail_RZR(guid);
// }
// catch (Exception exc)
// {
// ScriptManager.RegisterClientScriptBlock(this.Page, typeof(Page), "alert", "alert('新增失败！" + exc + "')", true);
// }
// BindGrid3(id3);
// UpdatePanel_CFRoute.Update();
// BindGrid4(id4);
// UpdatePanel_Craft.Update();
// }
// }
//}
//编辑
protected void GridView_Craft_Editing(object sender, GridViewEditEventArgs e)
{
Grid_Craft.EditIndex = e.NewEditIndex;
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
//检索栏检索其他按钮
//protected void BtnSearchElse_Click(object sender, EventArgs e)
//{
// Grid_ProType.Columns[3].Visible = false;
// Grid_ProType.Columns[4].Visible = false;
// Grid_ProType.Columns[5].Visible = false;
// Grid_ProType.Columns[6].Visible = true;
// LblGridProType.Text = "其他产品型号表";
// condSearch.Text = "QT";//以此变量存储检索栏是否处于检索其他的状态
// if (TxtProSeries.Text != "")
// {
// PS_Name = TxtProSeries.Text;
// }
// if (TxtProType.Text != "")
// {
// PT_Name = TxtProType.Text;
// }
// BindGrid1QT(PS_Name, PT_Name);
// this.UpdatePanel_GridProType.Update();
//}
#endregion
#region 产品型号表Grid1
//操作Gridview的命令行
protected void Grid_ProType_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edt_CFCraft")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_ProType.SelectedIndex = row.RowIndex;
GridViewRow gvr = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent));
id2 = new Guid(e.CommandArgument.ToString());
IQCBasicDataInfo IQC = new IQCBasicDataInfo();
IQC = iQCBasicDataL.Search_ProType_ID(id2)[0];
LblRZState.Text = IQC.PT_Name;
BindGrid2(id2);
Panel_GridCFCraft.Visible = true;
UpdatePanel_GridCFCraft.Update();
Panel_CFRoute.Visible = false;
UpdatePanel_CFRoute.Update();
condSearch4 = "";
LblState.Text = "认证"; //用“认证”标识grid4处于认证工序检索，“工艺”标识处于认证工艺路线检索
LblGongxuState.Text = "认证"; //用“认证”标识grid4处于认证工序编辑，“工艺”标识处于认证工艺路线编辑
((BoundField)Grid_Craft.Columns[1]).ReadOnly = false; //注意类型转换，你所操作的列的类型是BoundField
((BoundField)Grid_Craft.Columns[2]).ReadOnly = true;
id4 = id2;
IQCBasicDataInfo IQC1 = new IQCBasicDataInfo();
IQC1 = iQCBasicDataL.Search_ProType_ID(id2)[0];
LblSCState.Text = IQC1.PT_Name;
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
if (e.CommandName == "Edt_CFRoute")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_ProType.SelectedIndex = row.RowIndex;
GridViewRow gvr = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent));
id3 = new Guid(e.CommandArgument.ToString());
IQCBasicDataInfo IQC = new IQCBasicDataInfo();
IQC = iQCBasicDataL.Search_ProType_ID(id3)[0];
LblRTState.Text = IQC.PT_Name;
BindGrid3(id3);
Panel_CFRoute.Visible = true;
UpdatePanel_CFRoute.Update();
Panel_GridCFCraft.Visible = false;
UpdatePanel_GridCFCraft.Update();
condSearch4 = "";
LblState.Text = "工艺"; //用“认证”标识grid4处于认证工序检索，“工艺”标识处于认证工艺路线检索
LblGongxuState.Text = "工艺"; //用“认证”标识grid4处于认证工序编辑，“工艺”标识处于认证工艺路线编辑
((BoundField)Grid_Craft.Columns[1]).ReadOnly = true; //注意类型转换，你所操作的列的类型是BoundField
((BoundField)Grid_Craft.Columns[2]).ReadOnly = false;
id4 = id3;
IQCBasicDataInfo IQC1 = new IQCBasicDataInfo();
IQC1 = iQCBasicDataL.Search_ProType_ID(id3)[0];
LblSCState.Text = IQC1.PT_Name;
BindGrid4(id4);
UpdatePanel_SearchCraft.Update();
}
if (e.CommandName == "Delete_ProType")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_ProType.SelectedIndex = row.RowIndex;
Guid guid = new Guid(e.CommandArgument.ToString());
try
{
iQCBasicDataL.Delete_ProType_RZ(guid);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('删除成功！')", true);
BindGrid1RZ(PS_Name, PT_Name);
UpdatePanel_GridProType.Update();
}
if (e.CommandName == "Chs_ProType")
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_ProType.SelectedIndex = row.RowIndex;
Guid guid = new Guid(e.CommandArgument.ToString());
try
{
iQCBasicDataL.Insert_ProType_RZ(guid);
}
catch (Exception exc)
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('新增失败！" + exc + "')", true);
}
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('新增成功！')", true);
BindGrid1QT(PS_Name, PT_Name);
UpdatePanel_GridProType.Update();
}
}