protected override void InitGridColumn()
{
//GridPanel1.ColumnModel.Columns.Clear();
ColumnCollection columns = GridPanel1.ColumnModel.Columns;
ColumnBase col = new RowNumbererColumn();
//columns.Add(col);
col = new NumberColumn()
{
Header = "排序", DataIndex = "orderID", Width = 50, Fixed = true
};
(col as NumberColumn).Format = "0";
col.Editor.Add(new NumberField());
columns.Add(col);
col = new Column()
{
Header = "代码", DataIndex = "ProgCode", Width = 80, Fixed = true
};
col.Editor.Add(new TextField());
columns.Add(col);
col = new Column()
{
Header = "名称", DataIndex = "ProgName"
};
col.Editor.Add(new TextField());
columns.Add(col);
col = new Column()
{
Header = "页面", DataIndex = "ProgClass"
};
col.Editor.Add(new TextField());
columns.Add(col);
col = new Column()
{
Header = "小图标", DataIndex = "ProgIcon1", Width = 50, Fixed = true
};
col.Editor.Add(new TextField());
columns.Add(col);
col = new Column()
{
Header = "大图标", DataIndex = "ProgIcon2", Width = 50, Fixed = true
};
col.Editor.Add(new TextField());
columns.Add(col);
col = new Column()
{
Header = "分类", DataIndex = "IsCore", Width = 40, Fixed = true
};
col.Editor.Add(new TextField());
columns.Add(col);
col = new Column()
{
Header = "组", DataIndex = "IsGroup", Width = 30, Fixed = true
};
col.Editor.Add(new TextField());
columns.Add(col);
}
public virtual void InitHeader(string PanelID, DataListManage datalistMan)
{
var list = this.GetCmp <GridPanel>(PanelID);
var store = this.GetCmp <Store>(PanelID + "_Store");
store.PageSize = AppSettingValues.DATALISTPAGELIMIT;
store.RemoveFields();
RowNumbererColumn col = new RowNumbererColumn();
col.Width = 40;
list.AddColumn(col);
setStoreField(PanelID, "ID", CosDataBase.INT_TYPE);
if (PanelID == "BMKSearch_DataList")
{
for (int i = 0; i < datalistMan.arrColumn.Count; i++)
{
bool visiable = true;
if (((i >= 9) && (i != datalistMan.arrColumn.Count - 1)) || (i == 0))
{
visiable = false;
}
if (i < datalistMan.arrColumn.Count - 1)
{
setPanelColumn(PanelID, (ColumnModel)datalistMan.arrColumn[i], datalistMan.bSort, 0, visiable);
}
else
{
setPanelColumn(PanelID, (ColumnModel)datalistMan.arrColumn[i], datalistMan.bSort, 1, visiable);
}
setStoreField(PanelID, (ColumnModel)datalistMan.arrColumn[i]);
}
}
else
{
for (int i = 0; i < datalistMan.arrColumn.Count; i++)
{
bool visiable = true;
if ((i >= 9) && (i != datalistMan.arrColumn.Count - 1))
{
visiable = false;
}
if (i < datalistMan.arrColumn.Count - 1)
{
setPanelColumn(PanelID, (ColumnModel)datalistMan.arrColumn[i], datalistMan.bSort, 0, visiable);
}
else
{
setPanelColumn(PanelID, (ColumnModel)datalistMan.arrColumn[i], datalistMan.bSort, 1, visiable);
}
setStoreField(PanelID, (ColumnModel)datalistMan.arrColumn[i]);
}
}
list.SortableColumns = true;
}
private ColumnBase[] BuildGridPanel(DataTable data)
{
ColumnBase[] nameFields = new ColumnBase[data.Columns.Count + 1];
nameFields[0] = new RowNumbererColumn();
int count = 1;
foreach (DataColumn column in data.Columns)
{
if (count <= 1)
{
nameFields[count] = new Column()
{
Text = column.ColumnName, DataIndex = column.ColumnName, Visible = false
};
}
else if (count < 4)
{
nameFields[count] = new Column()
{
Text = column.ColumnName, DataIndex = column.ColumnName
};
}
else if (count == 4)
{
nameFields[count] = new Column()
{
Text = column.ColumnName, DataIndex = column.ColumnName, Flex = 1
};
}
else if (count == 5)
{
nameFields[count] = new Column()
{
Text = column.ColumnName, DataIndex = column.ColumnName
};
nameFields[count].Renderer.Fn = "change";
}
else
{
nameFields[count] = new Column()
{
Text = RemoveLastWord(column.ColumnName), DataIndex = column.ColumnName, Editor = { new TextField() }
};
nameFields[count].Renderer.Fn = "change";
}
count++;
}
return(nameFields);
}
/// <summary>
/// 初始化查询 明细列表
/// </summary>
/// <param name="grid"></param>
public void IniSelectDetailGrid(Ext.Net.GridPanel grid)
{
#region 分页每页数量
var pagesize = uiHelper.Select.DetailGrid.PageSize;
if (pagesize <= 0)
{
pagesize = 15;
}
grid.GetStore().PageSize = pagesize;
#endregion
string prefix = UiControlNamePrefix.SelectDetailGrid;
Model model = grid.GetStore().ModelInstance;
#region 网格条数信息
int havecount = grid.ColumnModel.Columns.Count;
RowNumbererColumn numbercol = new RowNumbererColumn();
numbercol.Width = 40;
grid.ColumnModel.Columns.Insert(grid.ColumnModel.Columns.Count - havecount, numbercol);
#endregion
#region 添加设置字段
foreach (GridColumn column in uiHelper.Select.DetailGrid.Columns)
{
ModelField mField = new ModelField();
mField.Name = column.ColumnName;
if (column.ColumnType == GridColumnType.Date)
{
mField.Type = ModelFieldType.Date;
}
model.Fields.Add(mField);
if (column.IsShow)
{
CellCommandColumn cell = IniGridColumn(prefix, column);
grid.ColumnModel.Columns.Insert(grid.ColumnModel.Columns.Count - havecount, cell);
}
}
#endregion
}
private void InitComponent(GridPanelInfo panel, List <GridPanelColumnInfo> columnList)
{
if (panel.DisplayRowNumber)
{
RowNumbererColumn stt = new RowNumbererColumn();
stt.Header = "STT";
GridPanel1.ColumnModel.Columns.Add(stt);
}
if (panel.Header == false)
{
GridPanel1.Title = "";
}
else
{
GridPanel1.Title = panel.Title;
}
if (!string.IsNullOrEmpty(panel.AutoExpandColumn))
{
columnList = GridController.GetInstance().GetColumnInfo(this.ID, TableName, 1);
if (columnList.Count() != 0)
{
if (columnList.Where(p => p.ColumnName == panel.AutoExpandColumn).FirstOrDefault() != null)
{
GridPanel1.AutoExpandColumn = panel.AutoExpandColumn;
}
}
else
{
datatable = DataController.DataHandler.GetInstance().ExecuteDataTable("select top 1 * from " + TableName);
foreach (DataColumn item in datatable.Columns)
{
if (item.ColumnName == panel.AutoExpandColumn)
{
GridPanel1.AutoExpandColumn = panel.AutoExpandColumn;
break;
}
}
}
}
this.PrimaryKey = Util.GetInstance().GetPrimaryKeyOfTable(panel.TableName);
// Store1.AutoLoadParams.Add(new Ext.Net.Parameter("limit", panel.PageSize.ToString()));
//sHdfgridName.Value = this.ID.ToString();
//sHdftable.Value = this.TableName;
//sHdfPrimaryKey.Value = panel.PrimaryColumn;
//sHdfwhere.Value = panel.WhereClause.Replace("where", "");
//if (this.Height != 0)
// GridPanel1.Height = this.Height;
//else
// GridPanel1.Height = panel.Height.Value;
//if (this.Width != 0)
// GridPanel1.Width = this.Width;
//else
// GridPanel1.Width = panel.Width.Value;
GenerateListener();
//if (panel.PageSize.HasValue)
// PagingToolbar1.PageSize = panel.PageSize.Value;
//else
// PagingToolbar1.PageSize = 5;
if (!string.IsNullOrEmpty(panel.Icon))
{
GridPanel1.IconCls = panel.Icon;
}
else
{
GridPanel1.Icon = Icon.Table;
}
//set local filter
if (panel.AllowFilter)
{
GridFilters filter = new GridFilters();
filter.Local = true;
filter.FiltersText = "Lọc";
GridPanel1.Plugins.Add(filter);
datatable = DataController.DataHandler.GetInstance().ExecuteDataTable("select top 1 * from " + TableName);
foreach (DataColumn item in datatable.Columns)
{
switch (item.DataType.ToString())
{
case "System.Int32":
NumericFilter numberic = new NumericFilter();
numberic.DataIndex = item.ColumnName;
filter.Filters.Add(numberic);
break;
case "System.Boolean":
BooleanFilter boolean = new BooleanFilter();
boolean.DataIndex = item.ColumnName;
filter.Filters.Add(boolean);
break;
case "System.String":
StringFilter str = new StringFilter();
str.DataIndex = item.ColumnName;
filter.Filters.Add(str);
break;
case "System.DateTime":
DateFilter datefilter = new DateFilter();
datefilter.BeforeText = "Trước ngày";
datefilter.AfterText = "Sau ngày";
datefilter.OnText = "Vào ngày";
datefilter.DataIndex = item.ColumnName;
filter.Filters.Add(datefilter);
break;
}
}
}
}
private void AddColumn()
{
// remove fields
storeEvaluation.RemoveFields();
// column index
var colIndex = new RowNumbererColumn
{
ColumnID = "colIndex",
Header = "STT",
Align = Alignment.Center,
Width = 40
};
gpEvaluation.AddColumn(colIndex);
// column employee code
var colEmployeeCode = new Column
{
ColumnID = "colEmployeeCode",
Header = "Mã nhân viên",
DataIndex = "EmployeeCode",
Align = Alignment.Left,
Width = 100
};
var recordFieldEmployeeCode = new RecordField()
{
Name = "EmployeeCode",
Mapping = "EmployeeCode"
};
storeEvaluation.AddField(recordFieldEmployeeCode);
gpEvaluation.AddColumn(colEmployeeCode);
// init column employee name
var colFullName = new Column
{
ColumnID = "colFullName",
Header = "Họ và tên",
DataIndex = "FullName",
Align = Alignment.Left,
Width = 150
};
var recordFieldFullName = new RecordField()
{
Name = "FullName",
Mapping = "FullName"
};
storeEvaluation.AddField(recordFieldFullName);
gpEvaluation.AddColumn(colFullName);
//init column departmentName
var colDepartmentName = new Column
{
ColumnID = "colDepartmentName",
Header = "Đơn vị",
DataIndex = "DepartmentName",
Align = Alignment.Left,
Width = 150
};
var recordFieldDepartmentName = new RecordField()
{
Name = "DepartmentName",
Mapping = "DepartmentName"
};
storeEvaluation.AddField(recordFieldDepartmentName);
gpEvaluation.AddColumn(colDepartmentName);
// get criterion in group
var criterionGroups = CriterionGroupController.GetAll(null, null, Convert.ToInt32(hdfGroupFilter.Text), null, null);
// init count
var count = 0;
// add kpi criterion column
foreach (var item in criterionGroups)
{
// init field
var recordField = new RecordField()
{
Name = item.CriterionCode,
Mapping = "CriterionDetailModels[{0}].Display".FormatWith(count++)
};
// init column
var col = new Column
{
ColumnID = recordField.Name,
Header = item.CriterionName,
DataIndex = recordField.Name,
Align = Alignment.Center,
Width = 150,
Renderer = { Fn = "RenderCriterion" }
};
// add field
storeEvaluation.AddField(recordField);
// add column
gpEvaluation.AddColumn(col);
}
}
/// <summary>
/// 初始化查询主界面项
/// </summary>
/// <param name="grid"></param>
public void IniSelectMainGrid(Ext.Net.GridPanel grid)
{
#region 分页每页数量
var pagesize = uiHelper.Select.MainGrid.PageSize;
if (pagesize <= 0)
{
pagesize = 15;
}
grid.GetStore().PageSize = pagesize;
#endregion
string prefix = UiControlNamePrefix.SelectMainGrid;
Model model = grid.GetStore().ModelInstance;
#region 网格条数信息
int havecount = grid.ColumnModel.Columns.Count;
RowNumbererColumn numbercol = new RowNumbererColumn();
numbercol.Width = 40;
grid.ColumnModel.Columns.Insert(grid.ColumnModel.Columns.Count - havecount, numbercol);
#endregion
#region 添加特殊字段
if (uiHelper.UiData.Crud.Primarykey != null &&
!string.IsNullOrWhiteSpace(uiHelper.UiData.Crud.Primarykey.FieldName))
{
IniAddGridColumn(prefix, uiHelper.UiData.Crud.Primarykey.FieldName, havecount, grid);
}
IniAddGridColumn(prefix, uiHelper.UiData.Crud.DeleteFlag, havecount, grid);
#endregion
#region 添加设置字段
foreach (GridColumn column in uiHelper.Select.MainGrid.Columns)
{
ModelField mField = new ModelField();
mField.Name = column.ColumnName;
if (column.ColumnType == GridColumnType.Date)
{
mField.Type = ModelFieldType.Date;
}
model.Fields.Add(mField);
if (column.IsShow)
{
CellCommandColumn cell = IniGridColumn(prefix, column);
grid.ColumnModel.Columns.Insert(grid.ColumnModel.Columns.Count - havecount, cell);
}
}
#endregion
#region 更新显示按钮
if (uiHelper.Update.Panel.ParamFields.Count > 0)
{
return;
}
int commandcount = 0;
if (uiHelper.Select.MainDetail.ParamFields.Count > 0)
{
commandcount++;
}
if (uiHelper.Select.DetailGrid.Columns.Count > 0)
{
commandcount++;
}
if (commandcount == 0)
{
return;
}
CommandColumn commandColumn = new CommandColumn();
commandColumn.ID = "commandColumnShowDetail";
commandColumn.Width = commandcount * 86;
commandColumn.Text = "查看";
commandColumn.Align = Alignment.Center;
int _command = commandColumn.Commands.Count;
if (uiHelper.Select.MainDetail.ParamFields.Count > 0)
{
GridCommand command = new GridCommand();
command.Icon = Icon.TableColumn;
command.Text = "详细信息";
command.CommandName = "ShowFieldsInfo";
commandColumn.Commands.Add(command);
commandColumn.Listeners.Command.Fn = "showdetailcommandcolumn_click";
}
if (commandColumn.Commands.Count > _command)
{
commandColumn.Commands.Add(new CommandSeparator());
_command = commandColumn.Commands.Count;
}
if (uiHelper.Select.DetailGrid.Columns.Count > 0)
{
GridCommand command = new GridCommand();
command.Icon = Icon.TableColumn;
command.Text = "明细信息";
command.CommandName = "ShowDetail";
commandColumn.Commands.Add(command);
commandColumn.Listeners.Command.Fn = "showdetailcommandcolumn_click";
}
grid.ColumnModel.Columns.Add(commandColumn);
#endregion
}
/// <summary>
///
/// </summary>
private void AddColumn()
{
// remove fields
storeInsurance.RemoveFields();
var view = gpInsurance.View[0];
//init group header
var headerGroupRow = new HeaderGroupRow();
//add column group header
headerGroupRow.Columns.Add(new HeaderGroupColumn
{
Header = "",
ColSpan = 4,
Align = Alignment.Center
});
// column index
var colIndex = new RowNumbererColumn
{
ColumnID = "colIndex",
Header = "STT",
Align = Alignment.Center,
Width = 40
};
gpInsurance.ColumnModel.Columns.Add(colIndex);
// init column employee name
var colFullName = new Column
{
ColumnID = "colFullName",
Header = "Họ và tên",
DataIndex = "FullName",
Align = Alignment.Left,
Width = 150
};
var recordFieldFullName = new RecordField()
{
Name = "FullName",
Mapping = "FullName"
};
storeInsurance.AddField(recordFieldFullName);
gpInsurance.ColumnModel.Columns.Add(colFullName);
// column employee code
var colEmployeeCode = new Column
{
ColumnID = "colEmployeeCode",
Header = "Mã nhân viên",
DataIndex = "EmployeeCode",
Align = Alignment.Left,
Width = 100
};
var recordFieldEmployeeCode = new RecordField()
{
Name = "EmployeeCode",
Mapping = "EmployeeCode"
};
storeInsurance.AddField(recordFieldEmployeeCode);
gpInsurance.ColumnModel.Columns.Add(colEmployeeCode);
//init column departmentName
var colDepartmentName = new Column
{
ColumnID = "colDepartmentName",
Header = "Đơn vị",
DataIndex = "DepartmentName",
Align = Alignment.Left,
Width = 150
};
var recordFieldDepartmentName = new RecordField()
{
Name = "DepartmentName",
Mapping = "DepartmentName"
};
storeInsurance.AddField(recordFieldDepartmentName);
gpInsurance.ColumnModel.Columns.Add(colDepartmentName);
// init count
var count = 0;
var products = new string[] { "Công ty đóng", "Người LĐ đóng" };
// add column by month
for (var i = 0; i < 12; i++)
{
//add group header
headerGroupRow.Columns.Add(new HeaderGroupColumn
{
Header = @"Tháng {0}".FormatWith(i + 1),
ColSpan = products.Length,
Align = Alignment.Center
});
// init field
var recordField = new RecordField()
{
Name = "Month{0}".FormatWith(i + 1),
Mapping = "InsuranceDetailModels[{0}]".FormatWith(count++)
};
foreach (var product in products)
{
var value = "EnterpriseSocial";
if (product == @"Công ty đóng")
{
value = "EnterpriseSocial";
}
else
{
value = "LaborerSocial";
}
// init column
var col = new Column
{
ColumnID = value,
Header = product,
DataIndex = recordField.Name,
Align = Alignment.Left,
Width = 150,
Renderer = { Fn = "RenderMonth" }
};
// add column
gpInsurance.ColumnModel.Columns.Add(col);
}
// add field
storeInsurance.AddField(recordField);
}
//add header group row
view.HeaderGroupRows.Add(headerGroupRow);
}
