/// <summary> /// 根据传入参数生成SQL /// </summary> private void AnalysisData() { try { string errorStr = ""; DataTable dt = Session["DataTable"] as DataTable; Common.ConfigModel modelConfig = Common.ConfigOperater.GetConfigModel(); DAL.SqlHelper.connectionString = modelConfig.SqlConnectionString; InitConfig(modelConfig); string result = SetExcelToSQL.RenderDataTableToSQLResult(dt, modelConfig, ref errorStr); if (errorStr != "") { SQLResult.InnerText = errorStr; sqlConnection.Value = modelConfig.SqlConnectionString; } else { SQLResult.InnerText = result; sqlConnection.Value = modelConfig.SqlConnectionString; } } catch (Exception ex) { SQLResult.InnerText = ex.ToString(); } }
public List <DAL.TableColomns> GetColomn() { if (listColomn == null) { if (Session["DataTable"] != null) { Common.ConfigModel modelConfig = Common.ConfigOperater.GetConfigModel(); DAL.SqlHelper.connectionString = modelConfig.SqlConnectionString; listColomn = dalColomn.GetColomns(modelConfig.TableName); } else { listColomn = new List <DAL.TableColomns>(); } } return(listColomn); }
public List <string> GetTables() { if (listTables == null) { if (Session["DataTable"] != null) { Common.ConfigModel modelConfig = Common.ConfigOperater.GetConfigModel(); DAL.SqlHelper.connectionString = modelConfig.SqlConnectionString; listTables = dalColomn.GetTableNames(modelConfig.TableName); } else { listExcelField = new List <string>(); } } return(listTables); }