public ActionResult RepairAssign()
{
using (var db = new LcSoft.Models.DbContext())
{
var vm = new Asset.Models.AssetRepair.List();
var Users = (from p in db.Table <Sys.Entity.tbSysUserRole>().Include(d => d.tbSysUser)
where p.tbSysRole.RoleCode == Code.EnumHelper.SysRoleCode.Repair
select new Code.MuiJsonDataBind
{
text = p.tbSysUser.UserName,
value = p.tbSysUser.Id.ToString()
});
vm.AssetTypeListJson = JsonConvert.SerializeObject(Users);
var tb = (from p in db.Table <Asset.Entity.tbAssetRepair>() where p.AssetRepairStatusCode == Code.EnumHelper.AssetRepair.UnProcessed select p).Include(m => m.tbAsset.tbAssetCatalog.tbAssetType).Include(m => m.tbAssetRepairLevel).Include(m => m.tbProcessUser).Include(m => m.tbSysUser);
vm.AssetRepairList = (from p in tb
select new Asset.Dto.AssetRepair.List()
{
AssetName = p.tbAsset.AssetName,
AssetCatalogName = p.tbAsset.tbAssetCatalog.AssetCatalogName,
AssetRepairStatusCode = p.AssetRepairStatusCode,
Id = p.Id,
InputDate = p.InputDate,
AssetRepairLevelName = p.tbAssetRepairLevel.AssetRepairLevelName,
ProcessUser = p.tbProcessUser.UserName,
CreateUser = p.tbSysUser.UserName,
//CreateUserId = p.tbSysUser.Id,
//ProcessUserId = p.tbProcessUser.Id,
Remark = p.Remark,
FileName = p.FileName
}).ToList();
return(View(vm));
}
}
public ActionResult AssetRepairIndex(Asset.Models.AssetRepair.List vm)
{
using (var db = new LcSoft.Models.DbContext())
{
var tb = (from p in db.Table <Areas.Asset.Entity.tbAssetRepair>() select p)
.Include(m => m.tbAsset.tbAssetCatalog.tbAssetType)
.Include(m => m.tbAssetRepairLevel)
.Include(m => m.tbProcessUser)
.Include(m => m.tbSysUser);
tb = tb.Where(m => m.tbSysUser.Id == Code.Common.UserId || m.tbProcessUser.Id == Code.Common.UserId);//申请人或者受理人只看自己的数据
var types = (from p in db.Table <Areas.Asset.Entity.tbAssetType>()
select new Code.MuiJsonDataBind
{
text = p.AssetTypeName,
value = p.Id.ToString()
});
vm.AssetTypeListJson = JsonConvert.SerializeObject(types);
if (string.IsNullOrEmpty(vm.SubmitDate) == false && vm.SubmitDate != "0")
{
var date = Convert.ToDateTime(vm.SubmitDate);
tb = tb.Where(m => m.InputDate >= date);
}
if (vm.Statu != null && vm.Statu > 0)
{
tb = tb.Where(m => m.AssetRepairStatusCode == (Code.EnumHelper.AssetRepair)vm.Statu);
}
if (vm.AssetTypeId != null && vm.AssetTypeId != 0)
{
tb = tb.Where(m => m.tbAsset.tbAssetCatalog.tbAssetType.Id == vm.AssetTypeId);
}
vm.AssetRepairList = (from p in tb
join a in db.Table <Areas.Asset.Entity.tbAssetRepairAppraise>() on p.Id equals a.tbAssetRepair.Id into g
from x in g.DefaultIfEmpty()
select new Asset.Dto.AssetRepair.List()
{
AssetName = p.tbAsset.AssetName,
AssetCatalogName = p.tbAsset.tbAssetCatalog.AssetCatalogName,
AssetRepairStatusCode = p.AssetRepairStatusCode,
Id = p.Id,
InputDate = p.InputDate,
AcceptDate = p.AcceptDate,
CompleteDate = p.CompleteDate,
AssetRepairLevelName = p.tbAssetRepairLevel.AssetRepairLevelName,
ProcessUser = p.tbProcessUser.UserName,
CreateUser = p.tbSysUser.UserName,
CreateUserId = p.tbSysUser.Id,
ProcessUserId = p.tbProcessUser == null ? 0 : p.tbProcessUser.Id,
Remark = p.Remark,
FileName = p.FileName,
IsAppraise = x != null
//IsAppraise = db.Table<Entity.tbAssetRepairAppraise>().Where(m=>m.tbAssetRepair.Id == p.Id).FirstOrDefault() != null
}).ToList();
if (Request.IsAjaxRequest())
{
return(PartialView("PList", vm));
}
return(View(vm));
}
}
