public ActionResult Add([ModelBinder(typeof(JsonBinder<LocationEntity>))] LocationEntity entity) { LocationProvider provider = new LocationProvider(); if (entity.LocalNum.IsEmpty()) { entity.LocalNum = SequenceProvider.GetSequence(typeof(LocationEntity)); entity.LocalBarCode = entity.LocalBarCode.IsEmpty() ? entity.LocalNum : entity.LocalBarCode; entity.IsForbid = (int)EBool.No; entity.IsDelete = (int)EIsDelete.NotDelete; entity.UnitNum = ""; entity.UnitName = ""; entity.CreateTime = DateTime.Now; int line = provider.Add(entity); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } } else { entity.LocalBarCode = entity.LocalBarCode.IsEmpty() ? entity.LocalNum : entity.LocalBarCode; entity.Include(a => new { a.LocalName, a.LocalBarCode, a.StorageNum, a.LocalType, a.IsDefault }); entity.Where(a => a.LocalNum == entity.LocalNum); int line = provider.Update(entity); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } } return Content(this.ReturnJson.ToString()); }
/// <summary> /// 库位 /// </summary> /// <param name="roleNum"></param> /// <returns></returns> public static string GetLocalNumList(string storeNum, string localNum) { LocationProvider provider = new LocationProvider(); List<LocationEntity> list = provider.GetList(); list = list.Where(a => a.StorageNum == storeNum).ToList(); StringBuilder sb = new StringBuilder(); string storeTemplate = "<option value='{0}' {1}>{2}</option>"; if (!list.IsNullOrEmpty()) { foreach (LocationEntity store in list) { sb.AppendFormat(storeTemplate, store.LocalNum, store.LocalNum == localNum ? "selected='selected'" : string.Empty, store.LocalName); } } return sb.ToString(); }
/// <summary> /// 获得某个仓库中某种类型的仓库列表 /// </summary> /// <param name="storeNum">仓库编号</param> /// <param name="localType">库位类型</param> /// <param name="localNum">选中库位编号</param> /// <returns></returns> public static string GetLocalNum(string storeNum, ELocalType localType, string localNum) { LocationProvider provider = new LocationProvider(); List<LocationEntity> list = provider.GetList(); StringBuilder sb = new StringBuilder(); if (!list.IsNullOrEmpty()) { string storeTemplate = "<option value='{0}' {1}>{2}</option>"; sb.AppendFormat(storeTemplate,"","","请选择库位"); foreach (LocationEntity entity in list.Where(a=>a.StorageNum==storeNum && a.LocalType==(int)localType)) { sb.AppendFormat(storeTemplate, entity.LocalNum, entity.LocalNum == localNum ? "selected='selected'" : string.Empty, entity.LocalName); } } return sb.ToString(); }
public ActionResult AddProduct() { string ProductNum = WebUtil.GetFormValue<string>("SnNum", string.Empty); string BarCode = WebUtil.GetFormValue<string>("BarCode", string.Empty); string ProductName = WebUtil.GetFormValue<string>("ProductName", string.Empty); string BatchNum = WebUtil.GetFormValue<string>("ProductBatch", string.Empty); string LocalNum = WebUtil.GetFormValue<string>("LocalNum", string.Empty); string Size = WebUtil.GetFormValue<string>("Size", string.Empty); double LocalQty = WebUtil.GetFormValue<double>("LocalQty", 0); double Num = WebUtil.GetFormValue<double>("Num", 0); double InPrice = WebUtil.GetFormValue<double>("Price", 0); InStorDetailEntity entity = new InStorDetailEntity(); entity.SnNum = SequenceProvider.GetSequence(typeof(InStorDetailEntity)); entity.OrderNum = string.Empty; entity.ProductName = ProductName; entity.BarCode = BarCode; entity.ProductNum = ProductNum; entity.Num = Num; entity.IsPick = (int)EBool.No; entity.RealNum = 0; entity.InPrice = InPrice; entity.CreateTime = DateTime.Now; entity.LocalNum = LocalNum; LocationEntity localtion = new LocationProvider().GetSingleByNumCache(LocalNum); if (localtion != null) { entity.LocalName = new LocationProvider().GetSingleByNumCache(LocalNum).LocalName; } else { entity.LocalName = ""; } entity.Amount = entity.InPrice * entity.Num; entity.StorageNum = this.DefaultPStore; entity.Size = Size; entity.BatchNum = BatchNum; entity.TotalPrice = entity.Num * entity.InPrice; List<InStorDetailEntity> list = Session[CacheKey.TEMPDATA_CACHE_INSTORDETAIL] as List<InStorDetailEntity>; list = list.IsNull() ? new List<InStorDetailEntity>() : list; list.Add(entity); Session[CacheKey.TEMPDATA_CACHE_INSTORDETAIL] = list; return Content(string.Empty); }
public ActionResult Audit(string LocalNum, string IsForbid) { LocationProvider provider = new LocationProvider(); LocationEntity entity = new LocationEntity(); entity.IncludeIsForbid(true); entity.IsForbid = ConvertHelper.ToType<int>(IsForbid); entity.Where(a => a.LocalNum == LocalNum); int line = provider.Update(entity); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } else { this.ReturnJson.AddProperty("d", ""); } return Content(this.ReturnJson.ToString()); }
public ActionResult Add() { string LocalNum = WebUtil.GetQueryStringValue<string>("LocalNum"); if (LocalNum.IsEmpty()) { ViewBag.Storage = LocalHelper.GetStorageNumList(string.Empty); ViewBag.LocalTypeList = EnumHelper.GetOptions<ELocalType>(string.Empty, "请选择库位类型"); ViewBag.IsDefault = EnumHelper.GetOptions<EBool>(string.Empty, "请选择"); ViewBag.Location = new LocationEntity(); } else { LocationProvider provider = new LocationProvider(); LocationEntity entity = provider.GetSingleByNum(LocalNum); entity = entity == null ? new LocationEntity() : entity; ViewBag.StorageType = EnumHelper.GetOptions<EStorageType>(entity.StorageType, "请选择仓库类型"); ViewBag.IsDefault = EnumHelper.GetOptions<EBool>(entity.IsDefault, "请选择"); ViewBag.Storage = LocalHelper.GetStorageNumList(entity.StorageNum); ViewBag.LocalTypeList = EnumHelper.GetOptions<ELocalType>(entity.LocalType, "请选择仓库类型"); ViewBag.Location = entity; } return View(); }
public ActionResult Delete(string LocalNum) { LocationProvider provider = new LocationProvider(); int line = provider.Delete(LocalNum); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } else { this.ReturnJson.AddProperty("d", ""); } return Content(this.ReturnJson.ToString()); }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string StorageNum = WebUtil.GetFormValue<string>("StorageName", string.Empty); string LocalName = WebUtil.GetFormValue<string>("LocalName", string.Empty); string LocalType = WebUtil.GetFormValue<string>("LocalType", string.Empty); LocationProvider provider = new LocationProvider(); LocationEntity entity = new LocationEntity(); StorageEntity SEntity = new StorageEntity(); SEntity.Include(a => new { StorageName = a.StorageName }); entity.Left<StorageEntity>(SEntity, new Params<string, string>() { Item1 = "StorageNum", Item2 = "StorageNum" }); if (!StorageNum.IsEmpty()) { entity.Where<LocationEntity>("StorageNum", ECondition.Like, "%" + StorageNum + "%"); } if (!LocalName.IsEmpty()) { entity.Begin<LocationEntity>() .Where<LocationEntity>("LocalName", ECondition.Like, "%" + LocalName + "%") .Or<LocationEntity>("LocalNum", ECondition.Like, "%" + LocalName + "%") .Or<LocationEntity>("LocalBarCode", ECondition.Like, "%" + LocalName + "%") .End<LocationEntity>() ; } if (!LocalType.IsEmpty()) { entity.Where<LocationEntity>("LocalType", ECondition.Like, "%" + LocalType + "%"); } List<LocationEntity> listResult = provider.GetList(entity, ref pageInfo); listResult = listResult.IsNull() ? new List<LocationEntity>() : listResult; if (listResult.IsNotNull()) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("序号 ")); dt.Columns.Add(new DataColumn("库位编号 ")); dt.Columns.Add(new DataColumn("库位名 ")); dt.Columns.Add(new DataColumn("所在仓库 ")); dt.Columns.Add(new DataColumn("库位类型")); dt.Columns.Add(new DataColumn("是否禁用")); dt.Columns.Add(new DataColumn("是否默认")); dt.Columns.Add(new DataColumn("创建时间")); int count = 1; foreach (LocationEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.LocalNum; row[2] = t.LocalName; row[3] = t.StorageName; row[4] = EnumHelper.GetEnumDesc<ELocalType>(t.LocalType); row[5] = EnumHelper.GetEnumDesc<EBool>(t.IsForbid); row[6] = EnumHelper.GetEnumDesc<EBool>(t.IsDefault); row[7] = t.CreateTime.ToString("yyyy-MM-dd"); dt.Rows.Add(row); count++; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("库位管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); NPOIExcel excel = new NPOIExcel("库位管理", "库位", System.IO.Path.Combine(filePath, filename)); excel.ToExcel(dt); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult GetList() { int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 1); int pageSize = WebUtil.GetFormValue<int>("pageSize", 15); string LocalName = WebUtil.GetFormValue<string>("LocalName", string.Empty); string LocalType = WebUtil.GetFormValue<string>("LocalType", string.Empty); PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; LocationProvider provider = new LocationProvider(); LocationEntity entity = new LocationEntity(); StorageEntity SEntity = new StorageEntity(); SEntity.Include(a => new { StorageName = a.StorageName }); entity.Left<StorageEntity>(SEntity, new Params<string, string>() { Item1 = "StorageNum", Item2 = "StorageNum" }); string StorageNum = this.DefaultStore; entity.Where<LocationEntity>("StorageNum", ECondition.Eth, StorageNum); if (!LocalName.IsEmpty()) { entity.Begin<LocationEntity>() .Where<LocationEntity>("LocalName", ECondition.Like, "%" + LocalName + "%") .Or<LocationEntity>("LocalNum", ECondition.Like, "%" + LocalName + "%") .Or<LocationEntity>("LocalBarCode", ECondition.Like, "%" + LocalName + "%") .End<LocationEntity>() ; } if (!LocalType.IsEmpty()) { entity.Where<LocationEntity>("LocalType", ECondition.Eth, LocalType); } List<LocationEntity> listResult = provider.GetList(entity, ref pageInfo); string json = ConvertJson.ListToJson<LocationEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount); return Content(this.ReturnJson.ToString()); }
public ActionResult ToInventoryReportExcel() { string searchKey = WebUtil.GetFormValue<string>("SearchKey", string.Empty); string change = WebUtil.GetFormValue<string>("Change", string.Empty); string beginTime = WebUtil.GetFormValue<string>("beginTime", string.Empty); string endTime = WebUtil.GetFormValue<string>("endTime", string.Empty); string storageNum = this.DefaultStore; InventoryProvider provider = new InventoryProvider(); InventoryBookEntity entity = new InventoryBookEntity(); if (!searchKey.IsEmpty()) { entity.Begin<InventoryBookEntity>() .Where<InventoryBookEntity>("ProductName", ECondition.Like, "%" + searchKey + "%") .Or<InventoryBookEntity>("ProductNum", ECondition.Like, "%" + searchKey + "%") .Or<InventoryBookEntity>("BarCode", ECondition.Like, "%" + searchKey + "%") .End<InventoryBookEntity>(); } if (!storageNum.IsEmpty()) { entity.Where("StoreNum", ECondition.Eth, storageNum); } if (!change.IsEmpty()) { entity.Where("Type", ECondition.Eth, change); } PageInfo pageInfo = new PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; List<InventoryBookEntity> listResult = provider.GetList(entity, ref pageInfo); LocationProvider locaProvider = new LocationProvider(); foreach (InventoryBookEntity item in listResult) { LocationEntity locaEntity1 = locaProvider.GetSingleByNum(item.FromLocalNum); if (locaEntity1.IsNotNull()) { item.FromLocalName = locaEntity1.LocalName; } else { item.FromLocalName = string.Empty; } LocationEntity locaEntity2 = locaProvider.GetSingleByNum(item.ToLocalNum); if (locaEntity2.IsNotNull()) { item.ToLocalName = locaEntity2.LocalName; } else { item.ToLocalName = string.Empty; } } if (!listResult.IsNullOrEmpty()) { Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[0]; Action<Cell> action = (Cell cellItem) => { cellItem.Style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin; cellItem.Style.Borders[BorderType.BottomBorder].Color = System.Drawing.Color.Black; cellItem.Style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin; cellItem.Style.Borders[BorderType.TopBorder].Color = System.Drawing.Color.Black; cellItem.Style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin; cellItem.Style.Borders[BorderType.LeftBorder].Color = System.Drawing.Color.Black; cellItem.Style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin; cellItem.Style.Borders[BorderType.RightBorder].Color = System.Drawing.Color.Black; }; sheet.Name = "台帐报表"; sheet.Cells.Merge(0, 0, 1, 11); //设置高度 Cells cells = sheet.Cells; cells.SetRowHeight(0, 30); for (int i = 0; i < 11; i++) { cells.SetColumnWidth(i, 15); } Cell cell = sheet.Cells[0, 0]; cell.PutValue("台帐报表"); cell.Style.HorizontalAlignment = TextAlignmentType.Center; cell.Style.Font.Color = System.Drawing.Color.Blue; cell.Style.Font.Size = 12; cell.Style.Font.IsBold = true; action(cell); int rowIndex = 1; sheet.Cells.SetRowHeight(1, 27); sheet.Cells[rowIndex, 0].PutValue("序号"); sheet.Cells[rowIndex, 1].PutValue("产品编号"); sheet.Cells[rowIndex, 2].PutValue("产品条码"); sheet.Cells[rowIndex, 3].PutValue("产品名称"); sheet.Cells[rowIndex, 4].PutValue("数量"); sheet.Cells[rowIndex, 5].PutValue("台帐类型"); sheet.Cells[rowIndex, 6].PutValue("关联订单号"); sheet.Cells[rowIndex, 7].PutValue("原库位"); sheet.Cells[rowIndex, 8].PutValue("目标库位"); sheet.Cells[rowIndex, 9].PutValue("创建时间"); sheet.Cells[rowIndex, 10].PutValue("操作人"); for (int i = 0; i < 11; i++) { sheet.Cells[rowIndex, i].Style.Font.IsBold = true; action(sheet.Cells[rowIndex, i]); } rowIndex++; Dictionary<string, int> dic = new Dictionary<string, int>(); string tempProductNum = listResult[0].ProductNum; int index = 0; int tempIndex = 1; foreach (InventoryBookEntity item in listResult) { if (item.ProductNum == tempProductNum) { index++; } if (item.ProductNum != tempProductNum) { dic[tempProductNum] = index; index = 1; } if (listResult.Count == tempIndex) { Dictionary<string, int>.KeyCollection keys = dic.Keys; if (!keys.Exists(a => a == item.ProductNum)) { dic[item.ProductNum] = index; } } tempProductNum = item.ProductNum; tempIndex++; } index = 0; int number = 1; foreach (InventoryBookEntity t in listResult) { sheet.Cells.SetRowHeight(rowIndex, 25); sheet.Cells[rowIndex, 0].PutValue(number); if (index == 0) { index = dic[t.ProductNum]; sheet.Cells[rowIndex, 1].PutValue(t.ProductNum); sheet.Cells[rowIndex, 2].PutValue(t.BarCode); sheet.Cells[rowIndex, 3].PutValue(t.ProductName); for (int i = 1; i < 4; i++) { sheet.Cells.Merge(rowIndex, i, index, 1); sheet.Cells[rowIndex, i].Style.HorizontalAlignment = TextAlignmentType.Center; } } sheet.Cells[rowIndex, 4].PutValue(t.Num); sheet.Cells[rowIndex, 5].PutValue(EnumHelper.GetEnumDesc<EChange>(t.Type)); sheet.Cells[rowIndex, 6].PutValue(t.ContactOrder); sheet.Cells[rowIndex, 7].PutValue(t.FromLocalName); sheet.Cells[rowIndex, 8].PutValue(t.ToLocalName); sheet.Cells[rowIndex, 9].PutValue(t.CreateTime.ToString("yyyy-MM-dd")); sheet.Cells[rowIndex, 10].PutValue(t.UserName); for (int i = 0; i < 11; i++) { //sheet.Cells[rowIndex, i].Style.Font.IsBold = true; sheet.Cells[rowIndex, i].Style.Font.Size = 13; action(sheet.Cells[rowIndex, i]); } number++; rowIndex++; index--; } string filePath = Server.MapPath("~/UploadFiles/"); if (!System.IO.Directory.Exists(filePath)) { System.IO.Directory.CreateDirectory(filePath); } string filename = string.Format("台帐报表{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")); book.Save(filePath + filename); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape()); } else { this.ReturnJson.AddProperty("d", "无数据导出!"); } return Content(this.ReturnJson.ToString()); }
public ActionResult InventoryList() { string searchKey = WebUtil.GetFormValue<string>("SearchKey", string.Empty); string change = WebUtil.GetFormValue<string>("Change", string.Empty); int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 0); int pageSize = WebUtil.GetFormValue<int>("pageSize", 0); string beginTime = WebUtil.GetFormValue<string>("beginTime", string.Empty); string endTime = WebUtil.GetFormValue<string>("endTime", string.Empty); string storageNum = this.DefaultStore; InventoryProvider provider = new InventoryProvider(); InventoryBookEntity entity = new InventoryBookEntity(); if (!searchKey.IsEmpty()) { entity.Begin<InventoryBookEntity>() .Where<InventoryBookEntity>("ProductName", ECondition.Like, "%" + searchKey + "%") .Or<InventoryBookEntity>("ProductNum", ECondition.Like, "%" + searchKey + "%") .Or<InventoryBookEntity>("BarCode", ECondition.Like, "%" + searchKey + "%") .End<InventoryBookEntity>(); } if (!storageNum.IsEmpty()) { entity.Where("StoreNum", ECondition.Eth, storageNum); } if (!change.IsEmpty()) { entity.Where("Type", ECondition.Eth, change); } PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize }; List<InventoryBookEntity> listResult = provider.GetList(entity, ref pageInfo); LocationProvider locaProvider = new LocationProvider(); foreach (InventoryBookEntity item in listResult) { LocationEntity locaEntity1 = locaProvider.GetSingleByNum(item.FromLocalNum); if (locaEntity1.IsNotNull()) { item.FromLocalName = locaEntity1.LocalName; } else { item.FromLocalName = string.Empty; } LocationEntity locaEntity2 = locaProvider.GetSingleByNum(item.ToLocalNum); if (locaEntity2.IsNotNull()) { item.ToLocalName = locaEntity2.LocalName; } else { item.ToLocalName = string.Empty; } } string json = ConvertJson.ListToJson<InventoryBookEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount); return Content(this.ReturnJson.ToString()); }
public ActionResult LoadProduct([ModelBinder(typeof(JsonBinder<List<MoveOrderDetailEntity>>))] List<MoveOrderDetailEntity> List) { List<MoveOrderDetailEntity> listResult = Session[CacheKey.TEMPDATA_CACHE_MOVERODUCTDETAIL] as List<MoveOrderDetailEntity>; listResult = listResult.IsNull() ? new List<MoveOrderDetailEntity>() : listResult; if (!List.IsNullOrEmpty()) { string storageNum = this.DefaultStore; ProductProvider provider = new ProductProvider(); List<ProductEntity> listProduct = provider.GetListByCache(); LocationProvider localProvider = new LocationProvider(); List<LocationEntity> listLocals = localProvider.GetList(storageNum); foreach (MoveOrderDetailEntity item in List) { ProductEntity product = listProduct.FirstOrDefault(a => a.BarCode == item.BarCode && a.SnNum == item.ProductNum); if (product != null) { MoveOrderDetailEntity entity = new MoveOrderDetailEntity(); entity.SnNum = SequenceProvider.GetSequence(typeof(MoveOrderDetailEntity)); entity.ProductName = product.ProductName; entity.BarCode = product.BarCode; entity.ProductNum = product.SnNum; entity.BatchNum = item.BatchNum; entity.Num = item.Num; entity.InPrice = product.InPrice; entity.Amout = entity.InPrice * item.Num; entity.IsPick = (int)EBool.Yes; entity.RealNum = item.Num; entity.CreateTime = DateTime.Now; entity.StorageNum = storageNum; entity.FromLocalNum = item.FromLocalNum; entity.ToLocalNum = item.ToLocalNum; LocationEntity local = listLocals.FirstOrDefault(a => a.LocalNum == item.FromLocalNum); entity.FromLocalName = local != null ? local.LocalName : ""; local = listLocals.FirstOrDefault(a => a.LocalNum == item.ToLocalNum); entity.ToLocalName = local != null ? local.LocalName : ""; listResult.Add(entity); } } Session[CacheKey.TEMPDATA_CACHE_MOVERODUCTDETAIL] = listResult; } return Content(string.Empty); }
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> /// <param name="entity"></param> /// <returns></returns> public List<OutStoDetailEntity> GetOrderDetail(OutStoDetailEntity entity) { entity.IncludeAll(); List<OutStoDetailEntity> list = this.OutStoDetail.GetList(entity); if (!list.IsNullOrEmpty()) { List<LocationEntity> listLocation = new LocationProvider().GetList(); listLocation = listLocation == null ? new List<LocationEntity>() : listLocation; foreach (OutStoDetailEntity item in list) { LocationEntity location = listLocation.FirstOrDefault(a => a.LocalNum == item.LocalNum); item.LocalName = location == null ? "" : location.LocalName; if (item.Amount == 0) { item.Amount = item.OutPrice * item.Num; } } } return list; }
public ActionResult GetLocal() { string StorageNum = WebUtil.GetFormValue<string>("StorageNum", string.Empty); List<LocationEntity> listResult = new List<LocationEntity>(); LocationProvider provider = new LocationProvider(); if (!StorageNum.IsEmpty()) { listResult = provider.GetList(StorageNum); } string json = ConvertJson.ListToJson<LocationEntity>(listResult, "List"); this.ReturnJson.AddProperty("Data", new JsonObject(json)); this.ReturnJson.AddProperty("RowCount", listResult.Count); return Content(this.ReturnJson.ToString()); }