//Gridview编辑设备类型
protected void Grid_EquipType_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Guid eTT_ID = new Guid(Grid_EquipType.DataKeys[e.RowIndex].Value.ToString());
//类型不为空
if (((TextBox)(Grid_EquipType.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim().ToString() == "")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('设备类型不能为空！')", true);
return;
}
string eTT_Type = Convert.ToString(((TextBox)(Grid_EquipType.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim().ToString());
DataSet ds = equipTypeL.Search_EquipTypeTableInfo("and ETT_Type = '" + eTT_Type + " '");
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('系统中已有该设备类型名称，不能重名！')", true);
return;
}
Grid_EquipType.EditIndex = -1;
eMEquipTypeTableInfo.ETT_ID = eTT_ID;
eMEquipTypeTableInfo.ETT_Type = eTT_Type;
equipTypeL.Update_EquipTypeTableInfo(eMEquipTypeTableInfo);
BindGrid_EquipType("");
Txtname.Text = "";
UpdatePanel_Search.Update();
UpdatePanel_TypeItem.Update();
}
//取消编辑
protected void Grid_EquipType_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
Grid_EquipType.EditIndex = -1;
Txtname.Text = "";
UpdatePanel_Search.Update();
BindGrid_EquipType("");
}
//取消编辑
protected void Grid_EquipUpkeepItem_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
Grid_EquipUpkeepItem.EditIndex = -1;
Textname.Text = "";
Textitems.Text = "";
Textperiod.Text = "";
UpdatePanel_Search.Update();
BindGrid_EquipUpkeepItem("");
}
protected void Btn_Clear_Click(object sender, EventArgs e)
{
Grid_EquipType.EditIndex = -1;
Txtname.Text = "";
UpdatePanel_Search.Update();
BindGrid_EquipType("");
UpdatePanel_TypeItem.Update();
Panel_NewType.Visible = false;
UpdatePanel_NewType.Update();
}
protected void BtnReset_Click(object sender, EventArgs e)
{
startime.Text = "";
endtime.Text = "";
textno.Text = "";
textname.Text = "";
UpdatePanel_Search.Update();
Panel_Grid.Visible = false;
UpdatePanel_Grid.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 Senior_DetailOPEN_Click(object sender, EventArgs e)
{
Panel_Grid.Visible = false;
UpdatePanel_Grid.Update();
Senior_DetailOPEN.Visible = false;
Senior_DetailCLOSE.Visible = true;
Panel1.Visible = true;
UpdatePanel1.Update();
BindGridView1(" and EN_Output is not null and EN_WorkTime is not null and EN_Output!=-1 and EN_WorkTime!=-1");
UpdatePanel_Search.Update();
}
//打开统计数据维护
protected void Senior_DetailOPEN_Click(object sender, EventArgs e)
{
Panel_Grid.Visible = false;
this.UpdatePanel_Grid.Update();
Senior_DetailOPEN.Visible = false;
Senior_DetailCLOSE.Visible = true;
Panel1.Visible = true;
UpdatePanel1.Update();
BindGridView1(" and EN_OperationTime is not null and EN_Limit is not null and EN_OperationTime!=-1 and EN_Limit!=-1");
UpdatePanel_Search.Update();
panelGraph.Visible = false;
UpdatepanelGraph.Update();
}
protected void Btn_Clear_Click(object sender, EventArgs e)
{
Grid_EquipUpkeepItem.EditIndex = -1;
Textname.Text = "";
Textitems.Text = "";
Textperiod.Text = "";
UpdatePanel_Search.Update();
BindGrid_EquipUpkeepItem("");
UpdatePanel_Item.Update();
Panel_searchname.Visible = false;
Panel_New.Visible = false;
UpdatePanel_New.Update();
}
//检索设备台账
protected void Btn_Search_Click(object sender, EventArgs e)
{
string condition = GetCondition();
BindGrid_EquipInfo(condition);
Panel_InfoItem.Visible = true;
UpdatePanel_InfoItem.Update();
UpdatePanel_Search.Update();
Panel_EditInfo.Visible = false;
UpdatePanel_EditInfo.Update();
Panel_searchname.Visible = false;
Panel_NewInfo.Visible = false;
UpdatePanel_NewInfo.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();
}
//Gridview编辑
protected void Grid_EquipUpkeepItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Guid eUI_ID = new Guid(Grid_EquipUpkeepItem.DataKeys[e.RowIndex]["EUI_ID"].ToString());
Guid eN_ID = new Guid(Grid_EquipUpkeepItem.DataKeys[e.RowIndex]["EN_ID"].ToString());
//项目不为空
if (((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim().ToString() == "")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('保养项目不能为空！')", true);
return;
}
string eUI_Items = Convert.ToString(((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim().ToString());
//周期不为空
if (((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[4].Controls[0])).Text.Trim().ToString() == "")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('保养周期不能为空！')", true);
return;
}
decimal m2;
if (!(Decimal.TryParse(((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[4].Controls[0])).Text, out m2)))
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel_New, GetType(), "alert", "alert('保养周期只能为两位小数！')", true);
return;
}
decimal eUI_Period = m2;
//short eUI_Period = Convert.ToInt16 (((TextBox)(Grid_EquipUpkeepItem.Rows[e.RowIndex].Cells[4].Controls[0])).Text.Trim().ToString());
//判断重复
DataSet ds = equipUpkeepItemL.Search_EquipUpkeepItemInfo("and EUI_Items = '" + eUI_Items + " ' and b.EN_ID='" + eN_ID + " ' and EUI_Period='" + eUI_Period + " '");
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('该保养项目未做任何改变！')", true);
return;
}
Grid_EquipUpkeepItem.EditIndex = -1;
equipUpkeepItemL.Update_EquipUpkeepItemInfo(eUI_ID, eN_ID, eUI_Items, eUI_Period);
BindGrid_EquipUpkeepItem("");
Textname.Text = "";
Textitems.Text = "";
Textperiod.Text = "";
UpdatePanel_Search.Update();
UpdatePanel_Item.Update();
}
//GridView1相关
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
Panel_Name.Visible = false;
UpdatePanel_Name.Update();
if (e.CommandName == "Delete_Name")//取消统计
{
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
GridView1.SelectedIndex = row.RowIndex;
Grid_EquipName.EditIndex = -1;
Guid EN_ID = new Guid(Convert.ToString(e.CommandArgument));
sd.Update_EquipmentName_Output(EN_ID, -1, -1);
BindGrid_EquipName(" and (EN_Output is null or EN_Output=-1) and (EN_WorkTime is null or EN_WorkTime=-1)");
UpdatePanel_Name.Update();
BindGridView1(" and EN_Output is not null and EN_WorkTime is not null and EN_Output!=-1 and EN_WorkTime!=-1");
UpdatePanel_Search.Update();
}
}
//重置
protected void Clear(object sender, EventArgs e)
//sender是动作,EventArgs是具体的参数
{
try
{
DropDownList1.Items.Insert(0, new ListItem("选择物料类别", "选择物料类别"));
BindDropDownList1();
MatName.Text = "";
Model.Text = "";
SafeStock.Text = "";
StockDay.Text = "";
UpdatePanel_Search.Update();
}
catch (Exception)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('you make some mistakes ');</script>");
}
}
protected void Btn_Clear_Click(object sender, EventArgs e)
{
DropDownList1.Items.Insert(0, new ListItem("请选择", ""));
BindDropDownList1();
Textname.Text = "";
Textmodel.Text = "";
Textno.Text = "";
TextLocation.Text = "";
TextProvidor.Text = "";
DropDownList2.SelectedIndex = 0;
TextAcceptDate.Text = "";
DropDownList7.SelectedIndex = 0;
UpdatePanel_Search.Update();
BindGrid_EquipInfo("");
UpdatePanel_InfoItem.Update();
Panel_EditInfo.Visible = false;
UpdatePanel_EditInfo.Update();
Panel_searchname.Visible = false;
Panel_NewInfo.Visible = false;
UpdatePanel_NewInfo.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 Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownList1.Items.Insert(0, new ListItem("请选择", "请选择"));
BindDropDownList1();
DropDownList3.Items.Insert(0, new ListItem("请选择", "请选择"));
BindDropDownList3();
Panel_Search.Visible = true;
UpdatePanel_Search.Update();
Panel_InfoItem.Visible = true;
UpdatePanel_InfoItem.Update();
string condition = "";
BindGrid_EquipInfo(condition);
try
{
if (Request.QueryString["status"].ToString() != "")
{
Lab_Status.Text = Request.QueryString["status"].ToString();
}
if (Lab_Status.Text == "EMInf" && Session["UserRole"].ToString().Contains("设备台账管理"))
{
Title = "设备台账管理";
}
if (Lab_Status.Text == "EMLookInf" && Session["UserRole"].ToString().Contains("设备台账查看"))
{
Title = "设备台账查看";
Btn_New.Visible = false;
Grid_EquipInfo.Columns[14].Visible = false; //编辑
Grid_EquipInfo.Columns[15].Visible = false; //删除
}
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('可能您没有权限操作和查看本页面，请退出选择其他账号登陆，或联系管理员！')", true);
Response.Redirect("~/Default.aspx");
}
}
}
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 ConfirmMatTypeNew(object sender, EventArgs e)
{
//try
//{
string mattypename = TextBox_NewTypeName.Text.ToString();
string comment = TextArea1.InnerText.ToString();
if (TextBox_NewTypeName.Text.ToString() == "")
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatTypeNew, GetType(), "alert", "alert('必须填写物料名称')", true);
return;
}
int temp = mat.Select_IMMaterialTypeRepeat(mattypename);
if (temp != 0)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatTypeNew, GetType(), "alert", "alert('物料类型名称重复，不可以添加！')", true);
return;
}
mat.Insert_MaterialType(mattypename, comment);
BindGridView_MatType();
UpdatePanel_MatType.Update();
TextBox_NewTypeName.Text = "";
TextArea1.InnerText = "";
Panel_MatTypeNew.Visible = false;
UpdatePanel_MatTypeNew.Update();
BindDropDownList1();
BindDropDownList2();
UpdatePanel_Search.Update();
UpdatePanel_MatBasicDataNew.Update();
ScriptManager.RegisterClientScriptBlock(UpdatePanel_MatTypeNew, GetType(), "alert", "alert('提交成功！')", true);
//}
//catch (Exception)
//{
// Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('you make some mistakes ');</script>");
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Title = "设备保养项目管理";
Panel_Search.Visible = true;
UpdatePanel_Search.Update();
string condition = "";
BindGrid_EquipUpkeepItem(condition);
try
{
if (!((Session["UserRole"].ToString().Contains("设备保养项目管理"))))
{
Response.Redirect("~/Default.aspx");
}
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('可能您没有权限操作和查看本页面，请退出选择其他账号登陆，或联系管理员！')", true);
Response.Redirect("~/Default.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindDropDownList1();
BindDropDownList11();
BindDropDownList111();
BindPlanMain();
BindOrder();
BindMatPlan_Add();
BindMatPlan_Original();
BindMatPlan_Week();
#region 权限
if (Request.QueryString["status"] == "PurchasingPlanLook")//采购计划查看
{
Title = "采购计划查看";
Button6.Visible = false;
UpdatePanel_Search.Update();
Gridview_MonthPlan.Columns[9].Visible = false;
Gridview_MonthPlan.Columns[10].Visible = false;
Gridview_MonthPlan.Columns[11].Visible = false;
UpdatePanel_MonthPlan.Update();
Gridview_DetailPlan.Columns[11].Visible = false;
Gridview_DetailPlan.Columns[12].Visible = false;
Gridview_DetailPlan.Columns[13].Visible = false;
Button31.Visible = false;
Button2.Visible = false;
Button33.Visible = false;
UpdatePanel_Detail.Update();
}
if (Request.QueryString["status"] == "PurchasingPlanEdit")//采购计划维护
{
Title = "采购计划维护";
Button6.Visible = true;
ButtonPro.Visible = true;
Cbx2_SelectAll.Visible = true;
Button8.Visible = true;
CheckBox1.Visible = true;
UpdatePanel_Search.Update();
Gridview_MonthPlan.Columns[9].Visible = true;
Gridview_MonthPlan.Columns[10].Visible = false;
Gridview_MonthPlan.Columns[11].Visible = true;
UpdatePanel_MonthPlan.Update();
Gridview_DetailPlan.Columns[11].Visible = true;
Gridview_DetailPlan.Columns[12].Visible = true;
Gridview_DetailPlan.Columns[13].Visible = true;
Button31.Visible = true;
Button2.Visible = false;
Button33.Visible = true;
UpdatePanel_Detail.Update();
}
if (Request.QueryString["status"] == "PurchasingPlanCheck")//采购计划审核
{
Title = "采购计划审核";
Button6.Visible = false;
UpdatePanel_Search.Update();
Gridview_MonthPlan.Columns[9].Visible = false;
Gridview_MonthPlan.Columns[10].Visible = true;
Gridview_MonthPlan.Columns[11].Visible = false;
UpdatePanel_MonthPlan.Update();
Gridview_DetailPlan.Columns[11].Visible = false;
Gridview_DetailPlan.Columns[12].Visible = false;
Gridview_DetailPlan.Columns[13].Visible = false;
Button31.Visible = false;
Button2.Visible = false;
Button33.Visible = false;
UpdatePanel_Detail.Update();
}
if (Request.QueryString["status"] == "PurchasingPlanBuy")//采购计划执行
{
Title = "采购计划执行";
ButtonPro.Visible = true;
Button8.Visible = true;
Button17.Visible = true;
Cbx2_SelectAll.Visible = true;
CheckBox1.Visible = true;
CheckBox3.Visible = true;
Button6.Visible = false;
UpdatePanel_Search.Update();
Gridview_MonthPlan.Columns[9].Visible = false;
Gridview_MonthPlan.Columns[10].Visible = false;
Gridview_MonthPlan.Columns[11].Visible = false;
UpdatePanel_MonthPlan.Update();
Gridview_DetailPlan.Columns[0].Visible = true;
Gridview_DetailPlan.Columns[11].Visible = false;
Gridview_DetailPlan.Columns[12].Visible = false;
Gridview_DetailPlan.Columns[13].Visible = false;
Button31.Visible = false;
Button2.Visible = true;
Button33.Visible = false;
UpdatePanel_Detail.Update();
}
if (Request.QueryString["status"] == "PurchasingPlanMatBuy")//材料周计划执行
{
Title = "材料周计划执行";
Panel_PMPurchaseOrder.Visible = false;
UpdatePanel_PMPurchaseOrder.Update();
Button17.Visible = true;
CheckBox3.Visible = true;
Panel_Search.Visible = false;
UpdatePanel_Search.Update();
Panel_MonthPlan.Visible = false;
UpdatePanel_MonthPlan.Update();
Panel_Choose.Visible = true;
Button10.Visible = false;
Button11.Visible = false;
UpdatePanel_Choose.Update();
//this.Label6.Text = "6CFEB693-4DE7-49F9-A0C3-2A89A5B990FB";
BindOrder();
Panel_PMPurchaseOrder.Visible = false;
UpdatePanel_PMPurchaseOrder.Update();
}
#endregion
}
}
//重置按钮
protected void BtnReset_Click(object sender, EventArgs e)
{
startime.Text = "";
endtime.Text = "";
UpdatePanel_Search.Update();
}
//关闭检索栏
protected void ColseMaterialBasicSearch(object sender, EventArgs e)
{
Panel_Search.Visible = false;
UpdatePanel_Search.Update();
}
//打开检索栏
protected void SelectMatBasicData_open(object sender, EventArgs e)
{
Panel_Search.Visible = true;
UpdatePanel_Search.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
}
}
