尝试着写自己的代码生成器(4)

 88         {
 89             //暂时假设主键名就是id
 90              DataTable dt_column = ExecuteDataTable("select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=@tablename and Column_Name<>'id'", new SqlParameter("tablename", TableName));
 91            string[] ColumnNames=new string[dt_column.Rows.Count];//保存所属表中的字段名
 92            for(int i=0;i<dt_column.Rows.Count;i++)
 93            {
 94              string colname=(string)dt_column.Rows[i]["COLUMN_NAME"];//获得列名
 95                ColumnNames[i]=colname;//将循环获取的列名加入列名数组
 96            }
 97            string[] paramers = new string[dt_column.Rows.Count];
 98             for(int i=0;i<paramers.Length;i++)
 99             {
100                paramers[i]="@"+ColumnNames[i];
101             }
102           
103             StringBuilder sb = new StringBuilder();
104             sb.AppendLine("//添加操作");
105             sb.AppendLine(" partial Class " + TableName + "DAL");
106             sb.AppendLine("{");
107             sb.AppendLine("public static int AddNew(" + TableName + "model");//返回新添加字段的主键");
108             sb.AppendLine("{");
109             sb.AppendLine("object obj= SQLHelper.ExecuteScalar(");
110             sb.AppendLine("\"insert into "+TableName+"("+string.Join(",",ColumnNames)+") output inserted.id values("+string.Join(",",paramers)+")\"");