private void FillWares()
{
WaresLogic wares = new WaresLogic(manager);
int?categoryId = null;
int?manufacturerId = null;
int?unitId = null;
//string name = wareFilterUC1.WareName;
categoryId = categoriesUC2.SelectedCategoryID;
if (categoryId < 0)
{
categoryId = null;
}
BindingSource bs = new BindingSource();
List <ViewWare> waresList = wares.GetAllView("", categoryId, manufacturerId, unitId);
view = new SortableBindingList <ViewWare>(waresList);
WaresGV.Visible = false;
WaresFLP.Visible = false;
switch (this.WaresViewMode)
{
case WaresViewModes.GridView:
{
WaresGV.AutoGenerateColumns = false;
WaresGV.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
WaresGV.DataSource = view;
WaresGV.Visible = true;
break;
}
case WaresViewModes.Button:
{
WaresFLP.Controls.Clear();
WaresFLP.Dock = DockStyle.Fill;
foreach (var ware in view)
{
this.CreateButton(ware.ID.ToString(), ware.Name.ToString() + "\n" + "1" + ware.UnitName, Helpers.ImageOperations.ByteArrayToImage(ware.Image));
}
WaresFLP.Visible = true;
break;
}
}
}
private void FillWares()
{
WaresLogic wares = new WaresLogic(manager);
int?categoryId = null;
int?manufacturerId = null;
int?unitId = null;
//string name = wareFilterUC1.WareName;
if (WareCategoriesLUE.EditValue != null)
{
categoryId = Convert.ToInt32(WareCategoriesLUE.EditValue);
}
if (UnitLUE.EditValue != null)
{
unitId = Convert.ToInt32(UnitLUE.EditValue);
}
var waresList = wares.GetAllView("", categoryId, manufacturerId, unitId);
//var waresList = wares.GetAll("", categoryId, manufacturerId, unitId).Select(a => new
//{
// a.ID,
// Name = a.Name,
// UnitName = a.WareUnit != null ? a.WareUnit.Name : "",
// ManufacturerName = a.WareManufacturer != null ? a.WareManufacturer.Name : "",
// CategoryName = a.WareCategory != null ? a.WareCategory.Name : "",
// SecondaryUnitID = a.SecondaryUnitID != null ? a.SecondaryUnitID : null,
// SecondaryUnitName = a.WareUnit1 != null ? a.WareUnit1.Name : "",
// SecondaryUnitQuantity = a.SecondaryUnitQuantity != null ? a.SecondaryUnitQuantity : null,
// a.WareCodes
//});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
List <WareView> viewList = new List <WareView>();
foreach (var a in waresList)
{
WareView wv = new WareView();
wv.ID = a.ID;
wv.Name = a.Name;
wv.CategoryName = a.WareCategoryName;
wv.ManufacturerName = a.ManufacturerName;
wv.UnitName = a.UnitName;
wv.SecondaryUnitID = a.SecondaryUnitID;
wv.SecondaryUnitName = a.SecondaryUnitName;
wv.SecondaryUnitQuantity = a.SecondaryUnitQuantity;
wv.WareCode = a.WareCode == null ? "": a.WareCode;
//wv.WareCodes = a.WareCodes.ToList();
viewList.Add(wv);
}
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
view = new SortableBindingList <WareView>(viewList);
WaresLUE.Properties.DataSource = view;
WaresLUE.Properties.ValueMember = "ID";
WaresLUE.Properties.DisplayMember = "Name";
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("WareCode", 0, "Код"));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Name", 0, "Назва"));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ManufacturerName", 0, "Виробник"));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("UnitName", 0, "Осн. од. вим."));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("SecondUnitName", 0, "втор. од. вим."));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("CategoryName", 0, "Категорія"));
}
private void FillWares()
{
WaresLogic wares = new WaresLogic(manager);
int? categoryId = null;
int? manufacturerId = null;
int? unitId = null;
//string name = wareFilterUC1.WareName;
if( WareCategoriesLUE.EditValue != null)
categoryId =Convert.ToInt32(WareCategoriesLUE.EditValue);
if(UnitLUE.EditValue != null)
unitId =Convert.ToInt32(UnitLUE.EditValue);
var waresList = wares.GetAllView("", categoryId, manufacturerId, unitId);
//var waresList = wares.GetAll("", categoryId, manufacturerId, unitId).Select(a => new
//{
// a.ID,
// Name = a.Name,
// UnitName = a.WareUnit != null ? a.WareUnit.Name : "",
// ManufacturerName = a.WareManufacturer != null ? a.WareManufacturer.Name : "",
// CategoryName = a.WareCategory != null ? a.WareCategory.Name : "",
// SecondaryUnitID = a.SecondaryUnitID != null ? a.SecondaryUnitID : null,
// SecondaryUnitName = a.WareUnit1 != null ? a.WareUnit1.Name : "",
// SecondaryUnitQuantity = a.SecondaryUnitQuantity != null ? a.SecondaryUnitQuantity : null,
// a.WareCodes
//});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
List<WareView> viewList = new List<WareView>();
foreach (var a in waresList)
{
WareView wv = new WareView();
wv.ID = a.ID;
wv.Name = a.Name;
wv.CategoryName = a.WareCategoryName;
wv.ManufacturerName = a.ManufacturerName;
wv.UnitName = a.UnitName;
wv.SecondaryUnitID = a.SecondaryUnitID;
wv.SecondaryUnitName = a.SecondaryUnitName;
wv.SecondaryUnitQuantity = a.SecondaryUnitQuantity;
wv.WareCode = a.WareCode == null ? "": a.WareCode;
//wv.WareCodes = a.WareCodes.ToList();
viewList.Add(wv);
}
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
view = new SortableBindingList<WareView>(viewList);
WaresLUE.Properties.DataSource = view;
WaresLUE.Properties.ValueMember = "ID";
WaresLUE.Properties.DisplayMember = "Name";
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("WareCode", 0, "Код"));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Name", 0, "Назва"));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ManufacturerName", 0, "Виробник"));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("UnitName", 0, "Осн. од. вим."));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("SecondUnitName", 0, "втор. од. вим."));
WaresLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("CategoryName", 0, "Категорія"));
}
private void Fill(string columnName)
{
DateTime start = DateTime.Now;
WaresLogic wares = new WaresLogic(manager);
DataGV.AutoGenerateColumns = false;
int?categoryId = null;
int?manufacturerId = null;
int?unitId = null;
//string name = wareFilterUC1.WareName;
if (categoriesFilterUC1.SelectedCategoryID >= 0)
{
categoryId = categoriesFilterUC1.SelectedCategoryID;
}
//manufacturerId = wareFilterUC1.ManufacturerID;
//unitId = wareFilterUC1.UnitID;
BindingSource bs = new BindingSource();
var waresList = wares.GetAllView("", categoryId, manufacturerId, unitId);
// .Select(a => new
//{
// a.ID,
// Name = a.Name,
// UnitName = a.WareUnit != null ? a.WareUnit.Name : "",
// ManufacturerName = a.WareManufacturer != null ? a.WareManufacturer.Name : "",
// CategoryName = a.WareCategory != null ? a.WareCategory.Name : "",
// CategoryID = a.CategoryID,
// SecondaryUnitID = a.SecondaryUnitID != null ? a.SecondaryUnitID : null,
// SecondaryUnitName = a.WareUnit1 != null ? a.WareUnit1.Name : "",
// SecondaryUnitQuantity = a.SecondaryUnitQuantity != null ? a.SecondaryUnitQuantity : null,
// a.WareCodes,
// a.WareTimeLimits
//});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
//List<WareView> viewList = new List<WareView>();
DateTime start0 = DateTime.Now;
//foreach (var a in waresList)
//{
// WareView wv = new WareView();
// wv.ID = a.ID;
// wv.CategoryID = a.CategoryID;
// wv.Name = a.Name;
// wv.CategoryName = a.CategoryName;
// wv.ManufacturerName = a.ManufacturerName;
// wv.UnitName = a.UnitName;
// wv.SecondaryUnitID = a.SecondaryUnitID;
// wv.SecondaryUnitName = a.SecondaryUnitName;
// wv.SecondaryUnitQuantity = a.SecondaryUnitQuantity;
// //wv.WareCodes = a.WareCodes.ToList();
// //var lastTimeLimit = (from aa in a.WareTimeLimits
// // where aa.Active == true
// // select aa).FirstOrDefault();
// //if (lastTimeLimit != null)
// // wv.TimeLimit = lastTimeLimit.TimeLimit;
// //else
// // wv.TimeLimit = 0;
// viewList.Add(wv);
//}
DateTime start1 = DateTime.Now;
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
view = new SortableBindingList <ViewWare>(waresList);
ListToDataTable listToDataTable = new ListToDataTable();
DataGV.DataSource = listToDataTable.ToDataTable <ViewWare>(waresList);
//DataGV.DataSource = view;
DataGV.Update();
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
DateTime start2 = DateTime.Now;
//MessageBox.Show(start.ToString() + " " + start0.ToString() + " " + start1.ToString() + " " + start2.ToString());
}
private void Fill(string columnName)
{
DateTime start = DateTime.Now;
WaresLogic wares = new WaresLogic(manager);
DataGV.AutoGenerateColumns = false;
int? categoryId = null;
int? manufacturerId = null;
int? unitId = null;
//string name = wareFilterUC1.WareName;
if(categoriesFilterUC1.SelectedCategoryID >= 0)
categoryId = categoriesFilterUC1.SelectedCategoryID;
//manufacturerId = wareFilterUC1.ManufacturerID;
//unitId = wareFilterUC1.UnitID;
BindingSource bs = new BindingSource();
var waresList = wares.GetAllView("", categoryId, manufacturerId, unitId);
// .Select(a => new
//{
// a.ID,
// Name = a.Name,
// UnitName = a.WareUnit != null ? a.WareUnit.Name : "",
// ManufacturerName = a.WareManufacturer != null ? a.WareManufacturer.Name : "",
// CategoryName = a.WareCategory != null ? a.WareCategory.Name : "",
// CategoryID = a.CategoryID,
// SecondaryUnitID = a.SecondaryUnitID != null ? a.SecondaryUnitID : null,
// SecondaryUnitName = a.WareUnit1 != null ? a.WareUnit1.Name : "",
// SecondaryUnitQuantity = a.SecondaryUnitQuantity != null ? a.SecondaryUnitQuantity : null,
// a.WareCodes,
// a.WareTimeLimits
//});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
//List<WareView> viewList = new List<WareView>();
DateTime start0 = DateTime.Now;
//foreach (var a in waresList)
//{
// WareView wv = new WareView();
// wv.ID = a.ID;
// wv.CategoryID = a.CategoryID;
// wv.Name = a.Name;
// wv.CategoryName = a.CategoryName;
// wv.ManufacturerName = a.ManufacturerName;
// wv.UnitName = a.UnitName;
// wv.SecondaryUnitID = a.SecondaryUnitID;
// wv.SecondaryUnitName = a.SecondaryUnitName;
// wv.SecondaryUnitQuantity = a.SecondaryUnitQuantity;
// //wv.WareCodes = a.WareCodes.ToList();
// //var lastTimeLimit = (from aa in a.WareTimeLimits
// // where aa.Active == true
// // select aa).FirstOrDefault();
// //if (lastTimeLimit != null)
// // wv.TimeLimit = lastTimeLimit.TimeLimit;
// //else
// // wv.TimeLimit = 0;
// viewList.Add(wv);
//}
DateTime start1 = DateTime.Now;
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
view = new SortableBindingList<ViewWare>(waresList);
ListToDataTable listToDataTable = new ListToDataTable();
DataGV.DataSource = listToDataTable.ToDataTable<ViewWare>(waresList);
//DataGV.DataSource = view;
DataGV.Update();
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
DateTime start2 = DateTime.Now;
//MessageBox.Show(start.ToString() + " " + start0.ToString() + " " + start1.ToString() + " " + start2.ToString());
}
