/// <summary> /// 根据订单号查询所有订单相关联的的排产单号 /// </summary> /// <param name="orderNum"></param> /// <returns></returns> public List<string> GetOrderPlan(string orderNum) { OrdersEntity entity = new OrdersEntity(); entity.Include(a => new { a.OrderNum, a.ContractOrder }); entity.Where("OrderNum", ECondition.Like, "%" + orderNum + "%"); List<OrdersEntity> list = this.Orders.GetList(entity); if (!list.IsNullOrEmpty()) { List<string> items = list.Select(a => a.ContractOrder).ToList(); return items; } return null; }
public ActionResult AutoOrder(string productName) { string orderNum = WebUtil.GetFormValue<string>("orderNum", string.Empty); PageInfo page = new PageInfo { PageIndex = 1, PageSize = 5 }; Bill<OrdersEntity, OrderDetailEntity> bill = new OrderBill(); OrdersEntity entity = new OrdersEntity(); if (orderNum != string.Empty) { entity.Where("OrderNum", ECondition.Like, "%" + orderNum + "%"); } entity.Where(a => a.AuditeStatus == (int)EAudite.Pass).And(a => a.Status != (int)EOrderStatus.AllDelivery); List<OrdersEntity> list = bill.GetList(entity, ref page); list = list.IsNull() ? new List<OrdersEntity>() : list; StringBuilder sb = new StringBuilder(); JsonObject jsonObject = null; foreach (OrdersEntity t in list) { jsonObject = new JsonObject(); jsonObject.AddProperty("OrderNum", t.OrderNum); jsonObject.AddProperty("CusName", t.CusName); sb.Append(jsonObject.ToString() + "\n"); } if (sb.Length == 0) { sb.Append("\n"); } return Content(sb.ToString()); }