protected void BaseUc_Page_Load(object sender, EventArgs e)
{
SH = Screen.PrimaryScreen.Bounds.Height;
SW = Screen.PrimaryScreen.Bounds.Width;
dt_a00201 = Fun.getDtBySql("Select t.* from A00201_V01 t where a00201_key = '" + a00201_key + "'");
// dt_a0130101 = Fun.getA0130101(a00201_key);
//dt_a013010101 = Fun.getA013010101(a00201_key);
// showdatasql = Fun.getShowDataSql(a00201_key);
// A002_ID='[REQUEST_A002ID]'
//解析出request
for (int i = 0; i < Request.QueryString.AllKeys.Length; i++)
{
string key = Request.QueryString.AllKeys.GetValue(i).ToString();
// Request.QueryString("").
showdatasql = showdatasql.Replace("[REQUEST_" + key.ToUpper() + "]", Request.QueryString[key].ToString());
}
string json = "";
try
{
json = Session["J_" + dt_a00201.Rows[0]["A00201_KEY"].ToString()].ToString();
}
catch
{
json = "";
}
if (json == "")
{
Hashtable ht = new Hashtable();
dt_a013010101 = Fun.getA013010101(a00201_key);
ht.Add("P1", Fun.DataTable2Json(dt_a013010101));
ht.Add("P2", dt_a00201.Rows[0]["TABLE_KEY"].ToString());
ht.Add("P3", dt_a00201.Rows[0]["main_key"].ToString());
ht.Add("P4", dt_a00201.Rows[0]["table_id"].ToString());
ht.Add("P5", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00210_V01 t where a00201_key ='" + dt_a00201.Rows[0]["A00201_KEY"].ToString() + "' and rb_type='C'")));
ht.Add("P6", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00210_V01 t where a00201_key ='" + dt_a00201.Rows[0]["A00201_KEY"].ToString() + "' and rb_type='U'")));
ht.Add("P7", dt_a00201.Rows[0]["tbl_type"].ToString());
ht.Add("P8", Fun.DataTable2Json(Fun.getDtBySql("select t.* from a00201_v02 t where a00201_key ='" + dt_a00201.Rows[0]["A00201_KEY"].ToString() + "' order by sort_by")));
// ht.Add("P001", Fun.DataTable2Json(Fun.getDtBySql("Select t.* from A00201_V01 t where a00201_key = '" + a00201_key + "'")));
// ht.Add("P002", Fun.getA0130101(a00201_key));
// ht.Add("P003", Fun.DataTable2Json(dt_a013010101));
ht.Add("P004", Fun.getShowDataSql(a00201_key));
string jsonText = JsonConvert.SerializeObject(ht);
Session["J_" + dt_a00201.Rows[0]["A00201_KEY"].ToString()] = jsonText;
json = jsonText;
}
else
{
dt_a013010101 = Fun.getdtByJson(Fun.getJson(json, "P1"));
}
showdatasql = Fun.getJson(json, "P004");
}
public String getPData(string a00201_key___, string pnum)
{
string v = "";
try
{
string jsonText = Session["J_" + a00201_key___].ToString();
v = Fun.getJson(jsonText, pnum);
return(v);
}
catch (Exception ex) {
v = "";
}
return(v);
}
public void PageBase_Load(object sender, System.EventArgs e)
{
if (GlobeAtt.A007_KEY == "")
{
Response.Write("showlogin();");
return;
}
try
{
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
a00201_key = BaseFun.getAllHyperLinks(RequestXml, "<A00201KEY>", "</A00201KEY>")[0].Value;
try
{
RequestURL = BaseFun.getAllHyperLinks(RequestXml, "<URL>", "</URL>")[0].Value;
}
catch
{
RequestURL = "";
}
}
catch (Exception ex)
{
a00201_key = "-1";
return;
}
// a00201_key = Request.QueryString["A00201KEY"] == null ? "-1" : Request.QueryString["A00201KEY"].ToString();
if (a00201_key == "-1")
{
return;
}
try
{
json = Session["JSON_" + a00201_key].ToString();
}
catch
{
json = "";
}
if (GlobeAtt.SYS_MODE == "K")
{
json = "";
}
if (json == "")
{
Hashtable ht = new Hashtable();
dt_a013010101 = Fun.getA013010101(a00201_key);
dt_a00201 = Fun.getDtBySql("Select t.* from A00201_V01 t where a00201_key = '" + a00201_key + "' order by line_no ");
//列属性
ht.Add("P1", Fun.DataTable2Json(dt_a013010101));
//菜单属性
ht.Add("P2", Fun.DataTable2Json(dt_a00201));
//数据检测属性
if (dt_a00201.Rows[0]["IF_MAIN"].ToString() == "1")
{
ht.Add("P3", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00210_V01 t where menu_id ='" + dt_a00201.Rows[0]["MENU_ID"].ToString() + "' and rb_type='C'")));
ht.Add("P4", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00210_V01 t where menu_id ='" + dt_a00201.Rows[0]["MENU_ID"].ToString() + "' and rb_type='U'")));
ht.Add("P9", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00201_V01 t where menu_id ='" + dt_a00201.Rows[0]["MENU_ID"].ToString() + "' order by line_no")));
}
//右键属性
ht.Add("P5", Fun.DataTable2Json(Fun.getDtBySql("select t.* from a00201_v02 t where a00201_key ='" + a00201_key + "' order by sort_by")));
//查询数据的SQL
showdatasql = Fun.getShowDataSql(a00201_key);
ht.Add("P6", showdatasql);
//查询数据数量的SQL
getShowDataCountSql = Fun.getShowDataCountSql(a00201_key);
ht.Add("P7", getShowDataCountSql);
//打印列表
if (dt_a00201.Rows[0]["if_main"].ToString() == "1")
{
ht.Add("P8", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00205 t where menu_id ='" + dt_a00201.Rows[0]["menu_id"].ToString() + "' order by sort_by")));
}
else
{
ht.Add("P8", "");
}
string form_init = dt_a00201.Rows[0]["FORM_INIT"].ToString();
ht.Add("P10", form_init);
string jsonText = JsonConvert.SerializeObject(ht);
Session["JSON_" + a00201_key] = jsonText;
json = jsonText;
}
else
{
dt_a013010101 = Fun.getdtByJson(Fun.getJson(json, "P1"));
dt_a00201 = Fun.getdtByJson(Fun.getJson(json, "P2"));
showdatasql = Fun.getJson(json, "P6");
getShowDataCountSql = Fun.getJson(json, "P7");
}
try
{
QUERYID = BaseFun.getAllHyperLinks(RequestXml, "<QUERYID>", "</QUERYID>")[0].Value;
}
catch
{
QUERYID = "";
}
string condition = "";
if (QUERYID != "")
{
condition = Fun.getQueryCondition(dt_a00201, QUERYID);
int pos = condition.IndexOf("ORDER BY");
string str_order = "";
if (pos > 0)
{
str_order = condition.Substring(pos);
condition = condition.Substring(0, pos - 1);
}
showdatasql = showdatasql + condition + " " + str_order;
getShowDataCountSql = getShowDataCountSql + condition;
}
string url = "";
try
{
url = BaseFun.getAllHyperLinks(RequestXml, "<URL>", "</URL>")[0].Value;
}
catch
{
url = "";
}
if (url.IndexOf("?") > 0)
{
int pos = url.IndexOf("?");
url = url.Substring(pos + 1);
string[] data_ = url.Split('&');
for (int i = 0; i < data_.Length; i++)
{
string[] data1_ = data_[i].Split('=');
showdatasql = showdatasql.Replace("[REQUEST_" + data1_[0] + "]", data1_[1]);
getShowDataCountSql = getShowDataCountSql.Replace("[REQUEST_" + data1_[0] + "]", data1_[1]);
}
}
}
