//生成测试数据 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; }