コード例 #1
0
        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));
        }
コード例 #2
0
        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));
        }