Esempio n. 1
0
        public async Task <FileResult> GetOneMallImage(int MallImageId)
        {
            MallImageViewModel onePC = await IMR.GetOneMallImage(MallImageId);

            if (onePC == null)
            {
                return(null);
            }
            return(File(onePC.PictureContent, onePC.PictureType));
        }
Esempio n. 2
0
        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);
        }