public async Task <IHttpActionResult> Get([FromUri] queryParam q) { #region 連接BusinessLogicLibary資料庫並取得資料 db0 = getDB0(); var resultItems = await db0.Editor_L2 .Where(x => x.editor_l1_id == q.main_id) .Select(x => new m_Editor_L2 { editor_l1_id = x.editor_l1_id, editor_l2_id = x.editor_l2_id, l2_name = x.l2_name, l2_content = x.l2_content, sort = x.sort, edit_type = IEditType.Update, view_mode = InputViewMode.view }) .ToListAsync(); db0.Dispose(); return(Ok(resultItems)); #endregion }
public async Task <IHttpActionResult> Get([FromUri] queryParam q) { #region 連接BusinessLogicLibary資料庫並取得資料 db0 = getDB0(); var resultItems = await db0.ProductDetail .Where(x => x.product_id == q.main_id) .Select(x => new { product_id = x.product_id, product_detail_id = x.product_detail_id, sn = x.sn, //料號 pack_name = x.pack_name, //包裝 weight = x.weight, //重量 price = x.price, //單價 stock_state = x.stock_state, //狀態 上架/缺貨中 edit_type = IEditType.Update, view_mode = InputViewMode.view }) .ToListAsync(); db0.Dispose(); return(Ok(resultItems)); #endregion }
/// <summary> /// 用于渲染账户管理页面 /// </summary> /// <param name="queryParams"></param> /// <returns></returns> public JsonResult GetUserInfo(queryParam queryParams) { OrderManageDbContext db = new OrderManageDbContext(); List <User> data = db.Users.Where(u => u.Id > 0).ToList(); //var total = data.Count; // var rows = data.Skip(queryParams.offset).Take(queryParams.limit).ToList(); return(Json(data.ToList(), JsonRequestBehavior.AllowGet)); }
/// <summary> /// 用于渲染订单页面 /// </summary> /// <param name="queryParams"></param> /// <returns></returns> public JsonResult GetOrder(queryParam queryParams) { OrderManageDbContext db = new OrderManageDbContext(); DbSet <Order> data = db.Orders; List <Order> dataRows = null; if (queryParams.sortName != null && queryParams.sortOrder != null) { dataRows = OrderByHelper <Order> .OrderBy(data, queryParams.sortName, queryParams.sortOrder).ToList(); } else { dataRows = data.ToList(); } var total = dataRows.Count; var rows = dataRows.Skip(queryParams.offset).Take(queryParams.limit).ToList(); return(Json(new { total = total, rows = rows }, JsonRequestBehavior.AllowGet)); }
public IActionResult getGoodsInfoById(queryParam param) { DBHelper dbHelper = new DBHelper(); try { var res = new GoodsInfo(); string queryName = "SELECT NAME FROM GOODS WHERE ID =:goodsId"; OracleParameter[] parameterForQueryName = { new OracleParameter(":goodsId", OracleDbType.Long, 10) }; parameterForQueryName[0].Value = param.goodsId; DataTable dtForName = dbHelper.ExecuteTable(queryName, parameterForQueryName); if (dtForName.Rows.Count == 0) { return(NotFound("无此周边!")); } res.name = dtForName.Rows[0]["NAME"].ToString(); string queryOther = "SELECT PRICE,AVAILABLE FROM SELLER_GOODS WHERE SELLER_ID=:sellerId AND GOODS_ID=:goodsId"; OracleParameter[] parametersForQueryOther = { new OracleParameter(":sellerId", OracleDbType.Long, 10), new OracleParameter(":goodsId", OracleDbType.Long, 10) }; parametersForQueryOther[0].Value = param.sellerId; parametersForQueryOther[1].Value = param.goodsId; DataTable dtForOther = dbHelper.ExecuteTable(queryOther, parametersForQueryOther); if (dtForOther.Rows.Count == 0) { return(NotFound("暂未售卖此周边!")); } res.price = double.Parse(dtForOther.Rows[0]["PRICE"].ToString()); res.available = long.Parse(dtForOther.Rows[0]["AVAILABLE"].ToString()); return(Ok(new JsonResult(res))); } catch (OracleException oe) { return(BadRequest("数据库请求错误" + " 错误代码" + oe.Number)); } }
public async Task <IHttpActionResult> Get([FromUri] queryParam q) { #region 連接BusinessLogicLibary資料庫並取得資料 db0 = getDB0(); var predicate = PredicateBuilder.True <Edit>(); if (q.name != null) { predicate = predicate.And(x => x.edit_name.Contains(q.name)); } int page = (q.page == null ? 1 : (int)q.page); var result = db0.Edit.AsExpandable().Where(predicate); var resultCount = await result.CountAsync(); int startRecord = PageCount.PageInfo(page, defPageSize, resultCount); var resultItems = await result .OrderBy(x => x.edit_id) .Skip(startRecord) .Take(defPageSize) .ToListAsync(); db0.Dispose(); return(Ok(new { rows = resultItems, total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount, startcount = PageCount.StartCount, endcount = PageCount.EndCount })); #endregion }
public async Task <IHttpActionResult> Get([FromUri] queryParam q) { #region 連接BusinessLogicLibary資料庫並取得資料 db0 = getDB0(); var predicate = PredicateBuilder.True <ProductKind>(); if (q.name != null) { predicate = predicate.And(x => x.kind_name.Contains(q.name)); } if (q.i_Hide != null) { predicate = predicate.And(x => x.i_Hide == q.i_Hide); } int page = (q.page == null ? 1 : (int)q.page); var result = db0.ProductKind.AsExpandable().Where(predicate); var resultCount = await result.CountAsync(); IQueryable <ProductKind> resultOrderItems = null; if (q.field != null) { if (q.sort == "asc") { resultOrderItems = result.OrderBy(q.field); } if (q.sort == "desc") { resultOrderItems = result.OrderBy(q.field + " descending"); } } else { resultOrderItems = result.OrderBy(x => x.product_kind_id); } int startRecord = PageCount.PageInfo(page, defPageSize, resultCount); var resultItems = await resultOrderItems .Skip(startRecord) .Take(defPageSize) .Select(x => new { x.product_kind_id, x.kind_name, x.sort, x.i_Hide, x.i_InsertUserID, x.i_InsertDeptID, x.i_InsertDateTime, x.i_UpdateUserID, x.i_UpdateDeptID, x.i_UpdateDateTime, x.i_Lang, edit_type = IEditType.Update, view_mode = InputViewMode.view }) .ToListAsync(); db0.Dispose(); return(Ok(new { rows = resultItems, total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount, startcount = PageCount.StartCount, endcount = PageCount.EndCount, field = q.field, sort = q.sort })); #endregion }
public async Task <IHttpActionResult> Get([FromUri] queryParam q) { #region 連接BusinessLogicLibary資料庫並取得資料 db0 = getDB0(); var predicate = PredicateBuilder.True <News>(); if (q.name != null) { predicate = predicate.And(x => x.news_title.Contains(q.name)); } if (q.day != null) { DateTime start = (DateTime)q.day; DateTime end = ((DateTime)q.day).AddDays(1); predicate = predicate.And(x => x.day >= start & x.day < end); } if (q.i_Hide != null) { predicate = predicate.And(x => x.i_Hide == q.i_Hide); } int page = (q.page == null ? 1 : (int)q.page); var result = db0.News.AsExpandable().Where(predicate); var resultCount = await result.CountAsync(); IQueryable <News> resultOrderItems = null; if (q.field != null) { if (q.sort == "asc") { resultOrderItems = result.OrderBy(q.field); } if (q.sort == "desc") { resultOrderItems = result.OrderBy(q.field + " descending"); } } else { resultOrderItems = result.OrderByDescending(x => x.sort); } int startRecord = PageCount.PageInfo(page, defPageSize, resultCount); var resultItems = await resultOrderItems .Skip(startRecord) .Take(defPageSize) .Select(x => new { x.news_id, x.news_title, x.day, x.i_Hide, //狀態 x.no_index, //首頁顯示 x.sort }) .ToListAsync(); db0.Dispose(); return(Ok(new { rows = resultItems, total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount, startcount = PageCount.StartCount, endcount = PageCount.EndCount, field = q.field, sort = q.sort })); #endregion }
public async Task <IHttpActionResult> Get([FromUri] queryParam q) { #region 連接BusinessLogicLibary資料庫並取得資料 db0 = getDB0(); var predicate = PredicateBuilder.True <Customer>(); if (q.name != null) { predicate = predicate.And(x => x.c_name.Contains(q.name) || x.email.Contains(q.name) || x.tel.Contains(q.name) || x.mobile.Contains(q.name) || x.zip.Contains(q.name) || x.address.Contains(q.name)); } int page = (q.page == null ? 1 : (int)q.page); var result = db0.Customer.AsExpandable().Where(predicate); var resultCount = await result.CountAsync(); IQueryable <Customer> resultOrderItems = null; if (q.field != null) { if (q.sort == "asc") { resultOrderItems = result.OrderBy(q.field); } if (q.sort == "desc") { resultOrderItems = result.OrderBy(q.field + " descending"); } } else { resultOrderItems = result.OrderBy(x => x.customer_id); } int startRecord = PageCount.PageInfo(page, defPageSize, resultCount); var resultItems = await resultOrderItems .Skip(startRecord) .Take(defPageSize) .Select(x => new { x.customer_id, x.c_name, x.email, x.tel, x.mobile, x.zip, x.address }) .ToListAsync(); db0.Dispose(); return(Ok(new { rows = resultItems, total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount, startcount = PageCount.StartCount, endcount = PageCount.EndCount, field = q.field, sort = q.sort })); #endregion }
public async Task <IHttpActionResult> Get([FromUri] queryParam q) { #region 連接BusinessLogicLibary資料庫並取得資料 db0 = getDB0(); var predicate = PredicateBuilder.True <Purchase>(); if (q.keyword != null) { predicate = predicate.And(x => x.purchase_no.Contains(q.keyword) || x.receive_name.Contains(q.keyword)); } if (q.order_date != null) { DateTime start = (DateTime)q.order_date; DateTime end = ((DateTime)q.order_date).AddDays(1); predicate = predicate.And(x => x.order_date >= start & x.order_date < end); } if (q.pay_date != null) { DateTime start = (DateTime)q.pay_date; DateTime end = ((DateTime)q.pay_date).AddDays(1); predicate = predicate.And(x => x.remit_date >= start & x.remit_date < end); } if (q.type != null) { if (q.type == 1) {//pay_state predicate = predicate.And(x => x.pay_state == q.type_val); } else if (q.type == 2) {//ship_state predicate = predicate.And(x => x.ship_state == q.type_val); } } int page = (q.page == null ? 1 : (int)q.page); var result = db0.Purchase.AsExpandable().Where(predicate); var resultCount = await result.CountAsync(); IQueryable <Purchase> resultOrderItems = null; if (q.field != null) { if (q.sort == "asc") { resultOrderItems = result.OrderBy(q.field); } if (q.sort == "desc") { resultOrderItems = result.OrderBy(q.field + " descending"); } } else { resultOrderItems = result.OrderByDescending(x => x.order_date); } int startRecord = PageCount.PageInfo(page, defPageSize, resultCount); var resultItems = await resultOrderItems .Skip(startRecord) .Take(defPageSize) .Select(x => new { x.purchase_no, x.customer_id, x.order_date, x.remit_date, x.receive_name, x.pay_type, //付款方式 x.pay_state, //付款狀態 x.ship_state, //出貨狀態 Deatil = x.PurchaseDetail.ToList() }) .ToListAsync(); db0.Dispose(); return(Ok(new { rows = resultItems, total = PageCount.TotalPage, page = PageCount.Page, records = PageCount.RecordCount, startcount = PageCount.StartCount, endcount = PageCount.EndCount, field = q.field, sort = q.sort })); #endregion }