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(); 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) { 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) { 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) { 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 (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 (!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) { ViewState["CurPageIndex"] = 0; ViewState["PageCount"] = 0; SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); ViewState["BaseSql"] = "select * from DMIS_SYS_LOG"; //模块的查询条件,一般是按年、月、日查询;此变量在“检索”按钮中修改,在此初始化。 ViewState["BaseQuery"] = "to_char(OPT_TIME,'YYYYMM')='" + DateTime.Now.ToString("yyyyMM") + "'"; if (Session["Orders"] == null) //平台中没有设置排序条件 { ViewState["sql"] = ViewState["BaseSql"] + " where " + ViewState["BaseQuery"] + " order by OPT_TIME desc"; } 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 (Session["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; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!Page.IsPostBack) { SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); iniTree(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01")); wdlEnd.setTime(DateTime.Now); } }
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; 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) { 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 (!Page.IsPostBack) { SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); //开始查询 ViewState["BaseSql"] = "select * from DMIS_SYS_WK_CYCLE_TASK_PARA"; 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) { SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); grvRef = grvList; tdPageMessage = tdMessage; txtPageNumber = txtPage; if (!IsPostBack) { _sql = "select id,name from dmis_sys_depart order by order_id"; DataTable depart = DBOpt.dbHelper.GetDataTable(_sql); ddlDepart.DataTextField = "name"; ddlDepart.DataValueField = "id"; ddlDepart.DataSource = depart; ddlDepart.DataBind(); wdlStart.setTime(Convert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01")); wdlEnd.setTime(DateTime.Now); } }
protected void Page_Load(object sender, EventArgs e) { tdPageMessage = tdMessage; if (!IsPostBack) { SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); FillDropDownList.FillByTable(ref ddl对应业务ID, "DMIS_SYS_PACKTYPE", "F_NAME", "F_NO"); if (Request["TID"] != "") { FillDropDownList.FillByTable(ref ddl任务启动人, "DMIS_SYS_MEMBER", "NAME", "ID"); CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "DMIS_SYS_WK_CYCLE_TASK_PARA", "TID=" + Request["TID"]); } else { ddl对应业务ID_SelectedIndexChanged(null, null); } ddl周期类型_SelectedIndexChanged(null, null); } }
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) { grvRef = grvList; tdPageMessage = tdMessage; if (!IsPostBack) { SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); //if (!btnAdd.Enabled) //没有权限的,只能浏览 //{ // return; //} _sql = "select TID,日期,系统值班人 from T_ZDH_自动化值班记录 where 状态='当值' order by 日期 desc"; DataTable dt = DBOpt.dbHelper.GetDataTable(_sql); if (dt.Rows.Count > 0) { ViewState["系统值班人"] = dt.Rows[0][2]; ViewState["当值日期"] = dt.Rows[0][1]; wdlDate.setTime(Convert.ToDateTime(dt.Rows[0][1])); btnQuery_Click(null, null); } else { ViewState["系统值班人"] = ""; ViewState["当值日期"] = "1900-01-01"; btnAdd.Enabled = false; btnDelete.Enabled = false; JScript.Alert("还不存在当前自动化值班记录,请联系管理员!"); return; } } else { //双击时用 SetGridViewEditRow(); } }
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["OtherPara"] != null) { if (Session["OtherPara"].ToString().IndexOf("path") > -1) { int startPos = Session["OtherPara"].ToString().IndexOf("path="); int endPos = Session["OtherPara"].ToString().IndexOf(';'); if (endPos > 0) { Session["FilePath"] = Session["OtherPara"].ToString().Substring(startPos + 5, endPos - startPos - 5); } else { Session["FilePath"] = Session["OtherPara"].ToString().Substring(startPos + 5); } } else { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "FileNoPath").ToString());//"此功能没有设置文件存放路径,请联系管理员设置!" btnAdd.Enabled = false; btnDelete.Enabled = false; btnModify.Enabled = false; return; } } else { JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "FileNoPath").ToString());//"此功能没有设置文件存放路径,请联系管理员设置!" btnAdd.Enabled = false; btnDelete.Enabled = false; btnModify.Enabled = false; return; } //开始查询 ViewState["BaseSql"] = "select * from T_FILE_INFO"; ViewState["BaseQuery"] = "MODULE_ID=" + Session["FuncId"].ToString(); 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) { if (!Page.IsPostBack) { PageControlLocalizationText pl = new PageControlLocalizationText(this); pl.SetListPageControlLocalizationText(); lblFuncName.Text = Session["FuncName"].ToString(); SetRight.SetPageRight(this.Page, Session["FuncId"].ToString(), Session["RoleIDs"].ToString()); btnJIAOBAN.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "Common004").ToString() + "');"); btnDelete.Attributes.Add("onClick", "return confirm('" + GetGlobalResourceObject("WebGlobalResource", "DeleteBeforeConfirm").ToString() + "');"); object obj; //为了突出哪个变电站,功能名要加变电站名称 if (Session["Culture"] == null || Session["Culture"].ToString() == "zh-CN") { _sql = "select NAME from DMIS_SYS_DEPART where ID=" + Session["DepartID"].ToString(); } else { _sql = "select OTHER_LANGUAGE_DESCR from DMIS_SYS_DEPART where ID=" + Session["DepartID"].ToString(); } obj = DBOpt.dbHelper.ExecuteScalar(_sql); if (obj != null) { lblFuncName.Text += "[" + obj.ToString() + "]"; } FillDropDownList.FillByTable(ref ddlWEATHER, "DMIS_SYS_WEATHER", "NAME", "TID"); FillDDY(); FillShift(); if (ddlQueryShift.Items.Count < 1) { //JScript.Alert("还没有设置调度值班班次信息,请联系系统管理员!"); return; } DateTime st; //没有权限修改交接班记录的人只能查看数据,不能执行下面查找或生成当前班次的记录。 if (!SetRight.IsModify(Session["FuncID"].ToString(), "frmSTATION_SHIFT.aspx", "btnSave", Session["MemberID"].ToString())) { return; } if (SetRight.IsAdminitrator(Session["MemberID"].ToString())) { btnAdd.Visible = true; btnDelete.Visible = true; } int days = 1; //没有设置值班天数,则为1 if (ddlQueryShift.Items.Count == 1) //值班参数表只有一条记录时,则要判断值班天数,多条记录则为1 { obj = DBOpt.dbHelper.ExecuteScalar("select SHIFT_DAYS from T_STATION_SHIFT_PARA where STATION_ID=" + Session["DepartID"].ToString()); if (obj != null) //得到值班天数 { days = Convert.ToInt16(obj); } } else { days = 1; } uint tid = 1; /*************************************** * 判断当前班次的规则如下: * 1、首先找flag为1(正在当班)的记录,没有找到则以当前日期和第一个班次新建当前班次 * 2、如果有flag为1(正在当班)的记录,则再判断此当班日期是否在今天以前的days内之内;如果不是,则把此表内条件flag=1(正值)的记录的列flag的值设置为0(已值),再以当前日期和第一个班次新建当前班次; * 3、flag为1(正在当班)的记录的当班日期在今天以前的days天之内,则当前班次就是此班次。 * **************************************/ _sql = "select TID,DATEM,SHIFT from T_STATION_SHIFT where flag=1 and STATION_ID=" + Session["DepartID"].ToString() + " order by DATEM desc"; DataTable dt = DBOpt.dbHelper.GetDataTable(_sql); if (dt.Rows.Count > 0) //找到了当班的记录 { st = (Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))).AddDays(-days); //值班天数之前的00:00,用于下列比较 if ((DateTime)dt.Rows[0]["DATEM"] < st) //当前班次在值班天数以前,则新建班次 { _sql = "update T_STATION_SHIFT set flag=0 where flag=1 and STATION_ID=" + Session["DepartID"].ToString(); //先把当班记录状态设置为已交班 DBOpt.dbHelper.ExecuteSql(_sql); //查找当日的第一个班次的记录在数据库中是否存在 obj = DBOpt.dbHelper.ExecuteScalar("select count(*) from T_STATION_SHIFT where to_char(DATEM,'YYYYMMDD')='" + DateTime.Now.ToString("yyyyMMdd") + "' and SHIFT=" + ddlQueryShift.Items[0].Value + " and STATION_ID=" + Session["DepartID"].ToString()); if (obj == null || Convert.ToInt16(obj) == 0) //数据库中没有当日的第一个班次的记录 { tid = DBOpt.dbHelper.GetMaxNum("T_STATION_SHIFT", "TID"); obj = DBOpt.dbHelper.ExecuteScalar("select SHIFT_STARTTIME,to_char(SHIFT_STARTTIME,'HH24:MI') ss from T_STATION_SHIFT_PARA where STATION_ID=" + Session["DepartID"].ToString() + " order by ss"); st = (DateTime)obj; _sql = "insert into T_STATION_SHIFT(TID,DATEM,SHIFT,FLAG,STATION_ID) values(" + tid + ",TO_DATE('" + DateTime.Now.ToString("yyyy-MM-dd") + st.ToString(" HH:mm") + "','YYYY-MM-DD HH24:MI')," + ddlQueryShift.Items[0].Value + "," + ddlQueryShift.Items[0].Value + "," + Session["DepartID"].ToString() + ")"; if (DBOpt.dbHelper.ExecuteSql(_sql) < 0) { JScript.Alert((String)GetGlobalResourceObject("WebGlobalResource", "Common001")); MultiView1.Visible = false; return; } } else //数据库中有当日的第一个班次的记录,则把状态设置为当班状态(为1) { _sql = "update T_STATION_SHIFT set flag=1 where to_char(DATEM,'YYYYMMDD')='" + DateTime.Now.ToString("yyyyMMdd") + "' and SHIFT=" + ddlQueryShift.Items[0].Value + " and STATION_ID=" + Session["DepartID"].ToString(); if (DBOpt.dbHelper.ExecuteSql(_sql) != 1) { JScript.Alert((String)GetGlobalResourceObject("WebGlobalResource", "Common002")); MultiView1.Visible = false; return; } tid = Convert.ToUInt16(DBOpt.dbHelper.ExecuteScalar("select TID from T_STATION_SHIFT where to_char(DATEM,'YYYYMMDD')='" + DateTime.Now.ToString("yyyyMMdd") + "' and SHIFT=" + ddlQueryShift.Items[0].Value + " and STATION_ID=" + Session["DepartID"].ToString())); } Session["CurrentShiftDate"] = DateTime.Now.ToString("yyyyMMdd"); Session["CurrentShift"] = 1; ViewState["CurrentShiftDate"] = DateTime.Now.ToString("yyyy-MM-dd"); } else //当前班次是昨天以后,则以此作为当前班次 { Session["CurrentShiftDate"] = ((DateTime)dt.Rows[0][1]).ToString("yyyyMMdd"); Session["CurrentShift"] = dt.Rows[0][2]; tid = Convert.ToUInt16(dt.Rows[0][0]); ViewState["CurrentShiftDate"] = ((DateTime)dt.Rows[0][1]).ToString("yyyy-MM-dd"); } } else //没有当前班次,则以当日的第一个班次新建当前班次 { obj = DBOpt.dbHelper.ExecuteScalar("select count(*) from T_STATION_SHIFT where to_char(DATEM,'YYYYMMDD')='" + DateTime.Now.ToString("yyyyMMdd") + "' and SHIFT=" + ddlQueryShift.Items[0].Value + " and STATION_ID=" + Session["DepartID"].ToString()); if (obj == null || Convert.ToInt16(obj) == 0) //数据库中没有当日的第一个班次的记录 { tid = DBOpt.dbHelper.GetMaxNum("T_STATION_SHIFT", "TID"); obj = DBOpt.dbHelper.ExecuteScalar("select SHIFT_STARTTIME,to_char(SHIFT_STARTTIME,'HH24:MI') ss from T_STATION_SHIFT_PARA where STATION_ID=" + Session["DepartID"].ToString() + " order by ss"); st = (DateTime)obj; _sql = "insert into T_STATION_SHIFT(TID,DATEM,SHIFT,FLAG,STATION_ID,CURRENT_SHIFT_MAN1) values(" + tid + ",TO_DATE('" + DateTime.Now.ToString("yyyy-MM-dd") + st.ToString(" HH:mm") + "','YYYY-MM-DD HH24:MI')" + "," + ddlQueryShift.Items[0].Value + ",1," + Session["DepartID"].ToString() + ",'" + Session["MemberName"].ToString() + "')"; if (DBOpt.dbHelper.ExecuteSql(_sql) < 0) { JScript.Alert((String)GetGlobalResourceObject("WebGlobalResource", "Common001")); MultiView1.Visible = false; return; } } else //数据库中有当日的第一个班次的记录,把其状态改为当值(为1) { _sql = "update T_STATION_SHIFT set flag=1 where to_char(DATEM,'YYYYMMDD')='" + DateTime.Now.ToString("yyyyMMdd") + "' and SHIFT=" + ddlQueryShift.Items[0].Value + " and STATION_ID=" + Session["DepartID"].ToString(); if (DBOpt.dbHelper.ExecuteSql(_sql) != 1) { JScript.Alert((String)GetGlobalResourceObject("WebGlobalResource", "Common002")); MultiView1.Visible = false; return; } tid = Convert.ToUInt16(DBOpt.dbHelper.ExecuteScalar("select TID from T_STATION_SHIFT where to_char(DATEM,'YYYYMMDD')='" + DateTime.Now.ToString("yyyyMMdd") + "' and SHIFT=" + ddlQueryShift.Items[0].Value + " and STATION_ID=" + Session["DepartID"].ToString())); } Session["CurrentShiftDate"] = DateTime.Now.ToString("yyyyMMdd"); Session["CurrentShift"] = ddlQueryShift.Items[0].Value; ViewState["CurrentShiftDate"] = DateTime.Now.ToString("yyyy-MM-dd"); } CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_STATION_SHIFT", "TID=" + tid); wdlQueryDate.setTime(Convert.ToDateTime(ViewState["CurrentShiftDate"])); ddlQueryShift.SelectedIndex = ddlQueryShift.Items.IndexOf(ddlQueryShift.Items.FindByValue(Session["CurrentShift"].ToString())); btnQuery_Click(null, null); } else { //btnQuery_Click(null, null); } }