public void Dispose()
{
if (this.DB.Database.Connection.State == System.Data.ConnectionState.Open)
{
this.DB.Database.Connection.Close();
}
this.DB.Dispose();
this.DB = null;
}
/// <summary>
/// 取得訂單的發票號碼
/// </summary>
/// <param name="orderNo"></param>
/// <returns></returns>
public string GetEinvoiceNoByOrderNo(string orderNo)
{
string einvoiceNo = string.Empty;
ERPDB db = new ERPDB();
var order = db.Rinnai_Service_Ledger_Entry.Where(o => o.Service_Order_No_ == orderNo && o.Document_Type == 2).FirstOrDefault();
if (order == null)
{
throw new Exception("[系統]無法取得該訂單相關資料");
}
var orderDealis = db.Rinnai_Sales_Invoice_Line.Where(o => o.Document_No_ == order.Document_No_ && o.VAT_Transaction_Number != "").FirstOrDefault();
if (orderDealis == null)
{
throw new Exception("[系統]無法取得該訂單相關資料");
}
einvoiceNo = orderDealis.VAT_Transaction_Number;
return(einvoiceNo);
}
public HomeController()
{
dbContext = new ERPDB();
}
