protected void Page_PreInit(object sender, EventArgs e)
{
if (Session["MemberID"] == null)
{
JScript.ReturnLogin(Page);
}
if (!Page.IsPostBack)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["MemberID"] == null)
{
JScript.ReturnLogin();
}
if (!IsPostBack)
{
if (Session["FuncName"] != null)
{
tdTitle.InnerText = Session["FuncName"].ToString();
}
Session["TableName"] = DBOpt.dbHelper.ExecuteScalar("select NAME from DMIS_SYS_TABLES where ID=" + Session["MainTableId"].ToString());
//加前提条件。
if (Request["Precondition"] != null && Request["Precondition"] != "")
{
ViewState["Precondition"] = Request["Precondition"];
}
createNewRow();
StringBuilder sbValues = new StringBuilder();
DropDownList ddlColumns, ddlGuanXi, ddlRoJi;
HtmlComboBox cbbValue;
//列名
ddlColumns = (DropDownList)tblQuery.Rows[1].Cells[0].Controls[0];
sbValues.Append(ddlColumns.SelectedValue + "▲");
//关系符
ddlGuanXi = (DropDownList)tblQuery.Rows[1].Cells[1].Controls[0];
sbValues.Append(ddlGuanXi.SelectedValue + "▲");
//值
cbbValue = (HtmlComboBox)tblQuery.Rows[1].Cells[2].Controls[0];
sbValues.Append(cbbValue.Text + "▲");
//逻辑符
ddlRoJi = (DropDownList)tblQuery.Rows[1].Cells[3].Controls[0];
sbValues.Append(ddlRoJi.SelectedValue + "▲◆");
ViewState["values"] = sbValues.Remove(sbValues.Length - 1, 1).ToString();
}
else
{
if (ViewState["values"] != null)
{
buildTable();
}
}
}
protected void Page_PreInit(object sender, EventArgs e)
{
if (Session["MemberID"] == null)
{
JScript.ReturnLogin(this.Page);
}
if (Session["THEME"] == null)
{
Page.Theme = "default";
}
else
{
Page.Theme = Session["THEME"].ToString();
}
}
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 virtual void Page_PreInit(object sender, EventArgs e)
{
if (Session["MemberID"] == null)
{
JScript.ReturnLogin();
}
if (Session["Theme"] == null)
{
Page.Theme = "default";
}
else
{
Page.Theme = Session["Theme"].ToString();
}
if (!Page.IsPostBack)
{
// Session["Url"] =Request["URL"];
}
}
protected virtual void Page_PreInit(object sender, EventArgs e)
{
if (Session["MemberID"] == null)
{
JScript.ReturnLogin();
}
if (!Page.IsPostBack)
{
//2008-5-20 满足页面不在功能菜单中注册的情况
if (Request["ID"] == null || Request["ID"].Trim() == "")
{
Session["FuncId"] = null;
return;
}
Session["FuncId"] = Request["ID"];
string _sql = "select REPORT_ID,TABLE_IDS,OTHER_PARA,ORDERS,NAME,OTHER_LANGUAGE_DESCR from DMIS_SYS_TREEMENU where ID=" + Request["ID"];
DataTable _dt = DBOpt.dbHelper.GetDataTable(_sql);
//功能名称,用于在自定义查询显示时显示功能名
if (Session["Culture"] != null && Session["Culture"].ToString() == "zh-CN")
{
Session["FuncName"] = _dt.Rows[0]["NAME"];
}
else
{
Session["FuncName"] = _dt.Rows[0]["OTHER_LANGUAGE_DESCR"];
}
//报表ID
if (_dt.Rows[0]["REPORT_ID"] == Convert.DBNull || _dt.Rows[0]["REPORT_ID"].ToString().Trim() == "")
{
Session["ReportId"] = null;
}
else
{
Session["ReportId"] = _dt.Rows[0]["REPORT_ID"];
}
//数据库IDs
if (_dt.Rows[0]["TABLE_IDS"] != Convert.DBNull && _dt.Rows[0]["TABLE_IDS"].ToString().Trim() != "")
{
Session["TableIds"] = _dt.Rows[0]["TABLE_IDS"];
// Session["MainTableId"]: 主表ID，用于自定义排序和自定义查询中
if (_dt.Rows[0]["TABLE_IDS"].ToString().IndexOf(',') > 0)
{
Session["MainTableId"] = _dt.Rows[0]["TABLE_IDS"].ToString().Substring(0, _dt.Rows[0]["TABLE_IDS"].ToString().IndexOf(','));
}
else
{
Session["MainTableId"] = _dt.Rows[0]["TABLE_IDS"].ToString();
}
Session["TableName"] = DBOpt.dbHelper.ExecuteScalar("select NAME from DMIS_SYS_TABLES where ID=" + Session["MainTableId"].ToString()); //在细节页面时使用
//2009-6-22 增加日期查询列，用于通用浏览界面中
Session["DateQueryCol"] = DBOpt.dbHelper.ExecuteScalar("select QUERY_COL from DMIS_SYS_TABLES where ID=" + Session["MainTableId"].ToString()); //
//2010-9-16 增加细节页面自定列显示风格,一列、二列
Session["ColumnStyle"] = DBOpt.dbHelper.ExecuteScalar("select DISPLAY_STYLE from DMIS_SYS_TABLES where ID=" + Session["MainTableId"].ToString()); //
}
else
{
Session["MainTableId"] = null;
Session["TableIds"] = null;
Session["TableName"] = null;
Session["DateQueryCol"] = null;
Session["ColumnStyle"] = null;
}
//平台中的其它参数，例如文档管理中的文件存放路径
if (_dt.Rows[0]["OTHER_PARA"] == Convert.DBNull || _dt.Rows[0]["OTHER_PARA"].ToString().Trim() == "")
{
Session["OtherPara"] = null;
}
else
{
Session["OtherPara"] = _dt.Rows[0]["OTHER_PARA"];
}
//平台中程序中设置的排序条件
if (_dt.Rows[0]["ORDERS"] == Convert.DBNull || _dt.Rows[0]["ORDERS"].ToString().Trim() == "")
{
Session["Orders"] = null;
}
else
{
Session["Orders"] = _dt.Rows[0]["ORDERS"];
}
Session["URL"] = Page.Request.Url.ToString();
}
if (Session["Theme"] == null)
{
Page.Theme = "default";
}
else
{
Page.Theme = Session["Theme"].ToString();
}
}