/// <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);
}
