/// <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 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 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 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()); }