public override Task ProcessAsync(TagHelperContext context, TagHelperOutput output) { var columnTemplates = (IList <ColumnTemplate>)context.Items[typeof(IList <ColumnTemplate>)]; var column = columnTemplates.FirstOrDefault(col => col.ColumnName == Name); if (column != null) { column.Template = Template; column.ColumnItemAction = ColumnItemAction; column.ColumnAttributes = ParseAttributes(); column.HeaderAttributes.Add("style", ColumnStyle); } else { column = new ColumnTemplate { ColumnName = Name, HeaderName = string.IsNullOrWhiteSpace(HeaderName) ? Name : HeaderName, Template = Template, ColumnItemAction = ColumnItemAction, ColumnAttributes = ParseAttributes(), }; column.HeaderAttributes.Add("style", ColumnStyle); columnTemplates.Add(column); } return(Task.CompletedTask); }
private void SetupDefaultColumnTemplate(TagHelperContext context) { _columnTemplates = new List <ColumnTemplate>(); var ignoreColumns = IgnoreColumns?.Split(','); if (_columns != null) { foreach (var pair in _columns) { if (ignoreColumns != null && ignoreColumns.Contains(pair.Key)) { continue; } _columnTemplates.Add(new ColumnTemplate { ColumnName = pair.Key, HeaderName = pair.Value }); } } else { foreach (var propertyInfo in _rowItemCollection.ItemPropertyInfos) { if (ignoreColumns != null && ignoreColumns.Contains(propertyInfo.Name)) { continue; } var displayName = propertyInfo.GetDisplayName(); var template = new ColumnTemplate { ColumnName = propertyInfo.Name, HeaderName = string.IsNullOrWhiteSpace(displayName) ? propertyInfo.Name : displayName, }; _columnTemplates.Add(template); } } context.Items[typeof(IList <ColumnTemplate>)] = _columnTemplates; }
public void Generate(string name, string tableName, Column[] columns, Parameter[] prms) { // List of table columns var colTempl = new ColumnTemplate(); colTempl.GenerateWithoutType(columns, 2); var tableColumns = colTempl.TransformText().TrimEnd(); // List of rpocedure params var prmTempl = new ColumnTemplate(); prmTempl.GenerateWithoutType(prms, 2); var paramList = prmTempl.TransformText().TrimEnd(); // List of procedure input param descriptions var prmDescTempl = new ColumnTemplate(); prmDescTempl.GenerateParameters(prms, 1); var procParams = prmDescTempl.TransformText().TrimEnd(); #line default #line hidden #line 22 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write("-- INSERT INTO "); #line default #line hidden #line 23 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(tableName)); #line default #line hidden #line 23 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write("\r\nCREATE OR REPLACE PROCEDURE "); #line default #line hidden #line 24 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(name)); #line default #line hidden #line 24 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write("\r\n(\r\n"); #line default #line hidden #line 26 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(procParams)); #line default #line hidden #line 26 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write("\r\n)\r\nLANGUAGE \'sql\'\r\nAS\r\n$BODY$\r\n INSERT INTO "); #line default #line hidden #line 31 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(tableName)); #line default #line hidden #line 31 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write("\r\n (\r\n"); #line default #line hidden #line 33 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(tableColumns)); #line default #line hidden #line 33 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write("\r\n )\r\n VALUES\r\n (\r\n"); #line default #line hidden #line 37 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(paramList)); #line default #line hidden #line 37 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" this.Write("\r\n );\r\n$BODY$;\r\n"); #line default #line hidden #line 40 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\AddProcedureTemplate.tt" }
private List <ColumnTemplate> GetColumnTemplateDataSource() { List <ColumnTemplate> TreeGridCollection = new List <ColumnTemplate>(); ColumnTemplate ParentRecord = null; ParentRecord = new ColumnTemplate() { Name = "Local Disk (C:)", DateModified = "06/26/2017", Type = "File Folder", DateCreated = "06/16/2017", Children = new List <ColumnTemplate>() }; ColumnTemplate ParentRecord1 = new ColumnTemplate() { Name = "Users", DateModified = "06/26/2017", Type = "File Folder", DateCreated = "06/16/2017", Children = new List <ColumnTemplate>() }; ColumnTemplate ParentRecord2 = new ColumnTemplate() { Name = "Documents", DateModified = "06/26/2017", Type = "File Folder", DateCreated = "06/16/2017", Children = new List <ColumnTemplate>() }; ColumnTemplate ParentRecord3 = new ColumnTemplate() { Name = "My Web Sites", DateModified = "06/26/2017", Type = "File Folder", DateCreated = "06/16/2017", Children = new List <ColumnTemplate>() }; ColumnTemplate ChildRecord1 = new ColumnTemplate() { Name = "Home.html", DateModified = "06/26/2017", Type = "HTML document", DateCreated = "06/16/2017", }; ColumnTemplate ChildRecord2 = new ColumnTemplate() { Name = "Login.html", DateModified = "06/26/2017", Type = "HTML document", DateCreated = "06/16/2017", }; ColumnTemplate ChildRecord3 = new ColumnTemplate() { Name = "Account.html", DateModified = "06/26/2017", Type = "HTML document", DateCreated = "06/16/2017", }; ParentRecord3.Children.Add(ChildRecord1); ParentRecord3.Children.Add(ChildRecord2); ParentRecord3.Children.Add(ChildRecord3); ParentRecord2.Children.Add(ParentRecord3); ParentRecord1.Children.Add(ParentRecord2); ParentRecord.Children.Add(ParentRecord1); TreeGridCollection.Add(ParentRecord); return(TreeGridCollection); }
/// <summary> /// iType,0=Lable,1,TextBox,2,DropList,3,Image,99,上传控件 /// </summary> /// <param name="tKeyName"></param> /// <param name="ColExList"></param> /// <param name="ds"></param> /// <param name="tModifyURL"></param> /// <param name="AllowSorting"></param> /// <param name="showEdit"></param> /// <param name="EditName"></param> public void InitGrid(string tKeyName, List <GridExPara> ColExList, DataSet ds, string tModifyURL, bool AllowSorting, bool showEdit, string EditName) { SmartGridView1.AllowSorting = AllowSorting; ViewState["DS"] = ds; SmartGridView1.Columns.Clear(); //填加选择列 ButtonField fldSelect = new ButtonField(); fldSelect.HeaderText = ""; SmartGridView1.Columns.Add(fldSelect); string[] KeyNames = new string[1]; KeyNames[0] = tKeyName; int Pos1 = 1; BLL.T_Field_BLL fieldBll = new DigiPower.Onlinecol.Standard.BLL.T_Field_BLL(); string TableName = ds.Tables[0].TableName; foreach (GridExPara paraEx in ColExList) { GridExPara.CtrlType cellType = paraEx.iType;// TemListShow[i].Split(','); switch (cellType) { //普通列 case 0: { TemplateField tc = new TemplateField(); tc.Visible = paraEx.bShow; if (paraEx.ShowName == "") { tc.HeaderText = fieldBll.GetCNFieldNameByFieldName(TableName, paraEx.FieldName); } else { tc.HeaderText = paraEx.ShowName; } tc.SortExpression = paraEx.FieldName; ColumnTemplate ctp = new ColumnTemplate("Label", paraEx.FieldName, paraEx.iLength); tc.ItemTemplate = ctp; tc.HeaderStyle.Width = paraEx.iLength; tc.ItemStyle.Width = paraEx.iLength; SmartGridView1.Columns.Insert(Pos1++, tc); } break; //可编辑的文本列 case GridExPara.CtrlType.TextBox: { TemplateField tc = new TemplateField(); tc.Visible = paraEx.bShow; tc.HeaderText = fieldBll.GetCNFieldNameByFieldName(TableName, paraEx.FieldName); tc.SortExpression = paraEx.FieldName; ColumnTemplate ctp = new ColumnTemplate("TXT", paraEx.FieldName, paraEx.iLength); tc.ItemTemplate = ctp; tc.HeaderStyle.Width = paraEx.iLength; tc.ItemStyle.Width = paraEx.iLength; SmartGridView1.Columns.Insert(Pos1++, tc); } break; //下拉列 case GridExPara.CtrlType.DropDownList: { TemplateField tc = new TemplateField(); tc.Visible = paraEx.bShow; tc.HeaderText = fieldBll.GetCNFieldNameByFieldName(TableName, paraEx.FieldName); tc.SortExpression = paraEx.FieldName; ColumnTemplate ctp = new ColumnTemplate("DRP", "OperateUserName", 0); tc.ItemTemplate = ctp; SmartGridView1.Columns.Insert(Pos1++, tc); } break; //图片列 case GridExPara.CtrlType.Image: { TemplateField tc = new TemplateField(); tc.Visible = paraEx.bShow; tc.HeaderText = fieldBll.GetCNFieldNameByFieldName(TableName, paraEx.FieldName); tc.SortExpression = paraEx.FieldName; ColumnTemplate ctp = new ColumnTemplate("Image", paraEx.FieldName, paraEx.iLength); tc.ItemTemplate = ctp; tc.HeaderStyle.Width = paraEx.iLength; tc.ItemStyle.Width = paraEx.iLength; SmartGridView1.Columns.Insert(Pos1++, tc); } break; //CheckBox case GridExPara.CtrlType.CheckBox: { TemplateField tc = new TemplateField(); tc.Visible = paraEx.bShow; tc.HeaderText = fieldBll.GetCNFieldNameByFieldName(TableName, paraEx.FieldName); tc.SortExpression = paraEx.FieldName; ColumnTemplate ctp = new ColumnTemplate("CheckBox", paraEx.FieldName, paraEx.iLength, paraEx.Enabled); tc.ItemTemplate = ctp; tc.HeaderStyle.Width = paraEx.iLength; tc.ItemStyle.Width = paraEx.iLength; SmartGridView1.Columns.Insert(Pos1++, tc); } break; //上传控件 case GridExPara.CtrlType.FileUpload: { TemplateField tc = new TemplateField(); tc.Visible = paraEx.bShow; tc.HeaderText = ""; ColumnTemplate ctp = new ColumnTemplate("FileUpload", paraEx.FieldName, paraEx.iLength); tc.ItemTemplate = ctp; tc.HeaderStyle.Width = paraEx.iLength; tc.ItemStyle.Width = paraEx.iLength; SmartGridView1.Columns.Insert(Pos1++, tc); } break; case GridExPara.CtrlType.SystemInfo: { TemplateField tc = new TemplateField(); tc.Visible = paraEx.bShow; tc.HeaderText = ""; ColumnTemplate ctp = new ColumnTemplate("SystemInfo", paraEx.FieldName, paraEx.iLength, paraEx.subType); tc.ItemTemplate = ctp; tc.HeaderStyle.Width = paraEx.iLength; tc.ItemStyle.Width = paraEx.iLength; SmartGridView1.Columns.Insert(Pos1++, tc); } break; } } //显示编辑列 if (showEdit) { ModifyURL = tModifyURL; AddEditColumn(EditName); } SmartGridView1.DataKeyNames = KeyNames; SmartGridView1.DataSource = ds.Tables[0].DefaultView; MyDataBind(AllowSorting); if (SmartGridView1.Rows.Count > 0) { if (_selType == SelType.Radio) { Control obj = SmartGridView1.Rows[0].FindControl("box2"); if (obj != null) { RadioButton c1 = (RadioButton)obj; c1.Checked = true; } } } }
public void Generate(string name, string tableName, Column[] columns, Parameter[] prms, Column[] filterColumns, Parameter[] filterPrms) { // Parameter-column equations list var eqTempl = new ColumnTemplate(); eqTempl.GenerateColumnParametrEquation(columns, prms, 2); var equation = eqTempl.TransformText().TrimEnd(); // List of procedure input parameter descriptions var allParams = new Parameter[prms.Length + filterPrms.Length]; Array.Copy(filterPrms, 0, allParams, 0, filterPrms.Length); Array.Copy(prms, 0, allParams, filterPrms.Length, prms.Length); var prmDescTempl = new ColumnTemplate(); prmDescTempl.GenerateParameters(allParams, 1); var parameters = prmDescTempl.TransformText().TrimEnd(); // Filter condition var filter = ""; if (filterColumns != null && filterPrms != null) { var filterTempl = new ColumnTemplate(); filterTempl.GenerateColumnParametrEquation(filterColumns, filterPrms, 2, false); filter = " WHERE\n" + filterTempl.TransformText().TrimEnd(); } #line default #line hidden #line 28 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write("-- UPDATE "); #line default #line hidden #line 29 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write(this.ToStringHelper.ToStringWithCulture(tableName)); #line default #line hidden #line 29 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write("\r\nCREATE OR REPLACE PROCEDURE "); #line default #line hidden #line 30 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write(this.ToStringHelper.ToStringWithCulture(name)); #line default #line hidden #line 30 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write("\r\n(\r\n"); #line default #line hidden #line 32 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write(this.ToStringHelper.ToStringWithCulture(parameters)); #line default #line hidden #line 32 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write("\r\n)\r\nLANGUAGE \'sql\'\r\nAS\r\n$BODY$\r\n UPDATE "); #line default #line hidden #line 37 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write(this.ToStringHelper.ToStringWithCulture(tableName)); #line default #line hidden #line 37 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write("\r\n SET\r\n"); #line default #line hidden #line 39 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write(this.ToStringHelper.ToStringWithCulture(equation)); #line default #line hidden #line 39 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write("\r\n"); #line default #line hidden #line 40 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write(this.ToStringHelper.ToStringWithCulture(filter)); #line default #line hidden #line 40 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" this.Write(";\r\n$BODY$;\r\n"); #line default #line hidden #line 42 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\PostgreSQL\ModifyProcedureTemplate .tt" }
public void Generate(string name, string tableName, Column[] filterColumns, Parameter[] filterPrms) { // Filter condition var filter = ""; if (filterColumns != null && filterPrms != null) { var filterTempl = new ColumnTemplate(); filterTempl.GenerateColumnParametrEquation(filterColumns, filterPrms, 2, false); filter = " WHERE\n" + filterTempl.TransformText().TrimEnd(); } // List of procedure input parameter descriptions var paramsDescTempl = new ColumnTemplate(); paramsDescTempl.GenerateParameters(filterPrms, 1); var paramsDesc = paramsDescTempl.TransformText().TrimEnd(); #line default #line hidden #line 20 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write("-- DELETE FROM "); #line default #line hidden #line 21 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(tableName)); #line default #line hidden #line 21 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write("\r\nCREATE OR REPLACE PROCEDURE "); #line default #line hidden #line 22 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(name)); #line default #line hidden #line 22 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write("\r\n(\r\n"); #line default #line hidden #line 24 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(paramsDesc)); #line default #line hidden #line 24 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write("\r\n)\r\nLANGUAGE \'sql\'\r\nAS\r\n$BODY$\r\n DELETE FROM "); #line default #line hidden #line 29 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(tableName)); #line default #line hidden #line 29 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write("\r\n"); #line default #line hidden #line 30 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write(this.ToStringHelper.ToStringWithCulture(filter)); #line default #line hidden #line 30 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" this.Write(";\r\n$BODY$;\r\n"); #line default #line hidden #line 32 "C:\Users\admin\source\repos\DatabaseUtils\DatabaseScriptGenerator\Templates\Oracle\RemoveProcedureTemplate.tt" }
public JqColumnBuilder Template(ColumnTemplate template) { LastColumn.Template = template; return(this); }