在BLL转换
public List<MP_invoiceItem> getinvoiceItem(string doc_no, string dept)
{
List<MP_invoiceItem> list = new List<MP_invoiceItem>();
DataTable dt = D_i.getinvoiceItem(doc_no,dept);
if (dt != null & dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
MP_invoiceItem mii = new MP_invoiceItem();
mii.n_description = dr["n_description"].getString();
mii.n_partno = dr["n_partno"].getString();
mii.qty = dr["qty"].getInt();
mii.price = dr["price"].getDbl();
mii.amount = mii.qty * mii.price;
list.Add(mii);
}
}
return list;
}
public static MP_Invoice get_MInvoice_ByDeptDoc(string dept, string doc_no)
{
MP_Invoice mi = new MP_Invoice();
DataTable dtb = D_Invoice.getInvoice_ByDeptDoc(dept, doc_no);
if (dtb != null && dtb.Rows.Count > 0)
{
DataRow dr = dtb.Rows[0];
mi.doc_title = "Invoice";
mi.status = dr["status"].getInt();
if (mi.status == 0)
{
mi.doc_title = "Proforma Invoice";
}
mi.dept = dr["dept"].getString();
mi.doc_no = dr["doc_no"].getString();
mi.version = dr["version"].getInt();
mi.iss_date = MyDatetime.getDate_Default_1990_1_1(dr["iss_date"]);
mi.show_iss_date = MyDatetime.showDateTime_ddMMMyyyy(dr["iss_date"]);
mi.sales1 = dr["sales1"].getString();
mi.sales2 = dr["sales2"].getString();
mi.sales1_fullname = B_Staff.getFullName(mi.sales1);
if (mi.sales2 != "")
{
mi.sales2_fullname = B_Staff.getFullName(mi.sales2);
}
mi.show_signature = mi.sales1_fullname;
if (mi.sales2_fullname != "")
{
mi.show_signature = mi.show_signature + " / " + mi.sales2_fullname;
}
mi.sales1_email = B_Staff.getUserEmailByID(mi.sales1);
mi.refer_no = dr["refer_no"].getString();
mi.del_date = MyDatetime.getDate_Default_1990_1_1(dr["del_date"]);
mi.del_date_display = dr["del_date_display"].getString();
mi.forwarder = dr["forwarder"].getString();
mi.airway_bill = dr["airway_bill"].getString();
mi.parcel = dr["parcel"].getString();
mi.weight = dr["weight"].getString();
mi.pay_term = dr["pay_term"].getString();
mi.comp_name = dr["comp_name"].getString();
mi.comp_name_ship = dr["comp_name_ship"].getString();
mi.addr_sold = dr["addr_sold"].getString();
mi.addr_ship = dr["addr_ship"].getString();
mi.tel = dr["tel"].getString();
mi.tel_ship = "";
mi.attn = dr["attn"].getString();
mi.attn_ship = dr["attn_ship"].getString();
mi.fax = dr["fax"].getString();
mi.notes = dr["notes"].getString();
mi.terms = dr["terms"].getString();
mi.terms_add = dr["terms_add"].getString();
mi.banker_info = dr["banker_info"].getString();
mi.currency = dr["currency"].getString();
mi.currency_pay = dr["currency_pay"].getString();
mi.amount_pay = dr["amount_pay"].getDbl();
mi.insu_charge = dr["insu_charge"].getDbl();
mi.deli_charge = dr["deli_charge"].getDbl();
mi.other_charge = dr["other_charge"].getDbl();
mi.exchange_rate_pay = dr["exchange_rate_pay"].getDbl();
mi.exchange_rate = dr["exchange_rate"].getDbl();
mi.final_exchange_rate = mi.exchange_rate_pay / mi.exchange_rate;
mi.amount_usd = dr["amount_usd"].getDbl();
mi.approved = MyGeneral.getBool(dr["approved"]);
return mi;
}
return null;
}
p_currInvoice = B_Invoice.get_MInvoice_ByDeptDoc(dept, doc_no);
p_currInvoice.item_list = B_Invoice.getList_MInvoiceNotes_ByDeptDoc(dept, doc_no);