protected void Page_Load(object sender, EventArgs e)
{
try
{
string u_select_sql = "";
PageRow = int.Parse(GlobeAtt.DetailRowS);
MaxRow = int.Parse(GlobeAtt.QueryList_MaxRow);
string if_main = dt_a00201.Rows[0]["if_main"].ToString();
string sort_col = dt_a00201.Rows[0]["sort_col"].ToString();
Boolean if_select = false;
if (sort_col == null)
{
sort_col = "";
}
ifinsertrow = Request.QueryString["IFINSERT"] == null ? "V" : Request.QueryString["IFINSERT"].ToString();
/*新增*/
main_key_value = BaseFun.getAllHyperLinks(RequestXml, "<KEY>", "</KEY>")[0].Value;
option = BaseFun.getAllHyperLinks(RequestXml, "<OPTION>", "</OPTION>")[0].Value;
//调整dt_a013010101 的数据
if (dt_a013010101.Rows.Count > 0)
{
string a016_a016_enable = dt_a013010101.Rows[0]["a016_enable"].ToString();
DataTable dt = dt_a013010101.Clone();
dt.Clear();
//格式化列
for (int i = 0; i < dt_a013010101.Rows.Count; i++)
{
a016_a016_enable = dt_a013010101.Rows[i]["a016_enable"].ToString();
if (a016_a016_enable == "0" || a016_a016_enable == "1")
{
string A016_ENABLE = dt_a013010101.Rows[i]["A016_ENABLE"].ToString();
if (A016_ENABLE == "0")
{
dt_a013010101.Rows[i]["COL_ENABLE"] = "0";
}
string A016_VISIBLE = dt_a013010101.Rows[i]["A016_VISIBLE"].ToString();
if (A016_VISIBLE == "0")
{
dt_a013010101.Rows[i]["COL_VISIBLE"] = "0";
}
string A016_NECESSARY = dt_a013010101.Rows[i]["A016_NECESSARY"].ToString();
if (A016_NECESSARY == "1")
{
dt_a013010101.Rows[i]["COL_NECESSARY"] = "1";
}
string a016_col_x = dt_a013010101.Rows[i]["a016_col_x"].ToString();
if (a016_col_x != null && a016_col_x != "")
{
dt_a013010101.Rows[i]["COL_X"] = decimal.Parse(a016_col_x);
}
string a016_bs_width = dt_a013010101.Rows[i]["a016_bs_width"].ToString();
string bs_width = dt_a013010101.Rows[i]["bs_width"].ToString();
if (a016_bs_width != null && a016_bs_width != "" && a016_bs_width != bs_width)
{
dt_a013010101.Rows[i]["bs_width"] = decimal.Parse(a016_bs_width);
string bs_edit_width = dt_a013010101.Rows[i]["BS_EDIT_WIDTH"].ToString();
dt_a013010101.Rows[i]["BS_EDIT_WIDTH"] = decimal.Parse(bs_edit_width) + (decimal.Parse(a016_bs_width) - decimal.Parse(bs_width));
string col_width = dt_a013010101.Rows[i]["col_width"].ToString();
dt_a013010101.Rows[i]["col_width"] = decimal.Parse(col_width) + (decimal.Parse(a016_bs_width) - decimal.Parse(bs_width));
}
}
string col01 = dt_a013010101.Rows[i]["col01"].ToString().ToLower();
if (col01 == "1")
{
if_select = true;
string COLUMN_ID = dt_a013010101.Rows[i]["COLUMN_ID"].ToString();
string line_no = dt_a013010101.Rows[i]["LINE_NO"].ToString();
string select_sql_ = dt_a013010101.Rows[i]["SELECT_SQL"].ToString();
select_sql_ = select_sql_.Replace("[A007_KEY]", GlobeAtt.A007_KEY);
select_sql_ = select_sql_.Replace("[A30001_KEY]", GlobeAtt.A30001_KEY);
select_sql_ = select_sql_.Replace("[USER_ID]", GlobeAtt.A007_KEY);
select_sql_ = select_sql_.Replace("[MAIN_KEY]", main_key_value);
dt_temp = Fun.getDtBySql(select_sql_);
//sql
string BS_HTML_ = dt_a013010101.Rows[i]["BS_HTML"].ToString();
string col10 = dt_a013010101.Rows[i]["col10"].ToString();
string col_X = dt_a013010101.Rows[i]["COL_X"].ToString();
for (int j = 0; j < dt_temp.Rows.Count; j++)
{
string id = dt_temp.Rows[j][0].ToString();
string name = dt_temp.Rows[j][1].ToString();
DataRow dr = dt_a013010101.NewRow();
dr = dt_a013010101.Rows[i];
dr["COLUMN_ID"] = COLUMN_ID + id;
dr["COL_TEXT"] = name;
dr["COL_X"] = double.Parse(col_X) + 0.0001 * j;
dr["A10001_KEY"] = int.Parse(line_no) * 1000 + j;
string BS_HTML = BS_HTML_.Replace("[" + COLUMN_ID + "]", "[" + COLUMN_ID + id + "]");
BS_HTML = BS_HTML.Replace("[" + dt_temp.Columns[0].ToString().ToUpper() + "]", id);
dr["BS_HTML"] = BS_HTML;
dt.ImportRow(dr);
//替换列名称
u_select_sql = u_select_sql + col10.Replace("[" + dt_temp.Columns[0].ToString().ToUpper() + "]", id) + " as " + COLUMN_ID + id + ",";
}
}
else
{
dt.ImportRow(dt_a013010101.Rows[i]);
}
}
dt_a013010101 = dt;
DataRow[] rows = dt_a013010101.Select("", "COL_X asc");
DataTable t = dt_a013010101.Clone();
t.Clear();
foreach (DataRow row in rows)
{
t.ImportRow(row);
}
dt_a013010101 = t;
}
if (option == "Q")
{
PageRow = int.Parse(GlobeAtt.QueryList_PageRow);
string PageRow_ = dt_a00201.Rows[0]["pagerows"].ToString();
if (PageRow_ != null && PageRow_ != "")
{
PageRow = int.Parse(PageRow_);
}
}
else
{
string PageRow_ = dt_a00201.Rows[0]["pagerows"].ToString();
if (PageRow_ != null && PageRow_ != "")
{
PageRow = int.Parse(PageRow_);
}
}
try
{
PageNum = int.Parse(BaseFun.getAllHyperLinks(RequestXml, "<PageNum>", "</PageNum>")[0].Value);
}
catch
{
PageNum = 1;
}
string data_sql = "";
string con_sql = "";
if (option != "Q")
{
if (option == "I")
{
con_sql = con_sql + " AND 1=2";
}
else
{
if (dt_a00201.Rows[0]["if_main"].ToString() != "1")
{
if (dt_a00201.Rows[0]["MAIN_KEY"].ToString() != "")
{
con_sql = con_sql + " AND " + dt_a00201.Rows[0]["MAIN_KEY"].ToString() + "='" + main_key_value + "'";
}
else
{
con_sql = con_sql + " AND " + dt_a00201.Rows[0]["TABLE_KEY"].ToString() + "='" + main_key_value + "'";
}
}
}
}
else
{
// showdatasql = replace_getShowDataSql(dt_a013010101, showdatasql, u_select_sql);
if (PageNum <= 0)
{
string RETRIEVE = dt_a00201.Rows[0]["RETRIEVE"].ToString();
if (RETRIEVE != "1")
{
con_sql = con_sql + " AND 1=2";
}
}
string A002ID = BaseFun.getAllHyperLinks(RequestXml, "<A002ID>", "</A002ID>")[0].Value;
if (a00201_key != A002ID)
{
option = "V";
con_sql = con_sql + " AND " + dt_a00201.Rows[0]["MAIN_KEY"].ToString() + "='" + main_key_value + "'";
}
//if (RequestURL.ToUpper().IndexOf("QUERYDATA.ASPX") > 0 && main_key_value != "")
//{
// con_sql = con_sql + " AND " + dt_a00201.Rows[0]["TABLE_KEY"].ToString() + "='" + main_key_value + "'";
//}
}
if (option == "Q")
{
con_sql = con_sql + " AND ROWNUM <=" + dt_a00201.Rows[0]["MAXROWS"].ToString();
}
int pos = showdatasql.IndexOf("ORDER BY");
string str_order = "";
if (pos > 0)
{
str_order = " " + showdatasql.Substring(pos);
showdatasql = showdatasql.Substring(0, pos - 1);
}
else
{
str_order = " " + sort_col;
}
data_sql = showdatasql + con_sql + str_order;
getShowDataCountSql = getShowDataCountSql + con_sql;
data_sql = data_sql.Replace("[MAIN_KEY]", main_key_value);
getShowDataCountSql = getShowDataCountSql.Replace("[MAIN_KEY]", main_key_value);
/*把查询的写日志记录到A00601中*/
if (GlobeAtt.BS_LOG_SELECTSQL == "1")
{
string log_sql = "pkg_a.saveQuerySql('" + GlobeAtt.A007_KEY + "', '" + a00201_key + "' , '" + data_sql.Replace("'", "''") + "','" + main_key_value + "' ) ";
try
{
Fun.saveQuerySql(a00201_key, data_sql, main_key_value, option);
}
catch (Exception ex)
{
log_sql = ex.Message;
}
}
if (option != "Q")
{
if (if_select)
{
data_sql = "Select a.* , " + u_select_sql + " rownum as rn from (" + data_sql + ") a where rownum <= " + (PageNum * PageRow).ToString();
}
else
{
data_sql = "Select a.* , rownum as rn from (" + data_sql + ") a where rownum <= " + (PageNum * PageRow).ToString();
}
}
else
{
data_sql = "Select a.* , rownum as rn from (" + data_sql + ") a where rownum <= " + (PageNum * PageRow).ToString();
}
data_sql = "Select b.* from (" + data_sql + ") b where rn > " + ((PageNum - 1) * PageRow).ToString();
Session["QUERY" + a00201_key] = data_sql;
DateTime ld = DateTime.Now;
dt_data = Fun.getDtBySql(data_sql);
double le = (DateTime.Now - ld).TotalSeconds;
string sql_ = "Select pkg_show.geta00204('" + a00201_key + "','" + main_key_value + "','" + GlobeAtt.A007_KEY + "','0','" + option + "','" + status + "') as c from dual ";
if (option == "Q")
{
sql_ = "Select pkg_show.geta00204('" + a00201_key + "','[LIST]','" + GlobeAtt.A007_KEY + "','1','Q') as c from dual ";
}
dt_a00204 = Fun.getDtBySql(sql_);
double GRID_SECONDS = 5;
try
{
GRID_SECONDS = double.Parse(GlobeAtt.GetValue("GRID_SECONDS"));
}
catch
{
GRID_SECONDS = 5;
}
if (le < GRID_SECONDS)
{
dt_temp = Fun.getDtBySql(getShowDataCountSql);
try
{
rowscount = int.Parse(dt_temp.Rows[0][0].ToString());
}
catch
{
rowscount = 0;
}
}
else
{
if (dt_data.Rows.Count < PageRow)
{
rowscount = dt_data.Rows.Count;
}
else
{
rowscount = int.Parse(dt_a00201.Rows[0]["MAXROWS"].ToString());
}
}
pagecount = rowscount / PageRow;
if (rowscount % PageRow > 0)
{
pagecount = pagecount + 1;
}
}
catch (Exception ex)
{
Response.Write("ERROR URL:" + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
try
{
// str_a002 = Session["JUMP_A002"].ToString();
key = Session["JUMP_KEY"].ToString(); //菜单的跳转KEY
a002_key = Session["JUMP_A002_KEY"].ToString();
}
catch
{
key = "-1";
a002_key = "-1";
}
try
{
IF_JUMP = Session["IF_JUMP"].ToString();
}
catch
{
IF_JUMP = "1";
}
key = Request.QueryString["JUMP_KEY"] == null ? "-1" : Request.QueryString["JUMP_KEY"].ToString();
a002_key = Request.QueryString["JUMP_A002_KEY"] == null ? "-1" : Request.QueryString["JUMP_A002_KEY"].ToString();
IF_JUMP = Request.QueryString["IF_JUMP"] == null ? "1" : Request.QueryString["IF_JUMP"].ToString();
string QUERY = Request.QueryString["QUERY"] == null ? "0" : Request.QueryString["QUERY"].ToString();
dt_main = Fun.getDtBySql("Select t.* from A002_v01 t where a002_key='" + a002_key + "'");
showchild = GlobeAtt.GetValue("SHOWCHILD_" + a002_key);
if (showchild == "")
{
Session["SHOWCHILD_" + a002_key] = "0";
showchild = "0";
}
string if_showdetail = "1";
try
{
if_showdetail = dt_main.Rows[0]["if_showdetail"].ToString();
}
catch
{
if_showdetail = "0";
}
if (if_showdetail == "1")
{
dt_detail = Fun.getDtBySql("Select t.* from A00201_V01 t where t.menu_id='" + dt_main.Rows[0]["MENU_ID"].ToString() + "' and line_no > 0 order by control_id");
}
else
{
dt_detail = Fun.getDtBySql("Select t.* from A00201_V01 t where t.menu_id='" + dt_main.Rows[0]["MENU_ID"].ToString() + "' and line_no > 0 and 1=2 order by control_id");
}
query_id = "";
if (QUERY == "0")
{
DataTable dt_a006 = new DataTable();
string a006_sql = "Select query_id from A006 t where user_id='" + GlobeAtt.A007_KEY + "' AND a00201_key ='" + a002_key + "' and DEF_FLAG ='1' and rownum = 1";
dt_a006 = Fun.getDtBySql(a006_sql);
if (dt_a006.Rows.Count > 0)
{
query_id = dt_a006.Rows[0][0].ToString();
}
else
{
query_id = "";
}
}
else
{
query_id = "最近的查询";
}
}