public BasePage() { // // TODO: 在此处添加构造函数逻辑 // http_url = Fun.GetIndexUrl(); }
protected void Page_Load(object sender, EventArgs e) { try { table_id = Request.QueryString["table_id"] == null ? "" : Request.QueryString["table_id"].ToString(); key_id = Request.QueryString["key_id"] == null ? "" : Request.QueryString["key_id"].ToString(); line_no = Request.QueryString["line_no"] == null ? "" : Request.QueryString["line_no"].ToString(); basekey = Request.QueryString["basekey"] == null ? "" : Request.QueryString["basekey"].ToString(); basekey = basekey.Replace("-", "+"); key_id = key_id.Replace("-", "+"); key_id = key_id.Replace("'", "''"); string sql = "Select t.* from A10001 t where t.table_id='" + table_id + "' and line_no='" + line_no + "'"; dt_a10001 = fun.getDtBySql(sql); a308_id = dt_a10001.Rows[0]["col_mask"].ToString(); dt_a308 = fun.getDtBySql("Select t.* from A308 t where t.a308_id='" + a308_id + "'"); FILE_TYPE = dt_a308.Rows[0]["FILE_TYPE"].ToString().ToUpper(); // FILE_TYPE = FILE_TYPE.Substring(0, 3); if (FILE_TYPE != "*") { string model_file_name_ = HttpContext.Current.Request.MapPath("../data/" + a308_id + "." + FILE_TYPE); if (System.IO.File.Exists(model_file_name_)) { model_file_name = fun.GetIndexUrl() + "\\data\\" + a308_id + "." + FILE_TYPE; } else { model_file_name = ""; } } else { model_file_name = ""; } dt_a30801 = fun.getDtBySql("Select t.* from A30801 t where t.a308_id='" + a308_id + "'"); dt_a30802 = fun.getDtBySql("Select t.* from A30802 t where t.a308_id='" + a308_id + "'"); uploadfilepath = "..\\data\\import\\" + a308_id + "\\upload"; sql = "Select count(*) from a30803 t where a308_id='" + a308_id + "' and t.BASE_TABLE_ID='" + table_id + "' and BASE_COLUMN_ID='" + dt_a10001.Rows[0]["COLUMN_ID"].ToString() + "' and BASE_KEY='" + basekey + "'"; DataTable dt_count = new DataTable(); dt_count = fun.getDtBySql(sql); if (dt_count.Rows[0][0].ToString() == "0") { DataTable dt_key = new DataTable(); dt_key = fun.getDtBySql("select s_a30803.nextval as c from dual "); a30803_key = dt_key.Rows[0][0].ToString(); sql = "insert into a30803(a308_id,line_no,d001_id,d001_name,BASE_TABLE_ID,BASE_COLUMN_ID,BASE_KEY,BASE_USER,BASE_DATE,state)"; sql += "Select '" + a308_id + "'," + a30803_key + ",'" + key_id + "','','" + table_id + "','" + dt_a10001.Rows[0]["COLUMN_ID"].ToString() + "','" + basekey + "','" + GlobeAtt.A007_KEY + "',sysdate,'-1' from dual "; // Response.Write(sql); fun.execSqlOnly(sql); } else { DataTable dt_key = new DataTable(); sql = "select line_no as c from a30803 t where a308_id='" + a308_id + "' and t.BASE_TABLE_ID='" + table_id + "' and BASE_COLUMN_ID='" + dt_a10001.Rows[0]["COLUMN_ID"].ToString() + "' and BASE_KEY='" + basekey + "'"; // Response.Write(sql); dt_key = fun.getDtBySql(sql); a30803_key = dt_key.Rows[0][0].ToString(); } } catch (Exception ex) { Response.Write(ex.Message.Replace("\n", ";").Replace("'", "\"")); } }