public ActionResult CreateStore()
{
ETDataConnection gConn = new ETDataConnection(GetConnectionString(SDatabase));
DataTable tables = gConn.GetDataTable("SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME NOT LIKE N'%cof%'");
return(View(tables));
}
public JsonResult CreateObject(string jsonTable = "")
{
try
{
if (!String.IsNullOrEmpty(jsonTable))
{
List <GenerateTableModel> generateTables = JsonConvert.DeserializeObject <List <GenerateTableModel> >(jsonTable);
if (generateTables != null && generateTables.Count() > 0)
{
foreach (GenerateTableModel table in generateTables)
{
ETDataConnection gConn = new ETDataConnection(GetConnectionString(SDatabase));
TableInfo tableInfo = new TableInfo(table.TableName, gConn);
ClassInfo classInfo = new ClassInfo(tableInfo);
string fileTemplatePath = Server.MapPath("/DataTemp");
string fileResultPath = Server.MapPath("/DataGen");
classInfo.GenerateSourceCode(fileTemplatePath);
classInfo.Save(fileResultPath);
}
}
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
//constructor
public TableInfo(string name, ETDataConnection gConn)
{
this.Name = name;
this.gConn = gConn;
Colums = new List <ColumnInfo>();
// lấy danh sách cột
string strQuery = "select * " +
"from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='" + Name + "'";
DataTable dt = gConn.GetDataTable(strQuery);
// lấy danh sách các cột là khóa chính
strQuery = "select COLUMN_NAME from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where TABLE_NAME = '" + Name + "' and CONSTRAINT_NAME like N'PK_%'";
PrimaryKey = gConn.ExecuteScalar(strQuery).ToString();
for (int i = 0; i < dt.Rows.Count; i++)
{
ColumnInfo column = new ColumnInfo();
column.Name = dt.Rows[i]["COLUMN_NAME"].ToString();
column.DataType = dt.Rows[i]["DATA_TYPE"].ToString();
if (dt.Rows[i]["CHARACTER_MAXIMUM_LENGTH"].ToString() != "")
{
column.MaxValue = int.Parse(dt.Rows[i]["CHARACTER_MAXIMUM_LENGTH"].ToString());
}
else
{
column.MaxValue = 0;
}
if (dt.Rows[i]["NUMERIC_PRECISION"].ToString() != "")
{
column.NumericPrecision = int.Parse(dt.Rows[i]["NUMERIC_PRECISION"].ToString());
}
else
{
column.NumericPrecision = 0;
}
if (dt.Rows[i]["NUMERIC_SCALE"].ToString() != "")
{
column.NumericScale = int.Parse(dt.Rows[i]["NUMERIC_SCALE"].ToString());
}
else
{
column.NumericScale = 0;
}
column.Default = dt.Rows[i]["COLUMN_DEFAULT"].ToString();
if (column.Name != PrimaryKey)
{
Colums.Add(column);
}
}
this.StoredProcedure = "";
this.SpSelect = GenerateStoredProcedureGetFilter(this);
this.SpAddUpdate = GenerateStoredProcedureAddUpdate(this);
}
private bool TestConnection(DatabaseModel serverInfo)
{
try
{
ETDataConnection gConn = new ETDataConnection(GetConnectionString(serverInfo));
int test = int.Parse(gConn.ExecuteScalar("select 10").ToString());
if (test == 10)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public JsonResult CreateStore(string jsonTable = "")
{
try
{
if (!String.IsNullOrEmpty(jsonTable))
{
List <GenerateTableModel> generateTables = JsonConvert.DeserializeObject <List <GenerateTableModel> >(jsonTable);
if (generateTables != null && generateTables.Count() > 0)
{
foreach (GenerateTableModel table in generateTables)
{
ETDataConnection gConn = new ETDataConnection(GetConnectionString(SDatabase));
TableInfo tableInfo = new TableInfo(table.TableName, gConn);
tableInfo.CreateStoreProcedure();
}
}
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
