public List <ReadableSale> GetSpecificWordGroup(string customer, string manufacturer, string keywords, int staff_Id, string helper,
DateTime salesOrderStartDate, DateTime salesOrderEndDate, DateTime salesStartDate,
DateTime salesEndDate)
{
using (DefaultConnection db = new DefaultConnection())
{
SQLWhereString whereString = new SQLWhereString();
string where = whereString.SearchKeyWhere <ReadableSale>(db, keywords);
int openCustomer_Id = BusinessPartnerData.NameToId(db, customer)[0];
int closeCustomer_Id = BusinessPartnerData.NameToId(db, customer)[1];
int openManufacturer_Id = ManufacturerData.NameToId(db, manufacturer)[0];
int closeManufacturer_Id = ManufacturerData.NameToId(db, manufacturer)[1];
int openStaff_Id = StaffData.GetIdRange(db, staff_Id)[0];
int closeStaff_Id = StaffData.GetIdRange(db, staff_Id)[1];
int openHelper_Id = HelperData.NameToId(db, helper)[0];
int closeHelper_Id = HelperData.NameToId(db, helper)[1];
List <ReadableSale> readableSales = new List <ReadableSale>();
if (!String.IsNullOrEmpty(keywords))
{
readableSales = db.Database
.SqlQuery <ReadableSale>(where)
.ToList();
return(readableSales
.Where(rs => rs.Customer_Id >= openCustomer_Id &&
rs.Customer_Id <= closeCustomer_Id &&
rs.Manufacturer_Id >= openManufacturer_Id &&
rs.Manufacturer_Id <= closeManufacturer_Id &&
rs.ResponsibleStaff_Id >= openStaff_Id &&
rs.ResponsibleStaff_Id <= closeStaff_Id &&
rs.Helper_Id >= openHelper_Id &&
rs.Helper_Id <= closeHelper_Id &&
rs.SalesOrderDate >= salesOrderStartDate &&
rs.SalesOrderDate <= salesOrderEndDate &&
rs.SalesDate >= salesStartDate &&
rs.SalesDate <= salesEndDate)
.ToList());
}
else
{
readableSales = db.ReadableSales
.Where(rs => rs.Customer_Id >= openCustomer_Id &&
rs.Customer_Id <= closeCustomer_Id &&
rs.Manufacturer_Id >= openManufacturer_Id &&
rs.Manufacturer_Id <= closeManufacturer_Id &&
rs.ResponsibleStaff_Id >= openStaff_Id &&
rs.ResponsibleStaff_Id <= closeStaff_Id &&
rs.Helper_Id >= openHelper_Id &&
rs.Helper_Id <= closeHelper_Id &&
rs.SalesOrderDate >= salesOrderStartDate &&
rs.SalesOrderDate <= salesOrderEndDate &&
rs.SalesDate >= salesStartDate &&
rs.SalesDate <= salesEndDate)
.ToList();
return(readableSales);
}
}
}
public List <ReadablePurchase> GetSpecificWordGroup(string supplier, string manufacturer, string keywords, int staff_Id,
DateTime purchaseStartDate, DateTime purchaseEndDate,
DateTime receiptStartDate, DateTime receiptEndDate)
{
using (DefaultConnection db = new DefaultConnection())
{
SQLWhereString whereString = new SQLWhereString();
string where = whereString.SearchKeyWhere <ReadablePurchase>(db, keywords);
int[] supplier_Ids = BusinessPartnerData.NameToId(db, supplier);
int openSupplier_Id = supplier_Ids[0];
int closeSupplier_Id = supplier_Ids[1];
int[] manufacturer_Ids = ManufacturerData.NameToId(db, manufacturer);
int openManufacturer_Id = manufacturer_Ids[0];
int closeManufacturer_Id = manufacturer_Ids[1];
int[] staff_Ids = StaffData.GetIdRange(db, staff_Id);
int openStaff_Id = staff_Ids[0];
int closeStaff_Id = staff_Ids[1];
List <ReadablePurchase> readablePurchases = new List <ReadablePurchase>();
if (!String.IsNullOrEmpty(keywords))
{
readablePurchases = db.Database
.SqlQuery <ReadablePurchase>(where)
.ToList();
return(readablePurchases
.Where(p => p.Supplier_Id >= openSupplier_Id &&
p.Supplier_Id <= closeSupplier_Id &&
p.ResponsibleStaff_Id >= openStaff_Id &&
p.ResponsibleStaff_Id <= closeStaff_Id &&
p.PurchaseDate >= purchaseStartDate &&
p.PurchaseDate <= purchaseEndDate &&
p.ReceiptDate >= receiptStartDate &&
p.ReceiptDate <= receiptEndDate)
.ToList());
}
else
{
readablePurchases = db.ReadablePurchases
.Where(p => p.Supplier_Id >= openSupplier_Id &&
p.Supplier_Id <= closeSupplier_Id &&
p.ResponsibleStaff_Id >= openStaff_Id &&
p.ResponsibleStaff_Id <= closeStaff_Id &&
p.PurchaseDate >= purchaseStartDate &&
p.PurchaseDate <= purchaseEndDate &&
p.ReceiptDate >= receiptStartDate)
.ToList();
return(readablePurchases);
}
}
}
public List<ReadableGoodsIssue> GetSpecificWordGroup(string manufacturer, string keywords, int accountTitle_Id
, int responsibleStaff_Id, DateTime startDate, DateTime endDate)
{
using (DefaultConnection db = new DefaultConnection())
{
int[] manufacturer_Ids = ManufacturerData.NameToId(db, manufacturer);
int openManufacturer_Id = manufacturer_Ids[0];
int closeManufacturer_Id = manufacturer_Ids[1];
int[] accountTitle_Ids = AccountTitleData.GetIdRange(db, accountTitle_Id);
int openAccountTitle_Id = accountTitle_Ids[0];
int closeAccountTitle_Id = accountTitle_Ids[1];
int[] staff_Ids = StaffData.GetIdRange(db, responsibleStaff_Id);
int openResponsibleStaff_Id = staff_Ids[0];
int closeResponsibleStaff_Id = staff_Ids[1];
if (!String.IsNullOrEmpty(keywords))
{
SQLWhereString whereString = new SQLWhereString();
string where = whereString.SearchKeyWhere<ReadableGoodsIssue>(db, keywords);
List<ReadableGoodsIssue> readableGoodsIssues = new List<ReadableGoodsIssue>();
readableGoodsIssues = db.Database
.SqlQuery<ReadableGoodsIssue>(where)
.ToList();
return readableGoodsIssues
.Where(gi => gi.AccountTitle_Id >= openAccountTitle_Id
&& gi.AccountTitle_Id <= closeAccountTitle_Id
&& gi.FluctuatingDate >= startDate
&& gi.FluctuatingDate <= endDate
&& gi.Manufacturer_Id >= openManufacturer_Id
&& gi.Manufacturer_Id <= closeManufacturer_Id
&& gi.ResponsibleStaff_Id >= openResponsibleStaff_Id
&& gi.ResponsibleStaff_Id <= closeResponsibleStaff_Id)
.ToList();
}
else
{
return db.ReadableGoodsIssues
.Where(r => r.AccountTitle_Id >= openAccountTitle_Id
&& r.AccountTitle_Id <= closeAccountTitle_Id
&& r.FluctuatingDate >= startDate
&& r.FluctuatingDate <= endDate
&& r.Manufacturer_Id >= openManufacturer_Id
&& r.Manufacturer_Id <= closeManufacturer_Id
&& r.ResponsibleStaff_Id >= openResponsibleStaff_Id
&& r.ResponsibleStaff_Id <= closeResponsibleStaff_Id)
.ToList();
}
}
}