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);
}
