public IList <Book.Model.AcOtherShouldCollection> SelectByDateRangeAndCustomerCompany(DateTime startdate, DateTime enddate, Book.Model.Customer customer, Book.Model.Company company) { Hashtable ht = new Hashtable(); ht.Add("startdate", startdate.ToString("yyyy-MM-dd HH:mm:ss")); ht.Add("enddate", enddate.ToString("yyyy-MM-dd HH:mm:ss")); ht.Add("customer", customer == null ? null : customer.CustomerId); ht.Add("company", company == null ? null : company.CompanyId); return(sqlmapper.QueryForList <Model.AcOtherShouldCollection>("AcOtherShouldCollection.SelectByDateRangeAndCustomerCompany", ht)); }
public IList <Book.Model.AcOtherShouldPayment> SelectByDateRangeAndSupCompany(DateTime startdate, DateTime enddate, Book.Model.Supplier supplier, Book.Model.Company company) { Hashtable ht = new Hashtable(); ht.Add("startdate", startdate); ht.Add("enddate", enddate); ht.Add("supplier", supplier == null ? null : supplier.SupplierId); ht.Add("company", company == null ? null : company.CompanyId); return(sqlmapper.QueryForList <Model.AcOtherShouldPayment>("AcOtherShouldPayment.SelectByDateRangeAndSupCompany", ht)); }