public List<Customer> getCusByMultiFilter(CusSearchTerm filter)
{
List<Customer> cusList;
UtilService utilService = new UtilService();
Hashtable hashTable = new Hashtable();
if (!(filter.CustomerName == null || filter.CustomerName.Equals("")))
{
hashTable.Add("@CusName", utilService.buildWildSearchFilter(filter.CustomerName));
}
if (!(filter.CompanyName == null || filter.CompanyName.Equals("")))
{
hashTable.Add("@CusCompName", utilService.buildWildSearchFilter(filter.CompanyName));
}
if (!(filter.TelNum == null || filter.TelNum.Equals("")))
{
hashTable.Add("@TelNum", utilService.buildWildSearchFilter(filter.TelNum));
}
if (!(filter.CusTypeID == null || filter.CusTypeID.Equals("")))
{
hashTable.Add("@CusTypeID", filter.CusTypeID);
}
try
{
cusList = cusDAO.searchCusByMultiFilter(hashTable);
}
catch (Exception ex)
{
cusList = null;
}
return cusList;
}
public static Hashtable EmpMultiFilterToHashTable(EmpSearchTerm filter)
{
UtilService utilService = new UtilService();
Hashtable hashTable = new Hashtable();
if (!(filter.EmpName == null || filter.EmpName.Equals("")))
{
hashTable.Add("@EmpName", utilService.buildWildSearchFilter(filter.EmpName));
}
if (!(filter.IdCard == null || filter.IdCard.Equals("")))
{
hashTable.Add("@IdCard", utilService.buildWildSearchFilter(filter.IdCard));
}
if (!(filter.MultiEmpTypeId == null || filter.MultiEmpTypeId.Equals("")))
{
hashTable.Add("@EmpTypeID", filter.MultiEmpTypeId);
}
if (!(filter.MultiDeptId == null || filter.MultiDeptId.Equals("")))
{
hashTable.Add("@DeptID", filter.MultiDeptId);
}
if (!(filter.MultiStatusKBN == null || filter.MultiStatusKBN.Equals("")))
{
hashTable.Add("@StatusKBN", filter.MultiStatusKBN);
}
if (filter.EntryTimeStart != DateTime.MinValue)
{
hashTable.Add("@EntryTimeStart", filter.EntryTimeStart);
}
if (filter.EntryTimeEnd != DateTime.MinValue)
{
hashTable.Add("@EntryTimeEnd", filter.EntryTimeEnd);
}
if (filter.LeaveTimeStart != DateTime.MinValue)
{
hashTable.Add("@LeaveTimeStart", filter.LeaveTimeStart);
}
if (filter.LeaveTimeEnd != DateTime.MinValue)
{
hashTable.Add("@LeaveTimeEnd", filter.LeaveTimeEnd);
}
return hashTable;
}
public List<SaleParent> SOGetParentByMultiFilter(SOSearchTerm filter)
{
List<SaleParent> saleParentList;
UtilService utilService = new UtilService();
Hashtable hashTable = new Hashtable();
//orderid
if (!(filter.OrderId == null || filter.OrderId.Equals("")))
{
hashTable.Add("@SaleOrderID", filter.OrderId);
}
//customer
if (!(filter.CustomerID == null || filter.CustomerID.Equals("")))
{
hashTable.Add("@CustomerID", filter.CustomerID);
}
if (!(filter.CustomerName == null || filter.CustomerName.Equals("")))
{
hashTable.Add("@CustomerName", utilService.buildWildSearchFilter(filter.CustomerName));
}
//saleman
if (!(filter.SaleEmpID == null || filter.SaleEmpID.Equals("")))
{
hashTable.Add("@SaleEmpID", filter.SaleEmpID);
}
if (!(filter.SaleEmpName == null || filter.SaleEmpName.Equals("")))
{
hashTable.Add("@SaleEmpName", utilService.buildWildSearchFilter(filter.SaleEmpName));
}
//commodity
if (!(filter.ComdID == null || filter.ComdID.Equals("")))
{
hashTable.Add("@ComdID", filter.ComdID);
}
if (!(filter.ComdName == null || filter.ComdName.Equals("")))
{
hashTable.Add("@ComdName", utilService.buildWildSearchFilter(filter.ComdName));
}
//SaleDate
if (filter.SaleDateStart != DateTime.MinValue)
{
hashTable.Add("@SaleDateStart", filter.SaleDateStart.ToString("yyyy-MM-dd"));
}
if (filter.SaleDateEnd != DateTime.MinValue)
{
hashTable.Add("@SaleDateEnd", filter.SaleDateEnd.ToString("yyyy-MM-dd"));
}
//KBN AND FLG
if (filter.StatusKBN >= 0)
{
hashTable.Add("@StatusKBN", filter.StatusKBN);
}
if (filter.DeliveryFLG == 0)
{
hashTable.Add("@DeliveryFLG", false);
}
else if (filter.DeliveryFLG == 1)
{
hashTable.Add("@DeliveryFLG", true);
}
if (filter.PaymentFLG == 0)
{
hashTable.Add("@PaymentFLG", false);
}
else if (filter.PaymentFLG == 1)
{
hashTable.Add("@PaymentFLG", true);
}
try
{
saleParentList = comdDAO.SearchSaleParentByMultiFilter(hashTable);
}
catch (Exception ex)
{
throw;
}
return saleParentList;
}
public List<PurchaseParent> POGetParentByMultiFilter(POSearchTerm filter)
{
List<PurchaseParent> purchaseParentList;
UtilService utilService = new UtilService();
Hashtable hashTable = new Hashtable();
if (!(filter.Supplier == null || filter.Supplier.Equals("")))
{
hashTable.Add("@SupplierID", utilService.buildWildSearchFilter(filter.Supplier));
}
if (!(filter.PurchaseEmpName == null || filter.PurchaseEmpName.Equals("")))
{
hashTable.Add("@EmpName", utilService.buildWildSearchFilter(filter.PurchaseEmpName));
}
if (filter.PurchaseDateStart != DateTime.MinValue)
{
hashTable.Add("@PurchaseDateStart", filter.PurchaseDateStart.ToString("yyyy-MM-dd"));
}
if (filter.PurchaseDateEnd != DateTime.MinValue)
{
hashTable.Add("@PurchaseDateEnd", filter.PurchaseDateEnd.ToString("yyyy-MM-dd"));
}
if (!(filter.ComdName == null || filter.ComdName.Equals("")))
{
hashTable.Add("@ComdName", utilService.buildWildSearchFilter(filter.ComdName));
}
if (!(filter.ComdID == null || filter.ComdID.Equals("")))
{
hashTable.Add("@ComdID", filter.ComdID);
}
if (filter.StatusKBN >= 0)
{
hashTable.Add("@StatusKBN", filter.StatusKBN);
}
if (filter.ReceivingFLG == 0)
{
hashTable.Add("@ReceivingFLG", false);
}
else if (filter.ReceivingFLG == 1)
{
hashTable.Add("@ReceivingFLG", true);
}
if (filter.PaymentFLG == 0)
{
hashTable.Add("@PaymentFLG", false);
}
else if (filter.PaymentFLG == 1)
{
hashTable.Add("@PaymentFLG", true);
}
try
{
purchaseParentList = comdDAO.SearchPurchaseParentByMultiFilter(hashTable);
}
catch (Exception ex)
{
throw;
}
return purchaseParentList;
}
