public void clear() { //无关信息隐藏 Panel_PR.Visible = false; Panel_AddOrEditPR.Visible = false; Panel_CraftMgt.Visible = false; Panel_Craft.Visible = false; GridView_CraftMgt.EditIndex = -1; GridView_CraftMgt.SelectedIndex = -1; GridView_PR.EditIndex = -1; GridView_PR.SelectedIndex = -1; UpdatePanel_PR.Update(); UpdatePanel_AddOrEditPR.Update(); UpdatePanel_CraftMgt.Update(); UpdatePanel_Craft.Update(); GridView_Doc.SelectedIndex = -1; TextBox_DocType.Text = ""; TextBox_ApplySN.Text = ""; TextBox_ApplyTime1.Text = ""; TextBox_ApplyTime2.Text = ""; TextBox_AppMan.Text = ""; TextBox_ChagenType.Text = ""; TextBox_DocSN.Text = ""; TextBox_PRName.Text = ""; TextBox_State.Text = ""; TextBox_VersionNum.Text = ""; label_GridPageState.Text = "默认数据源"; string condition = " and 1=1"; GridView_Doc.DataSource = cmpr.S_ProcessRoute_Doc(condition); GridView_Doc.DataBind(); UpdatePanel_Doc.Update(); }
public void dataBind()//检索数据源绑定 { string condition; string CDA_DocName = TextBox_PRName.Text.Trim() == "" ? " and 1=1 " : " and CDA_DocName like '%" + TextBox_PRName.Text.Trim() + "%' "; string CDA_DocNO = TextBox_DocSN.Text.Trim() == "" ? " and 1=1 " : " and CDA_DocNO like '%" + TextBox_DocSN.Text.Trim() + "%' "; string CDA_AppNO = TextBox_ApplySN.Text.Trim() == "" ? " and 1=1 " : " and CDA_AppNO like '%" + TextBox_ApplySN.Text.Trim() + "%' "; string CDA_EditionNO = TextBox_VersionNum.Text.Trim() == "" ? " and 1=1 " : " and CDA_EditionNO like '%" + TextBox_VersionNum.Text.Trim() + "%' "; string CDA_DocType = TextBox_DocType.Text.Trim() == "" ? " and 1=1 " : "and CDA_DocType like '%" + TextBox_DocType.Text.Trim() + "%' "; string CDA_ChangedType = TextBox_ChagenType.Text.Trim() == "" ? " and 1=1 " : "and CDA_ChangedType like '%" + TextBox_ChagenType.Text.Trim() + "%' "; string CDA_AppState = TextBox_State.Text.Trim() == "" ? " and 1=1 " : "and CDA_AppState like '%" + TextBox_State.Text.Trim() + "%' "; string CDA_AppPer = TextBox_AppMan.Text.Trim() == "" ? " and 1=1 " : "and CDA_AppPer like '%" + TextBox_AppMan.Text.Trim() + "%' "; if ((TextBox_ApplyTime1.Text != "" && TextBox_ApplyTime2.Text == "") || (TextBox_ApplyTime1.Text == "" && TextBox_ApplyTime2.Text != "")) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('请将时间检索范围输入完整,请您再次核对!')", true); return; } string CDA_AppTime = (TextBox_ApplyTime1.Text.Trim() == "" && TextBox_ApplyTime2.Text.Trim() == "") ? " and 1=1 " : " and CDA_AppTime between ' " + TextBox_ApplyTime1.Text.Trim() + "' and ' " + TextBox_ApplyTime2.Text.Trim() + "'"; condition = CDA_DocName + CDA_DocNO + CDA_AppNO + CDA_EditionNO + CDA_DocType + CDA_AppState + CDA_AppPer + CDA_AppTime + CDA_ChangedType; GridView_Doc.DataSource = cmpr.S_ProcessRoute_Doc(condition); GridView_Doc.DataBind(); UpdatePanel_Doc.Update(); }
protected void GridView_Doc_PageIndexChanging(object sender, GridViewPageEventArgs e) //工艺文件表分页 { GridView theGrid = sender as GridView; // refer to the GridView int newPageIndex = 0; GridView_Doc.SelectedIndex = -1; if (-2 == e.NewPageIndex) { TextBox txtNewPageIndex = null; GridViewRow pagerRow = GridView_Doc.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_Doc.PageCount ? GridView_Doc.PageCount - 1 : newPageIndex; GridView_Doc.PageIndex = newPageIndex; GridView_Doc.PageIndex = newPageIndex; if (label_GridPageState.Text == "默认数据源") { string condition = " and 1=1"; GridView_Doc.DataSource = cmpr.S_ProcessRoute_Doc(condition); GridView_Doc.DataBind(); UpdatePanel_Doc.Update(); } if (label_GridPageState.Text == "检索数据源") { dataBind(); } Panel_PR.Visible = false; Panel_AddOrEditPR.Visible = false; Panel_CraftMgt.Visible = false; Panel_Craft.Visible = false; GridView_CraftMgt.EditIndex = -1; GridView_CraftMgt.SelectedIndex = -1; GridView_PR.EditIndex = -1; GridView_PR.SelectedIndex = -1; UpdatePanel_PR.Update(); UpdatePanel_AddOrEditPR.Update(); UpdatePanel_CraftMgt.Update(); UpdatePanel_Craft.Update(); GridView_Doc.SelectedIndex = -1; UpdatePanel_Doc.Update(); }
protected void Page_Load(object sender, EventArgs e) //权限判定 { try { if (Request.QueryString["state"] == null) { label_pagestate.Text = "look"; } else { label_pagestate.Text = Request.QueryString["state"]; } string state = label_pagestate.Text; if (state == "look") { Button_AddPR.Visible = false; Title = "工艺路线查看"; GridView_PR.Columns[5].Visible = false; GridView_PR.Columns[6].Visible = false; GridView_CraftMgt.Columns[7].Visible = false; GridView_CraftMgt.Columns[8].Visible = false; Button_AddCraft.Visible = false; Label1.Visible = false; DropDownList1.Visible = false; Button_copy.Visible = false; } if (state == "manage") { Title = "工艺路线管理"; } if (!IsPostBack)//页面初始化 { try { if (!((Session["UserRole"].ToString().Contains("工艺路线查看")) || (Session["UserRole"].ToString().Contains("工艺路线管理")))) { Response.Redirect("~/Default.aspx"); } if (!Session["UserRole"].ToString().Contains("工艺路线管理")) { Button_AddPR.Visible = false; Title = "工艺路线查看"; GridView_PR.Columns[5].Visible = false; GridView_PR.Columns[6].Visible = false; GridView_CraftMgt.Columns[7].Visible = false; GridView_CraftMgt.Columns[8].Visible = false; Button_AddCraft.Visible = false; Label1.Visible = false; DropDownList1.Visible = false; Button_copy.Visible = false; } label_GridPageState.Text = "默认数据源"; string condition = " and 1=1"; GridView_Doc.DataSource = cmpr.S_ProcessRoute_Doc(condition); GridView_Doc.DataBind(); } catch (Exception) { ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('可能您没有权限操作和查看本页面,请退出选择其他账号登陆,或联系管理员!')", true); Response.Redirect("~/Default.aspx"); } } } catch (Exception) { Response.Redirect("~/Default.aspx"); } }