public void stockSearchView_SearchStockEvent(object sender, DepartmentStockSearchEventArgs e)
{
var objectCriteria = new ObjectCriteria(true);
objectCriteria.AddEqCriteria("s.DelFlg", (long)0);
objectCriteria.AddEqCriteria("sdetail.DelFlg", (long)0);
objectCriteria.AddLikeCriteria("pm.ProductMasterId", e.ProductMasterId + "%");
objectCriteria.AddLikeCriteria("pm.ProductName", e.ProductMasterName + "%");
objectCriteria.AddEqCriteria("pm.ProductType", e.ProductType);
objectCriteria.AddEqCriteria("pm.ProductSize", e.ProductSize);
objectCriteria.AddEqCriteria("pm.ProductColor", e.ProductColor);
objectCriteria.AddEqCriteria("pm.Manufacturer", e.Manufacturer);
objectCriteria.AddEqCriteria("pm.Country", e.Country);
objectCriteria.AddEqCriteria("s.DepartmentStockPK.DepartmentId", CurrentDepartment.Get().DepartmentId);
e.DepartmentStockList = DepartmentStockLogic.FindByQuery(objectCriteria);
}
public void stockSearchView_InitStockSearchEvent(object sender, DepartmentStockSearchEventArgs e)
{
var criteria = new ObjectCriteria();
criteria.AddEqCriteria("DelFlg", (long)0);
e.ProductTypeList = ProductTypeLogic.FindAll(criteria);
e.ProductTypeList.Insert(0, new ProductType());
e.ProductSizeList = ProductSizeLogic.FindAll(criteria);
e.ProductSizeList.Insert(0, new ProductSize());
e.ProductColorList = ProductColorLogic.FindAll(criteria);
e.ProductColorList.Insert(0, new ProductColor());
e.ManufacturerList = ManufacturerLogic.FindAll(criteria);
e.ManufacturerList.Insert(0, new Manufacturer());
e.CountryList = CountryLogic.FindAll(criteria);
e.CountryList.Insert(0, new Country());
}
private void DepartmentStockSearchForm_Load(object sender, EventArgs e)
{
var eventArgs = new DepartmentStockSearchEventArgs();
EventUtility.fireEvent(InitDepartmentStockSearchEvent, this, eventArgs);
productMasterSearchControl.cbbProductType.DataSource = eventArgs.ProductTypeList;
productMasterSearchControl.cbbProductType.DisplayMember = "TypeName";
productMasterSearchControl.cbbProductSize.DataSource = eventArgs.ProductSizeList;
productMasterSearchControl.cbbProductSize.DisplayMember = "SizeName";
productMasterSearchControl.cbbProductColor.DataSource = eventArgs.ProductColorList;
productMasterSearchControl.cbbProductColor.DisplayMember = "ColorName";
productMasterSearchControl.cbbCountry.DataSource = eventArgs.CountryList;
productMasterSearchControl.cbbCountry.DisplayMember = "CountryName";
}
private void btnSearch_Click(object sender, EventArgs e)
{
var eventArgs = new DepartmentStockSearchEventArgs
{
ProductMasterId = productMasterSearchControl.txtProductMasterId.Text,
ProductMasterName = productMasterSearchControl.txtProductName.Text,
ProductSize = productMasterSearchControl.cbbProductSize.SelectedIndex > 0 ? ((ProductSize)productMasterSearchControl.cbbProductSize.SelectedItem) : null,
ProductType = productMasterSearchControl.cbbProductType.SelectedIndex > 0 ? ((ProductType)productMasterSearchControl.cbbProductType.SelectedItem) : null,
ProductColor = productMasterSearchControl.cbbProductColor.SelectedIndex > 0 ?
((ProductColor)productMasterSearchControl.cbbProductColor.SelectedItem) : null,
Country = productMasterSearchControl.cbbCountry.SelectedIndex > 0 ? ((Country)productMasterSearchControl.cbbCountry.SelectedItem) : null,
Manufacturer = productMasterSearchControl.cbbManufacturer.SelectedIndex > 0 ? ((Manufacturer)productMasterSearchControl.cbbManufacturer.SelectedItem) : null,
Distributor = productMasterSearchControl.cbbDistributor.SelectedIndex > 0 ? ((Distributor)productMasterSearchControl.cbbDistributor.SelectedItem) : null,
Packager = productMasterSearchControl.cbbPackager.SelectedIndex > 0 ? ((Packager)productMasterSearchControl.cbbPackager.SelectedItem) : null
};
EventUtility.fireEvent(SearchDepartmentStockEvent, this, eventArgs);
DepartmentStockSearchResultList = eventArgs.DepartmentStockList;
PopulateDataGrid();
}
private void DepartmentStockSearchForm_Load(object sender, EventArgs e)
{
stockViewList = new DepartmentStockViewCollection(bdsStockView);
bdsStockView.ResetBindings(true);
stockList = new DepartmentStockCollection(bdsStock);
bdsStock.ResetBindings(true);
var eventArgs = new DepartmentStockSearchEventArgs();
EventUtility.fireEvent(InitDepartmentStockSearchEvent, this, eventArgs);
productMasterSearchControl.cbbProductType.DataSource = eventArgs.ProductTypeList;
productMasterSearchControl.cbbProductType.DisplayMember = "TypeName";
productMasterSearchControl.cbbProductSize.DataSource = eventArgs.ProductSizeList;
productMasterSearchControl.cbbProductSize.DisplayMember = "SizeName";
productMasterSearchControl.cbbProductColor.DataSource = eventArgs.ProductColorList;
productMasterSearchControl.cbbProductColor.DisplayMember = "ColorName";
productMasterSearchControl.cbbCountry.DataSource = eventArgs.CountryList;
productMasterSearchControl.cbbCountry.DisplayMember = "CountryName";
}
private void btnSearch_Click(object sender, EventArgs e)
{
var eventArgs = new DepartmentStockSearchEventArgs
{
ProductMasterId = productMasterSearchControl.txtProductMasterId.Text,
ProductMasterName = productMasterSearchControl.txtProductName.Text,
ProductSize = productMasterSearchControl.cbbProductSize.SelectedIndex > 0 ? ((ProductSize)productMasterSearchControl.cbbProductSize.SelectedItem) : null,
ProductType = productMasterSearchControl.cbbProductType.SelectedIndex > 0 ? ((ProductType)productMasterSearchControl.cbbProductType.SelectedItem) : null,
ProductColor = productMasterSearchControl.cbbProductColor.SelectedIndex > 0 ?
((ProductColor)productMasterSearchControl.cbbProductColor.SelectedItem) : null,
Country = productMasterSearchControl.cbbCountry.SelectedIndex > 0 ? ((Country)productMasterSearchControl.cbbCountry.SelectedItem) : null,
Manufacturer = productMasterSearchControl.cbbManufacturer.SelectedIndex > 0 ? ((Manufacturer)productMasterSearchControl.cbbManufacturer.SelectedItem) : null,
Distributor = productMasterSearchControl.cbbDistributor.SelectedIndex > 0 ? ((Distributor)productMasterSearchControl.cbbDistributor.SelectedItem) : null,
Packager = productMasterSearchControl.cbbPackager.SelectedIndex > 0 ? ((Packager)productMasterSearchControl.cbbPackager.SelectedItem) : null
};
EventUtility.fireEvent(SearchDepartmentStockEvent, this, eventArgs);
DepartmentStockSearchResultList = eventArgs.DepartmentStockList;
if(DepartmentStockSearchResultList!= null && DepartmentStockSearchResultList.Count > 0)
{
stockViewList.Clear();
foreach (DepartmentStockView departmentStockView in DepartmentStockSearchResultList)
{
stockViewList.Add(departmentStockView);
}
bdsStockView.ResetBindings(false);
dgvStockView.Refresh();
dgvStockView.Invalidate();
}
}
public void stockSearchView_SearchStockEvent(object sender, DepartmentStockSearchEventArgs e)
{
var criteria = new SubObjectCriteria("ProductMaster");
if (!string.IsNullOrEmpty(e.ProductMasterId))
{
criteria.AddLikeCriteria("ProductMasterId", "%" + e.ProductMasterId + "%");
}
criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
criteria.AddLikeCriteria("ProductName", "%" +e.ProductMasterName + "%");
if (e.ProductType != null && e.ProductType.TypeId > 0)
{
criteria.AddEqCriteria("ProductType.TypeId", e.ProductType.TypeId);
}
if (e.ProductSize != null && e.ProductSize.SizeId > 0)
{
criteria.AddEqCriteria("ProductSize.SizeId", e.ProductSize.SizeId);
}
if (e.ProductColor != null && e.ProductColor.ColorId > 0)
{
criteria.AddEqCriteria("ProductColor.ColorId", e.ProductColor.ColorId);
}
if (e.Country != null && e.Country.CountryId > 0)
{
criteria.AddEqCriteria("Country.CountryId", e.Country.CountryId);
}
if (!string.IsNullOrEmpty(e.Description))
{
criteria.AddLikeCriteria("Description", "%" + e.Description +"%");
}
criteria.AddOrder("ProductName",true);
var objectCriteria = new ObjectCriteria(true);
objectCriteria.AddEqCriteria("DelFlg", (long)0);
if (!string.IsNullOrEmpty(e.ProductId))
{
objectCriteria.AddLikeCriteria("DepartmentStockPK.ProductId", "%" + e.ProductMasterId + "%");
}
objectCriteria.AddEqCriteria("DepartmentStockPK.DepartmentId", CurrentDepartment.Get().DepartmentId);
objectCriteria.AddSubCriteria("ProductMaster",criteria);
IList departmentStocks = DepartmentStockLogic.FindAll(objectCriteria);
IList stockViewList = new ArrayList();
// create stock view
if (departmentStocks != null && departmentStocks.Count > 0)
{
DepartmentStockView stockView = null;
foreach (DepartmentStock departmentStock in departmentStocks)
{
if (stockView!=null)
{
if(!stockView.ProductMaster.ProductName.Equals(
departmentStock.Product.ProductMaster.ProductName))
{
stockViewList.Add(stockView);
stockView = null;
}
}
if(stockView == null)
{
stockView = new DepartmentStockView();
stockView.ProductMaster = departmentStock.Product.ProductMaster;
stockView.DepartmentStocks = new ArrayList();
}
stockView.DepartmentStocks.Add(departmentStock);
stockView.Quantity += departmentStock.Quantity;
stockView.GoodQuantity += departmentStock.GoodQuantity;
}
// add last item
if(stockView!=null)
{
stockViewList.Add(stockView);
stockView = null;
}
e.DepartmentStockList = stockViewList;
}
}
