//生成测试数据
private void menuItemBuildTestDataForTable_Click(object sender, EventArgs e)
{
TreeNode tn = tvDatabase.SelectedNode;
SOTable table = tn.Tag as SOTable;
TestDataGenerator generator = null;
//保证代码生成器使用一个实例
if (this.DockPanel.ActiveDocument != null && this.DockPanel.ActiveDocument is TestDataGenerator)
{
generator = this.DockPanel.ActiveDocument as TestDataGenerator;
generator.Table = table;
generator.LoadColumnList();
}
else
{
generator = new TestDataGenerator();
generator.Table = table;
generator.LoadColumnList();
generator.Show(this.DockPanel);
}
}
public void UpdateOrderHeadTable(long?sales_order_head_id, string tableCode)
{
if (sales_order_head_id.HasValue)
{
SOTable table = ServiceProvider.SOTableService.GetTaleByCode(tableCode);
SaleOrderHeader updateTableItem = new SaleOrderHeader();
updateTableItem.sales_order_head_id = sales_order_head_id;
updateTableItem = this.FindByKeys(updateTableItem, false);
if (updateTableItem != null)
{
if (table != null)
{
updateTableItem.table_id = table.table_id;
}
else
{
updateTableItem.table_id = null;
}
this.Update(updateTableItem, ValidationRuleset.Update);
}
}
}
/// <summary>
/// 获取表所拥有的列列表
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public override List <SOColumn> GetTableColumnList(SOTable table)
{
List <SOColumn> list = new List <SOColumn>();
string[] restrictions = new string[4];
restrictions[0] = table.Database.Name;
restrictions[2] = table.Name;
DataTable dt = GetSchema(MetaDataCollectionName_Columns, restrictions);
List <SOIndex> indexList = this.GetTableIndexList(table);
foreach (DataRow dr in dt.Rows)
{
SOColumn c = new SOColumn();
c.Name = dr["column_name"].ToString();
c.Comment = dr["DESCRIPTION"].ToString();
c.Parent = table;
if (dr["COLUMN_HASDEFAULT"].ToString().ToLower() != "false")
{
c.DefaultValue = ConvertUtil.ToString(dr["COLUMN_DEFAULT"]);
}
c.Nullable = dr["IS_NULLABLE"].ToString().ToLower() == "true" ? true : false;
c.NativeType = dr["DATA_TYPE"].ToString();
c.Length = ConvertUtil.ToInt32(dr["CHARACTER_MAXIMUM_LENGTH"], -1);
c.Precision = ConvertUtil.ToInt32(dr["NUMERIC_PRECISION"], -1);
c.Scale = ConvertUtil.ToInt32(dr["NUMERIC_SCALE"], -1);
c.DataType = this.GetDbType(c.NativeType);
c.PrimaryKey = IndexColumnIsPrimary(indexList, c.Name);
c.Identify = IndexColumnIsIdentity(indexList, c.Name);
c.Computed = false;
list.Add(c);
}
return(list);
}
//获取表的主键列
List <string> GetPrimaryKeys(SOTable table)
{
string cmdText = string.Format(@"select c.owner,c.constraint_name,c.table_name,cc.column_name,cc.position
from dba_constraints c inner join dba_cons_columns cc on c.constraint_name = cc.constraint_name
where c.owner='{0}' and c.constraint_type='P' and c.table_name='{1}'", table.Database.Name, table.Name);
if (!IsDBA)
{
cmdText = string.Format(@"select c.owner,c.constraint_name,c.table_name,cc.column_name,cc.position
from user_constraints c inner join user_cons_columns cc on c.constraint_name = cc.constraint_name
where c.owner='{0}' and c.constraint_type='P' and c.table_name='{1}'", table.Database.Name, table.Name);
}
List <string> list = new List <string>();
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
list.Add(row["column_name"].ToString());
}
return(list);
}
//使用自定义模板批量生成代码
//private void menuItemBatchBuildCustomCode_Click(object sender, EventArgs e)
//{
// SODatabase db = null;
// TreeNode node = tv.SelectedNode;
// if (node.Tag is PDModel)
// {
// PDModel m = node.Tag as PDModel;
// db = SOConverter.ToSODatabase(m);
// }
// else
// {
// PDPackage p = node.Tag as PDPackage;
// db = SOConverter.ToSODatabase(p);
// }
// BatchBuildCustomCode dialog = new BatchBuildCustomCode(db);
// dialog.ShowDialog();
//}
#endregion
#region 表节点右键菜单事件处理
//代码生成器
private void menuItemBuildCodeForTable_Click(object sender, EventArgs e)
{
TreeNode tn = tv.SelectedNode;
SOTable table = SOConverter.ToSOTable(tn.Tag as PDTable);
CodeBuilder builder = null;
//保证代码生成器使用一个实例
if (this.DockPanel.ActiveDocument != null && this.DockPanel.ActiveDocument is CodeBuilder)
{
builder = this.DockPanel.ActiveDocument as CodeBuilder;
builder.Table = table;
builder.ColumnList = table.ColumnList;
builder.LoadColumnList();
}
else
{
builder = new CodeBuilder();
builder.Table = table;
builder.ColumnList = table.ColumnList;
builder.LoadColumnList();
builder.Show(this.DockPanel);
}
}
//代码生成器
private void menuItemBuildCodeForTable_Click(object sender, EventArgs e)
{
TreeNode tn = tvDatabase.SelectedNode;
SOTable table = tn.Tag as SOTable;
CodeBuilder builder = null;
//保证代码生成器使用一个实例
if (this.DockPanel.ActiveDocument != null && this.DockPanel.ActiveDocument is CodeBuilder)
{
builder = this.DockPanel.ActiveDocument as CodeBuilder;
builder.Table = table;
builder.ColumnList = dbSchema.GetTableColumnList(table);
builder.LoadColumnList();
}
else
{
builder = new CodeBuilder();
builder.Table = table;
builder.ColumnList = dbSchema.GetTableColumnList(table);
builder.LoadColumnList();//???:初始化列表CheckBox状态时，数据需要Load两次才能将CheckBox列全部初始化为选中状态
builder.Show(this.DockPanel);
}
}
private string GetTableComment(SOTable table)
{
string key = string.Format("{0}_{1}_{2}", table.Database.Name, table.Owner, table.Name);
lock (syncObject)
{
if (dic.ContainsKey(key))
{
return(dic[key]);
}
else
{
string cmdText = string.Format(@"use [{0}];
SELECT objname as 'table_name', value as 'comment'
FROM fn_listextendedproperty (NULL, 'schema', '{1}', 'table', default, NULL, NULL); ", table.Database.Name, table.Owner);
DataTable dt = this.DbProvider.ExecuteDataSet(CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
string tempKey = string.Format("{0}_{1}_{2}", table.Database.Name, table.Owner, row["table_name"].ToString());
if (dic.ContainsKey(tempKey))
{
continue;
}
dic.Add(tempKey, row["comment"].ToString());
}
}
if (dic.ContainsKey(key))
{
return(dic[key]);
}
else
{
return(table.Name);
}
}
}
/// <summary>
/// 获取表列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public override List <SOTable> GetTableList(SODatabase db)
{
List <SOTable> list = new List <SOTable>();
string[] restrictions = new string[4];
restrictions[0] = db.Name;
DataTable dt = GetSchema(MetaDataCollectionName_Tables, restrictions);
foreach (DataRow dr in dt.Rows)
{
if (dr["TABLE_TYPE"].ToString() != "TABLE")
{
continue; //排除系统表
}
SOTable table = new SOTable();
table.Name = dr["table_name"].ToString();
table.Comment = table.Name;
table.Parent = db;
list.Add(table);
}
return(list);
}
/// <summary>
/// 生成
/// </summary>
private string Generate(string templateFile, string toDic)
{
string result = string.Empty;
try
{
//遍历选中的表，一张表对应生成一个代码文件
foreach (object item in listBox2.Items)
{
SOTable table = item as SOTable;
string className = table.Name;
if (cbDeleteTablePrifix.Checked)
{
className = table.Name.RemovePrefix(tablePrefix, prefixLevel).Replace(" ", "");
}
if (cbClassNamePascal.Checked)
{
className = className.InitialToUpperMulti();
}
if (cbClassNameRemovePlural.Checked)
{
className = className.EndsWith("s") ? className.TrimEnd('s') : className.Trim();
}
if (cbAddSuffix.Checked)
{
className = txtClassPrefix.Text.Trim() + className + txtClassSuffix.Text.Trim();
}
List <SOColumn> columnList = table.ColumnList;//可能传入的是从PDObject对象转换过来的SODatabase对象
if (columnList == null || columnList.Count == 0)
{
columnList = DbSchemaHelper.Instance.CurrentSchema.GetTableColumnList(table);
}
//生成代码文件
TableHost host = new TableHost();
host.Table = table;
host.ColumnList = columnList;
host.TemplateFile = templateFile;
host.SetValue("NameSpace", nameSpace);
host.SetValue("ClassName", className);
host.SetValue("TablePrefix", tablePrefix);
//host.SetValue("ColumnPrefix", columnPrefix);
host.SetValue("PrefixLevel", prefixLevel);
Engine engine = new Engine();
string templateContent = string.Empty;
var templateFileInfo = new FileInfo(templateFile);
if (dicTemp.ContainsKey(templateFile))
{
templateContent = dicTemp[templateFile];
}
else
{
templateContent = File.ReadAllText(templateFile);
dicTemp.Add(templateFile, templateContent);
}
var outputContent = engine.ProcessTemplate(templateContent, host);
var extName = templateFileInfo.Name.Replace(templateFileInfo.Extension, ""); //模板名称
var fileNameFormat = new StringBuilder("{0}");
string outputFile = string.Empty;
if (cbTemplateName.Checked || cbClassNameIsFileName.Checked)
{
if (cbClassNameIsFileName.Checked && cbTemplateName.Checked)
{
outputFile = Path.Combine(toDic, string.Format("{0}{1}{2}", className, extName, host.FileExtention)); //类名和模板名作为文件名
}
else
{
if (cbClassNameIsFileName.Checked)
{
outputFile = Path.Combine(toDic, string.Format("{0}{1}", className, host.FileExtention)); //类名作为文件名
}
else if (cbTemplateName.Checked)
{
outputFile = Path.Combine(toDic, string.Format("{0}{1}", extName, host.FileExtention)); //模板名作为文件名
}
}
}
else
{
outputFile = Path.Combine(toDic, string.Format("{0}{1}", table.Name, host.FileExtention)); //表名作为文件名
}
StringBuilder sb = new StringBuilder();
if (host.ErrorCollection != null && host.ErrorCollection.HasErrors)
{
foreach (CompilerError err in host.ErrorCollection)
{
sb.AppendLine(err.ToString());
}
outputContent = outputContent + Environment.NewLine + sb.ToString();
outputFile = outputFile + ".error";
}
if (Directory.Exists(toDic) == false)
{
Directory.CreateDirectory(toDic);
}
File.WriteAllText(outputFile, outputContent, Encoding.UTF8);
result = table.Name + "生成成功";
Config.Console(string.Format("根据模板文件“{0}”生成“{1}”成功！", templateFile, outputFile));
percent += 1;
backgroundWorkerGenerate.ReportProgress(percent, table.Name);
}
}
catch (Exception ex)
{
Config.ConsoleException(ex);
result = ex.Message;
this.backgroundWorkerGenerate.CancelAsync(); //中止
}
return(result);
}
/// <summary>
/// 获取表的Sql脚本
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public virtual string GetTableSqlText(SOTable table)
{
return("该方法目前还没有实现");
}
/// <summary>
/// 获取表所拥有的索引列表
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public virtual List <SOIndex> GetTableIndexList(SOTable table)
{
throw new NotImplementedException();
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 21 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> list = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
string tableName = table.Name.EndsWith("s") ?table.Name.TrimEnd('s') : table.Name.Trim();
int length = tableName.Length;
string controllerName = tableName + "Controller";
string lowerTableName = tableName.Substring(0, 1).ToLower() + tableName.Substring(1, length - 1);
string serviceName = "_" + lowerTableName + "Service";
#line default
#line hidden
this.Write("@model IPagedList<");
#line 36 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write(".Core.Domain.");
#line 36 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@">
@{
ViewBag.Title = ""Index"";
Layout = ""~/Views/Shared/_LayoutSubMenu.cshtml"";
}
<div id=""content"" class=""same-hight height100 overflow-auto no-padding"">
<!-- row -->
<section id=""sub-menu"" class="" l custom-scroll"">
<h4>@ViewBag.Title</h4>
<ul class=""sub-nav-list"">
<li class=""active"">
<a href=""#"">@ViewBag.Title</a>
</li>
</ul>
</section>
<!-- end row -->
<!-- widget grid -->
<section id=""widget-grid"" class=""r custom-scroll"">
<!-- RIBBON -->
<div id=""ribbon"" class=""no-padding"">
<!-- breadcrumb -->
<ol class=""breadcrumb"">
<li>
@ViewBag.Title
</li>
</ol>
<!-- end breadcrumb -->
<span class=""ribbon-button-alignment pull-right"">
</span>
</div>
<!-- END RIBBON -->
<!-- row -->
<div class=""row"">
<!-- NEW WIDGET START -->
<article class=""col-xs-12 col-sm-12 col-md-12 col-lg-12"">
<!-- Widget ID (each widget will need unique ID)-->
<div class=""jarviswidget"" id=""wid-");
#line 72 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("-index\"\r\n data-widget-editbutton=\"false\"\r\n " +
" data-widget-colorbutton=\"false\"\r\n data-widget-togglebutton" +
"=\"false\"\r\n data-widget-fullscreenbutton=\"false\"\r\n " +
" data-widget-deletebutton=\"false\">\r\n <!-- widget div" +
"-->\r\n <div>\r\n <!-- widget edit box -->" +
"\r\n <div class=\"jarviswidget-editbox\">\r\n " +
" <!-- This area used as dropdown edit box -->\r\n " +
" <input class=\"form-control\" type=\"text\">\r\n </div>\r\n " +
" <!-- end widget edit box -->\r\n <!--" +
" widget content -->\r\n <div class=\"widget-body\">\r\n " +
" <div class=\"dt-toolbar bg-color-lightgray padding-top-5\">\r\n " +
" <div class=\"col-xs-12 col-sm-12\">\r\n\r\n " +
" <div id=\"datatable_tabletools_filter\" class=\"dataTables_" +
"filter\">\r\n <label class=\"pull-left\">\r\n " +
" <span class=\"input-group-addon width-au" +
"to no-bg no-border\">\r\n 关键字：\r\n " +
" </span>\r\n " +
" <input type=\"search\" class=\"form-control txt_search_key\" placeholde" +
"r=\"\"\r\n aria-controls=\"datatabl" +
"e_tabletools\">\r\n </label>\r\n " +
" <label class=\"pull-left\">\r\n " +
" <button class=\"btn btn-default margin-left-15 btn_search\">查询</b" +
"utton>\r\n </label>\r\n " +
" </div>\r\n </div>\r\n " +
" </div>\r\n <div class=\"dt-toolbar\">\r\n " +
" <div class=\"col-md-6\">\r\n " +
" <a href=\'@Url.Action(\"Create\",\"");
#line 107 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@""")' id=""del"" class=""btn btn-success btn-sm"" data-title=""add"">添加</a>
</div>
<div class=""col-md-6"">
<div class=""dataTables_length"">
<label>
<select name=""dt_basic_length"" aria-controls=""dt_basic"" class=""form-control"" id=""changeSize"">
<option value=""10"">10</option>
<option value=""20"">20</option>
<option value=""30"">30</option>
<option value=""50"">50</option>
<option value=""100"">100</option>
</select>
</label>
</div>
</div>
</div>
<table id=""datatable_fixed_column"" class=""table table-bordered"">
<thead>
<tr>
");
#line 127 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
foreach (SOColumn c in list)
{
#line default
#line hidden
this.Write(" <th>\r\n " +
" @Html.DisplayNameFor(model => model.");
#line 130 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(")\r\n </th>\r\n " +
" ");
#line 132 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
}
#line default
#line hidden
this.Write(@" <th></th>
</tr>
</thead>
<tbody>
@foreach (var item in Model)
{
<tr>
");
#line 140 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
foreach (SOColumn c in list)
{
#line default
#line hidden
this.Write(" <td>\r\n " +
" @Html.DisplayFor(modelItem => item.");
#line 143 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(")\r\n </td>\r\n " +
" ");
#line 145 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Index.tt"
}
#line default
#line hidden
this.Write(" <td>\r\n " +
" @Html.ActionLink(\"修改\", \"Edit\", new { id = item.Id }, new { @class = \"bt" +
"n btn-primary btn-xs\" })\r\n @Html.Acti" +
"onLink(\"详细\", \"Details\", new { id = item.Id }, new { @class = \"btn btn-info btn-x" +
"s\" })\r\n @Html.ActionLink(\"删除\", \"Delet" +
"e\", new { id = item.Id }, new { @class = \"btn btn-danger btn-xs\" })\r\n " +
" </td>\r\n </tr>\r\n " +
" }\r\n </tbody>\r\n " +
" </table>\r\n <div class=\"dt-to" +
"olbar-footer\">\r\n <div class=\"col-xs-12 col-sm" +
"-3\">\r\n <div class=\"dataTables_info\" id=\"d" +
"t_basic_info\" role=\"status\" aria-live=\"polite\">第 <span class=\"txt-color-darken\">" +
"@Model.CurrentPageIndex</span> /<span class=\"txt-color-darken\">@Model.TotalPageC" +
"ount</span>页，共<span class=\"text-primary\">@Model.TotalItemCount</span> 条记录</div>\r" +
"\n </div>\r\n " +
" <div class=\"col-md-9\">\r\n <div class=\"dat" +
"aTables_paginate paging_simple_numbers\" id=\"datatable_tabletools_paginate\">\r\n " +
" @Html.Pager(Model, new PagerOptions\r\n " +
" {\r\n PageIndexParameterN" +
"ame = \"page\",\r\n ShowGoButton = false\r\n " +
" },\r\n new { @id " +
"= \"bootstrappager\", @class = \"pagination pagination-sm\" })\r\n " +
" </div>\r\n </div>\r\n\r\n\r\n " +
" </div>\r\n </div>\r\n " +
" <!-- end widget content -->\r\n </div>\r\n " +
" <!-- end widget div -->\r\n </div>\r\n <!-- e" +
"nd widget -->\r\n </article>\r\n <!-- WIDGET END -->\r\n " +
"</div>\r\n <!-- end row -->\r\n <!-- row -->\r\n <div class=\"row\"" +
">\r\n <!-- a blank row to get started -->\r\n <div class=\"col-" +
"sm-12\">\r\n <!-- your contents here -->\r\n </div>\r\n " +
" </div>\r\n <!-- end row -->\r\n </section>\r\n <!-- end widget grid -->" +
"\r\n</div>\r\n@section scripts{\r\n @Scripts.Render(\"~/scripts/filter-datatables\")\r\n" +
"}");
return(this.GenerationEnvironment.ToString());
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 21 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\IService.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> list = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
string tableName = table.Name.EndsWith("s") ?table.Name.TrimEnd('s') : table.Name.Trim();
#line default
#line hidden
this.Write("using Ebboy.Core.Domain;\r\nusing System.Linq;\r\n\r\nnamespace ");
#line 34 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\IService.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write(".IServices\r\n{\r\n\t/// <summary>\r\n /// ");
#line 37 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\IService.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Comment == "" ? table.Name : table.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n /// </summary>\r\n\tpublic partial interface I");
#line 39 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\IService.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("Service\r\n\t{\r\n\t\t#region Interface\r\n /// <summary>\r\n /// 添加\r\n " +
"/// </summary>\r\n /// <param name=\"model\"></param>\r\n void Insert(");
#line 46 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\IService.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(" model);\r\n /// <summary>\r\n /// 修改\r\n /// </summary>\r\n " +
"/// <param name=\"model\"></param>\r\n void Update(");
#line 51 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\IService.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@" model);
/// <summary>
/// 删除
/// </summary>
/// <param name=""id""></param>
void Delete(int id);
/// <summary>
/// 获取实体
/// </summary>
/// <param name=""id""></param>
/// <returns></returns>
");
#line 62 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\IService.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(" GetById(int id);\r\n /// <summary>\r\n /// 获取所有列表\r\n /// </summa" +
"ry>\r\n /// <returns></returns>\r\n IQueryable<");
#line 67 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\IService.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("> GetAllList();\r\n #endregion\r\n\t}\r\n}");
return(this.GenerationEnvironment.ToString());
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 20 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> colList = host.ColumnList;
int maxColumnNameLength = colList.Max(tmp => tmp.Name.Length);
String className = String.Format("{0}Model", host.FormatName(table.Name));
string nameSpace = className.FirstLower();
// 设置输出文件名
host.OutputFileName = className + ".go";
#line default
#line hidden
this.Write("package ");
#line 31 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write("\r\n\r\n// 模块名\r\nconst ModuleName = \"");
#line 34 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("\"\r\n\r\n// 调度日志\r\ntype ");
#line 37 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write(" struct {\r\n");
#line 38 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
foreach (SOColumn c in colList)
{
#line default
#line hidden
this.Write("\r\n // ");
#line 40 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Comment == "" ? c.Name : c.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n ");
#line 41 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(" ");
#line 41 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(host.GetTypeString(c)));
#line default
#line hidden
this.Write(" `gorm:\"Column:");
#line 41 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
#line 41 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.PrimaryKey?";PRIMARY_KEY":""));
#line default
#line hidden
this.Write("\"`\r\n");
#line 42 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
}
#line default
#line hidden
this.Write("}\r\n\r\n// 表名\r\nfunc (this *");
#line 46 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write(") TableName() string {\r\n\treturn \"");
#line 47 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("\"\r\n}\r\n\r\n// 新建调度模型对象\r\nfunc New");
#line 51 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("() *");
#line 51 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write(" {\r\n\treturn &");
#line 52 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("{}\r\n}\r\n\r\n// 新建调度模型对象\r\n");
#line 56 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write("// ");
#line 57 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write(":");
#line 57 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Comment));
#line default
#line hidden
this.Write("\r\n");
#line 58 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
}
#line default
#line hidden
this.Write("func New");
#line 59 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("2(");
#line 59 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("{0} {1}", tmp.Name.FirstLower(), host.GetTypeString(tmp))))));
#line default
#line hidden
this.Write(") *");
#line 59 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write(" {\r\n\treturn &");
#line 60 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("{\r\n");
#line 61 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write("\t\t");
#line 62 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(": ");
#line 62 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(StringUtil.GetRepeatString(" ", maxColumnNameLength - item.Name.Length)));
#line default
#line hidden
#line 62 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write(",\r\n");
#line 63 "E:\testcode\csharp\ToolManager\Plugn.CodeGenerate\T4Template\SingleTableHost\Golang\Model\Model.tt"
}
#line default
#line hidden
this.Write("\t}\r\n}");
return(this.GenerationEnvironment.ToString());
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 20 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> colList = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
string authorName = host.GetString("Author");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
#line default
#line hidden
this.Write("//*******************************************************************************" +
"****\r\n// 文件名称：");
#line 31 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("DAL.cs\r\n// 功能描述：");
#line 32 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Comment == "" ? table.Name : table.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n// 数据表：");
#line 33 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("\r\n// 作者：");
#line 34 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(authorName));
#line default
#line hidden
this.Write("\r\n// 日期：");
#line 35 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(DateTime.Now.ToDateTimeString()));
#line default
#line hidden
this.Write("\r\n// 修改记录：\r\n//*******************************************************************" +
"****************\r\n\r\nusing System;\r\nusing System.Data;\r\n\r\nnamespace ");
#line 42 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write("\r\n{\r\n using MySql.Data.MySqlClient;\r\n using Xingji.Util;\r\n\r\n /// <summar" +
"y>\r\n /// ");
#line 48 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Comment == "" ? table.Name : table.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n /// </summary>\r\n internal class ");
#line 50 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("DAL : GameBaseDAL\r\n {\r\n #region 属性\r\n\r\n // 定义表的所有字段（以, 进行分隔）\r\n " +
" const String columns = @\"");
#line 55 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => tmp.Name))));
#line default
#line hidden
this.Write("\";\r\n\r\n // 定义此类所能用到的所有参数名称（以pn = ParameterName开始）；双引号内是@+字段名称\r\n");
#line 58 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" const String pn");
#line 59 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(" = \"@");
#line 59 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write("\";\r\n");
#line 60 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(@"
//定义此类所能用到的所有sql语句（以Command结尾，表示为sql命令）
static String getAllCommand = String.Empty;
static String replaceCommand = String.Empty;
static String insertCommand = String.Empty;
static String updateCommand = String.Empty;
static String deleteCommand = String.Empty;
#endregion
#region 构造函数
/// <summary>
/// 初始化此类所能用到的所有sql语句
/// </summary>
static ");
#line 76 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("DAL()\r\n {\r\n getAllCommand = String.Format(\"SELECT {0} FROM `");
#line 78 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("`;\", columns);\r\n replaceCommand = \"REPLACE INTO `");
#line 79 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("` SET ");
#line 79 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("`{0}`=@{0}", tmp.Name)))));
#line default
#line hidden
this.Write(" ;\";\r\n insertCommand = \"INSERT INTO `");
#line 80 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("` (");
#line 80 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("`{0}`", tmp.Name)))));
#line default
#line hidden
this.Write(") VALUES (");
#line 80 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("@{0}", tmp.Name)))));
#line default
#line hidden
this.Write(");\";\r\n updateCommand = \"UPDATE `");
#line 81 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("` SET ");
#line 81 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Where(tmp => !tmp.PrimaryKey).Select(tmp => String.Format("`{0}`=@{0}", tmp.Name)))));
#line default
#line hidden
this.Write(" WHERE ");
#line 81 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Where(tmp => tmp.PrimaryKey).Select(tmp => String.Format("`{0}`=@{0}", tmp.Name)))));
#line default
#line hidden
this.Write(";\";\r\n deleteCommand = \"DELETE FROM `");
#line 82 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("` WHERE ");
#line 82 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Where(tmp => tmp.PrimaryKey).Select(tmp => String.Format("`{0}`=@{0}", tmp.Name)))));
#line default
#line hidden
this.Write(@";"";
}
#endregion
#region 数据操作
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>数据列表</returns>
public static DataTable GetAllList()
{
return ExecuteDataTable(getAllCommand);
}
/// <summary>
/// 更新数据
/// </summary>
");
#line 101 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" /// <param name=\"");
#line 102 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("\">");
#line 102 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Comment));
#line default
#line hidden
this.Write("</param>\r\n");
#line 103 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(" /// <returns>受影响的行数</returns>\r\n public static Int32 ReplaceInfo(");
#line 105 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("{0} {1}", TypeUtil.DbType2CSharpTypeString(tmp.DataType), tmp.Name.FirstLower())))));
#line default
#line hidden
this.Write(")\r\n {\r\n //构造参数\r\n MySqlParameter[] paramList = new My" +
"SqlParameter[]\r\n {\r\n");
#line 110 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" new MySqlParameter(pn");
#line 111 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(", ");
#line 111 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("),\r\n");
#line 112 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(" };\r\n\r\n return ExecuteNonQuery(replaceCommand, paramList);\r" +
"\n }\r\n\r\n /// <summary>\r\n /// 插入数据\r\n /// </summary>\r\n");
#line 121 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" /// <param name=\"");
#line 122 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("\">");
#line 122 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Comment));
#line default
#line hidden
this.Write("</param>\r\n");
#line 123 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(" /// <returns>受影响的行数</returns>\r\n public static Int32 InsertInfo(");
#line 125 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("{0} {1}", TypeUtil.DbType2CSharpTypeString(tmp.DataType), tmp.Name.FirstLower())))));
#line default
#line hidden
this.Write(")\r\n {\r\n //构造参数\r\n MySqlParameter[] paramList = new My" +
"SqlParameter[]\r\n {\r\n");
#line 130 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" new MySqlParameter(pn");
#line 131 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(", ");
#line 131 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("),\r\n");
#line 132 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(" };\r\n\r\n return ExecuteNonQuery(insertCommand, paramList);\r\n" +
" }\r\n\r\n /// <summary>\r\n /// 更新数据\r\n /// </summary>\r\n");
#line 141 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" /// <param name=\"");
#line 142 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("\">");
#line 142 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Comment));
#line default
#line hidden
this.Write("</param>\r\n");
#line 143 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(" /// <returns>受影响的行数</returns>\r\n public static Int32 UpdateInfo(");
#line 145 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("{0} {1}", TypeUtil.DbType2CSharpTypeString(tmp.DataType), tmp.Name.FirstLower())))));
#line default
#line hidden
this.Write(")\r\n {\r\n //构造参数\r\n MySqlParameter[] paramList = new My" +
"SqlParameter[]\r\n {\r\n");
#line 150 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" new MySqlParameter(pn");
#line 151 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(", ");
#line 151 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("),\r\n");
#line 152 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(" };\r\n\r\n return ExecuteNonQuery(updateCommand, paramList);\r\n" +
" }\r\n\r\n /// <summary>\r\n /// 删除数据\r\n /// </summary>\r\n");
#line 161 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList.Where(tmp => tmp.PrimaryKey))
{
#line default
#line hidden
this.Write(" /// <param name=\"");
#line 162 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("\">");
#line 162 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Comment));
#line default
#line hidden
this.Write("</param>\r\n");
#line 163 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(" /// <returns>受影响的行数</returns>\r\n public static Int32 DeleteInfo(");
#line 165 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Where(tmp => tmp.PrimaryKey).Select(tmp => String.Format("{0} {1}", TypeUtil.DbType2CSharpTypeString(tmp.DataType), tmp.Name.FirstLower())))));
#line default
#line hidden
this.Write(")\r\n {\r\n //构造参数\r\n MySqlParameter[] paramList = new My" +
"SqlParameter[]\r\n {\r\n");
#line 170 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
foreach (SOColumn item in colList.Where(tmp => tmp.PrimaryKey))
{
#line default
#line hidden
this.Write(" new MySqlParameter(pn");
#line 171 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(", ");
#line 171 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("),\r\n");
#line 172 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\DAL.tt"
}
#line default
#line hidden
this.Write(" };\r\n\r\n return ExecuteNonQuery(deleteCommand, paramList);\r\n" +
" }\r\n\r\n #endregion\r\n }\r\n}\r\n");
return(this.GenerationEnvironment.ToString());
}
protected void BindConfigScreen(Panel contanner, string screenCode, BaseTextBox txt, bool isFullScreen)
{
Control_contanner = contanner;
Control_contanner.Controls.Clear();
ScreenConfig mainScreen = ServiceProvider.ScreenConfigService.getScreenByCode(screenCode);
txtProcress = txt;
if (mainScreen != null)
{
if (!isFullScreen)
{
Control_contanner.Width = mainScreen.control_width;
Control_contanner.Height = mainScreen.control_height;
}
else
{
Control_contanner.Dock = DockStyle.Fill;
}
contanner.BackColor = Color.FromArgb(mainScreen.background_color);
if (mainScreen.image != null && mainScreen.image.Length > 0)
{
contanner.BackgroundImage = Converts.ParseImage(mainScreen.image);
// contanner.BackgroundImageLayout = ImageLayout.Zoom;
}
List <ScreenConfig> dragItem = new List <ScreenConfig>();
dragItem = ServiceProvider.ScreenConfigService.getChildScreenByParent(mainScreen.control_id);
foreach (ScreenConfig item in dragItem)
{
switch (item.control_type)
{
case ControlType.Button:
BaseButton btn = new BaseButton();
btn.Location = new System.Drawing.Point(0, 0);
btn.Left = item.position_left;
btn.Top = item.position_top;
btn.Width = item.control_width;
btn.Height = item.control_height;
btn.Text = item.display_text;
btn.Font = Core.Standards.Converters.Converts.ConvertStringToFont(item.font);
if (item.control_command_group == CommandGroup.OpenNextScreen)
{
btn.CommandArg = item.control_command;
btn.Click += new EventHandler(btn_NextScreen);
}
else
{
btn.Click += new EventHandler(btn_Click);
}
Control_contanner.Controls.Add(btn);
break;
case ControlType.Table:
SOTable tableDB = ServiceProvider.SOTableService.GetTaleByCode(item.control_command);
if (tableDB != null && tableDB.active)
{
BasePanel PnlTable = new BasePanel();
PictureBox tableImage = new PictureBox();
PnlTable.DataObject = item;
Label labTableName = new Label();
if (item.image != null && item.image.Length > 0)
{
tableImage.BackgroundImage = Converts.ParseImage(item.image);
tableImage.BackgroundImageLayout = ImageLayout.Zoom;
tableImage.Dock = DockStyle.Fill;
}
labTableName.Font = Core.Standards.Converters.Converts.ConvertStringToFont(item.font);
PnlTable.Location = new System.Drawing.Point(0, 0);
PnlTable.Left = item.position_left;
PnlTable.Top = item.position_top;
PnlTable.Width = item.control_width;
PnlTable.Height = item.control_height;
PnlTable.Text = item.display_text;
labTableName.Text = item.display_text;
//labTableName.Anchor = ((AnchorStyles)(AnchorStyles.Left | AnchorStyles.Right | AnchorStyles.Bottom | AnchorStyles.Top));
labTableName.AutoSize = false;
labTableName.Dock = DockStyle.Fill;
labTableName.TextAlign = ContentAlignment.MiddleCenter;
PnlTable.Font = Core.Standards.Converters.Converts.ConvertStringToFont(item.font);
PnlTable.BackColor = Color.FromArgb(item.background_color);
labTableName.BackColor = Color.Transparent;
labTableName.Click += new EventHandler(btn_TableClick);
PnlTable.Controls.Add(tableImage);
labTableName.Location = new Point(0, 0);
labTableName.Parent = tableImage;
Control_contanner.Controls.Add(PnlTable);
}
break;
default:
Panel pnlObj = new Panel();
pnlObj.Location = new System.Drawing.Point(0, 0);
pnlObj.Left = item.position_left;
pnlObj.Top = item.position_top;
pnlObj.Width = item.control_width;
pnlObj.Height = item.control_height;
pnlObj.Text = item.display_text;
pnlObj.Font = Core.Standards.Converters.Converts.ConvertStringToFont(item.font);
pnlObj.BackColor = Color.FromArgb(item.background_color);
Control_contanner.Controls.Add(pnlObj);
break;
}
}
}
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 20 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\BLL_List.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> colList = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
string authorName = host.GetString("Author");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
#line default
#line hidden
this.Write("//*******************************************************************************" +
"****\r\n// 文件名称：");
#line 31 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\BLL_List.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("BLL.cs\r\n// 功能描述：");
#line 32 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\BLL_List.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Comment == "" ? table.Name : table.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n// 数据表：");
#line 33 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\BLL_List.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("\r\n// 作者：");
#line 34 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\BLL_List.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(authorName));
#line default
#line hidden
this.Write("\r\n// 日期：");
#line 35 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\BLL_List.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(DateTime.Now.ToDateTimeString()));
#line default
#line hidden
this.Write("\r\n// 修改记录：\r\n//*******************************************************************" +
"****************");
return(this.GenerationEnvironment.ToString());
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 21 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> colList = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
string authorName = host.GetString("Author");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
#line default
#line hidden
this.Write("//*******************************************************************************" +
"****\r\n// 文件名称：");
#line 32 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write(".cs\r\n// 功能描述：");
#line 33 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Comment == "" ? table.Name : table.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n// 数据表：");
#line 34 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Name));
#line default
#line hidden
this.Write("\r\n// 作者：");
#line 35 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(authorName));
#line default
#line hidden
this.Write("\r\n// 日期：");
#line 36 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(DateTime.Now.ToDateTimeString()));
#line default
#line hidden
this.Write("\r\n// 修改记录：\r\n//*******************************************************************" +
"****************\r\n\r\nusing System;\r\nusing System.Data;\r\n\r\nnamespace ");
#line 43 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write("\r\n{\r\n /// <summary>\r\n /// 充值日志\r\n /// </summary>\r\n public class ");
#line 48 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("\r\n {\r\n #region 属性\r\n");
#line 51 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
foreach (SOColumn c in colList)
{
#line default
#line hidden
this.Write("\r\n /// <summary>\r\n /// ");
#line 54 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Comment == "" ? c.Name : c.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n /// </summary>\r\n public ");
#line 56 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(TypeUtil.DbType2CSharpTypeString(c.DataType)));
#line default
#line hidden
this.Write(" ");
#line 56 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(" { get; set; }\t\t\r\n");
#line 57 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
}
#line default
#line hidden
this.Write("\r\n #endregion\r\n\r\n #region 构造函数\r\n\r\n /// <summary>\r\n //" +
"/ 构造函数\r\n /// </summary>\r\n");
#line 66 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" /// <param name=\"");
#line 67 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("\">");
#line 67 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Comment));
#line default
#line hidden
this.Write("</param>\r\n");
#line 68 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
}
#line default
#line hidden
this.Write(" public ");
#line 69 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("(");
#line 69 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("{0} {1}", TypeUtil.DbType2CSharpTypeString(tmp.DataType), tmp.Name.FirstLower())))));
#line default
#line hidden
this.Write(")\r\n {\r\n");
#line 71 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" this.");
#line 72 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(" = ");
#line 72 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write(";\r\n");
#line 73 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
}
#line default
#line hidden
this.Write(" }\r\n\r\n /// <summary>\r\n /// 构造函数\r\n /// </summary>\r\n " +
" /// <param name=\"dr\">DataRow</param>\r\n public ");
#line 80 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(className));
#line default
#line hidden
this.Write("(DataRow dr)\r\n {\r\n");
#line 82 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" this.");
#line 83 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(" = Convert.To");
#line 83 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(TypeUtil.DbType2CSharpTypeString(item.DataType)));
#line default
#line hidden
this.Write("(dr[GamePropertyName.");
#line 83 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write("]);\r\n");
#line 84 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
}
#line default
#line hidden
this.Write(" }\r\n\r\n #endregion\r\n\r\n #region 方法\r\n\r\n /// <summary>\r\n " +
" /// 构造函数\r\n /// </summary>\r\n");
#line 94 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" /// <param name=\"");
#line 95 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write("\">");
#line 95 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Comment));
#line default
#line hidden
this.Write("</param>\r\n");
#line 96 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
}
#line default
#line hidden
this.Write(" public void ConstructObject(");
#line 97 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(String.Join(", ", colList.Select(tmp => String.Format("{0} {1}", TypeUtil.DbType2CSharpTypeString(tmp.DataType), tmp.Name.FirstLower())))));
#line default
#line hidden
this.Write(")\r\n {\r\n");
#line 99 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
foreach (SOColumn item in colList)
{
#line default
#line hidden
this.Write(" this.");
#line 100 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name));
#line default
#line hidden
this.Write(" = ");
#line 100 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(item.Name.FirstLower()));
#line default
#line hidden
this.Write(";\r\n");
#line 101 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\CSharp\Global\Model.tt"
}
#line default
#line hidden
this.Write(" }\r\n\r\n #endregion\r\n }\r\n}");
return(this.GenerationEnvironment.ToString());
}
private void DoBuild()
{
int finish = 0;
int total = listBox2.Items.Count;
//遍历选中的表，一张表对应生成一个代码文件
foreach (object item in listBox2.Items)
{
SOTable table = item as SOTable;
string className = table.Name;
if (cbDeleteTablePrifix.Checked)
{
className = table.Name.RemovePrefix(tablePrefix, prefixLevel).Replace(" ", "");
}
if (cbClassNamePascal.Checked)
{
className = className.InitialToUpperMulti();
}
if (cbClassNameRemovePlural.Checked)
{
className = className.EndsWith("s") ? className.TrimEnd('s') : className.Trim();
}
if (cbAddSuffix.Checked)
{
className = txtClassPrefix.Text.Trim() + className + txtClassSuffix.Text.Trim();
}
templateFile = gbTemplateFile.Text;
List <SOColumn> columnList = table.ColumnList;//可能传入的是从PDObject对象转换过来的SODatabase对象
if (columnList == null || columnList.Count == 0)
{
columnList = DbSchemaHelper.Instance.CurrentSchema.GetTableColumnList(table);
}
//生成代码文件
TableHost host = new TableHost();
host.Table = table;
host.ColumnList = columnList;
host.TemplateFile = templateFile;
host.SetValue("NameSpace", nameSpace);
host.SetValue("ClassName", className);
host.SetValue("TablePrefix", tablePrefix);
//host.SetValue("ColumnPrefix", columnPrefix);
host.SetValue("PrefixLevel", prefixLevel);
Engine engine = new Engine();
string templateContent = string.Empty;
if (dicTemp.ContainsKey(templateFile))
{
templateContent = dicTemp[templateFile];
}
else
{
templateContent = File.ReadAllText(templateFile);
dicTemp.Add(templateFile, templateContent);
}
var outputContent = engine.ProcessTemplate(templateContent, host);
//string outputFile = Path.Combine(outputPath, string.Format("{0}.cs", className));
string outputFile = Path.Combine(outputPath, string.Format("{0}{1}", table.Name, host.FileExtention));
if (cbClassNameIsFileName.Checked)
{
outputFile = Path.Combine(outputPath, string.Format("{0}{1}", className, host.FileExtention));
}
StringBuilder sb = new StringBuilder();
if (host.ErrorCollection != null && host.ErrorCollection.HasErrors)
{
foreach (CompilerError err in host.ErrorCollection)
{
sb.AppendLine(err.ToString());
}
outputContent = outputContent + Environment.NewLine + sb.ToString();
outputFile = outputFile + ".error";
}
if (Directory.Exists(outputPath) == false)
{
Directory.CreateDirectory(outputPath);
}
File.WriteAllText(outputFile, outputContent, Encoding.UTF8);
finish = finish + 1;
int percent = ConvertUtil.ToInt32(finish * 100 / total, 0);
backgroundWorker1.ReportProgress(percent, table);
}//end build code foreach
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 21 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> list = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
string tableName = table.Name.EndsWith("s") ?table.Name.TrimEnd('s') : table.Name.Trim();
int length = tableName.Length;
string controllerName = tableName + "Controller";
string lowerTableName = tableName.Substring(0, 1).ToLower() + tableName.Substring(1, length - 1);
string serviceName = "_" + lowerTableName + "Service";
#line default
#line hidden
this.Write("@model ");
#line 36 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write(".Core.Domain.");
#line 36 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@"
@{
ViewBag.Title = ""Create"";
Layout = ""~/Views/Shared/_LayoutSubMenu.cshtml"";
}
<div id=""content"" class=""same-hight height100 overflow-auto no-padding"">
<!-- row -->
<section id=""sub-menu"" class=""l custom-scroll"">
<h4>@ViewBag.Title</h4>
<ul class=""sub-nav-list"">
<li class=""active"">
<a href=""#"">@ViewBag.Title</a>
</li>
<li class="""">
<a href=""#"">@ViewBag.Title</a>
</li>
</ul>
</section>
<!-- end row -->
<!-- widget grid -->
<section id=""widget-grid"" class=""r custom-scroll"">
<!-- row -->
<div class=""row"">
<article class=""col-sm-12 col-md-12 col-lg-6"">
<!-- Widget ID (each widget will need unique ID)-->
<div class=""jarviswidget"" id=""wid-");
#line 62 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@"-create""
data-widget-editbutton=""false""
data-widget-colorbutton=""false""
data-widget-togglebutton=""false""
data-widget-fullscreenbutton=""false""
data-widget-deletebutton=""false"">
<!-- widget div-->
<div>
<!-- widget content -->
<div class=""widget-body"">
@using (Html.BeginForm(""Create"", """);
#line 72 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@""", FormMethod.Post, new { @class = ""form-horizontal"" }))
{
@Html.AntiForgeryToken()
<fieldset>
<legend>@ViewBag.Title</legend>
");
#line 77 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
foreach (SOColumn c in list)
{
#line default
#line hidden
this.Write(" <div class=\"form-group\">\r\n " +
" <label class=\"col-md-2 control-label\">@Html.LabelFor(model " +
"=> model.");
#line 80 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(")</label>\r\n <div class=\"col-md-10\">\r\n " +
" @Html.TextBoxFor(model => model.");
#line 82 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(", new { @class = \"form-control\", @placeholder = \"");
#line 82 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write("\" })\r\n <p class=\"note has-error\">@Html" +
".ValidationMessageFor(model => model.");
#line 83 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(")</p>\r\n </div>\r\n " +
" </div>\r\n ");
#line 86 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
}
#line default
#line hidden
this.Write(@" </fieldset>
<fieldset>
<div class=""form-group"">
<div class=""col-md-9 col-md-offset-3"">
<div id=""messages"" class=""has-error"">
<small class=""help-block"" data-bv-validator=""notEmpty"" data-bv-for=""fullName"" data-bv-result=""INVALID"" style="""">@Html.ValidationSummary(true)</small>
</div>
</div>
</div>
</fieldset>
<div class=""form-actions"">
<div class=""row"">
<div class=""col-md-12"">
@Html.ActionLink(""返回"", ""Index"", """);
#line 100 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\View\Create.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@""", null, new { @class = ""btn btn-default"" })
<input type=""submit"" value=""保存"" class=""btn btn-primary"" />
</div>
</div>
</div>
}
</div>
<!-- end widget content -->
</div>
<!-- end widget div -->
</div>
<!-- end widget -->
</article>
</div>
<!-- end row -->
<!-- row -->
<div class=""row"">
<!-- a blank row to get started -->
<div class=""col-sm-12"">
<!-- your contents here -->
</div>
</div>
<!-- end row -->
</section>
<!-- end widget grid -->
</div>");
return(this.GenerationEnvironment.ToString());
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
this.Write("\r\n");
#line 21 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> list = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
string tableName = table.Name.EndsWith("s") ?table.Name.TrimEnd('s') : table.Name.Trim();
#line default
#line hidden
this.Write("using Ebboy.Core.Data;\r\nusing Ebboy.Core.Domain;\r\nusing System.Linq;\r\n\r\nnamespace" +
" ");
#line 35 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write(".Services\r\n{\r\n\t/// <summary>\r\n /// ");
#line 38 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Comment == "" ? table.Name : table.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n /// </summary>\r\n\tpublic partial class ");
#line 40 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("Service: I");
#line 40 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("Service\r\n\t{\r\n\t\t#region Fields\r\n private readonly IRepository<");
#line 43 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("> _repository;\r\n #endregion\r\n\r\n #region Ctor\r\n public ");
#line 47 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("Service(IRepository<");
#line 47 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@"> repository)
{
_repository = repository;
}
#endregion
#region Methods
/// <summary>
/// 添加
/// </summary>
/// <param name=""model""></param>
public virtual void Insert(");
#line 58 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(" model)\r\n {\r\n _repository.Insert(model);\r\n }\r\n\r\n " +
"/// <summary>\r\n /// 修改\r\n /// </summary>\r\n /// <param name=\"" +
"model\"></param>\r\n public virtual void Update(");
#line 67 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@" model)
{
_repository.Update(model);
}
/// <summary>
/// 删除
/// </summary>
/// <param name=""model""></param>
public virtual void Delete(int id)
{
_repository.Delete(GetById(id));
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name=""id""></param>
/// <returns></returns>
public virtual ");
#line 86 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(" GetById(int id)\r\n {\r\n return _repository.GetById(id);\r\n " +
" }\r\n\r\n /// <summary>\r\n /// 获取所有信息\r\n /// </summary>\r\n " +
" /// <returns></returns>\r\n public virtual IQueryable<");
#line 95 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Service\Service.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("> GetAllList()\r\n {\r\n return _repository.Table;\r\n }\r\n " +
" #endregion\r\n\t}\r\n}");
return(this.GenerationEnvironment.ToString());
}
public OrderHeadDTO SendOrderToKitchen(OrderHeadDTO orderHeadDTO)
{
TransactionOptions tranOpt = new TransactionOptions()
{
IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted
};
using (var trans = new TransactionScope(TransactionScopeOption.Required, tranOpt))
{
WorkPeriod activeWorkPeriod = ServiceProvider.WorkPeriodService.findActiveWorkPeriod();
if (activeWorkPeriod != null && orderHeadDTO != null)
{
SaleOrderHeader orderHead = new SaleOrderHeader();
if (!orderHeadDTO.sales_order_head_id.HasValue)
{
orderHead = new SaleOrderHeader();
// orderHead.sales_order_date = DateTime.Now;
orderHead.take_order_by = UserAccount.UserData.UserName;
orderHead.take_order_date = DateTime.Now;
orderHead.period_id = activeWorkPeriod.period_id;
orderHead.sales_order_head_id = this.Insert <long>(orderHead, ValidationRuleset.Insert);
orderHeadDTO.sales_order_head_id = orderHead.sales_order_head_id;
}
else
{
orderHead.sales_order_head_id = orderHeadDTO.sales_order_head_id;
}
orderHead = this.FindByKeys(orderHead, false);
if (orderHead != null)
{
SOTable table = ServiceProvider.SOTableService.GetTaleByCode(orderHeadDTO.TableCode);
if (table != null)
{
orderHead.table_id = table.table_id;
}
else
{
orderHead.table_id = null;
}
orderHead.is_cancel = orderHeadDTO.IsCancle;
orderHead.is_start_time = orderHeadDTO.IsStartTime;
orderHead.eating_start_time = orderHeadDTO.StartTimeEating;
orderHead.Person = orderHeadDTO.Person;
this.Update(orderHead, ValidationRuleset.Update);
}
else
{
throw new Exception("Your order is loss.");
}
orderHeadDTO.OrderList = ServiceProvider.SaleOrderDetailService.SaveOrderDetail(orderHeadDTO.OrderList, orderHeadDTO);
if (orderHeadDTO.OrderList != null && orderHeadDTO.OrderList.Count > 0)
{
orderHeadDTO.OrderList = orderHeadDTO.OrderList.Where(a => !a.is_cancel).ToList();
}
trans.Complete();
}
else
{
if (activeWorkPeriod == null)
{
throw new Exception("Please Opern Work Period");
}
}
}
return(orderHeadDTO);
}
//生成数据插入脚本
private void menuItemBuildInsertSqlForTable_Click(object sender, EventArgs e)
{
TreeNode tn = tvDatabase.SelectedNode;
SOTable table = tn.Tag as SOTable;
List <SOColumn> list = dbSchema.GetTableColumnList(table);
string cmdText = string.Format("select * from {0}", table.FullName);
DataTable dt = DbSchemaHelper.Instance.CurrentSchema.ExecuteQuery(table.Database, cmdText).Tables[0];
StringBuilder sbDocText = new StringBuilder();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO ");
sb.Append(table.FullName + " (");
for (int i = 0; i < list.Count; i++)
{
SOColumn c = list[i];
if (c.Identify)
{
continue; //忽略标识列
}
if (i != list.Count - 1)
{
sb.Append(string.Format("{0},", dbSchema.QuoteIdentifier(c.Name)));
}
else
{
sb.Append(string.Format("{0}) VALUES (", dbSchema.QuoteIdentifier(c.Name)));
}
}
for (int i = 0; i < list.Count; i++)
{
SOColumn c = list[i];
if (c.Identify)
{
continue; //忽略标识列
}
string value = "";
if (c.DataType == DbType.Boolean)
{
value = string.Format("'{0}'", Utils.DbBooleanValueToStirng(dr[c.Name]));
}
else if (c.DataType == DbType.Byte || c.DataType == DbType.Currency || c.DataType == DbType.Decimal ||
c.DataType == DbType.Double || c.DataType == DbType.Int16 || c.DataType == DbType.Int32 ||
c.DataType == DbType.Int64 || c.DataType == DbType.SByte || c.DataType == DbType.Single ||
c.DataType == DbType.UInt16 || c.DataType == DbType.UInt32 || c.DataType == DbType.UInt64)
{
value = Utils.DbNumericValueToString(dr[c.Name]);
}
else
{
value = string.Format("'{0}'", Utils.DbStringValueToString(dr[c.Name]));
}
if (i != list.Count - 1)
{
sb.Append(string.Format("{0},", value));
}
else
{
sb.Append(string.Format("{0});", value));
}
}
sbDocText.AppendLine(sb.ToString());
}
}
else
{
sbDocText.Append(string.Format("表“{0}”没有任何数据！", table.FullName));
}
base.MainForm.NewDockDocument(string.Format("{0}_InsertData", table.Name), CodeType.TSQL, sbDocText.ToString());
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="nameRuleConfig"></param>
/// <param name="typeMapConfigList"></param>
/// <param name="table"></param>
public TableHost(NameRuleConfig nameRuleConfig, List <TypeMapConfig> typeMapConfigList, SOTable table)
{
this.nameRuleConfig = nameRuleConfig;
this.typeMapConfigList = typeMapConfigList;
this.Table = table;
}
/// <summary>
/// 获取表的Sql脚本
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public override string GetTableSqlText(SOTable table)
{
throw new NotImplementedException();
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 21 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> list = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
string tableName = table.Name.EndsWith("s") ?table.Name.TrimEnd('s') : table.Name.Trim();
#line default
#line hidden
this.Write("using System;\r\nusing System.ComponentModel;\r\nusing System.ComponentModel.DataAnno" +
"tations;\r\n\r\nnamespace ");
#line 35 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write(".Core.Domain\r\n{\r\n\t/// <summary>\r\n /// ");
#line 38 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Comment == "" ? table.Name : table.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n /// </summary>\r\n\t[Serializable]\r\n\tpublic partial class ");
#line 41 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(" : BaseEntity\r\n\t{\r\n\t\t");
#line 43 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
foreach (SOColumn c in list)
{
#line default
#line hidden
this.Write("/// <summary>\r\n /// ");
#line 45 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Comment == "" ? c.Name : c.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n /// </summary>\r\n ");
#line 47 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Nullable?"":"[Required]"));
#line default
#line hidden
this.Write("\r\n [DisplayName(\"");
#line 48 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Comment == "" ? c.Name : c.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\")]\r\n\t\tpublic ");
#line 49 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(TypeUtil.DbType2TypeString(c.DataType)));
#line default
#line hidden
this.Write(" ");
#line 49 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(" { get; set; }\r\n\t\t\r\n\t\t");
#line 51 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Entity\Model.tt"
}
#line default
#line hidden
this.Write("\t\t\r\n\t}\r\n}");
return(this.GenerationEnvironment.ToString());
}
/// <summary>
/// Create the template output
/// </summary>
public virtual string TransformText()
{
#line 21 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
TableHost host = (TableHost)(Host);
SOTable table = host.Table;
List <SOColumn> list = host.ColumnList;
string nameSpace = host.GetString("NameSpace");
string className = host.GetString("ClassName");
if (string.IsNullOrEmpty(nameSpace))
{
nameSpace = "Entity";
}
if (string.IsNullOrEmpty(className))
{
className = table.Name;
}
string tableName = table.Name.EndsWith("s") ?table.Name.TrimEnd('s') : table.Name.Trim();
int length = tableName.Length;
string controllerName = tableName + "Controller";
string lowerTableName = tableName.Substring(0, 1).ToLower() + tableName.Substring(1, length - 1);
string serviceName = "_" + lowerTableName + "Service";
#line default
#line hidden
this.Write("using Ebboy.Core;\r\nusing Ebboy.Core.Domain;\r\nusing Ebboy.Core.PagedList;\r\nusing E" +
"bboy.Services.Users;\r\nusing Ebboy.Web.Framework.Controllers;\r\nusing System;\r\nusi" +
"ng System.Linq;\r\nusing System.Web.Mvc;\r\n\r\nnamespace ");
#line 45 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(nameSpace));
#line default
#line hidden
this.Write(".Controller\r\n{\r\n\t/// <summary>\r\n /// ");
#line 48 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(table.Comment == "" ? table.Name : table.Comment.Replace("\r\n", " ")));
#line default
#line hidden
this.Write("\r\n /// </summary>\r\n\tpublic class ");
#line 50 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(controllerName));
#line default
#line hidden
this.Write(": UserBaseController\r\n\t{\r\n\t\t#region Fileds\r\n private readonly ISystemUserS" +
"ervice _userService;\r\n private readonly IWorkContext _workContext;\r\n " +
" private readonly I");
#line 55 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("Service ");
#line 55 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(";\r\n #endregion\r\n\r\n #region Ctor\r\n public ");
#line 59 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(controllerName));
#line default
#line hidden
this.Write("(\r\n ISystemUserService userService,\r\n IWorkContext workCont" +
"ext,\r\n I");
#line 62 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write("Service ");
#line 62 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(lowerTableName));
#line default
#line hidden
this.Write("Service)\r\n {\r\n _userService = userService;\r\n _workCo" +
"ntext = workContext;\r\n ");
#line 66 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(" = ");
#line 66 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(lowerTableName));
#line default
#line hidden
this.Write(@"Service;
}
#endregion
#region Action
/// <summary>
/// 首页列表
/// </summary>
/// <param name=""page""></param>
/// <returns></returns>
public ActionResult Index(int page = 1)
{
var pageOption = new PageOption() { PageIndex = page < 1 ? 1 : page };
var list = ");
#line 80 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(".GetAllList();\r\n\r\n var pageList = new PagedList<");
#line 82 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@">(list, pageOption);
return View(pageList);
}
/// <summary>
/// 详细
/// </summary>
/// <param name=""id""></param>
/// <returns></returns>
public ActionResult Details(int id)
{
var model = ");
#line 94 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(@".GetById(id);
return View(model);
}
/// <summary>
/// 添加
/// </summary>
/// <returns></returns>
public ActionResult Create()
{
return View();
}
/// <summary>
/// 提交添加
/// </summary>
/// <param name=""model""></param>
/// <returns></returns>
[HttpPost]
public ActionResult Create(");
#line 113 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(" model)\r\n {\r\n try\r\n {\r\n if (!ModelSta" +
"te.IsValid)\r\n {\r\n ModelState.AddModelError(\"\"," +
" \"实体参数错误!\");\r\n return View(model);\r\n }\r\n\r\n " +
" ");
#line 123 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(@".Insert(model);
//this.Tips(""添加成功！"");
return RedirectToAction(""Index"");
}
catch (Exception ex)
{
ModelState.AddModelError("""", ex.Message);
return View(model);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name=""id""></param>
/// <returns></returns>
public ActionResult Edit(int id)
{
var model = ");
#line 141 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(".GetById(id);\r\n return View(model);\r\n }\r\n\r\n /// <summary" +
">\r\n /// 修改\r\n /// </summary>\r\n /// <param name=\"model\"></par" +
"am>\r\n /// <returns></returns>\r\n [HttpPost]\r\n public ActionR" +
"esult Edit(");
#line 151 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(@" model)
{
try
{
if (!ModelState.IsValid)
{
ModelState.AddModelError("""", ""实体参数错误!"");
return View(model);
}
var entity = ");
#line 160 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(".GetById(model.Id);\r\n ");
#line 161 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
foreach (SOColumn c in list)
{
#line default
#line hidden
this.Write("\t\t\t\tentity.");
#line 163 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(" = model.");
#line 163 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(c.Name));
#line default
#line hidden
this.Write(";\r\n\t\t\t\t");
#line 164 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
}
#line default
#line hidden
this.Write(" ");
#line 165 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(@".Update(entity);
//this.Tips(""修改成功！"");
return RedirectToAction(""Index"");
}
catch (Exception ex)
{
ModelState.AddModelError("""", ex.Message);
return View(model);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name=""id""></param>
/// <returns></returns>
public ActionResult Delete(int id)
{
var model = ");
#line 184 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(@".GetById(id);
return View(model);
}
/// <summary>
/// 提交删除
/// </summary>
/// <param name=""id""></param>
/// <param name=""collection""></param>
/// <returns></returns>
[HttpPost]
public ActionResult Delete(int id,");
#line 195 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(tableName));
#line default
#line hidden
this.Write(" model)\r\n {\r\n try\r\n {\r\n ");
#line 199 "E:\testCode\CsharpCode\Kalman.Studio\src\Kalman.Studio\T4Template\Asp.Net\Ebboy\Controller\Controller.tt"
this.Write(this.ToStringHelper.ToStringWithCulture(serviceName));
#line default
#line hidden
this.Write(@".Delete(id);
//this.Tips(""删除成功！"");
return RedirectToAction(""Index"");
}
catch (Exception ex)
{
this.Tips(ex.Message);
return RedirectToAction(""Index"");
}
}
#endregion
#region Utilities
#endregion
}
}");
return(this.GenerationEnvironment.ToString());
}
public DbTableViewer(SOTable table)
{
InitializeComponent();
currentTable = table;
}
