private void InitGrid()
{
GridPanel panel = rptGrid.PrimaryGrid;
GridColumnCollection columns = panel.Columns;
// Set both the Slider and SwitchButton columns to
// our own defined EditControls
GridColumn column1 = panel.Columns["PlModelNo"];
column1.EditorType = typeof(ModelNoComboxControl);
column1.Width = 150;
GridColumn column2 = panel.Columns["PlColor"];
column2.EditorType = typeof(ColorComboxControl);
column2.Width = 150;
GridColumn column3 = panel.Columns["PlKilnNo"];
column3.EditorType = typeof(KilnNoComboxControl);
column3.Width = 50;
//FTypeSteps
GridColumn column4 = panel.Columns["FTypeSteps1"];
column4.EditorType = typeof(TypeStepComboxControl);
column4.Width = 100;
GridColumn column6 = panel.Columns["FMaterial"];
column6.EditorType = typeof(MaterialComboxControl);
column6.Width = 50;
GridColumn column5 = panel.Columns["PlWorkNumID"];
column5.EditorType = typeof(MyGridComboxControl);
column5.Width = 50;
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("PlGoodsID", "产品编号", columns));
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("PlModelNo", "器型名称", columns));
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("PlColor", "花色名称", columns));
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("PlKilnNo", "窑炉编号", columns));
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("FMaterial", "瓷质", columns));
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("PlWorkNumID", "班次", columns));
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("FTypeSteps1", "成型工艺", columns));
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("FMaterialQty", "瓷重", columns));
panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("sumQty", "开窑总数", columns));
//panel.ColumnHeader.GroupHeaders.Add(GetSingleInfoHeader("HJSqty", "合计", columns));
columns["PlGoodsID"].HeaderStyles.MouseOver.Background = new Background(Color.Yellow);
panel.ColumnHeader.GroupHeaders.Add(GetLevelHeader(columns)); //A等品
panel.ColumnHeader.GroupHeaders.Add(GetLevelBHeader(columns)); //B等品
//panel.ColumnHeader.GroupHeaders.Add(GetLevelCHeader(columns));//C等品
panel.ColumnHeader.GroupHeaders.Add(GetHeader(columns, "C等品", GetDisplayIndex(columns, "CQty"), GetDisplayIndex(columns, "CRate"), Color.LightYellow));
panel.ColumnHeader.GroupHeaders.Add(GetHeader(columns, "补釉", GetDisplayIndex(columns, "BUQty"), GetDisplayIndex(columns, "BURate"), Color.LightYellow));
panel.ColumnHeader.GroupHeaders.Add(GetHeader(columns, "废品", GetDisplayIndex(columns, "FPQty"), GetDisplayIndex(columns, "FPRate"), Color.LightYellow));
panel.ColumnHeader.GroupHeaders.Add(GetHeader(columns, "小计", GetDisplayIndex(columns, "sumQty1"), GetDisplayIndex(columns, "sumRate1"), Color.LightYellow));
panel.ColumnHeader.GroupHeaders.Add(GetModelHeader(columns)); //成型缺陷
panel.ColumnHeader.GroupHeaders.Add(GetGlazeHeader(columns)); //釉彩缺陷
panel.ColumnHeader.GroupHeaders.Add(GetFireHeader(columns)); //看火缺陷
}
private void BindCombox4(GridColumnCollection dcl)
{
List <frmSort.SortCol> list = new List <frmSort.SortCol>();
frmSort.SortCol item = new frmSort.SortCol
{
valueMember = "0",
textMember = "无..."
};
list.Add(item);
for (int i = 0; i < dcl.Count; i++)
{
if (dcl[i].Visible)
{
frmSort.SortCol item2 = new frmSort.SortCol
{
valueMember = dcl[i].FieldName,
textMember = dcl[i].Caption
};
list.Add(item2);
}
}
this.comboBox4.DataSource = list;
this.comboBox4.DisplayMember = "textMember";
this.comboBox4.ValueMember = "valueMember";
}
/// <summary>
/// 绑定DGV控件，合并列
/// </summary>
private void MultiColumn()
{
GridPanel panel = superGridControlClient.PrimaryGrid;
GridColumnCollection columns = panel.Columns;
panel.ColumnHeader.GroupHeaders.Add(
GetSlCompanyInfoHeader(
columns,
"Columnsbase",
"客户基础资料",
"gridColumnCliName",
"gridColumnFax"));
panel.ColumnHeader.GroupHeaders.Add(
GetSlCompanyInfoHeader(
columns,
"Columnslocation",
"联系地址",
"gridColumnArea",
"gridColumnAd"));
//panel.ColumnHeader.GroupHeaders.Add(
// GetSlCompanyInfoHeader(
// columns,
// "Columnsother",
// "其他信息",
// "gridColumnBa",
// "gridColumnPic"));
}
private ColumnGroupHeader GetLevelHeader(GridColumnCollection columns)
{
ColumnGroupHeader cgh = new ColumnGroupHeader();
cgh.Name = "Levels";
cgh.MinRowHeight = 28;
// Enable MiniMarkup and set the header text as needed
cgh.EnableHeaderMarkup = true;
cgh.HeaderText = "<div align=\"center\"><font size=\"12\">A等品</font> </div>";
cgh.HeaderStyles.MouseOver.Background = new Background(Color.Yellow);
cgh.HeaderStyles.Default.Background = new Background(Color.LightYellow);
// Create and add the subordinate group headers
ColumnGroupHeader cshArea = GetWXHeader(columns);
ColumnGroupHeader cshPop = GetNXHeader(columns);
cgh.GroupHeaders.Add(cshArea);
cgh.GroupHeaders.Add(cshPop);
// We want the header to also contain the 'City' column
// so we must include it in the display range.
cgh.StartDisplayIndex = GetDisplayIndex(columns, "WXQTY");
cgh.EndDisplayIndex = GetDisplayIndex(columns, "NXRATE");
return(cgh);
}
public void DoExport(GridCommandEventArgs e, GridColumnCollection Columns, GridDataItemCollection Items)
{
ExportSettings.ExportOnlyData = true;
ExportSettings.OpenInNewWindow = true;
ExportSettings.Excel.Format = GridExcelExportFormat.Html;
ExportSettings.Pdf.PaperSize = GridPaperSize.A4;
ExportSettings.Pdf.PageHeight = Unit.Parse("210mm");
ExportSettings.Pdf.PageWidth = Unit.Parse("297mm");
ExportSettings.Pdf.AllowPrinting = true;
switch (e.CommandArgument.ToString())
{
case "Excel":
Task.Factory.StartNew(() => AsyncExportExcel(Columns, Items)).Wait();
break;
case "Word":
Task.Factory.StartNew(() => AsyncExportWord(Columns, Items)).Wait();
break;
case "Pdf":
Task.Factory.StartNew(() => AsyncExportPdf()).Wait();
break;
}
}
private void anadir_tmtos_Click(object sender, EventArgs e)
{
GridRow tupla = (GridRow)sgrid_tmtos.ActiveRow;
if (tupla != null)
{
if (sgrid_tmtos2.PrimaryGrid.Columns.Count == 0)
{
GridColumnCollection columnas = sgrid_tmtos.PrimaryGrid.Columns;
foreach (GridColumn columna in columnas)
{
sgrid_tmtos2.PrimaryGrid.Columns.Add(new GridColumn(columna.Name));
}
}
GridCellCollection c = tupla.Cells;
if (!esta_agregado(c[0].ToString()))
{
GridRow nueva = new GridRow(c[0].Value.ToString(), c[1].Value.ToString(), c[2].Value.ToString(), c[3].Value.ToString(),
c[4].Value.ToString(), c[5].Value.ToString(), c[6].Value.ToString());
sgrid_tmtos2.PrimaryGrid.Rows.Add((GridElement)nueva);
}
else
{
mensaje_error("Ya se ha agregado el mismo medicamento.");
}
}
}
public CGrid(Func <QueryDictionary <StringValues>, ItemsDTO <T> > dataService,
QueryDictionary <StringValues> query, bool renderOnlyRows,
Action <IGridColumnCollection <T> > columns = null, CultureInfo cultureInfo = null)
{
_dataService = dataService;
Items = new List <T>(); //response.Items;
Url = null;
_query = query;
//set up sort settings:
_settings = new QueryStringGridSettingsProvider(_query);
Sanitizer = new Sanitizer();
if (cultureInfo != null)
{
Strings.CultureInfo = cultureInfo;
}
EmptyGridText = Strings.DefaultGridEmptyText;
Language = Strings.Lang;
_annotations = new GridAnnotaionsProvider();
//Set up column collection:
_columnBuilder = new DefaultColumnBuilder <T>(this, _annotations);
_columnsCollection = new GridColumnCollection <T>(this, _columnBuilder, _settings.SortSettings);
ComponentOptions = new GridOptions();
ApplyGridSettings();
Pager = new GridPager(query);
ComponentOptions.RenderRowsOnly = renderOnlyRows;
columns?.Invoke(Columns);
}
public Grid(IQueryable <T> items)
: base(items)
{
#region init default properties
//set up sort settings:
_settings = new QueryStringGridSettingsProvider();
Sanitizer = new Sanitizer();
EmptyGridText = Strings.DefaultGridEmptyText;
Language = Strings.Lang;
_currentSortItemsProcessor = new SortGridItemsProcessor <T>(this, _settings.SortSettings);
_currentFilterItemsProcessor = new FilterGridItemsProcessor <T>(this, _settings.FilterSettings);
AddItemsPreProcessor(_currentFilterItemsProcessor);
InsertItemsProcessor(0, _currentSortItemsProcessor);
_annotaions = new GridAnnotaionsProvider();
#endregion
//Set up column collection:
_columnBuilder = new DefaultColumnBuilder <T>(this, _annotaions);
_columnsCollection = new GridColumnCollection <T>(_columnBuilder, _settings.SortSettings);
RenderOptions = new GridRenderOptions();
ApplyGridSettings();
}
public MainWindow()
{
InitializeComponent();
columns = new GridColumnCollection(gridControl1);
listBox1.SetValue(DragManager.DropTargetFactoryProperty, new ListBoxDropTargetFactory(listBox1));
listBox1.SetValue(GridControl.CurrentViewProperty, tableView1);
tableView1.ExternalColumnList = listBox1;
for (int i = 0; i < 5; i++)
{
columns.Add(new GridColumn()
{
FieldName = "Column" + (i + 1).ToString()
});
}
listBox1.ItemsSource = columns;
ObservableCollection <Customer> cusromers = new ObservableCollection <Customer>();
cusromers.Add(new Customer()
{
ID = 1, Name = "Name1"
});
cusromers.Add(new Customer()
{
ID = 2, Name = "Name2"
});
gridControl1.ItemsSource = cusromers;
}
protected void IniColumns()
{
GridColumnCollection columns = grid.PrimaryGrid.Columns;
ColumnGroupHeader cghFile = new ColumnGroupHeader();
cghFile.Name = "cghFile";
cghFile.HeaderText = "文件";
cghFile.MinRowHeight = 40;
cghFile.StartDisplayIndex = columns.GetDisplayIndex(columns[0]);
cghFile.EndDisplayIndex = columns.GetDisplayIndex(columns[1]);
grid.PrimaryGrid.ColumnHeader.GroupHeaders.Add(cghFile);
var cghLoc = new ColumnGroupHeader();
cghLoc.Name = "cghLoc";
cghLoc.HeaderText = "本地版本";
cghLoc.MinRowHeight = 40;
cghLoc.StartDisplayIndex = columns.GetDisplayIndex(columns[2]);
cghLoc.EndDisplayIndex = columns.GetDisplayIndex(columns[3]);
grid.PrimaryGrid.ColumnHeader.GroupHeaders.Add(cghLoc);
var cghSer = new ColumnGroupHeader();
cghSer.Name = "cghLoc";
cghSer.HeaderText = "服务器版本";
cghSer.MinRowHeight = 40;
cghSer.StartDisplayIndex = columns.GetDisplayIndex(columns[4]);
cghSer.EndDisplayIndex = columns.GetDisplayIndex(columns[5]);
grid.PrimaryGrid.ColumnHeader.GroupHeaders.Add(cghSer);
}
//生成excel
private void ToolStripMenuItemExcel_Click(object sender, EventArgs e)
{
string defaultName = DateTime.Now.ToString("yyyyMMddHHmm") + "产品资料";
saveFileDialog1.FileName = defaultName + ".xls";
saveFileDialog1.Filter = "Excel文件（*.xls）|*.xls|Excel 文件(*.xlsx)|*.xlsx";
saveFileDialog1.AddExtension = true;
if (saveFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
DataTable dt = ((DataSet)superGridControlMaterial.PrimaryGrid.DataSource).Tables[0];
GridColumnCollection gcc = superGridControlMaterial.PrimaryGrid.Columns;
string[] x =
{
"产品名称", "规格型号", "条码", "助记码", "编号", "所属类别", "售价", "预设售价A", "预设售价B", "预设售价C",
"预设售价D", "预设售价E", "创建时间", "供应商", "单位", "进价", "进货时间", "备注", "启用标志", "预留1", "预留2"
};
dt.Columns.Remove("Ma_ID");
dt.Columns.Remove("Ma_PicName");
dt.Columns.Remove("Ma_RFID");
dt.Columns.Remove("Ma_TypeID");
dt.Columns.Remove("Ma_SupID");
dt.Columns.Remove("Ma_Clear");
try
{
NPOIExcelHelper.DataTableToExcel(dt, "sdfe", saveFileDialog1.FileName, x);
MessageBox.Show("Excel文件已成功导出，请到保存目录下查看。");
}
catch (Exception ex)
{
MessageBox.Show("保存失败,请检查异常情况:" + ex.Message);
}
}
public SGrid(IEnumerable <T> items, IQueryCollection query)
: base(items)
{
#region init default properties
Query = QueryDictionary <StringValues> .Convert(query);
//set up sort settings:
_settings = new QueryStringGridSettingsProvider(Query);
Sanitizer = new Sanitizer();
EmptyGridText = Strings.DefaultGridEmptyText;
Language = Strings.Lang;
_currentSortItemsProcessor = new SortGridItemsProcessor <T>(this, _settings.SortSettings);
_currentFilterItemsProcessor = new FilterGridItemsProcessor <T>(this, _settings.FilterSettings);
_currentSearchItemsProcessor = new SearchGridItemsProcessor <T>(this, _settings.SearchSettings);
_currentTotalsItemsProcessor = new TotalsGridItemsProcessor <T>(this);
AddItemsPreProcessor(_currentFilterItemsProcessor);
AddItemsPreProcessor(_currentSearchItemsProcessor);
InsertItemsProcessor(0, _currentSortItemsProcessor);
SetTotalsProcessor(_currentTotalsItemsProcessor);
_annotations = new GridAnnotationsProvider();
#endregion init default properties
//Set up column collection:
_columnBuilder = new DefaultColumnBuilder <T>(this, _annotations);
_columnsCollection = new GridColumnCollection <T>(this, _columnBuilder, _settings.SortSettings);
RenderOptions = new GridRenderOptions();
ApplyGridSettings();
}
protected StringBuilder ConvertFilterExpressionToSqlExpression(GridColumnCollection columns, bool isDynamicQuery = false)
{
var querySb = new StringBuilder();
foreach (GridColumn column in columns)
{
if (column.ListOfFilterValues != null)
{
if (querySb.Length > 0)
{
querySb.Append(" AND ");
}
querySb.Append("(");
foreach (var c in column.ListOfFilterValues)
{
querySb.Append(GetFilterExpression(GridKnownFunction.EqualTo, column.UniqueName, c, isDynamicQuery) + " OR ");
}
querySb.Remove(querySb.Length - 3, 3);
querySb.Append(")");
}
var currentFilterExpression = GetFilterExpression(column.CurrentFilterFunction, column.UniqueName, column.CurrentFilterValue, isDynamicQuery);
var andCurrentFilterExpression = GetFilterExpression(column.AndCurrentFilterFunction, column.UniqueName, column.AndCurrentFilterValue, isDynamicQuery);
if (!string.IsNullOrEmpty(currentFilterExpression) || !string.IsNullOrEmpty(andCurrentFilterExpression))
{
if (querySb.Length > 0)
{
querySb.Append(" AND ");
}
}
switch (column.CurrentFilterFunction)
{
case GridKnownFunction.Between:
querySb.Append(currentFilterExpression + " AND " + andCurrentFilterExpression);
break;
case GridKnownFunction.NotBetween:
querySb.Append(currentFilterExpression + " OR " + andCurrentFilterExpression);
break;
default:
if (!string.IsNullOrEmpty(currentFilterExpression))
{
querySb.Append(currentFilterExpression);
}
if (!string.IsNullOrEmpty(andCurrentFilterExpression))
{
querySb.Append(andCurrentFilterExpression);
}
break;
}
}
return(querySb);
}
/// <summary>
/// Initializes a new instance of the <see cref="Eto.Forms.Grid"/> class.
/// </summary>
/// <param name="generator">Generator to instantiate the handler with</param>
/// <param name="type">Type of handler to create</param>
/// <param name="initialize">If set to <c>true</c> initialize.</param>
protected Grid(Generator generator, Type type, bool initialize = true)
: base(generator, type, false)
{
Columns = new GridColumnCollection();
if (initialize)
{
Initialize();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Eto.Forms.Grid"/> class.
/// </summary>
/// <param name="generator">Generator to instantiate the handler with</param>
/// <param name="handler">Pre-created handler to attach to this instance</param>
/// <param name="initialize">If set to <c>true</c> initialize.</param>
protected Grid(Generator generator, IControl handler, bool initialize = true)
: base(generator, handler, false)
{
Columns = new GridColumnCollection();
if (initialize)
{
Initialize();
}
}
public void GridColumnCollection_Constructor_WhenArgumentIsCorrect_DoesNotThrow()
{
Grid <string> grid = new Grid <string>(GRID_WIDTH, GRID_HEIGHT, "My taylor is rich!");
Assert.DoesNotThrow(() =>
{
GridColumnCollection <string> gcc = new GridColumnCollection <string>(grid);
});
}
public void GridColumnCollection_Constructor_WhenGridIsNull_ThrowArgumentNullException()
{
Grid <string> grid = null;
Assert.Throws <ArgumentNullException>(() =>
{
GridColumnCollection <string> gcc = new GridColumnCollection <string>(grid);
});
}
public frmFilter(GridColumnCollection dcl)
{
this.InitializeComponent();
clsMe clsMe = new clsMe();
clsMe.setFormStyl(this);
this.filtertype = "OTHER";
this.tempdcl = dcl;
base.Height -= 120;
this.grpNY.Visible = false;
}
public void Init()
{
var repo = new TestRepository();
var items = repo.GetAll().ToList();
_grid = new TestGrid(items);
_columns = new GridColumnCollection <TestModel>(_grid, new DefaultColumnBuilder <TestModel>(_grid, new GridAnnotationsProvider()), _grid.Settings.SortSettings);
}
public frmFilter(GridColumnCollection dcl)
{
this.InitializeComponent();
clsMe clsMe = new clsMe();
clsMe.setFormStyl(this);
this.filtertype = "OTHER";
this.tempdcl = dcl;
base.Height -= 120;
this.grpNY.Visible = false;
}
public void GridColumnCollection_Index_WhenArgumentOutOfRange_ThrowIndexOutOfRangeException(int col)
{
Grid <char> grid = new Grid <char>(GRID_WIDTH, GRID_HEIGHT);
GridColumnCollection <char> gcc = new GridColumnCollection <char>(grid);
Assert.Throws <IndexOutOfRangeException>(() =>
{
GridColumn <char> column = gcc[col];
});
}
public void GridColumnCollection_Columns_Count_Equals_Grid_Width()
{
Grid <ushort> grid = new Grid <ushort>(GRID_WIDTH, GRID_HEIGHT);
GridColumnCollection <ushort> gcc = new GridColumnCollection <ushort>(grid);
int columnCount = gcc.Count();
int gridWidth = grid.Width;
Assert.AreEqual(columnCount, gridWidth);
}
public void GridColumnCollection_Index_WhenArgumentIsCorrect_DoesNotThrow(int col)
{
Grid <char> grid = new Grid <char>(GRID_WIDTH, GRID_HEIGHT);
GridColumnCollection <char> gcc = new GridColumnCollection <char>(grid);
Assert.DoesNotThrow(() =>
{
GridColumn <char> column = gcc[col];
});
}
public void Init()
{
Action <IGridColumnCollection <TestModel> > columns = c =>
{
c.Add(r => r.Id);
};
var repo = new TestRepository();
_grid = new TestGrid((q) => repo.GetAllService(columns, q, false, true), true, columns, Thread.CurrentThread.CurrentCulture);
_columns = new GridColumnCollection <TestModel>(_grid, new DefaultColumnBuilder <TestModel>(_grid, new GridAnnotaionsProvider()), _grid.Settings.SortSettings);
}
private ColumnGroupHeader GetGlazeHeader(GridColumnCollection columns)
{
ColumnGroupHeader cgh = new ColumnGroupHeader();
//cgh.Name = "LevelB";
cgh.MinRowHeight = 28;
cgh.EnableHeaderMarkup = true;
cgh.HeaderText = "<div align=\"center\"><font size=\"12\">釉彩缺陷</font> </div>";
cgh.HeaderStyles.MouseOver.Background = new Background(Color.Yellow);
cgh.HeaderStyles.Default.Background = new Background(Color.Aquamarine);
// Create and add the subordinate group headers
ColumnGroupHeader csh1 = GetHeader(columns, "色不均", GetDisplayIndex(columns, "SBJQty"), GetDisplayIndex(columns, "SBJRate"), Color.Aquamarine);
ColumnGroupHeader csh2 = GetHeader(columns, "色脏", GetDisplayIndex(columns, "SZQty"), GetDisplayIndex(columns, "SZRate"), Color.Aquamarine);
ColumnGroupHeader csh3 = GetHeader(columns, "缺釉", GetDisplayIndex(columns, "QYQty"), GetDisplayIndex(columns, "QYRate"), Color.Aquamarine);
ColumnGroupHeader csh4 = GetHeader(columns, "釉彩斑点", GetDisplayIndex(columns, "YCBDQty"), GetDisplayIndex(columns, "YCBDRate"), Color.Aquamarine);
ColumnGroupHeader csh5 = GetHeader(columns, "缩釉", GetDisplayIndex(columns, "SYQty"), GetDisplayIndex(columns, "SYRate"), Color.Aquamarine);
ColumnGroupHeader csh6 = GetHeader(columns, "釉缕", GetDisplayIndex(columns, "YoLQty"), GetDisplayIndex(columns, "YoLRate"), Color.Aquamarine);
ColumnGroupHeader csh7 = GetHeader(columns, "毛孔", GetDisplayIndex(columns, "MKQty"), GetDisplayIndex(columns, "MKRate"), Color.Aquamarine);
ColumnGroupHeader csh8 = GetHeader(columns, "落渣", GetDisplayIndex(columns, "LZQty"), GetDisplayIndex(columns, "LZRate"), Color.Aquamarine);
ColumnGroupHeader csh9 = GetHeader(columns, "粘疤", GetDisplayIndex(columns, "NBQty"), GetDisplayIndex(columns, "NBRate"), Color.Aquamarine);
ColumnGroupHeader csh10 = GetHeader(columns, "粘渣脚", GetDisplayIndex(columns, "NZJQty"), GetDisplayIndex(columns, "NZJRate"), Color.Aquamarine);
ColumnGroupHeader csh11 = GetHeader(columns, "伤裂", GetDisplayIndex(columns, "SLQty"), GetDisplayIndex(columns, "SLRate"), Color.Aquamarine);
ColumnGroupHeader csh12 = GetHeader(columns, "薄釉", GetDisplayIndex(columns, "BOUQty"), GetDisplayIndex(columns, "BOURate"), Color.Aquamarine);
ColumnGroupHeader csh13 = GetHeader(columns, "其他", GetDisplayIndex(columns, "YCQTQty"), GetDisplayIndex(columns, "YCQTRate"), Color.Aquamarine);
ColumnGroupHeader csh14 = GetHeader(columns, "小计", GetDisplayIndex(columns, "sumQty3"), GetDisplayIndex(columns, "sumRate3"), Color.Aquamarine);
cgh.GroupHeaders.Add(csh1);
cgh.GroupHeaders.Add(csh2);
cgh.GroupHeaders.Add(csh3);
cgh.GroupHeaders.Add(csh4);
cgh.GroupHeaders.Add(csh5);
cgh.GroupHeaders.Add(csh6);
cgh.GroupHeaders.Add(csh7);
cgh.GroupHeaders.Add(csh8);
cgh.GroupHeaders.Add(csh9);
cgh.GroupHeaders.Add(csh10);
cgh.GroupHeaders.Add(csh11);
cgh.GroupHeaders.Add(csh12);
cgh.GroupHeaders.Add(csh13);
cgh.GroupHeaders.Add(csh14);
// We want the header to also contain the 'City' column
// so we must include it in the display range.
cgh.StartDisplayIndex = GetDisplayIndex(columns, "SBJQty");
cgh.EndDisplayIndex = GetDisplayIndex(columns, "sumRate3");
return(cgh);
}
private ColumnGroupHeader GetModelHeader(GridColumnCollection columns)
{
ColumnGroupHeader cgh = new ColumnGroupHeader();
//cgh.Name = "LevelB";
cgh.MinRowHeight = 28;
cgh.EnableHeaderMarkup = true;
cgh.HeaderText = "<div align=\"center\"><font size=\"12\">成型缺陷</font> </div>";
cgh.HeaderStyles.MouseOver.Background = new Background(Color.Yellow);
cgh.HeaderStyles.Default.Background = new Background(Color.SandyBrown);
// Create and add the subordinate group headers
ColumnGroupHeader csh1 = GetHeader(columns, "加工斑点", GetDisplayIndex(columns, "JGBDQty"), GetDisplayIndex(columns, "JGBDRate"), Color.SandyBrown);
ColumnGroupHeader csh2 = GetHeader(columns, "针孔", GetDisplayIndex(columns, "ZKQty"), GetDisplayIndex(columns, "ZKRate"), Color.SandyBrown);
ColumnGroupHeader csh3 = GetHeader(columns, "斑点", GetDisplayIndex(columns, "BDQty"), GetDisplayIndex(columns, "BDRate"), Color.SandyBrown);
ColumnGroupHeader csh4 = GetHeader(columns, "阴裂", GetDisplayIndex(columns, "YLQty"), GetDisplayIndex(columns, "YLRate"), Color.SandyBrown);
ColumnGroupHeader csh5 = GetHeader(columns, "凹凸", GetDisplayIndex(columns, "ATQty"), GetDisplayIndex(columns, "ATRate"), Color.SandyBrown);
ColumnGroupHeader csh6 = GetHeader(columns, "泥渣", GetDisplayIndex(columns, "NZQty"), GetDisplayIndex(columns, "NZRate"), Color.SandyBrown);
ColumnGroupHeader csh7 = GetHeader(columns, "缺泥", GetDisplayIndex(columns, "QNQty"), GetDisplayIndex(columns, "QNRate"), Color.SandyBrown);
ColumnGroupHeader csh8 = GetHeader(columns, "粗糙", GetDisplayIndex(columns, "CCQty"), GetDisplayIndex(columns, "CCRate"), Color.SandyBrown);
ColumnGroupHeader csh9 = GetHeader(columns, "开裂", GetDisplayIndex(columns, "KLQty"), GetDisplayIndex(columns, "KLRate"), Color.SandyBrown);
ColumnGroupHeader csh10 = GetHeader(columns, "裂耳", GetDisplayIndex(columns, "LEQty"), GetDisplayIndex(columns, "LERate"), Color.SandyBrown);
ColumnGroupHeader csh11 = GetHeader(columns, "变形", GetDisplayIndex(columns, "BXQty"), GetDisplayIndex(columns, "BXRate"), Color.SandyBrown);
ColumnGroupHeader csh12 = GetHeader(columns, "其他", GetDisplayIndex(columns, "CXQTQty"), GetDisplayIndex(columns, "CXQTRate"), Color.SandyBrown);
ColumnGroupHeader csh13 = GetHeader(columns, "小计", GetDisplayIndex(columns, "sumQty2"), GetDisplayIndex(columns, "sumRate2"), Color.SandyBrown);
cgh.GroupHeaders.Add(csh1);
cgh.GroupHeaders.Add(csh2);
cgh.GroupHeaders.Add(csh3);
cgh.GroupHeaders.Add(csh4);
cgh.GroupHeaders.Add(csh5);
cgh.GroupHeaders.Add(csh6);
cgh.GroupHeaders.Add(csh7);
cgh.GroupHeaders.Add(csh8);
cgh.GroupHeaders.Add(csh9);
cgh.GroupHeaders.Add(csh10);
cgh.GroupHeaders.Add(csh11);
cgh.GroupHeaders.Add(csh12);
cgh.GroupHeaders.Add(csh13);
// We want the header to also contain the 'City' column
// so we must include it in the display range.
cgh.StartDisplayIndex = GetDisplayIndex(columns, "JGBDQty");
cgh.EndDisplayIndex = GetDisplayIndex(columns, "sumRate2");
return(cgh);
}
public override void Bind(string entityName)
{
base.Bind(entityName);
GridColumnCollection columns = gridView1.Columns;
foreach (GridColumn column in columns)
{
if (column.Caption == "")
{
column.Caption = GetLocalizedCaption(column.Name);
}
}
}
public FormKolone(GridColumnCollection kolone, GridView view)
{
InitializeComponent();
foreach (GridColumn kolona in kolone)
{
kolona kol = new kolona
{
Naziv = kolona.Name,
Enabled = kolona.Visible,
};
}
gridControl1.DataSource = listakolona;
}
public void Init()
{
HttpContext.Current = new HttpContext(
new HttpRequest("", "http://tempuri.org", ""),
new HttpResponse(new StringWriter()));
var repo = new TestRepository();
var items = repo.GetAll().ToList();
_grid = new TestGrid(items);
_columns = new GridColumnCollection <TestModel>(new DefaultColumnBuilder <TestModel>(_grid, new GridAnnotaionsProvider()), _grid.Settings.SortSettings);
}
private void SetVisibleColumns_MasterMonthlyOperation(ComponentArt.Web.UI.Grid grid)
{
MonthlyOperationGridClientSettings monthlyOperationGridClientSettings = this.MonthlyOperationGridClientSettingsBusiness.GetMonthlyOperationGridClientSettings();
GridColumnCollection Gcc = grid.Levels[0].Columns;
for (int i = 1; i < Gcc.Count; i++)
{
PropertyInfo PInfo = typeof(MonthlyOperationGridClientSettings).GetProperty(Gcc[i].DataField);
if (PInfo != null)
{
Gcc[i].Visible = (bool)PInfo.GetValue(monthlyOperationGridClientSettings, null);
}
}
}
public void DisplaySelectedColumn()
{
GridColumnCollection columns = this._frmGridBuilder.GridView1.Columns;
columns.Clear();
this._frmGridBuilder.LstGridProperties.SelectedItems.ForEach(gP =>
{
string columnName = gP as string ?? string.Empty;
columns.AddVisible(columnName, columnName);
});
this.SetColumnEdits();
}
public void Init()
{
HttpContext.Current = new HttpContext(
new HttpRequest("", "http://tempuri.org", ""),
new HttpResponse(new StringWriter()));
var repo = new TestRepository();
var items = repo.GetAll().ToList();
_grid = new TestGrid(items);
_columns = new GridColumnCollection<TestModel>(new DefaultColumnBuilder<TestModel>(_grid, new GridAnnotaionsProvider()), _grid.Settings.SortSettings);
}
public frmSort(GridColumnCollection dcl)
{
this.InitializeComponent();
clsMe clsMe = new clsMe();
clsMe.setFormStyl(this);
this.BindCombox1(dcl);
this.BindCombox2(dcl);
this.BindCombox3(dcl);
this.BindCombox4(dcl);
this.comboBox1.SelectedIndex = 0;
this.comboBox2.SelectedIndex = 0;
this.comboBox3.SelectedIndex = 0;
this.comboBox4.SelectedIndex = 0;
this.fillfinishok = true;
}
// where T : class, new()
public static GridColumnCollection GetColumns(this Type obj, DevExpress.XtraGrid.Views.Base.ColumnView gridView)
{
var result = new GridColumnCollection(gridView);
var processedProperties = obj.GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance).Where(p => p.IsDefined(typeof(DisplayNameAttribute), true));
foreach (var p in processedProperties)
{
result.Add(new GridColumn()
{
FieldName = p.Name,
Name = "col" + p.Name,
Caption = (p.GetCustomAttributes(typeof(DisplayNameAttribute), true).FirstOrDefault() as DisplayNameAttribute).DisplayName,
Visible = true
});
}
logger.Info("Сформировали таблицы для " + obj.Name);
return result;
}
public frmView(GridColumnCollection dcl)
{
this.InitializeComponent();
clsMe clsMe = new clsMe();
clsMe.setFormStyl(this);
for (int i = 0; i < dcl.Count; i++)
{
if (dcl[i].Visible)
{
this.listBox2.Items.Add(dcl[i].Caption);
}
else
{
this.listBox1.Items.Add(dcl[i].Caption);
}
}
this.listBox2.SelectedIndex = this.listBox2.Items.Count - 1;
if (this.listBox1.Items.Count > 0)
{
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
}
}
public Grid()
{
this.CssClass = "ui table striped";
_columns = new GridColumnCollection(this);
}
private void BindCombox4(GridColumnCollection dcl)
{
List<frmSort.SortCol> list = new List<frmSort.SortCol>();
frmSort.SortCol item = new frmSort.SortCol
{
valueMember = "0",
textMember = "无..."
};
list.Add(item);
for (int i = 0; i < dcl.Count; i++)
{
if (dcl[i].Visible)
{
frmSort.SortCol item2 = new frmSort.SortCol
{
valueMember = dcl[i].FieldName,
textMember = dcl[i].Caption
};
list.Add(item2);
}
}
this.comboBox4.DataSource = list;
this.comboBox4.DisplayMember = "textMember";
this.comboBox4.ValueMember = "valueMember";
}
public GridPasswordTextColumn(GridColumnCollection columnCollection, string name)
: base(columnCollection, name)
{
}
public GridTextColumn(GridColumnCollection columnCollection, string name)
: base(columnCollection, name)
{
DefaultCellValue = defaultCellValueDefault;
MaxLength = MaxLengthDefault;
}
protected Grid (Generator generator, Type type, bool initialize = true)
: base (generator, type, false)
{
handler = (IGrid)Handler;
Columns = new GridColumnCollection ();
if (initialize)
Initialize ();
}
private string getFilterStr(GridColumnCollection dcl, string strval)
{
string text = "";
for (int i = 0; i < dcl.Count; i++)
{
if (dcl[i].Visible)
{
string text2 = text;
text = string.Concat(new string[]
{
text2,
dcl[i].FieldName,
" ",
strval,
" or "
});
}
}
return text;
}
internal GridFormatter(MediaConfiguration mediaConfiguration)
: base(mediaConfiguration)
{
Columns = new GridColumnCollection();
Columns.ItemsInserted += OnColumnsInserted;
}
public GridTable()
{
this.cols = new GridColumnCollection(this);
this.rows = new GridRowCollection(this);
}
/// <summary>
/// Initializes a new instance of the <see cref="Eto.Forms.Grid"/> class.
/// </summary>
/// <param name="generator">Generator to instantiate the handler with</param>
/// <param name="handler">Pre-created handler to attach to this instance</param>
/// <param name="initialize">If set to <c>true</c> initialize.</param>
protected Grid(Generator generator, IControl handler, bool initialize = true)
: base(generator, handler, false)
{
Columns = new GridColumnCollection();
if (initialize)
Initialize();
}
public GridPlainTextColumn(GridColumnCollection columnCollection, string name)
: base(columnCollection, name)
{
}
