public string dolistA00204(string key__, string menu_id__, string line_no__)
{
/*获取要处理的sql*/
int rowcount = Fun.getRowCount(key__);
System.Text.StringBuilder str_sql = new System.Text.StringBuilder("");//抬头html
string sql_list = "";
for (int i = 0; i < rowcount; i++)
{
string data = Fun.getXmlData(key__, i, "PARM");
string e_sql = "select pkg_show.getRb_ExecSql('" + menu_id__ + "'," + line_no__ + ",'" + data + "','" + GlobeAtt.A007_KEY + "') as c from dual ";
DataTable dt_sql = new DataTable();
dt_sql = Fun.getDtBySql(e_sql);
e_sql = Fun.execSql(dt_sql.Rows[0][0].ToString(), GlobeAtt.A007_KEY, menu_id__ + "_" + line_no__);
if (e_sql != "0")
{
return(e_sql);
}
/*
*
* e_sql = dt_sql.Rows[0][0].ToString();
* e_sql = e_sql.Replace(" end;", "");
* e_sql = e_sql.Replace(" end", "");
* e_sql = e_sql.Replace(";end;", ";");
* e_sql = e_sql.Replace(";end", ";");
* e_sql = e_sql.Replace("begin ", "");
*
*
*
* if (e_sql.Substring(e_sql.Length - 1, 1) != ";")
* {
* e_sql = e_sql + ";";
* }
* str_sql.Append(e_sql );
* str_sql.Append(Environment.NewLine);
*/
}
// return "00" + str_sql.ToString();
return("01操作成功！");//刷新页面
}
