public string BackupToQuery(string tablename, WebPath webPath)
{
MapperProvider defaultProvider = MapperProvider.DefaultProvider;
string str = string.Concat("SELECT * FROM ", tablename);
string dataSetQuery = SourceBuilder.GetDataSetQuery(defaultProvider.QueryForValueSet(str, null, CommandType.Text).Tables[0], tablename);
File.WriteAllText(webPath.Path, dataSetQuery);
return(string.Concat(new string[] { "<a href='", webPath.AbsolutePath, "'>", tablename, "</a>" }));
}
public string BuildService(string tablename)
{
string pascalCase = tablename.Substring(3);
pascalCase = SourceBuilder.ToPascalCase(pascalCase);
string str = "\r\nusing Test.Core;\r\nusing System;\r\nusing System.Linq;\r\nusing System.Collections.Generic;\r\nusing System.Transactions;\r\n\r\nnamespace [SOLUTION]\r\n{\r\n public class [ENTITY]Service : BaseService\r\n {\r\n public I[ENTITY]Mapper mapper[ENTITY] = null;\r\n\r\n public int Create([ENTITY]Entity [PARAM])\r\n {\r\n mapper[ENTITY].Create([PARAM]);\r\n }\r\n\r\n public int Update([ENTITY]Entity [PARAM])\r\n {\r\n return mapper[ENTITY].Update([PARAM]);\r\n }\r\n\r\n public int Delete(Sequence [PARAM]Id)\r\n {\r\n return mapper[ENTITY].Delete([PARAM]Id);\r\n }\r\n\r\n\r\n public [ENTITY]Entity Get(Sequence [PARAM]Id)\r\n {\r\n return mapper[ENTITY].Get([PARAM]Id);\r\n }\r\n\r\n public List<[ENTITY]Entity> GetList(SearchVo search, bool containCount = true)\r\n {\r\n search.SetSort();\r\n if (containCount)\r\n {\r\n search.TotalCount = mapper[ENTITY].GetListCount(search);\r\n }\r\n return mapper[ENTITY].GetList(search, search.GetRange());\r\n }\r\n }\r\n}\r\n".Replace("[SOLUTION]", this._namespace).Replace("[ENTITY]", pascalCase);
char chr = pascalCase[0];
return(str.Replace("[PARAM]", string.Concat(chr.ToString().ToLower(), pascalCase.Substring(1))));
}
public string BuildController(string tablename)
{
string pascalCase = tablename.Substring(3);
pascalCase = SourceBuilder.ToPascalCase(pascalCase);
string str = "\r\nusing using Test.Core;\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.Linq;\r\nusing System.Web;\r\nusing System.Web.Mvc;\r\n\r\nnamespace [SOLUTION].Controllers\r\n{\r\n public class [ENTITY]Controller : BaseController\r\n {\r\n [HttpGet]\r\n public ActionResult Write([ENTITY]SearchModel search)\r\n {\r\n }\r\n\r\n [HttpPost]\r\n public ActionResult Write([ENTITY]SearchModel search)\r\n {\r\n search.SetSort();\r\n search.UserID = _User.UserID;\r\n\r\n search.TotalCount = [PARAM]Repository.Get[ENTITY]Count(search);\r\n ViewData[\"List\"] = [PARAM]Repository.Get[ENTITY]List(search);\r\n\r\n ViewData[\"Search\"] = search;\r\n return View();\r\n \r\n }\r\n\r\n public ActionResult Read(string [PARAM]ID)\r\n {\r\n var [PARAM] = [PARAM]Repository.Get[ENTITY]([PARAM]ID);\r\n \r\n ViewData[\"[ENTITY]\"] = [PARAM];\r\n\r\n return View();\r\n }\r\n\r\n [Authorize]\r\n [HttpGet]\r\n public ActionResult Write(string [PARAM]ID)\r\n {\r\n [PARAM]Entity [PARAM];\r\n if (string.IsNullOrEmpty([PARAM]ID))\r\n {\r\n [PARAM] = new [PARAM]Entity();\r\n [PARAM].[ENTITY]ID = Sequence.Generate();\r\n }\r\n else\r\n {\r\n [PARAM] = [PARAM]Repository.Get[ENTITY]([PARAM]ID);\r\n\r\n if ([PARAM].RegID != _User.UserID && _User.User.AuthType != AuthType.ADMIN)\r\n {\r\n return new HttpStatusCodeResult(System.Net.HttpStatusCode.Forbidden);\r\n }\r\n }\r\n\r\n ViewData[\"[ENTITY]\"] = [PARAM];\r\n\r\n return View();\r\n }\r\n \r\n [Authorize]\r\n [HttpPost]\r\n public ActionResult Write([ENTITY]Entity [PARAM])\r\n {\r\n var [PARAM] = [PARAM]Repository.Get[ENTITY]([PARAM].[ENTITY]ID);\r\n\r\n if([PARAM] == null)\r\n {\r\n [PARAM].RegID = _User.UserID;\r\n [PARAM]Repository.Create[ENTITY]([PARAM]);\r\n }\r\n else if (existEntity.RegID == _User.UserID || _User.User.AuthType == AuthType.ADMIN)\r\n {\r\n [PARAM]Repository.Update[ENTITY]([PARAM]);\r\n }\r\n else\r\n {\r\n return new HttpStatusCodeResult(System.Net.HttpStatusCode.Forbidden);\r\n }\r\n\r\n return RedirectToAction(\"List\");\r\n }\r\n\r\n [Authorize]\r\n [HttpPost]\r\n public ActionResult Delete(string [PARAM]ID )\r\n {\r\n var [PARAM] = [PARAM]Repository.Get[ENTITY]([PARAM]ID);\r\n\r\n if ([PARAM].RegID == _User.UserID || _User.AuthType == AuthType.Admin)\r\n {\r\n [PARAM]Repository.Delete[ENTITY]([PARAM]ID);\r\n \r\n }\r\n else\r\n {\r\n return new HttpStatusCodeResult(System.Net.HttpStatusCode.Forbidden);\r\n }\r\n\r\n return RedirectToAction(\"List\");\r\n }\r\n }\r\n}\r\n\r\n".Replace("[SOLUTION]", this._namespace).Replace("[ENTITY]", pascalCase);
char chr = pascalCase[0];
return(str.Replace("[PARAM]", string.Concat(chr.ToString().ToLower(), pascalCase.Substring(1))));
}
public string BuildMapper(string tablename)
{
string str = "\r\nusing Test.Core;\r\nusing System;\r\nusing System.Collections.Generic;\r\n\r\nnamespace [SOLUTION]\r\n{\r\n public interface I[ENTITY]Mapper : IMapper\r\n {\r\n void Create([ENTITY]Entity [PARAM]);\r\n int Update([ENTITY]Entity [PARAM]);\r\n int Delete(Sequence [PARAM]Id);\r\n\r\n [ENTITY]Entity Get(Sequence [PARAM]Id);\r\n List<[ENTITY]Entity> GetList(SearchVo search, RangeVo range = null);\r\n [Name(\"[ENTITY].GetList\")]\r\n int GetListCount(SearchVo search);\r\n }\r\n}\r\n".Trim();
string pascalCase = tablename.Substring(3);
pascalCase = SourceBuilder.ToPascalCase(pascalCase);
string str1 = str.Replace("[SOLUTION]", this._namespace).Replace("[ENTITY]", pascalCase);
char chr = pascalCase[0];
return(str1.Replace("[PARAM]", string.Concat(chr.ToString().ToLower(), pascalCase.Substring(1))));
}
public void Generate()
{
ValueTable valueTable = MapperProvider.DefaultProvider.QueryForValueTable("select * from sys.all_objects where type_desc='USER_TABLE' and object_id>0", null, CommandType.Text);
string path = this.webPath.Path;
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
if (!Directory.Exists(string.Concat(path, "Command/")))
{
Directory.CreateDirectory(string.Concat(path, "Command/"));
}
if (!Directory.Exists(string.Concat(path, "Entity/")))
{
Directory.CreateDirectory(string.Concat(path, "Entity/"));
}
if (!Directory.Exists(string.Concat(path, "Mapper/")))
{
Directory.CreateDirectory(string.Concat(path, "Mapper/"));
}
if (!Directory.Exists(string.Concat(path, "Service/")))
{
Directory.CreateDirectory(string.Concat(path, "Service/"));
}
if (!Directory.Exists(string.Concat(path, "Controller/")))
{
Directory.CreateDirectory(string.Concat(path, "Controller/"));
}
foreach (ValueRow row in valueTable.Rows)
{
string item = row["name"] as string;
string pascalCase = item.Substring(3);
pascalCase = SourceBuilder.ToPascalCase(pascalCase);
File.WriteAllText(string.Concat(path, "Command/", pascalCase, ".xml"), this.BuildCommand(item));
File.WriteAllText(string.Concat(path, "Entity/", pascalCase, "Entity.cs"), this.BuildEntity(item));
File.WriteAllText(string.Concat(path, "Mapper/I", pascalCase, "Mapper.cs"), this.BuildMapper(item));
File.WriteAllText(string.Concat(path, "Service/", pascalCase, "Service.cs"), this.BuildService(item));
File.WriteAllText(string.Concat(path, "Controller/", pascalCase, "Controller.cs"), this.BuildController(item));
}
}
public string BuildCommand(string tablename)
{
MapperProvider defaultProvider = MapperProvider.DefaultProvider;
string pascalCase = tablename.Substring(3);
pascalCase = SourceBuilder.ToPascalCase(pascalCase);
string str = string.Concat("SELECT * FROM ", tablename);
ValueSet valueSet = defaultProvider.QueryForValueSet(str, null, CommandType.Text);
str = string.Concat("select object_id from sys.all_objects where type_desc='USER_TABLE' and name='", tablename, "'");
string str1 = defaultProvider.QueryForScalar(str, null, CommandType.Text).ToString();
str = string.Concat("select * from sys.index_columns where object_id='", str1, "'");
ValueTable item = defaultProvider.QueryForValueSet(str, null, CommandType.Text).Tables[0];
List <string> strs = new List <string>();
foreach (ValueRow row in item.Rows)
{
str = string.Concat(new object[] { "select name from sys.columns where object_id='", str1, "' AND column_id='", row["column_id"], "'" });
string str2 = defaultProvider.QueryForScalar(str, null, CommandType.Text).ToString();
strs.Add(str2);
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>\r\n<mapper>\r\n\t<commands>\r\n");
stringBuilder.AppendFormat("\t\t<post id=\"{0}.Create\">\r\n\t\t", pascalCase);
stringBuilder.Append("<![CDATA[\r\n\t\t\t");
stringBuilder.AppendFormat("INSERT INTO {0}", tablename);
stringBuilder.Append("(");
int num = 0;
foreach (ValueColumn column in valueSet.Tables[0].Columns)
{
stringBuilder.AppendFormat("{0}{1}", (num > 0 ? ", " : " "), column.ColumnName);
num++;
}
stringBuilder.AppendFormat(" )\r\n\t\t\tVALUES(", Array.Empty <object>());
num = 0;
foreach (ValueColumn valueColumn in valueSet.Tables[0].Columns)
{
stringBuilder.AppendFormat("{0}#{{{1}}}", (num > 0 ? ", " : " "), SourceBuilder.ToPascalCase(valueColumn.ColumnName));
num++;
}
stringBuilder.AppendFormat(" )", Array.Empty <object>());
stringBuilder.Append("\r\n\t\t\t]]>\r\n");
stringBuilder.Append("\t\t</post>\r\n\r\n");
stringBuilder.AppendFormat("\t\t<get id=\"{0}.Get\">\r\n\t\t", pascalCase);
stringBuilder.Append("<![CDATA[\r\n\t\t\t");
stringBuilder.AppendFormat("SELECT ", Array.Empty <object>());
num = 0;
foreach (ValueColumn column1 in valueSet.Tables[0].Columns)
{
stringBuilder.AppendFormat("{0}{1}", (num > 0 ? ", " : string.Empty), column1.ColumnName);
num++;
}
stringBuilder.AppendFormat(" FROM {0} \r\n\t\t\tWHERE ", tablename);
num = 0;
foreach (string str3 in strs)
{
stringBuilder.AppendFormat("{0}{1}=@{2}", (num > 0 ? " AND " : string.Empty), str3, SourceBuilder.ToPascalCase(str3));
num++;
}
stringBuilder.Append("\r\n\t\t\t]]>\r\n");
stringBuilder.Append("\t\t</get>\r\n\r\n");
stringBuilder.AppendFormat("\t\t<get id=\"{0}.GetList\">\r\n\t\t", pascalCase);
stringBuilder.Append("<![CDATA[\r\n\t\t\t");
stringBuilder.AppendFormat("SELECT ", Array.Empty <object>());
num = 0;
foreach (ValueColumn valueColumn1 in valueSet.Tables[0].Columns)
{
stringBuilder.AppendFormat("{0}{1}", (num > 0 ? ", " : string.Empty), valueColumn1.ColumnName);
num++;
}
stringBuilder.AppendFormat(" FROM {0} \r\n\t\t\tWHERE ", tablename);
num = 0;
foreach (string str4 in strs)
{
stringBuilder.AppendFormat("{0}{1}=@{2}", (num > 0 ? " AND " : string.Empty), str4, SourceBuilder.ToPascalCase(str4));
num++;
}
stringBuilder.Append("\r\n\t\t\t]]>\r\n");
stringBuilder.Append("\t\t</get>\r\n\r\n");
stringBuilder.AppendFormat("\t\t<patch id=\"{0}.Update\">\r\n\t\t\t", pascalCase);
stringBuilder.Append("<![CDATA[\r\n\t\t\t");
stringBuilder.AppendFormat("UPDATE {0} SET \r\n\t\t\t", tablename);
num = 0;
foreach (ValueColumn column2 in valueSet.Tables[0].Columns)
{
stringBuilder.AppendFormat("{0}{1}=@{2}", (num > 0 ? ", " : string.Empty), column2.ColumnName, SourceBuilder.ToPascalCase(column2.ColumnName));
stringBuilder.AppendFormat("\r\n\t\t\t", Array.Empty <object>());
num++;
}
stringBuilder.AppendFormat("WHERE ", Array.Empty <object>());
num = 0;
foreach (string str5 in strs)
{
stringBuilder.AppendFormat("{0}{1}=@{2}", (num > 0 ? " AND " : string.Empty), str5, SourceBuilder.ToPascalCase(str5));
num++;
}
stringBuilder.Append("\r\n\t\t\t]]>\r\n");
stringBuilder.Append("\t\t</patch>\r\n\r\n");
stringBuilder.AppendFormat("\t\t<delete id=\"{0}.Delete\">\r\n\t\t\t", pascalCase);
stringBuilder.Append("<![CDATA[\r\n\t\t\t");
stringBuilder.AppendFormat("DELETE FROM {0} WHERE ", tablename);
num = 0;
foreach (string str6 in strs)
{
stringBuilder.AppendFormat("{0}{1}=@{2}", (num > 0 ? " AND " : string.Empty), str6, SourceBuilder.ToPascalCase(str6));
num++;
}
stringBuilder.Append("\r\n\t\t\t]]>\r\n");
stringBuilder.Append("\t\t</delete>\r\n\r\n");
stringBuilder.Append("\t</commands>\r\n\r\n");
stringBuilder.Append("\t<matches>\r\n");
stringBuilder.Append("\t</matches>\r\n");
stringBuilder.Append("</mapper>");
return(stringBuilder.ToString());
}
public static string GetDataSetQuery(ValueTable dt, string tablename)
{
string str;
StringBuilder stringBuilder = new StringBuilder();
foreach (ValueRow row in dt.Rows)
{
stringBuilder.AppendFormat("INSERT INTO {0} VALUES(", tablename);
foreach (ValueColumn column in dt.Columns)
{
str = (column.DataType != typeof(DateTime) ? row[column.ColumnName].ToString().Replace("'", "''") : SourceBuilder.GetDBDateString((DateTime)row[column.ColumnName]));
stringBuilder.AppendFormat("'{0}',", str);
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringBuilder.AppendFormat(")\n", Array.Empty <object>());
}
return(stringBuilder.ToString());
}
