|
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
|
namespace GenerateCode_GEBrilliantFactory
|
{
|
/// <summary>
|
/// InsertSQL文件生成
|
/// </summary>
|
public class InsertSQL_Generate : BaseGenerate
|
{
|
/// <summary>
|
/// 生成InsertSQL
|
/// </summary>
|
/// <param name="TableName"></param>
|
/// <param name="Author"></param>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
public static string CreateInsertSQLText(string TableName, string Author, string ChinaComment,
|
List<ColumnModel> columnNameList)
|
{
|
try
|
{
|
StringBuilder sbText = new StringBuilder();
|
|
sbText.Append(GetInsertSQLStr(TableName, Author,ChinaComment, columnNameList));
|
|
return sbText.ToString();
|
}
|
catch (Exception)
|
{
|
throw;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 生成InsertSQL
|
/// </summary>
|
/// <param name="TableName"></param>
|
/// <param name="Author"></param>
|
/// <param name="columnNameList"></param>
|
/// <returns></returns>
|
private static string GetInsertSQLStr(string TableName, string Author, string ChinaComment, List<ColumnModel> columnNameList)
|
{
|
var str = TextHelper.ReadText(@"Templete\InitSQL模板.txt");
|
|
CommonReplace(ref str);
|
|
str = str.Replace("$TableName$", TableName);//表名
|
str = str.Replace("$Author$", Author);//作者
|
str = str.Replace("$TableName$", TableName);//表名
|
str = str.Replace("$Author$", Author);//作者
|
str = str.Replace("$ChinaComment$", ChinaComment);//中文注释
|
|
str = str.Replace("$CurDate$", CommonHelper.GetCurDate());//当前时间
|
|
|
string str_insert_cols = StructStrHelper.GetColumnsStrNoIDForAdd(columnNameList, "");
|
str = str.Replace("$insert_cols$", str_insert_cols);
|
str = str.Replace("$insert_cols_values$", StructStrHelper.GetColumnsStrNoIDForInsertSQL(columnNameList));
|
|
return str;
|
}
|
|
}
|
}
|
