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 = 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
});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
if (wareId != null)
{
waresList = waresList.Where(a => a.ID == wareId);
}
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;
viewList.Add(wv);
}
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
view = new SortableBindingList <WareView>(viewList);
WareCB.DataSource = view;
WareCB.ValueMember = "ID";
WareCB.DisplayMember = "Name";
}
private void FillFilteredWares(string columnName)
{
WaresLogic wares = new WaresLogic(manager);
int?categoryId = null;
int?manufacturerId = null;
int?unitId = null;
//string name = wareFilterUC1.WareName;
if (categoriesUC1.SelectedCategoryID >= 0)
{
categoryId = categoriesUC1.SelectedCategoryID;
}
//manufacturerId = wareFilterUC1.ManufacturerID;
//unitId = wareFilterUC1.UnitID;
BindingSource bs = new BindingSource();
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.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;
}
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 = 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
});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
if (wareId != null)
{
waresList = waresList.Where(a => a.ID == wareId);
}
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;
viewList.Add(wv);
}
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
view = new SortableBindingList<WareView>(viewList);
WareCB.DataSource = view;
WareCB.ValueMember = "ID";
WareCB.DisplayMember = "Name";
}
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;
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 FillFilteredWares(string columnName)
{
WaresLogic wares = new WaresLogic(manager);
int? categoryId = null;
int? manufacturerId = null;
int? unitId = null;
//string name = wareFilterUC1.WareName;
if(categoriesUC1.SelectedCategoryID >= 0)
categoryId = categoriesUC1.SelectedCategoryID;
//manufacturerId = wareFilterUC1.ManufacturerID;
//unitId = wareFilterUC1.UnitID;
BindingSource bs = new BindingSource();
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.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;
}
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, "Категорія"));
}
