public string GetCode(string templateFile, string modelSuffix, Model.TableModel tableModel, List <Model.ColumnModel> columnModelList, string sql)
{
string result = File.ReadAllText(templateFile);
result = result.Replace("{TableName}", CamelCase(tableModel.tablename));
result = result.Replace("{tablename}", tableModel.tablename);
result = result.Replace("{Model}", new ModelGenerateBLL().GetModelClassName(CamelCase(tableModel.tablename), modelSuffix));
result = result.Replace("{sql}", GenerateSqlCode(columnModelList, sql));
//result = result.Replace("{Key}", GenerateKeyCode(columnModelList));
//result = result.Replace("{KeyWhere}", GenerateKeyWhereCode(columnModelList));
//result = result.Replace("{GetModelParameter}", GenerateGetModelParameterCode(columnModelList));
//result = result.Replace("{DataRowToModel}", GenerateDataRowToModelCode(columnModelList));
//result = result.Replace("{InsertFields}", GenerateInsertFieldsCode(columnModelList));
//result = result.Replace("{InsertValues}", GenerateInsertValuesCode(columnModelList));
//result = result.Replace("{InsertParameters}", GenerateInsertParametersCode(columnModelList));
//result = result.Replace("{UpdateSets}", GenerateUpdateSetsCode(columnModelList));
//result = result.Replace("{UpdateParameters}", GenerateUpdateParametersCode(columnModelList));
return(result);
}
public string DeleteMaker(Model.TableModel o)
{
StringBuilder sb = new StringBuilder();
sb.Append("Delete _TableName ");
string IdInfo = "";
foreach (var row in o.rows)
{
if (row.Key == "Id")
{
IdInfo = "Where Id =" + row.Value;
break;
}
}
sb.Append(IdInfo);
sb.Replace("_TableName", o.TableName);
return(sb.ToString());
}
public List <Model.TableModel> GetTableModelList(string schemaName = "public")
{
List <Model.TableModel> result = new List <Model.TableModel>();
DataTable dt = GetTables(schemaName);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Model.TableModel model = new Model.TableModel();
model.schemaname = row["schemaname"].ToString();
model.tablename = row["tablename"].ToString();
model.tableowner = row["tableowner"].ToString();
model.tablespace = row["tablespace"].ToString();
model.hasindexes = bool.Parse(row["hasindexes"].ToString());
result.Add(model);
}
}
return(result);
}
public string InsertMaker(Model.TableModel o)
{
StringBuilder sb = new StringBuilder();
string columns = "";
string values = "";
sb.Append(@"Insert Into _TableName (");
foreach (var row in o.rows)
{
if (row.Key == "Id" && Convert.ToInt32(row.Value) == 0)
{
continue;
}
columns += row.Key + " ,";
values += ToSqlString(row.Value) + ",";
}
columns = columns.TrimEnd(',');
values = values.TrimEnd(',');
sb.Append(columns).Append(") Values(").Append(values).Append(")");
sb.Replace("_TableName", o.TableName);
return(sb.ToString());
}
private void GenerateCode(Model.TableModel table, List <Model.ColumnModel> columns)
{
string nameSpace = tbxNameSpace.Text.Trim();
string modelSuffix = tbxModel.Text.Trim();
string dalSuffix = tbxDAL.Text.Trim();
string bllSuffix = tbxBLL.Text.Trim();
BLL.ModelGenerateBLL model = new BLL.ModelGenerateBLL();
tecModel.Text = model.GetCode(Application.StartupPath + "/Templates/Model.cs.tpl",
nameSpace, modelSuffix, table, columns);
BLL.DALGenerateBLL dal = new BLL.DALGenerateBLL();
tecDAL.Text = dal.GetCode(Application.StartupPath + "/Templates/DAL.cs.tpl",
nameSpace, dalSuffix, modelSuffix, table, columns);
BLL.BLLGenerateBLL bll = new BLL.BLLGenerateBLL();
tecBLL.Text = bll.GetCode(Application.StartupPath + "/Templates/BLL.cs.tpl",
nameSpace, bllSuffix, dalSuffix, modelSuffix, table, columns);
tecSqlQuery.Text = string.Format("SELECT * FROM {0}.{1} WHERE {2}=0",
table.schemaname, table.tablename, columns[0].name);
}
public string UpdateMaker(Model.TableModel o)
{
StringBuilder sb = new StringBuilder();
string sets = "";
string IdInfo = "";
sb.Append("Update _TableName Set ");
foreach (var row in o.rows)
{
if (row.Key == "Id")
{
IdInfo = "Where Id =" + row.Value;
}
else
{
sets += row.Key + " = " + ToSqlString(row.Value) + ",";
}
}
sets = sets.TrimEnd(',');
sb.Append(sets).Append(IdInfo);
sb.Replace("_TableName", o.TableName);
return(sb.ToString());
}
public string GetCode(string templateFile, string nameSpace, string modelSuffix, Model.TableModel tableModel, List <Model.ColumnModel> columnModelList)
{
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Company.Project";
}
string result = File.ReadAllText(templateFile);
result = result.Replace("{DateTime}", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
result = result.Replace("{NameSpace}", nameSpace);
result = result.Replace("{TableName}", CamelCase(tableModel.tablename));
result = result.Replace("{ModelSuffix}", modelSuffix);
StringBuilder sbColumns = new StringBuilder();
foreach (var columnModel in columnModelList)
{
sbColumns.AppendLine(string.Format("\t\tpublic {0} {1}",
GetCSharpTypeString(columnModel.type, columnModel.notnull), CamelCase(columnModel.name)) + " { get; set; }");
}
result = result.Replace("{Columns}", sbColumns.ToString());
return(result);
}
public string GetCode(string templateFile, string nameSpace, string dalSuffix, string modelSuffix, Model.TableModel tableModel, List <Model.ColumnModel> columnModelList)
{
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Company.Project";
}
string result = File.ReadAllText(templateFile);
result = result.Replace("{DateTime}", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
result = result.Replace("{NameSpace}", nameSpace);
result = result.Replace("{TableName}", CamelCase(tableModel.tablename));
result = result.Replace("{tablename}", tableModel.tablename);
result = result.Replace("{DALSuffix}", dalSuffix);
result = result.Replace("{Model}", new ModelGenerateBLL().GetModelClassName(CamelCase(tableModel.tablename), modelSuffix));
result = result.Replace("{Key}", GenerateKeyCode(columnModelList));
result = result.Replace("{KeyWhere}", GenerateKeyWhereCode(columnModelList));
result = result.Replace("{GetModelParameter}", GenerateGetModelParameterCode(columnModelList));
result = result.Replace("{DataRowToModel}", GenerateDataRowToModelCode(columnModelList));
result = result.Replace("{InsertFields}", GenerateInsertFieldsCode(columnModelList));
result = result.Replace("{InsertValues}", GenerateInsertValuesCode(columnModelList));
result = result.Replace("{InsertParameters}", GenerateInsertParametersCode(columnModelList));
result = result.Replace("{UpdateSets}", GenerateUpdateSetsCode(columnModelList));
result = result.Replace("{UpdateParameters}", GenerateUpdateParametersCode(columnModelList));
return(result);
}
public string GetCode(string templateFile, string nameSpace, string bllSuffix, string dalSuffix, string modelSuffix, Model.TableModel tableModel, List <Model.ColumnModel> columnModelList)
{
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Company.Project";
}
string result = File.ReadAllText(templateFile);
result = result.Replace("{DateTime}", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
result = result.Replace("{NameSpace}", nameSpace);
result = result.Replace("{TableName}", CamelCase(tableModel.tablename));
result = result.Replace("{tablename}", tableModel.tablename);
result = result.Replace("{BLLSuffix}", bllSuffix);
result = result.Replace("{DAL}", new DALGenerateBLL().GetDALClassName(CamelCase(tableModel.tablename), dalSuffix));
result = result.Replace("{Model}", new ModelGenerateBLL().GetModelClassName(CamelCase(tableModel.tablename), modelSuffix));
result = result.Replace("{Key}", GenerateKeyCode(columnModelList));
result = result.Replace("{KeyParam}", GenerateKeyParamCode(columnModelList));
return(result);
}