public void Update(Book.Model.Invoice01 detail, Book.Model.InvoiceSK invoiceSK)
{
string invoiceKind = detail.Kind.ToUpper();
System.Collections.Hashtable hash = new System.Collections.Hashtable();
hash.Add("InvoiceId", detail.InvoiceId);
hash.Add("invoiceSKId", invoiceSK.InvoiceId);
hash.Add("XRmoney", detail.PayReceived);
switch (invoiceKind)
{
case "CT":
sqlmapper.Update("XR1.update_invoiceid_invoicesk", hash);
break;
case "XS":
sqlmapper.Update("XR2.update_invoiceid_invoicesk", hash);
break;
default:
break;
}
}
public void Delete(Book.Model.InvoiceSK invoice)
{
sqlmapper.Delete("XR1.delete_by_invoiceskid", invoice.InvoiceId);
}
public IList <Book.Model.XR1> Select(Book.Model.InvoiceSK invoice)
{
return(sqlmapper.QueryForList <Model.XR1>("XR1.select_by_invoiceskid", invoice.InvoiceId));
}
