Database OP model

   StringBuilder sb = new StringBuilder();
        string t1 = "   public string  ";
        string t2 = " { get; set; }  ";


        string p1 = "  new SqlParameter(\"@";
        string p2 = "\", data.";
        string p3 = "),\r\n";



        string column = "";
        string columnat = "";
        string feild = "";
        string createnew = "";
        string updatestr = "";
        string objstr = "";
        string queryallstr = "";

        string usingstr = "";
        column = txtsql.Text.Trim();
        columnat ="@"+ column.Replace(",", ",@");
        log.Info(column);
        log.Info(columnat);


        Array list = column.Split(',');
        foreach(var obj in list)
        {
            sb.Append(t1 + obj.ToString() + t2);
            sb.Append("\r\n");
        }

        feild = sb.ToString();

        sb.Clear();

        sb.Append("       public static void CreateNew(XXX data)  \r\n");
        sb.Append("   { \r\n");
        sb.Append("    string sql=\" insert into XXX(");
        sb.Append(column);
        sb.Append(")values( ");
        sb.Append(columnat + ")\";");

        sb.Append("\r\n");
        sb.Append("     SqlParameter[] paras = new SqlParameter[]   \r\n");
        sb.Append("     {\r\n");

        foreach (var obj in list)
        {
            sb.Append(p1 + obj.ToString() +p2+obj.ToString()+ p3);
             
        }

        sb.Append("      };\r\n");

        sb.Append("   foreach (SqlParameter parm in paras)   \r\n         {\r\n             if (parm.Value == null)\r\n");
        sb.Append("                parm.Value = DBNull.Value; \r\n          }\r\n         MsSql.ExecInsertParaTrans(sql, paras); \r\n  }");

        createnew = sb.ToString();
        sb.Clear();


        sb.Append("\r\n");
        sb.Append("      public static void UpdateDataByRefID(XXX data)\r\n         {\r\n " );
        sb.Append("        const string sql = \"update XXX set  \"; \r\n");
        sb.Append("           StringBuilder sb = new StringBuilder(); \r\n");
        sb.Append("        sb.Append(sql);\r\n");


        foreach(var obj in list)
        {
            sb.Append("  sb.AppendFormat( \"  "+obj.ToString()+ "='{0}' \", data."+obj.ToString()+");\r\n");
        }

        sb.Append("      MsSql.ExcuteNOQueryStr(sb.ToString()); \r\n");
        sb.Append("         }");

        updatestr = sb.ToString();

        sb.Clear();

        sb.Append("\r\n \r\n");


        sb.Append("public static XXX GetObject(string itemid) \r\n           {\r\n");
        sb.Append("        XXX data = new XXX(); \r\n");
        sb.Append("        DataTable dt = XXX.QueryDataByItemID(itemid); \r\n");
        sb.Append("        if(dt==null || dt.Rows.Count==0) \r\n");
        sb.Append("         {\r\n");
        sb.Append("             return null; \r\n");
        sb.Append("         }\r\n");
        sb.Append("         else\r\n           {\r\n");



        foreach (var obj in list)
        {
            sb.Append("            data." + obj.ToString() + "  = dt.Rows[0][\"" + obj.ToString() + "\"].ToString(); \r\n");
        }

        sb.Append("            if (dt.Rows[0][\"create_time\"] != System.DBNull.Value) \r\n");
        sb.Append("            {\r\n");
        sb.Append("                data.create_time = Convert.ToDateTime(dt.Rows[0][\"create_time\"]);\r\n");
        sb.Append("             }\r\n");
        sb.Append("            return data;\r\n");
        sb.Append("              }\r\n");
        sb.Append("   }");

        objstr = sb.ToString();

        sb.Clear();

        sb.Append("\r\n \r\n \r\n");


        sb.Append(" public static DataTable QueryAll() \r\n");
        sb.Append("     {\r\n");
        sb.Append("         string sql = \" select refid,");
        sb.Append(column);
        sb.Append(" from XXX      \r\n");

        sb.Append("        return MsSql.ExecuteQueryDataTable(sql);\r\n");
        sb.Append("    }");

        queryallstr = sb.ToString();


        sb.Clear();
        sb.Append("\r\n \r\n \r\n");
        sb.Append(" using System;\r\n");
        sb.Append(" using System.Collections.Generic;\r\n");
        sb.Append(" using System.Linq;\r\n");
        sb.Append(" using System.Web;\r\n");
        sb.Append(" using System.Data;\r\n");
        sb.Append(" using System.Data.SqlClient;\r\n");
        sb.Append(" using System.Text;\r\n");

        usingstr = sb.ToString();








        sb.Clear();

        sb.Append("\r\n \r\n \r\n");

        

       

        sb.Append(feild);
        sb.Append("\r\n \r\n \r\n");
        sb.Append(column);
        sb.Append("\r\n \r\n \r\n");
        sb.Append(columnat);
        sb.Append("\r\n \r\n \r\n");
        sb.Append(createnew);
        sb.Append("\r\n \r\n \r\n");
        sb.Append(updatestr);
        sb.Append("\r\n \r\n \r\n");
        sb.Append(objstr);
        sb.Append("\r\n \r\n \r\n");
        sb.Append(queryallstr);


        log.Info(sb.ToString());