/// <summary>
/// 依訂單id取得訂單資料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <OrderProductViewModel> GetOrderDetailById(int id)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
var datalist = orderDao.GetOrderDetailById(id);
return(this.MapOrderDetailData(datalist));
}
/*
* 取得 DataTable 資料
*/
/// <summary>
/// 依訂單id取得訂單資料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public eSaleModel.Order GetOrderById(int id)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
var datalist = orderDao.GetOrderById(id);
return(this.MapOrderData(datalist).FirstOrDefault());
}
/// <summary>
/// 依訂單編號取得訂單資料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public eSaleModel.Order GetOrderById(string id)
{
///資料庫存取方式1
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao();
return(orderDao.GetOrderById(id));
/// EXCEL 存取方式
/// eSalesXlsDao ...
}
public List <eSaleModel.Order> GetOrderByCondition(eSaleModel.Order condition)
{
List <eSaleModel.Order> result = new List <eSaleModel.Order>();
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
var datalist = orderDao.GetOrderByCondition(condition);
return(this.MapOrderStore(datalist));
}
public List <eSaleModel.Order> GetOrder()
{
List <eSaleModel.Order> result = new List <eSaleModel.Order>();
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
var datalist = orderDao.GetOrder();
return(this.MapOrderData(datalist));
}
///<summary>
///依訂單編號取得訂單資料
///</summary>
///<param name="id"></param>
///<returns><returns>
public eSaleModel.Order GetOrderById(string id)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao();
return(orderDao.GetOrderById(id));
}
/*
* 新增資料
*/
/// <summary>
/// 新增訂單資料
/// </summary>
/// <param name="data">訂單資料</param>
/// <returns></returns>
public int InsertOrder(OrderDetailViewModel data)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
return(orderDao.InsertOrderInSqlTrans(data));
}
/// <summary>
/// 刪除訂單明細
/// </summary>
/// <param name="data">訂單明細</param>
/// <returns></returns>
public void DeleteOrderDetail(eSaleModel.OrderDetails data)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
orderDao.DeleteOrderDetail(data);
}
/// <summary>
/// 刪除訂單
/// </summary>
/// <param name="data">訂單明細</param>
/// <returns></returns>
public Boolean DeleteOrder(OrderDetailViewModel data)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
return(orderDao.DeleteOrderInSqlTran(data));
}
/// <summary>
/// 新增訂單資料
/// </summary>
/// <param name="data">訂單資料</param>
/// <returns></returns>
public int UpdateOrder(eSaleModel.Order data)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
return(orderDao.UpdateOrder(data));
}
/// <summary>
/// 新增訂單明細
/// </summary>
/// <param name="data">訂單明細</param>
/// <returns></returns>
public void InsertOrderDetail(eSaleModel.OrderDetails data)
{
eSaleDao.OrderDao orderDao = new eSaleDao.OrderDao(this.DbConn);
orderDao.InsertOrderDetail(data);
}
