private void FillWares() { WaresLogic wares = new WaresLogic(manager); int?categoryId = null; int?manufacturerId = null; int?unitId = null; //string name = wareFilterUC1.WareName; categoryId = wareFilterUC1.CategoryID; manufacturerId = wareFilterUC1.ManufacturerID; unitId = wareFilterUC1.UnitID; BindingSource bs = new BindingSource(); var waresList = mode == "new" ? 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 }) : wares.GetAllByWareID(DocumentDetail.WareID).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.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(); viewList.Add(wv); } //BindingListView<WareView> view = new BindingListView<WareView>(viewList); //bs.DataSource = view; //bs.Sort = columnName; view = new SortableBindingList <WareView>(viewList); WareLUE.Properties.DataSource = view; WareLUE.Properties.ValueMember = "ID"; WareLUE.Properties.DisplayMember = "Name"; WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("WareCodesString", 0, "Код")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Name", 0, "Назва")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ManufacturerName", 0, "Виробник")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("UnitName", 0, "Осн. од. вим.")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("SecondUnitName", 0, "втор. од. вим.")); WareLUE.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; categoryId = wareFilterUC1.CategoryID; manufacturerId = wareFilterUC1.ManufacturerID; unitId = wareFilterUC1.UnitID; BindingSource bs = new BindingSource(); var waresList = mode == "new" ? 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 }) : wares.GetAllByWareID(DocumentDetail.WareID).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.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(); viewList.Add(wv); } //BindingListView<WareView> view = new BindingListView<WareView>(viewList); //bs.DataSource = view; //bs.Sort = columnName; view = new SortableBindingList<WareView>(viewList); WareLUE.Properties.DataSource = view; WareLUE.Properties.ValueMember = "ID"; WareLUE.Properties.DisplayMember = "Name"; WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("WareCodesString", 0, "Код")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Name", 0, "Назва")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ManufacturerName", 0, "Виробник")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("UnitName", 0, "Осн. од. вим.")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("SecondUnitName", 0, "втор. од. вим.")); WareLUE.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("CategoryName", 0, "Категорія")); }