public async Task <FileResult> GetOneMallImage(int MallImageId) { MallImageViewModel onePC = await IMR.GetOneMallImage(MallImageId); if (onePC == null) { return(null); } return(File(onePC.PictureContent, onePC.PictureType)); }
public async Task <MallImageViewModel> GetOneMallImage(int MallImageId) { MallImageViewModel ret = null; try { using (SqlConnection con = new SqlConnection(constr)) { var p = new DynamicParameters(); p.Add("@MallImageId", MallImageId, dbType: DbType.Int32, direction: ParameterDirection.Input); p.Add("@r", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue); await con.OpenAsync(); IEnumerable <MallImageViewModel> tmp = await con.QueryAsync <MallImageViewModel>("sp_GetOneMallImage", p, commandType : CommandType.StoredProcedure); ret = tmp.FirstOrDefault <MallImageViewModel>(); } } catch (Exception) { ret = null; } return(ret); }