public ResResultModel GetOrderSendList(PdaOrderSendModel model) { try { var bll = new OrderSend(); StringBuilder sqlWhere = null; ParamsHelper parms = null; var list = bll.GetList(model.PageIndex, model.PageSize, sqlWhere == null ? "" : sqlWhere.ToString(), parms == null ? null : parms.ToArray()); return(ResResult.Response(true, "", JsonConvert.SerializeObject(list))); } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }
public PrintOrderInfo GetPrintOrderSend(Guid Id) { var data = new PrintOrderInfo(); data.Title = "发货单"; data.SPrintDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); var bll = new OrderSend(); var oInfo = bll.GetModel(Id); data.OrderCode = oInfo.OrderCode; data.PurchaseOrderCode = ""; data.SupplierName = ""; data.SPlanArrivalTime = ""; data.SPlanArrivalTime = ""; Task[] tasks = new Task[2]; tasks[0] = Task.Factory.StartNew(() => { var bh = new BarcodeHelper(); data.BarcodeImageUri = bh.CreateBarcode(data.OrderCode); }); tasks[1] = Task.Factory.StartNew(() => { var ospBll = new OrderSendProduct(); var sqlWhere = "and osp.OrderId = @OrderId "; var parm = new SqlParameter("@OrderId", oInfo.Id); var pList = ospBll.GetListByJoin(sqlWhere, parm); if (pList != null && pList.Count > 0) { var cargoList = new List <PrintOrderCargoInfo>(); foreach (var item in pList) { cargoList.Add(new PrintOrderCargoInfo("", item.ProductCode, item.ProductName, item.CustomerCode, item.CustomerName, "", "", "", 0, item.Qty, "")); } data.CargoList = cargoList; //data.CargoList = JsonConvert.SerializeObject(cargoList); } }); Task.WaitAll(tasks); return(data); }
private void GetOrderSendList(HttpContext context, int pageIndex, int pageSize, string keyword) { var bll = new OrderSend(); int totalRecord = 0; StringBuilder sqlWhere = null; ParamsHelper parms = null; if (!string.IsNullOrWhiteSpace(keyword)) { parms = new ParamsHelper(); sqlWhere = new StringBuilder("and (o.OrderCode like @Keyword) "); var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50); parm.Value = parm.Value = "%" + keyword + "%"; parms.Add(parm); } var list = bll.GetList(pageIndex, pageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray()); context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}")); }