public ActionResult AddOrderDetailProduct([ModelBinder(typeof(JsonBinder<string[]>))] string[] ProductItems,
[ModelBinder(typeof(JsonBinder<string[]>))] string[] SnItems,
[ModelBinder(typeof(JsonBinder<int[]>))]int[] QtyItems)
{
List<OutStoDetailEntity> list = Session[CacheKey.TEMPDATA_CACHE_OUTSTORDETAIL] as List<OutStoDetailEntity>;
list = list.IsNull() ? new List<OutStoDetailEntity>() : list;
OrderProvider provider = new OrderProvider();
for (int i = 0; i < ProductItems.Length; i++)
{
string snNum = SnItems[i];
int qty = QtyItems[i];
string productNum = ProductItems[i];
OrderDetailEntity detail = provider.GetOrderDetailBySnNum(snNum);
detail = detail.IsNull() ? new OrderDetailEntity() : detail;
if (detail.IsNotNull())
{
list.Remove(a => a.ContractSn == detail.SnNum);
OutStoDetailEntity entity = new OutStoDetailEntity();
entity.SnNum = SequenceProvider.GetSequence(typeof(OutStoDetailEntity));
entity.ProductName = detail.ProductName;
entity.BarCode = detail.BarCode;
entity.ContractOrder = detail.OrderNum;
entity.ContractSn = detail.SnNum;
entity.BatchNum = "";
entity.ProductNum = detail.ProductNum;
entity.LocalNum = ResourceManager.GetSettingEntity("STORE_DEFAULT_MATERIAL_LocalNum").Value;//detail.LocalNum;
entity.LocalName = ResourceManager.GetSettingEntity("STORE_DEFAULT_MATERIAL_LocalName").Value;//detail.LocalName;
entity.StorageNum = this.DefaultStore;
entity.Num = qty;
entity.IsPick = (int)EBool.No;
entity.Size = detail.Size.IsEmpty() ? "" : detail.Size;
entity.RealNum = detail.RealNum;
entity.OutPrice = 0;//detail.InPrice;
entity.Amount = 0;//detail.InPrice * entity.Num;
entity.CreateTime = DateTime.Now;
list.Add(entity);
}
}
if (!list.IsNullOrEmpty())
{
Session[CacheKey.TEMPDATA_CACHE_OUTSTORDETAIL] = list;
}
return Content(string.Empty);
}
public ActionResult GetList()
{
int Status = WebUtil.GetFormValue<int>("Status", 0);
string OrderNum = WebUtil.GetFormValue<string>("OrderNum", string.Empty);
string CusName = WebUtil.GetFormValue<string>("CusName", string.Empty);
string beginTime = WebUtil.GetFormValue<string>("beginTime", string.Empty);
string endTime = WebUtil.GetFormValue<string>("endTime", string.Empty);
string order = WebUtil.GetFormValue<string>("order", string.Empty);
int OutType = WebUtil.GetFormValue<int>("OutType", 0);
string planNum = WebUtil.GetFormValue<string>("planNum");
int pageSize = WebUtil.GetFormValue<int>("PageSize", 10);
int pageIndex = WebUtil.GetFormValue<int>("PageIndex", 1);
PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize };
OutStorageEntity entity = new OutStorageEntity();
if (Status > 0)
{
entity.Where(a => a.Status == Status);
}
if (!OrderNum.IsEmpty())
{
entity.Where("OrderNum", ECondition.Like, "%" + OrderNum + "%");
}
if (!CusName.IsEmpty())
{
entity.Begin<OutStorageEntity>()
.And<OutStorageEntity>("CusNum", ECondition.Like, "%" + CusName + "%")
.Or<OutStorageEntity>("CusName", ECondition.Like, "%" + CusName + "%")
.End<OutStorageEntity>()
;
}
if (!beginTime.IsEmpty() && !endTime.IsEmpty())
{
entity.Where("OrderTime", ECondition.Between, ConvertHelper.ToType<DateTime>(beginTime), ConvertHelper.ToType<DateTime>(endTime));
}
entity.And(a => a.StorageNum == this.DefaultStore);
if (!order.IsEmpty())
{
OrderProvider orderProvider = new OrderProvider();
List<string> listContractOrder = orderProvider.GetOrderPlan(order);
listContractOrder = listContractOrder.IsNull() ? new List<string>() : listContractOrder;
if (listContractOrder.Count == 0)
{
listContractOrder.Add(order);
}
entity.And("ContractOrder", ECondition.In, listContractOrder.ToArray());
}
if (OutType > 0)
{
entity.And(a => a.OutType == OutType);
}
if (!planNum.IsEmpty())
{
OutStoDetailEntity detail = new OutStoDetailEntity();
detail.Where("ContractOrder", ECondition.Like, "%" + planNum + "%");
entity.Left<OutStoDetailEntity>(detail, new Params<string, string>() { Item1 = "OrderNum", Item2 = "OrderNum" });
}
Bill<OutStorageEntity, OutStoDetailEntity> bill = new OutStorageOrder();
List<OutStorageEntity> listResult = bill.GetList(entity, ref pageInfo);
listResult = listResult == null ? new List<OutStorageEntity>() : listResult;
string json = ConvertJson.ListToJson<OutStorageEntity>(listResult, "List");
this.ReturnJson.AddProperty("Data", json);
this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount);
return Content(this.ReturnJson.ToString());
}
public ActionResult Print()
{
string orderNum = WebUtil.GetQueryStringValue<string>("orderNum", string.Empty);
Bill<OutStorageEntity, OutStoDetailEntity> bill = new OutStorageOrder();
OutStorageEntity entity = new OutStorageEntity();
entity.OrderNum = orderNum;
entity = bill.GetOrder(entity);
entity = entity.IsNull() ? new OutStorageEntity() : entity;
ViewBag.Entity = entity;
OutStoDetailEntity detail = new OutStoDetailEntity();
detail.OrderNum = orderNum;
List<OutStoDetailEntity> listResult = bill.GetOrderDetail(detail);
listResult = listResult.IsNull() ? new List<OutStoDetailEntity>() : listResult;
OrderProvider orderProvider = new OrderProvider();
foreach (OutStoDetailEntity item in listResult)
{
OrderDetailEntity orderDetail = new OrderDetailEntity();
orderDetail.Where(a => a.SnNum == item.ContractSn).And(a => a.OrderNum == item.ContractOrder);
orderDetail = orderProvider.GetOrderDetail(orderDetail);
if (orderDetail != null)
{
item.Qty = orderDetail.Num;
}
}
ViewBag.Detail = listResult;
return View();
}