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操作成功!");//刷新页面 }