/// <summary> /// 查询借用的资产信息,通过扫码添加时用到 /// </summary> /// <param name="LocationID">区域编号</param> /// <param name="SN">序列号</param> /// <param name="UserID">用户名称</param> /// <returns></returns> public DataTable GetBorrowedAssEx(string LocationID, string SN, string UserID) { int status = (int)STATUS.借用中; var result = _AssetsRepository.GetAssByStatusEx(LocationID, SN, UserID, status); var dtos = Mapper.Map <List <Assets>, List <AssSelectOutputDto> >(result.ToList()); foreach (var dto in dtos) { dto.IsChecked = false; } return(LINQToDataTable.ToDataTable(dtos)); }
/// <summary> /// 查询借用的资产信息,通过扫码添加时用到 /// </summary> /// <param name="LocationID">区域编号</param> /// <param name="SN">序列号</param> /// <param name="UserID">用户名称</param> /// <returns></returns> public DataTable GetBorrowedAssEx(string LocationID, string SN, string UserID) { int status = (int)STATUS.借用中; var result = _AssetsRepository.GetAssByStatusEx(LocationID, SN, UserID, status); var ass = from assetse in result join user in SMOSECDbContext.coreUsers on assetse.CURRENTUSER equals user.USER_ID select new AssSelectOutputDto() { IsChecked = false, IMAGE = assetse.IMAGE, NAME = assetse.IMAGE, ASSID = assetse.ASSID, SN = assetse.SN, USERNAME = user.USER_NAME }; return(LINQToDataTable.ToDataTable(ass)); }
/// <summary> /// 查询借用的资产信息,通过扫码添加时用到 /// </summary> /// <param name="LocationID">区域编号</param> /// <param name="SN">序列号</param> /// <param name="UserID">用户名称</param> /// <returns></returns> public DataTable GetBorrowedAssEx(string SN) { int status = 3; var result = _AssetsRepository.GetAssByStatusEx(SN, status); //var ass = from assetse in result // join user in SMOSECDbContext.Userman on assetse.use_man_id equals user.id // select new AssSelectOutputDto() // { // IsChecked = false, // //IMAGE = assetse.IMAGE, // //NAME = assetse.IMAGE, // ASSID = assetse.uuid, // SN = assetse.sn, // USERNAME = user.name // }; return(LINQToDataTable.ToDataTable(result)); }