优化

schangxiang@126.com

2025-05-21 aab29f4290c968665312bfc98c5598a25a4debf9

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
 
 
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;
        }
 
    }
}