public void departmentStockInSearchView_SearchMainStockInEvent(object sender, MainStockInSearchEventArgs e)
{
var criteria = new ObjectCriteria();
criteria.AddGreaterOrEqualsCriteria("StockInDate", e.StockInDateFrom);
criteria.AddLesserOrEqualsCriteria("StockInDate", e.StockInDateTo);
criteria.AddLikeCriteria("StockInId", e.StockInId + "%");
criteria.AddEqCriteria("DelFlg", (long)0);
e.StockInList = StockInLogic.FindAll(criteria);
}
public void departmentStockInSearchView_SearchDepartmentStockInEvent(object sender, DepartmentStockInSearchEventArgs e)
{
var criteria = new ObjectCriteria();
criteria.AddEqCriteria("DepartmentStockInPK.DepartmentId", CurrentDepartment.Get().DepartmentId);
criteria.AddGreaterOrEqualsCriteria("StockInDate", e.StockInDateFrom);
criteria.AddLesserOrEqualsCriteria("StockInDate", e.StockInDateTo);
criteria.AddLikeCriteria("DepartmentStockInPK.StockInId", e.StockInId + "%");
criteria.AddEqCriteria("DelFlg", (long)0);
e.DepartmeneStockInList = DepartmentStockInLogic.FindAll(criteria);
EventUtility.fireEvent(CompletedSearchDepartmentStockInEvent,this,e);
}
public void departmentStockDetailView_SearchDepartmentStockInDetailEvent(object sender, DepartmentStockDetailEventArgs e)
{
long deptId = CurrentDepartment.Get().DepartmentId;
var objectCriteria = new ObjectCriteria(true);
objectCriteria.AddEqCriteria("s.DelFlg", CommonConstants.DEL_FLG_NO);
objectCriteria.AddEqCriteria("pm.ProductMasterId", e.ProductMasterId);
objectCriteria.AddEqCriteria("s.DepartmentStockInDetailPK.DepartmentId", deptId);
objectCriteria.AddGreaterOrEqualsCriteria("deptStockIn.StockInDate", e.StockInDateFrom);
objectCriteria.AddLesserOrEqualsCriteria("deptStockIn.StockInDate", e.StockInDateTo);
e.DepartmentStockInDetailList = DepartmentStockInDetailLogic.FindByQuery(objectCriteria);
e.ProductPrice = DepartmentPriceLogic.FindById(new DepartmentPricePK { ProductMasterId = e.ProductMasterId, DepartmentId = deptId });
}
private void posLogView_SearchPosLogEvent(object sender, PosLogEventArgs e)
{
var criteria = new ObjectCriteria();
if(!string.IsNullOrEmpty(e.Username))
{
criteria.AddLikeCriteria("PosUser", e.Username + "%");
}
if(!string.IsNullOrEmpty(e.Action))
{
criteria.AddLikeCriteria("PosAction", e.Action + "%");
}
criteria.AddGreaterOrEqualsCriteria("Date", DateUtility.ZeroTime(e.LogDateFrom));
criteria.AddLesserOrEqualsCriteria("Date", DateUtility.MaxTime(e.LogDateTo));
criteria.AddOrder("Date", false);
IList list = PosLogLogic.FindAll(criteria);
e.PosLogList = list;
}
public void goodsIOSearchView_DeleteBlockInDetailEvent(object sender, GoodsIOSearchEventArgs e)
{
// validate delete items
// delete
BlockInDetailLogic.DeleteList(e.DeleteList);
// search again
var criteria = new ObjectCriteria();
if (!string.IsNullOrEmpty(e.BlockDetailId))
{
criteria.AddLikeCriteria("BlockInDetailPK.BlockDetailId", string.Format("{0}%", e.BlockDetailId));
}
criteria.AddGreaterOrEqualsCriteria("ImportDate", DateUtility.ZeroTime(e.ImportDateFrom));
criteria.AddLesserOrEqualsCriteria("ImportDate", DateUtility.MaxTime(e.ImportDateTo));
if (!e.IsNeedDelete)
{
criteria.AddEqCriteria("DelFlg", (Int64)0);
}
e.BlockDetailList = BlockInDetailLogic.FindAll(criteria);
}
private void stockSearchView_BarcodeSearchStockEvent(object sender, StockSearchEventArgs e)
{
var subCriteria = new SubObjectCriteria("ProductMaster");
subCriteria.AddLikeCriteria("ProductName", "%" + e.ProductMasterName + "%");
subCriteria.AddEqCriteria("ProductType", e.ProductType);
subCriteria.AddEqCriteria("ProductSize", e.ProductSize);
subCriteria.AddEqCriteria("ProductColor", e.ProductColor);
subCriteria.AddEqCriteria("Country", e.Country);
subCriteria.AddEqCriteria("Manufacturer", e.Manufacturer);
subCriteria.AddEqCriteria("Packager", e.Packager);
subCriteria.AddEqCriteria("Distributor", e.Distributor);
var criteria = new ObjectCriteria(true);
criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
criteria.AddLikeCriteria("Product.ProductId", e.ProductMasterId + "%");
criteria.AddSubCriteria("ProductMaster", subCriteria);
criteria.AddGreaterOrEqualsCriteria("CreateDate", DateUtility.ZeroTime(e.FromDate));
criteria.AddLesserOrEqualsCriteria("CreateDate", DateUtility.MaxTime(e.ToDate));
IList list = StockLogic.FindAll(criteria);
e.StockList = list;
}
public void stockSearchView_RemainSearchStockEvent(object sender, StockSearchEventArgs e)
{
var criteria = new ObjectCriteria();
criteria.AddEqCriteria("DelFlg", (long)0);
criteria.AddLesserOrEqualsCriteria("CreateDate", e.FromDate);
IList deptStockInDetailFromList = DepartmentStockInDetailLogic.FindAll(criteria);
criteria.AddNotEqualsCriteria("StockInType", (long)1);
IList stockInDetailFromList = StockInDetailLogic.FindAll(criteria);
criteria = new ObjectCriteria();
criteria.AddEqCriteria("DelFlg", (long)0);
criteria.AddLesserOrEqualsCriteria("CreateDate", e.ToDate);
IList deptStockInDetailToList = DepartmentStockInDetailLogic.FindAll(criteria);
criteria.AddNotEqualsCriteria("StockInType", (long)1);
IList stockInDetailToList = StockInDetailLogic.FindAll(criteria);
// IList stockHistoryList = StockHistoryLogic.FindByMaxDate(criteria);
var reportList = new List<UniversalStockReportObject>();
// calculate dau` ton`
foreach (StockInDetail stockInDetail in stockInDetailFromList)
{
UniversalStockReportObject report = null;
foreach (var reportObject in reportList)
{
if (stockInDetail.Product.ProductMaster.ProductMasterId.Equals(reportObject.ProductMaster.ProductMasterId))
{
report = reportObject;
break;
}
}
if (report != null)
{
report.StockStartQuantity += stockInDetail.Quantity;
report.StockInStartQuantity += stockInDetail.Quantity;
}
else
{
report = new UniversalStockReportObject();
reportList.Add(report);
report.StockStartQuantity = stockInDetail.Quantity;
report.StockInStartQuantity = stockInDetail.Quantity;
}
report.ProductMaster = stockInDetail.Product.ProductMaster;
foreach (DepartmentStockInDetail deptStockInDetail in deptStockInDetailFromList)
{
if (report.ProductMaster.ProductMasterId.Equals(deptStockInDetail.Product.ProductMaster.ProductMasterId))
{
report.StockStartQuantity -= deptStockInDetail.Quantity;
report.DepartmentStockInStartQuantity += deptStockInDetail.Quantity;
}
}
reportList.Add(report);
}
// calculate cuoi ton
foreach (StockInDetail stockInDetail in stockInDetailToList)
{
UniversalStockReportObject report = null;
foreach (var reportObject in reportList)
{
if (stockInDetail.Product.ProductMaster.ProductMasterId.Equals(reportObject.ProductMaster.ProductMasterId))
{
report = reportObject;
break;
}
}
if (report != null)
{
report.StockEndQuantity += stockInDetail.Quantity;
report.StockInEndQuantity += stockInDetail.Quantity;
}
else
{
report = new UniversalStockReportObject();
report.ProductMaster = stockInDetail.Product.ProductMaster;
reportList.Add(report);
report.StockEndQuantity = stockInDetail.Quantity;
report.StockInEndQuantity = stockInDetail.Quantity;
}
foreach (DepartmentStockInDetail deptStockInDetail in deptStockInDetailToList)
{
if (report.ProductMaster.ProductMasterId.Equals(deptStockInDetail.Product.ProductMaster.ProductMasterId))
{
report.StockEndQuantity -= deptStockInDetail.Quantity;
report.DepartmentStockInEndQuantity += deptStockInDetail.Quantity;
}
}
// foreach (StockHistory stockHistory in stockHistoryList)
// {
// if (report.ProductMaster.ProductMasterId.Equals(stockHistory.Product.ProductMaster.ProductMasterId))
// {
// report.LostCount += stockHistory.LostCount;
// report.GoodCount += stockHistory.GoodCount;
// report.ErrorCount += stockHistory.ErrorCount;
// report.DamageCount += stockHistory.DamageCount;
// }
// }
}
e.ReportList = reportList;
}
