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");
}
}
