protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!Page.IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = GetLocalResourceObject("PageResource1.Title").ToString(); btnDelete.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); hcbYear.Text = DateTime.Now.Year.ToString(); ViewState["BaseSql"] = "select * from " + Session["TableName"]; //模块的查询条件,一般是按年、月、日查询;此变量在“检索”按钮中修改,在此初始化。 btnQuery_Click(null, null); Session["CustomOrder"] = null; } else { //自定义排序页面关闭后,刷新GridView if (Session["CustomOrder"] != null && ViewState["sql"].ToString().IndexOf(Session["CustomOrder"].ToString()) < 0) { if (ViewState["BaseQuery"] != null) //页面自带查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["CustomOrder"]; } else //无查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " order by " + Session["CustomOrder"]; } GridViewBind(); } } }
protected void Page_Load(object sender, EventArgs e) { info = detail_info; if (!IsPostBack) { Session["URL"] = Request["URL"]; PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetDetailPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); if (Request["TID"] == null || Request["TID"] == "") { txtMODULE_ID.Text = Session["FuncId"].ToString(); wdlDATEM.setTime(DateTime.Now); txtSCR.Text = Session["MemberName"].ToString(); txtFILE_PATH.Text = Session["FilePath"].ToString(); } else { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_FILE_SINGLE", "TID=" + Request["TID"]); if (txtFILE_NAME.Text.Trim() != "") { btnUpload.Enabled = false; //已经有文件的不允许再上传 } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetDetailPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); FillDropDownList.FillHtmlCombxByTable(ref hcbWeather, "DMIS_SYS_WEATHER", "NAME", "TID", "ORDER_ID asc"); if (hcbWeather.Items.Count > 0) { hcbWeather.SelectedIndex = 0; } if (Request["date"] != null) { wdlDate.Text = Request["date"]; } else { wdlDate.setTime(DateTime.Now); } btnSave_Click(null, null); } }
protected void Page_Load(object sender, EventArgs e) { info = detail_info; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetDetailPageControlLocalizationText(); object res = GetLocalResourceObject("PageResource1.Title"); if (res != null) { lblFuncName.Text = res.ToString(); } SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); if (Request["TID"] != "") { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, Session["TableName"].ToString(), "TID=" + Request["TID"]); } else { wdlDATEM.setTime(DateTime.Now); txtDEPART_ID.Text = Session["DepartID"].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01")); wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME"); //只有主办者才能抽回 ViewState["BaseSql"] = "SELECT A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN," + "B.F_FLOWNAME,B.f_receiver,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,B.F_NO as F_CurWorkFlowNo,A.F_MSG,B.f_preflowno " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B "; System.Text.StringBuilder BaseCond = new System.Text.StringBuilder(); BaseCond.Append(" where A.F_NO=B.F_PACKNO and A.F_STATUS='1' and b.f_working=0 AND b.F_STATUS='1' AND b.f_sender='" + Session["MemberName"] + "'"); BaseCond.Append(" order by B.f_receivedate desc"); ViewState["sql"] = ViewState["BaseSql"].ToString() + BaseCond.ToString(); GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { info = detail_info; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetDetailPageControlLocalizationText(); lblFuncName.Text = GetLocalResourceObject("PageResource1.Title").ToString(); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); FillDropDownList.FillHtmlCombxByTable(ref hcbWEATHER, "DMIS_SYS_WEATHER", "NAME", "TID", "ORDER_ID"); FillDropDownList.FillHtmlCombxByTable(ref hcbSTATION, "DMIS_SYS_STATION", "NAME", "TID", "ORDER_ID"); if (Request["TID"] != "") { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, Session["TableName"].ToString(), "TID=" + Request["TID"]); } else { txtDISPATCHER.Text = Session["MemberName"].ToString(); wdlSTARTTIME.setTime(DateTime.Now); wdlENDTIME.setTime(DateTime.Now); } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01")); wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME"); ddlStatus.Items.Clear(); ddlStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkStatusWorking").ToString(), "1")); ddlStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkStatusSuspend").ToString(), "3")); ddlStatus.SelectedIndex = -1; //主办人员 ViewState["BaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN,A.PLAN_STARTTIME,A.PLAN_ENDTIME," + "B.F_FLOWNAME,B.f_receiver,B.f_receivedate,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,B.F_NO as F_CurWorkFlowNo,A.F_MSG,B.F_LAST_FINISHED_TIME " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B "; //从办人员 ViewState["OtherBaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN,A.PLAN_STARTTIME,A.PLAN_ENDTIME," + "B.F_FLOWNAME,B.f_receiver,B.f_receivedate,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,B.F_NO as F_CurWorkFlowNo,A.F_MSG,B.F_LAST_FINISHED_TIME " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B,DMIS_SYS_MEMBERSTATUS C "; ViewState["sql"] = ViewState["BaseSql"].ToString() + " WHERE A.F_NO=B.F_PACKNO and A.F_STATUS='1' AND B.F_STATUS='1'"; //主办者 ViewState["OtherSql"] = ViewState["OtherBaseSql"] + " WHERE A.F_NO=B.F_PACKNO AND B.F_NO=C.F_WORKFLOWNO and A.F_NO=C.F_PACKNO and A.F_STATUS='1' AND C.F_STATUS='1'"; //从办者 GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM") + "-01")); wdlEnd.setTime(DateTime.Now); initStation(); ViewState["BaseSql"] = "select * from " + Session["TableName"] + ""; Session["CustomOrder"] = null; } else { //自定义排序页面关闭后,刷新GridView if (Session["CustomOrder"] != null && ViewState["sql"].ToString().IndexOf(Session["CustomOrder"].ToString()) < 0) { if (ViewState["BaseQuery"] != null) //页面自带查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["CustomOrder"]; } else //无查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " order by " + Session["CustomOrder"]; } GridViewBind(); } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01")); wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); ddlStatus.Items.Clear(); ddlStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkStatusAll").ToString(), "0")); //全部 ddlStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkStatusWorking").ToString(), "1")); //在办 ddlStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkStatusFinish").ToString(), "2")); //结案 ddlStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkStatusSuspend").ToString(), "3")); //挂起 ddlStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkStatusAbolish").ToString(), "4")); //作废 ddlStatus.SelectedIndex = 0; FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME"); ViewState["BaseSql"] = "SELECT * from DMIS_SYS_PACK a "; //显示所有的数据 ViewState["sql"] = ViewState["BaseSql"].ToString() + " order by a.f_createdate desc "; //主办者 GridViewBind(); //btnSearch_Click(null, null); } }
protected void Page_Load(object sender, EventArgs e) { info = detail_info; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetDetailPageControlLocalizationText(); lblFuncName.Text = GetLocalResourceObject("PageResource1.Title").ToString(); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); btnDeleteItem.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); if (!btnAppendItem.Enabled) //没有权限修改,则把步骤的编辑列隐藏 { grvList.Columns[grvList.Columns.Count - 1].Visible = false; } FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME", "TID", "ORDER_ID"); if (Request["TID"] != "") { ViewState["DxpTID"] = Request["TID"]; CustomControlFill.CustomControlFillByTableAndWhere(this.Page, Session["TableName"].ToString(), "TID=" + Request["TID"]); initGridView(); } else { ViewState["DxpTID"] = null; } } }
protected void Page_Load(object sender, EventArgs e) { info = detail_info; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetDetailPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); if (Request["TID"] == null || Request["TID"] == "") { txtMODULE_ID.Text = Session["FuncId"].ToString(); wdlNEW_DATE.setTime(DateTime.Now); txtMEMBER.Text = Session["MemberName"].ToString(); } else { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_FILE_INFO", "TID=" + Request["TID"]); _sql = "select * from T_FILE_ACCESSORIES where FILE_ID=" + Request["TID"]; _dt = DBOpt.dbHelper.GetDataTable(_sql); grvUpFileList.DataSource = _dt; grvUpFileList.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["ColumnStyle"] != null) { if (Session["ColumnStyle"].ToString() == "0") //二列 { generateControlByTwoColumn(); } else //一列 { generateControlByOneColumn(); } } if (!IsPostBack) { if (Request["FuncId"] == null) { return; } PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetDetailPageControlLocalizationText(); _sql = "select * from DMIS_SYS_TREEMENU where ID=" + Request["FuncId"]; DataTable treeMenu = DBOpt.dbHelper.GetDataTable(_sql); if (treeMenu.Rows.Count < 1) { return; } if (Session["Culture"] == null || Session["Culture"].ToString() == "zh-CN") { lblFuncName.Text = treeMenu.Rows[0]["NAME"] == Convert.DBNull ? "" : treeMenu.Rows[0]["NAME"].ToString(); } else { lblFuncName.Text = treeMenu.Rows[0]["OTHER_LANGUAGE_DESCR"] == Convert.DBNull ? "" : treeMenu.Rows[0]["OTHER_LANGUAGE_DESCR"].ToString(); } //_sql = "select DISPLAY_STYLE from DMIS_SYS_TABLES where ID=" + Session["MainTableId"].ToString(); //obj = DBOpt.dbHelper.ExecuteScalar(_sql); //if (Session["ColumnStyle"] == null || Session["ColumnStyle"].ToString() == "0") //二列 //{ // Session["ColumnStyle"] = 0; // generateControlByTwoColumn(); //} //else //一列 //{ // Session["ColumnStyle"] = 1; // generateControlByOneColumn(); //} SetRight.SetPageRight(this.Page, Request["FuncId"].ToString(), Session["RoleIDs"].ToString()); if (Request["TID"] != "") { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, Session["TableName"].ToString(), "TID=" + Request["TID"]); } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01")); wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME"); //主办人员 ViewState["BaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN,A.PLAN_STARTTIME,A.PLAN_ENDTIME," + "B.F_FLOWNAME,B.f_receiver,B.f_receivedate,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,B.F_NO as F_CurWorkFlowNo,A.F_MSG,B.F_LAST_INCEPT_TIME " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B "; //从办人员 ViewState["OtherBaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN,A.PLAN_STARTTIME,A.PLAN_ENDTIME," + "B.F_FLOWNAME,B.f_receiver,B.f_receivedate,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,C.f_workflowno as F_CurWorkFlowNo,A.F_MSG,B.F_LAST_INCEPT_TIME " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B,DMIS_SYS_MEMBERSTATUS C "; //针对处理实体类型是岗位时,先构造条件 System.Text.StringBuilder entiCond = new System.Text.StringBuilder(); string[] roles = Session["RoleIDs"].ToString().Split(','); string temp; for (int i = 0; i < roles.Length; i++) { temp = "," + roles[i] + ","; entiCond.Append("INSTR(',' || b.enti_id || ',','" + temp + "')>0 or "); } System.Text.StringBuilder BaseCond = new System.Text.StringBuilder(); System.Text.StringBuilder OtherCond = new System.Text.StringBuilder(); BaseCond.Append(" WHERE A.F_NO=B.F_PACKNO and A.F_STATUS='1' and B.F_STATUS='1'" //从办人员的状态不显示在待办中 + " AND ((B.F_RECEIVER='" + Session["MemberName"] + "' and B.F_WORKING=0) or " + "(b.enti_type='0' and (b.f_receiver='' or b.f_receiver is null) and (" + entiCond.Remove(entiCond.Length - 3, 3).ToString() + "))) "); OtherCond.Append(" where A.F_NO=B.F_PACKNO and A.F_NO=C.F_PACKNO and b.F_NO=c.f_workflowno and A.F_STATUS='1' and c.F_STATUS='1' and " + "B.F_WORKING=0 and c.F_RECEIVER='" + Session["MemberName"].ToString() + "' "); //处理从办人员 BaseCond.Append(" order by B.F_SENDDATE desc"); OtherCond.Append(" order by B.F_SENDDATE desc"); ViewState["sql"] = ViewState["BaseSql"].ToString() + BaseCond.ToString(); //主办者 ViewState["OtherSql"] = ViewState["OtherBaseSql"] + OtherCond.ToString(); //从办者 GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!Page.IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = GetLocalResourceObject("PageResource1.Title").ToString(); btnDelete.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); ViewState["BaseSql"] = "select * from " + Session["TableName"] + ""; //模块的查询条件,一般是按年、月、日查询;此变量在“检索”按钮中修改,在此初始化。 ViewState["BaseQuery"] = "to_char(STARTTIME,'YYYYMM')='" + DateTime.Now.ToString("yyyyMM") + "'"; if (Session["Orders"] == null) //平台中没有设置排序条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"]; } else { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["Orders"]; } GridViewBind(); Session["CustomOrder"] = null; } else { //自定义排序页面关闭后,刷新GridView if (Session["CustomOrder"] != null && ViewState["sql"].ToString().IndexOf(Session["CustomOrder"].ToString()) < 0) { if (ViewState["BaseQuery"] != null) //页面自带查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["CustomOrder"]; } else //无查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " order by " + Session["CustomOrder"]; } GridViewBind(); return; } //新增时,关闭新增窗口,控制刷新此页面 //if (Session["NeedRefesh"] != null && Session["NeedRefesh"].ToString() == "是") //{ // GridViewBind(); // Session["NeedRefesh"] = "否"; // return; //} } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; if (!IsPostBack) { SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); btnDelete.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); initShift(); ViewState["BaseSql"] = "select * from T_DD_RUNNING_LOG"; Session["CustomOrder"] = null; //找最新的当值记录 _sql = "select DATEM,SHIFT from T_DD_SHIFT where FLAG=1 order by DATEM desc,SHIFT desc"; _dt = DBOpt.dbHelper.GetDataTable(_sql); if (_dt.Rows.Count > 0) { ViewState["CurrentShiftDatem"] = _dt.Rows[0][0]; ViewState["CurrentShift"] = _dt.Rows[0][1]; wdlDate.setTime(Convert.ToDateTime(_dt.Rows[0][0])); ddlShift.SelectedIndex = ddlShift.Items.IndexOf(ddlShift.Items.FindByValue(_dt.Rows[0][1].ToString())); btnQuery_Click(null, null); } else { ViewState["CurrentShiftDatem"] = null; ViewState["CurrentShift"] = null; btnAdd.Enabled = false; btnDelete.Enabled = false; //JScript.Alert("还不存在当前值班记录,请联系管理员!"); return; } } else { //自定义排序页面关闭后,刷新GridView if (Session["CustomOrder"] != null && ViewState["sql"].ToString().IndexOf(Session["CustomOrder"].ToString()) < 0) { if (ViewState["BaseQuery"] != null) //页面自带查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["CustomOrder"]; } else //无查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " order by " + Session["CustomOrder"]; } GridViewBind(); } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!Page.IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); btnDelete.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); if (Session["DateQueryCol"] == null) { JScript.Alert("Date Query!"); //要翻译 return; } //获取每页显示的行数 object obj = DBOpt.dbHelper.ExecuteScalar("select PAGE_ROWS from DMIS_SYS_TABLES where ID=" + Session["MainTableId"].ToString()); if (obj == null) { grvList.PageSize = 20; } else { grvList.PageSize = Convert.ToInt16(obj); } ViewState["BaseSql"] = "select * from " + Session["TableName"] + ""; uwcMonth.Month = DateTime.Now.ToString("dd-MM-yyyy"); btnQuery_Click(null, null); Session["CustomOrder"] = null; } else { //自定义排序页面关闭后,刷新GridView if (Session["CustomOrder"] != null && ViewState["sql"].ToString().IndexOf(Session["CustomOrder"].ToString()) < 0) { LoadHeader(); if (ViewState["BaseQuery"] != null) //页面自带查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["CustomOrder"]; } else //无查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " order by " + Session["CustomOrder"]; } GridViewBind(); } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!Page.IsPostBack) { SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); ViewState["BaseSql"] = "select * from T_DD_SHIFT"; ViewState["BaseQuery"] = "to_char(DATEM,'YYYYMM')='" + DateTime.Now.ToString("yyyyMM") + "'"; if (Session["Orders"] == null) //平台中没有设置排序条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"]; } else { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["Orders"]; } GridViewBind(); Session["CustomOrder"] = null; //只有管理员可以修改状态 if (!SetRight.IsAdminitrator(Session["MemberID"].ToString())) { grvList.Columns[9].Visible = false; } } else { //自定义排序页面关闭后,刷新GridView if (Session["CustomOrder"] != null && ViewState["sql"].ToString().IndexOf(Session["CustomOrder"].ToString()) < 0) { if (ViewState["BaseQuery"] != null) //页面自带查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["CustomOrder"]; } else //无查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " order by " + Session["CustomOrder"]; } GridViewBind(); } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!Page.IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); FillDropDownList.FillByTable(ref ddlStation, "DMIS_SYS_STATION", "NAME", "TID", "ORDER_ID"); ddlStation.SelectedIndex = 1; ddlStation_SelectedIndexChanged(null, null); } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); btnDelete.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); initStation(); btnQuery_Click(null, null); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["MemberID"] == null) { JScript.ReturnLogin(); } if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); tdTitle.InnerText = Session["FuncName"].ToString().Trim(); tdCondition.InnerText = Session["SearchWheresDesc"].ToString(); GenerateSql(); GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); ViewState["BaseSql"] = "SELECT F_NO,F_PACKNAME,F_DESC,F_CREATEMAN,F_PACKTYPENO,F_MSG,f_createdate FROM DMIS_SYS_PACK"; initPackType(); btnSearch_Click(null, null); } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-") + "01")); wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); ViewState["BaseSql"] = "select * from DMIS_SYS_WK_OPT_HISTORY"; ViewState["BaseQuery"] = "1=1"; if (Session["Orders"] == null) //平台中没有设置排序条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"]; } else { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["Orders"]; } GridViewBind(); Session["CustomOrder"] = null; } else { //自定义排序页面关闭后,刷新GridView if (Session["CustomOrder"] != null && ViewState["sql"].ToString().IndexOf(Session["CustomOrder"].ToString()) < 0) { if (ViewState["BaseQuery"] != null) //页面自带查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["CustomOrder"]; } else //无查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " order by " + Session["CustomOrder"]; } GridViewBind(); return; } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); Session["sended"] = null; //防止第二次添加时,不弹出派工任务窗口(AssignTaskWindow.aspx) wdlStart.setTime(Convert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01")); wdlEnd.setTime(DateTime.Now); //wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("dd-MM-yyyy"))); FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME"); //主办人员 ViewState["BaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN,A.PLAN_STARTTIME,A.PLAN_ENDTIME,A.SUBPACKNO,A.F_STATUS as InstanceStatus," + "B.F_FLOWNAME,B.f_receiver,B.f_receivedate,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,B.F_NO as F_CurWorkFlowNo,A.F_MSG,B.F_LAST_FINISHED_TIME " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B "; //从办人员 ViewState["OtherBaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN,A.PLAN_STARTTIME,A.PLAN_ENDTIME,A.SUBPACKNO,A.F_STATUS as InstanceStatus," + "B.F_FLOWNAME,B.f_receiver,B.f_receivedate,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,C.f_workflowno as F_CurWorkFlowNo,A.F_MSG,B.F_LAST_FINISHED_TIME " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B,DMIS_SYS_MEMBERSTATUS C "; System.Text.StringBuilder BaseCond = new System.Text.StringBuilder(); System.Text.StringBuilder OtherCond = new System.Text.StringBuilder(); BaseCond.Append(" WHERE A.F_NO=B.F_PACKNO and (A.F_STATUS='1' or A.F_STATUS='暂缓') and B.F_RECEIVER='" + Session["MemberName"] + "' AND B.F_STATUS='1' AND B.F_WORKING=1"); OtherCond.Append(" WHERE A.F_NO=B.F_PACKNO AND B.F_NO=C.F_WORKFLOWNO and A.F_NO=C.F_PACKNO and (A.F_STATUS='1' or A.F_STATUS='暂缓') " + " AND C.F_RECEIVER='" + Session["MemberName"] + "' AND C.F_STATUS='1'"); //AND B.F_WORKING=1 BaseCond.Append(" order by B.f_receivedate desc"); OtherCond.Append(" order by B.f_receivedate desc"); ViewState["sql"] = ViewState["BaseSql"].ToString() + BaseCond.ToString(); ViewState["OtherSql"] = ViewState["OtherBaseSql"] + OtherCond.ToString(); //从办者 GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); btnDelete.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); ViewState["BaseSql"] = "select distinct DATEM,INSPECTOR from " + Session["TableName"] + ""; ViewState["BaseQuery"] = "to_char(DATEM,'YYYYMM')='" + DateTime.Now.ToString("yyyyMM") + "'"; if (Session["Orders"] == null) //平台中没有设置排序条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"]; } else { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["Orders"]; } GridViewBind(); Session["CustomOrder"] = null; } else { //自定义排序页面关闭后,刷新GridView if (Session["CustomOrder"] != null && ViewState["sql"].ToString().IndexOf(Session["CustomOrder"].ToString()) < 0) { if (ViewState["BaseQuery"] != null) //页面自带查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by " + Session["CustomOrder"]; } else //无查询条件 { ViewState["sql"] = ViewState["BaseSql"] + " order by " + Session["CustomOrder"]; } GridViewBind(); return; } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-") + "01")); wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME"); ddlPackStatus.Items.Clear(); ddlPackStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkReassigned").ToString(), "2")); //已改派 ddlPackStatus.Items.Add(new ListItem(GetGlobalResourceObject("WebGlobalResource", "WkNoReassigned").ToString(), "1")); //未改派 ddlPackStatus.SelectedIndex = 1; ViewState["BaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN," + "B.F_FLOWNAME,B.F_SENDER,B.F_SENDDATE,B.F_RECEIVER,B.F_FLOWNO,A.F_PACKTYPENO,B.F_NO as F_CurWorkFlowNo,A.F_MSG " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B "; System.Text.StringBuilder BaseCond = new System.Text.StringBuilder(); BaseCond.Append(" WHERE A.F_NO=B.F_PACKNO and A.F_STATUS='1' AND B.F_STATUS='1'"); //未改派 BaseCond.Append(" and A.F_NO not in(select PACKNO from DMIS_SYS_WK_OPT_HISTORY where OPT_TYPE='改派')"); BaseCond.Append(" order by B.F_SENDDATE desc"); ViewState["sql"] = ViewState["BaseSql"].ToString() + BaseCond.ToString(); GridViewBind(); ViewState["refreshPage"] = 0; } else { if (ViewState["refreshPage"].ToString() != refreshPage.Value) //要求页面刷新 { btnSearch_Click(null, null); ViewState["refreshPage"] = refreshPage.Value; } } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01")); wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME"); //主办人员 ViewState["BaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN," + "B.F_FLOWNAME,B.f_receiver,B.f_receivedate,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,B.F_NO as F_CurWorkFlowNo,A.F_MSG,B.F_PLANDAY,b.f_workday,b.f_finishdate " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B "; //从办人员 ViewState["OtherBaseSql"] = "SELECT distinct A.F_NO,A.F_PACKNAME,A.F_DESC,A.F_CREATEMAN," + "B.F_FLOWNAME,B.f_receiver,B.f_receivedate,B.F_SENDER,B.F_SENDDATE,B.F_FLOWNO,A.F_PACKTYPENO,B.F_NO as F_CurWorkFlowNo,A.F_MSG,c.F_PLANDAY,c.f_workday,b.f_finishdate " + " FROM DMIS_SYS_PACK A,DMIS_SYS_WORKFLOW B,DMIS_SYS_MEMBERSTATUS C "; System.Text.StringBuilder BaseCond = new System.Text.StringBuilder(); System.Text.StringBuilder OtherCond = new System.Text.StringBuilder(); BaseCond.Append(" WHERE A.F_NO=B.F_PACKNO AND (B.F_STATUS='2' or B.F_STATUS='3') AND B.F_RECEIVER='" + Session["MemberName"] + "' and A.F_STATUS='1'"); OtherCond.Append(" where A.F_NO=B.F_PACKNO and A.F_NO=C.F_PACKNO and b.F_NO=c.f_workflowno and A.F_STATUS='1' and (C.F_STATUS='2' or C.F_STATUS='3') and " + "c.F_RECEIVER='" + Session["MemberName"].ToString()); //处理从办人员 BaseCond.Append(" order by B.F_SENDDATE desc"); OtherCond.Append(" order by B.F_SENDDATE desc"); ViewState["sql"] = ViewState["BaseSql"].ToString() + BaseCond.ToString(); ViewState["OtherSql"] = ViewState["OtherBaseSql"] + OtherCond.ToString(); //从办者 GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy") + "-01-01")); wdlEnd.setTime(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))); FillDropDownList.FillByTable(ref ddlSTATION, "DMIS_SYS_STATION", "NAME"); ViewState["BaseSql"] = "select * from DMIS_SYS_PACK A"; ViewState["sql"] = ViewState["BaseSql"].ToString() + " WHERE A.F_STATUS='2' order by A.f_archivedate desc"; GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetDetailPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); if (Request["date"] != null) { wdlDate.Text = Request["date"]; } else { wdlDate.setTime(DateTime.Now); } btnSave_Click(null, null); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["sended"] != null) { if (Session["sended"].ToString() == "1" && ViewState["BackUrl"] != null) { Response.Redirect(ViewState["BackUrl"].ToString()); } } if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = GetLocalResourceObject("PageResource1.Title").ToString(); btnDelFile.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); if (Request["BackUrl"] != null) { ViewState["BackUrl"] = Request["BackUrl"]; } else { ViewState["BackUrl"] = null; } object obj = null; if (Request["PackTypeNo"] != null && Request["CurLinkNo"] != null) //从工作流界面打开,肯定有PackTypeNo和CurLinkNo { ViewState["PackTypeNo"] = Request["PackTypeNo"]; ViewState["CurLinkNo"] = Request["CurLinkNo"]; if (Request["PackNo"] != null) { ViewState["PackNo"] = Request["PackNo"]; _sql = "select f_recno from DMIS_SYS_DOC where f_packno=" + Request["PackNo"] + " and f_linkno=" + Request["CurLinkNo"]; ViewState["RecNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); if (ViewState["RecNo"] == null) { //JScript.Alert("业务表的记录号,请联系管理员!"); return; } } else { ViewState["RecNo"] = -1; } if (Request["CurWorkFlowNo"] != null) { ViewState["CurWorkFlowNo"] = Request["CurWorkFlowNo"]; } } else //从业务表查询界面打开,有PackTypeNo、TableName、RecNo { ViewState["PackTypeNo"] = Request["PackTypeNo"]; ViewState["TableName"] = Request["TableName"]; ViewState["RecNo"] = Request["RecNo"]; _sql = "select F_PACKNO from DMIS_SYS_DOC where f_tablename='" + Request["TableName"].ToString() + "' and f_recno=" + ViewState["RecNo"].ToString(); ViewState["PackNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); if (ViewState["PackNo"] == null) { //JScript.Alert("未找到业务号!"); return; } obj = DBOpt.dbHelper.ExecuteScalar("select f_no from DMIS_SYS_WORKFLOW where f_packno=" + ViewState["PackNo"].ToString() + " and f_status='在办'"); if (obj != null) //在办的业务 { ViewState["CurWorkFlowNo"] = obj; } else { _sql = "select max(f_no) from DMIS_SYS_WORKFLOW where f_packno=" + ViewState["PackNo"].ToString() + " and f_status='完成'"; //归档的业务,最后的环节 ViewState["CurWorkFlowNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); } ViewState["CurLinkNo"] = DBOpt.dbHelper.ExecuteScalar("select f_flowno from DMIS_SYS_WORKFLOW where f_no=" + ViewState["CurWorkFlowNo"].ToString()); } //找当前环节对应的文档 _sql = "select a.f_no,a.f_name,a.f_tablename,a.f_reportfile from dmis_sys_doctype a,DMIS_SYS_WK_LINK_DOCTYPE b where a.f_no=b.F_DOCTYPENO and b.f_packtypeno=" + ViewState["PackTypeNo"].ToString() + " and b.F_LINKNO=" + ViewState["CurLinkNo"].ToString(); DataTable temp = DBOpt.dbHelper.GetDataTable(_sql); if (temp == null || temp.Rows.Count < 1) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkNoDoc").ToString()); //"没有找到对应的文档!" return; } else { ViewState["DocTypeNo"] = temp.Rows[0][0]; //文档编号 ViewState["DocTypeName"] = temp.Rows[0][1]; //文档名称 ViewState["TableName"] = temp.Rows[0][2]; //文档对应的数据库表名称 ViewState["REPORT_ID"] = temp.Rows[0][3]; //报表编号 } int counts; btnSave.Enabled = false; btnSaveClose.Enabled = false; btnSend.Enabled = false; btnWithdraw.Enabled = false; btnAccept.Enabled = false; btnWithdraw.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmWithdraw").ToString() + "');"); //确定要退回到上一步? btnAccept.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmAccept").ToString() + "');"); //确定要接单? if (SetRight.IsAdminitrator(Session["MemberID"].ToString())) //管理员开放修改业务的数据的权限,但不能发送、回退。不参与流转的处理 { btnSave.Enabled = true; btnSaveClose.Enabled = true; WebWorkFlow.SetAllWebControlEnable(this.Page, Convert.ToInt16(ViewState["PackTypeNo"]), "T_BZ_TASK"); WebWorkFlow.SetAllWebControlEnable(this.Page, Convert.ToInt16(ViewState["PackTypeNo"]), "T_BZ_TASK_CHEECK"); WebWorkFlow.SetAllWebControlEnable(this.Page, Convert.ToInt16(ViewState["PackTypeNo"]), "T_BZ_TASK_DISPOSE"); } else { if (Session["Oper"] != null) { if (Convert.ToInt16(Session["Oper"]) > 0) //有权限修改 { WebWorkFlow.SetWebControlRight(this.Page, Session["RoleIDs"].ToString(), Convert.ToInt16(ViewState["PackTypeNo"]), Convert.ToInt16(ViewState["CurLinkNo"]), ViewState["TableName"].ToString()); btnSave.Enabled = true; btnSaveClose.Enabled = true; btnSend.Enabled = true; btnWithdraw.Enabled = true; //判断文件上传删除的权限,只要能修改委托书基本资料,则可以 if (hcbSTATION.Enabled) { btnAddFile.Enabled = true; btnDelFile.Enabled = true; } //如果是最后一步,则弹出是否要归档的窗口 string sMainer = ""; if (ViewState["CurWorkFlowNo"] != null) { obj = DBOpt.dbHelper.ExecuteScalar("select F_RECEIVER from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); } if (obj != null) { sMainer = obj.ToString(); } else { btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmSubmit").ToString() + "');"); //确定要提交到下一步?(新建业务时。) } if (sMainer == Session["MemberName"].ToString()) { int iCat = -1; obj = DBOpt.dbHelper.ExecuteScalar("SELECT F_FLOWCAT FROM DMIS_SYS_FLOWLINK WHERE F_NO=" + ViewState["CurLinkNo"]); if (obj != null) { iCat = Convert.ToInt16(obj); } if (iCat == 2) { btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmFinish").ToString() + "');");//该项目已办理完成,是否要归档? } else { btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmSubmit").ToString() + "');");//确定要提交到下一步 } } } else //待办的状态下处理接单按钮 { int flag = -1; //判断是否接单 obj = DBOpt.dbHelper.ExecuteScalar("select f_working from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); if (obj != null) { flag = Convert.ToInt16(obj); } if (flag == 0) //待办状态 { string zbr = ""; obj = DBOpt.dbHelper.ExecuteScalar("select f_receiver from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); if (obj != null) { zbr = obj.ToString().Trim(); } if (zbr == "" || zbr == Session["MemberName"].ToString()) { btnAccept.Enabled = true; } } else if (flag == 1) //从办人员点击进入状态,只能提交 { if (WebWorkFlow.IsCongBanRen(ViewState["PackNo"].ToString(), ViewState["CurWorkFlowNo"].ToString(), Session["MemberName"].ToString())) { btnSend.Enabled = true; } } else { btnAccept.Enabled = false; } } } } FillDropDownList.FillHtmlCombxByTable(ref hcbSTATION, "DMIS_SYS_STATION", "NAME", "TID"); initFile(); //显示上传的文件 string tid; if (ViewState["PackNo"] != null) { //任务单内容,只有一条,故用PACK查找 if (DBOpt.dbHelper.IsExist("T_BZ_TASK", "PACK_NO=" + ViewState["PackNo"].ToString())) { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_BZ_TASK", "PACK_NO=" + ViewState["PackNo"].ToString()); } if (DBOpt.dbHelper.IsExist("T_BZ_TASK_CHEECK", "PACK_NO=" + ViewState["PackNo"].ToString())) { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_BZ_TASK_CHEECK", "PACK_NO=" + ViewState["PackNo"].ToString()); } //任务处理情况,一个业务有多条记录,查找当前处理的步骤对应的文档是否在业务表是存在记录 string tableName = DBOpt.dbHelper.ExecuteScalar("select f_tablename from DMIS_SYS_DOC where f_packno=" + ViewState["PackNo"].ToString() + " and f_linkno=" + ViewState["CurLinkNo"].ToString()).ToString(); tid = DBOpt.dbHelper.ExecuteScalar("select f_recno from DMIS_SYS_DOC where f_packno=" + ViewState["PackNo"].ToString() + " and f_linkno=" + ViewState["CurLinkNo"].ToString()).ToString(); obj = DBOpt.dbHelper.ExecuteScalar("select f_name from dmis_sys_flowlink where f_no=" + ViewState["CurLinkNo"].ToString()); if (tableName == "T_BZ_TASK_DISPOSE") //成员处理环节 { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, tableName, "TID=" + tid); tdCurDispoase.InnerText = obj.ToString(); if (txtF_FLOWNAME.Text == "") { txtF_FLOWNAME.Text = obj.ToString(); } } else //不是处理环节 { tdCurDispoase.InnerText = ""; } //填充已经完成的处理步骤数据 initData(); //2009-3-6 每个业务表保存业务号,故用一个控件来保存就可以了. if (txtPACK_NO.Text.Trim() == "") { txtPACK_NO.Text = ViewState["PackNo"].ToString(); } } //确定当前步骤是否是第一步 obj = DBOpt.dbHelper.ExecuteScalar("select f_flowcat from dmis_sys_flowlink where f_no=" + ViewState["CurLinkNo"].ToString()); if (!obj.ToString().Equals("0")) //不是第一步 { //设置初始人名 if (!SetRight.IsAdminitrator(Session["MemberID"].ToString())) //不是管理员才设置初始人员及日期,否则会把管理员的名称也赋值给相应的控件 { string[] name = { "txtSTARTER", "txtCHECKER", "txtFZR" }; TextBox txt; for (int i = 0; i < name.Length; i++) { txt = (TextBox)Page.FindControl(name[i]); if (txt == null) { continue; } if (!txt.ReadOnly && txt.Text == "") { txt.Text = Session["MemberName"].ToString(); } } //设置初始日期 string[] date = { "wdlSTARTTIME", "wdlCHECK_DATE", "wdlDISPOSE_STARTTIME" }; WebDate wdl; for (int i = 0; i < date.Length; i++) { wdl = (WebDate)Page.FindControl(date[i]); if (wdl == null) { continue; } if (wdl.Enabled && wdl.Text == "") { wdl.setTime(DateTime.Now); } } } //设置从办人员的姓名,这样不用两次输入办理人员的姓名 DataTable memberStatus = DBOpt.dbHelper.GetDataTable("select f_receiver from dmis_sys_memberstatus where f_packno=" + ViewState["PackNo"].ToString() + " and f_workflowno=" + ViewState["CurWorkFlowNo"].ToString()); for (int i = 0; i < memberStatus.Rows.Count; i++) { if (i == 0) { txtJDR1.Text = memberStatus.Rows[i][0].ToString(); } else if (i == 1) { txtJDR2.Text = memberStatus.Rows[i][0].ToString(); } else if (i == 2) { txtJDR3.Text = memberStatus.Rows[i][0].ToString(); } } } else //开始步骤 { tdCurDispoase.InnerText = ""; if (ViewState["RecNo"].ToString() == "-1") //新增任务书的情况 { _sql = "select count(*) from T_BZ_TASK where to_char(STARTTIME,'YYYYMM')='" + DateTime.Now.ToString("yyyyMM") + "'"; counts = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar(_sql)) + 1; txtPH.Text = DateTime.Now.ToString("yyyyMM") + counts.ToString("000"); txtTID.Text = ""; txtSTARTER.Text = Session["MemberName"].ToString(); wdlSTARTTIME.setTime(DateTime.Now); } else //第二次打开任务书,则还是第一步的步骤,则显示任务书的数据 { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_BZ_TASK", "TID=" + ViewState["RecNo"].ToString()); } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["sended"] != null) { if (Session["sended"].ToString() == "1" && ViewState["BackUrl"] != null) { Response.Redirect(ViewState["BackUrl"].ToString()); } } if (!IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = GetLocalResourceObject("PageResource1.Title").ToString(); if (Request["BackUrl"] != null) { ViewState["BackUrl"] = Server.UrlDecode(Request["BackUrl"]); } else { ViewState["BackUrl"] = null; } object obj = null; if (Request["PackTypeNo"] != null && Request["CurLinkNo"] != null) //从工作流界面打开,肯定有PackTypeNo和CurLinkNo { ViewState["PackTypeNo"] = Request["PackTypeNo"]; ViewState["CurLinkNo"] = Request["CurLinkNo"]; if (Request["PackNo"] != null) { ViewState["PackNo"] = Request["PackNo"]; _sql = "select f_recno from DMIS_SYS_DOC where f_packno=" + Request["PackNo"] + " and f_linkno=" + Request["CurLinkNo"]; ViewState["RecNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); if (ViewState["RecNo"] == null) { //JScript.Alert("业务表的记录号,请联系管理员!"); return; } } else { ViewState["RecNo"] = -1; } if (Request["CurWorkFlowNo"] != null) { ViewState["CurWorkFlowNo"] = Request["CurWorkFlowNo"]; } } else //从业务表查询界面打开,有PackTypeNo、TableName、RecNo { ViewState["PackTypeNo"] = Request["PackTypeNo"]; ViewState["TableName"] = Request["TableName"]; ViewState["RecNo"] = Request["RecNo"]; _sql = "select F_PACKNO from DMIS_SYS_DOC where f_tablename='" + Request["TableName"].ToString() + "' and f_recno=" + ViewState["RecNo"].ToString(); ViewState["PackNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); if (ViewState["PackNo"] != null) { obj = DBOpt.dbHelper.ExecuteScalar("select f_no from DMIS_SYS_WORKFLOW where f_packno=" + ViewState["PackNo"].ToString() + " and f_status='1'"); if (obj != null) //在办的业务 { ViewState["CurWorkFlowNo"] = obj; } else { _sql = "select max(f_no) from DMIS_SYS_WORKFLOW where f_packno=" + ViewState["PackNo"].ToString() + " and f_status='2'"; //归档的业务,最后的环节 ViewState["CurWorkFlowNo"] = DBOpt.dbHelper.ExecuteScalar(_sql); } ViewState["CurLinkNo"] = DBOpt.dbHelper.ExecuteScalar("select f_flowno from DMIS_SYS_WORKFLOW where f_no=" + ViewState["CurWorkFlowNo"].ToString()); } else //查看历史数据,不能操作任何 { btnSave.Enabled = false; btnSaveClose.Enabled = false; btnSend.Enabled = false; btnWithdraw.Enabled = false; btnAccept.Enabled = false; CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_ZDH_DEVICE_FAULT", "TID=" + ViewState["RecNo"].ToString()); return; } } //找当前环节对应的文档 _sql = "select a.f_no,a.f_name,a.f_tablename,a.f_reportfile from dmis_sys_doctype a,DMIS_SYS_WK_LINK_DOCTYPE b where a.f_no=b.F_DOCTYPENO and a.f_packtypedef=1 and b.f_packtypeno=" + ViewState["PackTypeNo"].ToString() + " and b.F_LINKNO=" + ViewState["CurLinkNo"].ToString(); DataTable temp = DBOpt.dbHelper.GetDataTable(_sql); if (temp == null || temp.Rows.Count < 1) { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "WkNoDoc").ToString()); //"没有找到对应的文档!" return; } else { ViewState["DocTypeNo"] = temp.Rows[0][0]; //文档编号 ViewState["DocTypeName"] = temp.Rows[0][1]; //文档名称 ViewState["TableName"] = temp.Rows[0][2]; //文档对应的数据库表名称 ViewState["REPORT_ID"] = temp.Rows[0][3]; //报表编号 } int counts; btnSave.Enabled = false; btnSaveClose.Enabled = false; btnSend.Enabled = false; btnWithdraw.Enabled = false; btnAccept.Enabled = false; btnWithdraw.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmWithdraw").ToString() + "');"); //确定要退回到上一步? btnAccept.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmAccept").ToString() + "');"); //确定要接单? if (SetRight.IsAdminitrator(Session["MemberID"].ToString())) //管理员开放本业务类型所涉及的所有业务表修改数据的权限,但不能发送、回退。不参与流转的处理 { btnSave.Enabled = true; btnSaveClose.Enabled = true; _sql = "select f_tablename from dmis_sys_doctype where f_packtypeno=" + ViewState["PackTypeNo"].ToString(); //本业务所涉及到的所有业务表 DataTable AllTables = DBOpt.dbHelper.GetDataTable(_sql); for (int i = 0; i < AllTables.Rows.Count; i++) { WebWorkFlow.SetAllWebControlEnable(this.Page, Convert.ToInt16(ViewState["PackTypeNo"]), AllTables.Rows[i][0].ToString()); } } else { if (Session["Oper"] != null) { if (Convert.ToInt16(Session["Oper"]) > 0) //有权限修改 { WebWorkFlow.SetWebControlRight(this.Page, Session["RoleIDs"].ToString(), Convert.ToInt16(ViewState["PackTypeNo"]), Convert.ToInt16(ViewState["CurLinkNo"]), ViewState["TableName"].ToString()); btnSave.Enabled = true; btnSaveClose.Enabled = true; btnSend.Enabled = true; btnWithdraw.Enabled = true; //如果是最后一步,则弹出是否要归档的窗口 string sMainer = ""; if (ViewState["CurWorkFlowNo"] != null) { obj = DBOpt.dbHelper.ExecuteScalar("select F_RECEIVER from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); } if (obj != null) { sMainer = obj.ToString(); } else { btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmSubmit").ToString() + "');"); //确定要提交到下一步?(新建业务时。) } if (sMainer == Session["MemberName"].ToString()) { int iCat = -1; if (ViewState["CurLinkNo"] != null) { obj = DBOpt.dbHelper.ExecuteScalar("SELECT F_FLOWCAT FROM DMIS_SYS_FLOWLINK WHERE F_NO=" + ViewState["CurLinkNo"]); if (obj != null) { iCat = Convert.ToInt16(obj); } } if (iCat == 2) { btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmFinish").ToString() + "');");//该项目已办理完成,是否要归档? } else { btnSend.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "WkConfirmSubmit").ToString() + "');");//确定要提交到下一步 } } } else //待办的状态下处理接单按钮 { int flag = -1; //判断是否接单 obj = DBOpt.dbHelper.ExecuteScalar("select f_working from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); if (obj != null) { flag = Convert.ToInt16(obj); } if (flag == 0) //待办状态 { string zbr = ""; obj = DBOpt.dbHelper.ExecuteScalar("select f_receiver from DMIS_SYS_WORKFLOW where F_NO=" + ViewState["CurWorkFlowNo"]); if (obj != null) { zbr = obj.ToString().Trim(); } if (zbr == "" || zbr == Session["MemberName"].ToString()) { btnAccept.Enabled = true; } } else if (flag == 1) //从办人员点击进入状态,只能提交 { if (WebWorkFlow.IsCongBanRen(ViewState["PackNo"].ToString(), ViewState["CurWorkFlowNo"].ToString(), Session["MemberName"].ToString())) { btnSend.Enabled = true; } } else { btnAccept.Enabled = false; } } } } FillDropDownList.FillByTable(ref ddlDD_STATION, "DMIS_SYS_STATION", "NAME", "TID"); FillDropDownList.FillByTable(ref ddlXT_TYPE, "T_ZDH_DEVICE_XT_TYPE", "TYPE_NAME", "TID", "ORDER_ID ASC"); FillDropDownList.FillByTable(ref ddlYD_TYPE, "T_ZDH_DEVICE_XT_TYPE", "TYPE_NAME", "TID", "ORDER_ID ASC"); if (Convert.ToInt32(ViewState["RecNo"]) > -1) { CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_ZDH_DEVICE_FAULT", "TID=" + ViewState["RecNo"].ToString()); if (!SetRight.IsAdminitrator(Session["MemberID"].ToString())) //不是管理员才设置初始人员及日期,否则会把管理员的名称也赋值给相应的控件 { //设置初始人名,主办人,从办人在后面设置 string[] name = { "txtXT_JDR", "txtYD_JDR", "txtYS_YSR" }; TextBox txt; for (int i = 0; i < name.Length; i++) { txt = (TextBox)Page.FindControl(name[i]); if (txt == null) { continue; } if (!txt.ReadOnly && txt.Text == "") { txt.Text = Session["MemberName"].ToString(); } } //设置初始日期 string[] date = { "wdlXT_XDSJ", "wdlYD_JDSJ", "wdlYS_YSRQ" }; WebDate wdl; for (int i = 0; i < date.Length; i++) { wdl = (WebDate)Page.FindControl(date[i]); if (wdl == null) { continue; } if (wdl.Enabled && wdl.Text == "") { wdl.setTime(DateTime.Now); } } } //设置从办人员的姓名,这样不用两次输入办理人员的姓名 DataTable memberStatus = DBOpt.dbHelper.GetDataTable("select f_receiver from dmis_sys_memberstatus where f_packno=" + ViewState["PackNo"].ToString() + " and f_workflowno=" + ViewState["CurWorkFlowNo"].ToString()); for (int i = 0; i < memberStatus.Rows.Count; i++) { if (!txtXT_JDR.ReadOnly) { if (i == 0) { if (txtXT_JDR2.Text == "") { txtXT_JDR2.Text = memberStatus.Rows[i][0].ToString(); } } else if (i == 1) { if (txtXT_JDR3.Text == "") { txtXT_JDR3.Text = memberStatus.Rows[i][0].ToString(); } } else if (i == 2) { if (txtXT_JDR4.Text == "") { txtXT_JDR4.Text = memberStatus.Rows[i][0].ToString(); } } } else if (!txtYD_JDR.ReadOnly) { if (i == 0) { if (txtYD_JDR2.Text == "") { txtYD_JDR2.Text = memberStatus.Rows[i][0].ToString(); } } else if (i == 1) { if (txtYD_JDR3.Text == "") { txtYD_JDR3.Text = memberStatus.Rows[i][0].ToString(); } } else if (i == 2) { if (txtYD_JDR4.Text == "") { txtYD_JDR4.Text = memberStatus.Rows[i][0].ToString(); } } } } } else //新增时,确定缺陷编号 { _sql = "select count(*) from T_ZDH_DEVICE_FAULT where to_char(DD_DATEM,'YYYYMM')='" + DateTime.Now.ToString("yyyyMM") + "'"; counts = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar(_sql)) + 1; txtDD_PH.Text = DateTime.Now.ToString("yyyyMM") + counts.ToString("000"); txtDD_FINDER.Text = Session["MemberName"].ToString(); wdlDD_DATEM.setTime(DateTime.Now); } } }