/// <summary> /// 查询单据分页 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <param name="storageNum"></param> /// <returns></returns> public List <BadReportEntity> GetList(BadReportEntity entity, ref PageInfo pageInfo, string storageNum) { entity.IncludeAll(); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete); entity.And("Status", ECondition.Eth, (int)EAudite.Pass); entity.OrderBy(a => a.ID, EOrderBy.DESC); BadReportDetailEntity badDetail = new BadReportDetailEntity(); badDetail.Include(a => new { ProductName = a.ProductName, BarCode = a.BarCode, ProductNum = a.ProductNum }); badDetail.Where(a => a.StorageNum == storageNum); entity.Left <BadReportDetailEntity>(badDetail, new Params <string, string>() { Item1 = "OrderNum", Item2 = "OrderNum" }); int rowCount = 0; List <BadReportEntity> listResult = this.BadReport.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); int allNum = GetAllNum(); if (!listResult.IsNullOrEmpty()) { foreach (BadReportEntity item in listResult) { item.NumPCT = (item.Num * 100.00f) / allNum; } } pageInfo.RowCount = rowCount; return(listResult); }
public ActionResult Edit() { string orderNum = WebUtil.GetQueryStringValue <string>("orderNum", string.Empty); if (orderNum.IsEmpty()) { Response.Redirect("/Bad/Product/List"); } Bill <BadReportEntity, BadReportDetailEntity> bill = new BadOrder(); BadReportEntity entity = new BadReportEntity(); entity.OrderNum = orderNum; entity = bill.GetOrder(entity); if (entity.IsNull()) { Response.Redirect("/Bad/Product/List"); } ViewBag.BadType = EnumHelper.GetOptions <EBadType>(entity.BadType, "请选择报损类型"); ViewBag.ProductType = EnumHelper.GetOptions <EProductType>(entity.ProductType, "请选择入库产品类型"); ViewBag.Entity = entity; BadReportDetailEntity detail = new BadReportDetailEntity(); detail.OrderNum = orderNum; List <BadReportDetailEntity> listDetail = bill.GetOrderDetail(detail); Session[CacheKey.TEMPDATA_CACHE_BADPRODUCTDETAIL] = listDetail; return(View()); }
public ActionResult LoadProduct([ModelBinder(typeof(JsonBinder <List <LocalProductEntity> >))] List <LocalProductEntity> list) { List <BadReportDetailEntity> ListProducts = Session[CacheKey.TEMPDATA_CACHE_BADPRODUCTDETAIL] as List <BadReportDetailEntity>; ListProducts = ListProducts.IsNull() ? new List <BadReportDetailEntity>() : ListProducts; if (!list.IsNullOrEmpty()) { LocationProvider localProvider = new LocationProvider(); foreach (LocalProductEntity item in list) { string BarCode = item.BarCode; string ProductNum = item.ProductNum; string StorageNum = item.StorageNum; string FromLocalNum = item.LocalNum; string BatchNum = item.BatchNum; if (ListProducts.Exists(a => a.BarCode == BarCode && a.ProductNum == ProductNum && a.BatchNum == BatchNum && a.StorageNum == StorageNum && a.FromLocalNum == FromLocalNum)) { BadReportDetailEntity entity = ListProducts.FirstOrDefault(a => a.BarCode == BarCode && a.ProductNum == ProductNum && a.BatchNum == BatchNum && a.StorageNum == StorageNum && a.FromLocalNum == FromLocalNum); entity.Num += item.Num; } else { BadReportDetailEntity entity = new BadReportDetailEntity(); entity.SnNum = SequenceProvider.GetSequence(typeof(BadReportDetailEntity)); ProductProvider provider = new ProductProvider(); ProductEntity product = provider.GetProductBySn(ProductNum); entity.ProductName = product.ProductName; entity.BarCode = product.BarCode; entity.ProductNum = product.SnNum; entity.BatchNum = item.BatchNum; entity.LocalNum = item.Num; entity.Num = item.Qty; entity.Amount = product.InPrice * item.Num; entity.InPrice = product.InPrice; entity.CreateTime = DateTime.Now; entity.StorageNum = StorageNum; entity.FromLocalNum = item.LocalNum; LocationEntity fromLocal = localProvider.GetSingleByNumCache(item.LocalNum); if (fromLocal != null) { entity.FromLocalName = fromLocal.LocalName; } LocationEntity localtion = localProvider.GetDefaultLocal(StorageNum, ELocalType.Bad); if (localtion != null) { entity.ToLocalNum = localtion.LocalNum; } ListProducts.Add(entity); } } Session[CacheKey.TEMPDATA_CACHE_BADPRODUCTDETAIL] = ListProducts; } return(Content(string.Empty)); }
/// <summary> /// 查询报损单详细 /// </summary> /// <returns></returns> public ActionResult GetDetail() { string SnNum = WebUtil.GetFormValue <string>("SnNum"); string CompanyID = WebUtil.GetFormValue <string>("CompanyID", string.Empty); BadReportDetailEntity entity = new BadReportDetailEntity(); entity.OrderSnNum = SnNum; entity.CompanyID = CompanyID; Bill <BadReportEntity, BadReportDetailEntity> bill = new BadOrder(CompanyID); List <BadReportDetailEntity> list = bill.GetOrderDetail(entity); DataResult <List <BadReportDetailEntity> > dataResult = new DataResult <List <BadReportDetailEntity> >(); dataResult.Code = (int)EResponseCode.Success; dataResult.Message = "响应成功"; dataResult.Result = list; return(Content(JsonHelper.SerializeObject(dataResult))); }
public static BadReportDetail_CE ToCE(BadReportDetailEntity item) { BadReportDetail_CE target = new BadReportDetail_CE(); target.ID = item.ID; target.SnNum = item.SnNum; target.OrderNum = item.OrderNum; target.ProductName = item.ProductName; target.BarCode = item.BarCode; target.ProductNum = item.ProductNum; target.BatchNum = item.BatchNum; target.Num = item.Num; target.InPrice = item.InPrice; target.Amount = item.Amount; target.CreateTime = item.CreateTime; target.StorageNum = item.StorageNum; target.FromLocalNum = item.FromLocalNum; target.ToLocalNum = item.ToLocalNum; return(target); }
/// <summary> /// 编辑报损单详细信息 /// </summary> /// <returns></returns> public ActionResult EditDetail() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID", string.Empty); BadReportDetailEntity entity = WebUtil.GetFormObject <BadReportDetailEntity>("Entity"); Bill <BadReportEntity, BadReportDetailEntity> bill = new BadOrder(CompanyID); string returnValue = bill.EditDetail(entity); DataResult result = new DataResult(); if (EnumHelper.GetEnumDesc <EReturnStatus>(EReturnStatus.Success) == returnValue) { result.Code = (int)EResponseCode.Success; result.Message = "报损单详细编辑成功"; } else { result.Code = (int)EResponseCode.Exception; result.Message = "报损单详细编辑失败"; } return(Content(JsonHelper.SerializeObject(result))); }
/// <summary> /// 查询报损单详细分页 /// </summary> /// <returns></returns> public ActionResult GetDetailPage() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1); int PageSize = WebUtil.GetFormValue <int>("PageSize", 10); string OrderNum = WebUtil.GetFormValue <string>("OrderNum"); int BadType = WebUtil.GetFormValue <int>("BadType", 0); string ContractOrder = WebUtil.GetFormValue <string>("ContractOrder"); int Status = WebUtil.GetFormValue <int>("Status", 0); string BeginTime = WebUtil.GetFormValue <string>("BeginTime"); string EndTime = WebUtil.GetFormValue <string>("EndTime"); string StorageNum = WebUtil.GetFormValue <string>("StorageNum"); Bill <BadReportEntity, BadReportDetailEntity> bill = new BadOrder(CompanyID); BadReportDetailEntity entity = new BadReportDetailEntity(); entity.CompanyID = CompanyID; entity.OrderNum = OrderNum; entity.BadType = BadType; entity.Status = Status; entity.BeginTime = BeginTime; entity.EndTime = EndTime; entity.StorageNum = StorageNum; PageInfo pageInfo = new PageInfo() { PageIndex = PageIndex, PageSize = PageSize }; List <BadReportDetailEntity> listResult = bill.GetDetailList(entity, ref pageInfo); DataListResult <BadReportDetailEntity> dataResult = new DataListResult <BadReportDetailEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = listResult, PageInfo = pageInfo }; return(Content(JsonHelper.SerializeObject(dataResult))); }
public ActionResult Detail() { string orderNum = WebUtil.GetQueryStringValue <string>("orderNum", string.Empty); string flag = WebUtil.GetQueryStringValue <string>("flag", string.Empty); Bill <BadReportEntity, BadReportDetailEntity> bill = new BadOrder(); BadReportEntity entity = new BadReportEntity(); entity.OrderNum = orderNum; entity = bill.GetOrder(entity); entity = entity.IsNull() ? new BadReportEntity() : entity; entity.StatusLable = EnumHelper.GetEnumDesc <EAudite>(entity.Status); ViewBag.BadReport = entity; BadReportDetailEntity detail = new BadReportDetailEntity(); detail.OrderNum = orderNum; List <BadReportDetailEntity> listResult = bill.GetOrderDetail(detail); listResult = listResult.IsNull() ? new List <BadReportDetailEntity>() : listResult; ViewBag.Detail = listResult; ViewBag.Flag = flag; return(View()); }