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