/// <summary> /// 得到盘点单列表 /// </summary> /// <param name="LocationId">区域编号</param> /// <returns></returns> public DataTable GetConInventoryList(string UserId, string LocationId) { var area = _conInventoryRepository.GetAll(); if (!string.IsNullOrEmpty(LocationId)) { area = area.Where(a => a.LOCATIONID == LocationId); } if (!string.IsNullOrEmpty(UserId)) { area = area.Where(a => a.HANDLEMAN == UserId); } var list = from conInventory in area join user in _SMOSECDbContext.coreUsers on conInventory.HANDLEMAN equals user.USER_ID orderby conInventory.CREATEDATE descending select new ConInventoryListOutputDto() { IID = conInventory.IID, NAME = conInventory.NAME, CREATEDATE = conInventory.CREATEDATE, CREATEUSER = user.USER_NAME, TOTAL = conInventory.TOTAL, RESULTCOUNT = conInventory.RESULTCOUNT, STATUS = conInventory.STATUS, STATUSNAME = "", CanStart = "", CanEdit = "", CanDelete = "", Time = "" }; var temTable = LINQToDataTable.ToDataTable(list); foreach (DataRow row in temTable.Rows) { int status = int.Parse(row["STATUS"].ToString()); row["STATUSNAME"] = Enum.GetName(typeof(InventoryStatus), status); switch (status) { case (int)InventoryStatus.盘点未开始: row["CanStart"] = "开始盘点"; row["CanDelete"] = "删除"; row["CanEdit"] = "编辑"; break; case (int)InventoryStatus.盘点中: row["CanStart"] = "开始盘点"; break; } row["Time"] = DateTime.Parse(row["CREATEDATE"].ToString()).ToShortDateString(); } return(temTable); }
/// <summary> /// 得到盘点单列表 /// </summary> /// <param name="UserId"></param> /// <param name="WAREID"></param> /// <returns></returns> public DataTable GetConInventoryList(string UserId, string WAREID) { var area = _conInventoryRepository.GetAll(); if (!string.IsNullOrEmpty(WAREID)) { area = area.Where(a => a.WAREID == WAREID); } if (!string.IsNullOrEmpty(UserId)) { area = area.Where(a => a.HANDLEMAN == UserId); } var list = from conInventory in area join user in _SMOWMSDbContext.coreUsers on conInventory.HANDLEMAN equals user.USER_ID orderby conInventory.CREATEDATE descending select new ConInventoryListOutputDto() { IID = conInventory.IID, NAME = conInventory.NAME, CREATEDATE = conInventory.CREATEDATE, CREATEUSER = user.USER_NAME, CREATEUSERNAME = "", TOTAL = conInventory.TOTAL, RESULTCOUNT = conInventory.RESULTCOUNT, COUNT = "", STATUS = conInventory.STATUS, STATUSNAME = "", Time = "" }; var temTable = LINQToDataTable.ToDataTable(list); foreach (DataRow row in temTable.Rows) { int status = int.Parse(row["STATUS"].ToString()); row["CREATEUSERNAME"] = row["CREATEUSER"].ToString()[0]; row["STATUSNAME"] = Enum.GetName(typeof(InventoryStatus), status); row["COUNT"] = row["RESULTCOUNT"] + "/" + row["TOTAL"];; row["Time"] = string.Format("{0:yyyy.MM.dd}", row["CREATEDATE"]); } return(temTable); }