//跟据客户id得到发票的分页页面
public List<Invoice> GetCustomerInvoiceByPage(int CustomerId,MyPage page)
{
List<Invoice> invoices = new List<Invoice>();
try
{
page.CountPerPage = 10;
page.WholePage = (int)data.getCustomerInvoicePageCount(page.CountPerPage, CustomerId);
var table = data.getCustomerInvoiceByPage(page.CurrentPage, page.CountPerPage, CustomerId);
foreach (var col in table)
{
Invoice invoice = new Invoice();
invoice.Amount = (int)col.amount;
invoice.CustomerId = col.customer_id;
invoice.RegisterTime = (DateTime)col.regist_time;
invoice.InvoiceId = col.invoice_id;
invoices.Add(invoice);
}
return invoices;
}
catch {
return invoices;
}
}
public Invoice GetInvoiceByID(int id)
{
var table = data.getInvoiceByID(id);
var col = table.First<getInvoiceByIDResult>();
Invoice invoice = new Invoice();
invoice.Amount = (int)col.amount;
invoice.CustomerId = col.customer_id;
invoice.InvoiceId = col.invoice_id;
invoice.RegisterTime = (DateTime)col.regist_time;
return invoice;
}