public string DoA014Query(string a014_id_, string objid_, string table____)
{
string sql_ = objid_;
string[] sqllist = Regex.Split(objid_, "<V></V>", RegexOptions.IgnoreCase);
string e_sqllist = "";
for (int i = 0; i < sqllist.Length; i++)
{
string str_sql = sqllist[i];
if (str_sql == null || str_sql.Length < 5)
{
continue;
}
/*获取要处理的sql*/
try
{
string e_sql = "pkg_a.doa014('" + a014_id_ + "','" + table____ + "','" + str_sql + "','" + GlobeAtt.A007_KEY + "',[A311_KEY])";
e_sqllist += "begin " + e_sql + ";end;";
e_sql = Fun.execSql(e_sql, GlobeAtt.A007_KEY, GlobeAtt.A002_KEY, "A014_ID=" + a014_id_);
if (e_sql != "0")
{
return(e_sql);
}
}
catch (Exception ex)
{
return("00" + ex.Message);
}
}
// public string execSqlList(string sqlxml, string user_id_, string menu_id_,string key_id,string a014_id_)
Fun.execSqlList(e_sqllist, GlobeAtt.A007_KEY, GlobeAtt.A002_KEY, "[A311_KEY]", a014_id_);
return("00" + BaseMsg.getMsg("M0018"));;
}
protected void Page_Load(object sender, EventArgs e)
{
base.PageBase_Load(sender, e);
/*获取当前的角色列表*/
A014ID = Request.QueryString["A014ID"] == null ? "" : Request.QueryString["A014ID"].ToString();
ROWID = Request.QueryString["ROWID"] == null ? "" : Request.QueryString["ROWID"].ToString();
dt_A014 = Fun.getDtBySql("Select t.* from A014 t where t.a014_id='" + A014ID + "'");
if (dt_A014.Rows.Count == 0)
{
Response.Write("<script>winclose();</script>");
}
IF_FIRST = dt_A014.Rows[0]["IF_FIRST"].ToString();
DataTable dt_index = new DataTable();
dt_index = Fun.getDtBySql("select f_get_data_index() as c from dual");
data_index = dt_index.Rows[0][0].ToString();
try
{
if (IF_FIRST == "4")
{
child_url = dt_A014.Rows[0]["A014_SQL"].ToString();
DataTable dt_url = new DataTable();
dt_url = Fun.getDtBySql(child_url.Replace("[ROWID]", ROWID));
child_url = dt_url.Rows[0][0].ToString();
width_ = dt_url.Rows[0][1].ToString();
height_ = dt_url.Rows[0][2].ToString();
}
if (IF_FIRST == "5")
{
child_url = dt_A014.Rows[0]["NEXT_DO"].ToString();
exec_sql = dt_A014.Rows[0]["A014_SQL"].ToString();
dt_data = Fun.getDtBySql(child_url.Replace("[ROWID]", ROWID));
int max_width = 0;
int max_height = 0;
for (int i = 0; i < dt_data.Rows.Count; i++)
{
string width = dt_data.Rows[i]["width"].ToString();
string height = dt_data.Rows[i]["height"].ToString();
if (int.Parse(width) > max_width)
{
max_width = int.Parse(width);
}
max_height += int.Parse(height) + 25;
}
width_ = max_width.ToString();
height_ = max_height.ToString();
}
}
catch
{
Response.Write("<script> alert(\"" + BaseMsg.getMsg("M0014") + "\");winclose();</script>");
}
}
public string getMsg(string msg_id)
{
return(BaseMsg.getMsg(msg_id));
}