/// <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); }