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());
Database OP model
最新推荐文章于 2023-03-30 14:15:08 发布