Esempio n. 1
0
        public ResultModel LoadDetailAuth(UserModel user,int styleId,NFMT.Common.IAuthority auth)
        {
            ResultModel result = new ResultModel();

            SqlDataReader dr = null;
            try
            {
                result = auth.CreateAuthorityStr(user);
                if (result.ResultStatus != 0)
                    return result;

                string cmdText = string.Format("select * from dbo.BDStyleDetail sd where sd.BDStyleId={0} {1}", styleId, result.ReturnValue.ToString());

                dr = SqlHelper.ExecuteReader(ConnectString, CommandType.Text, cmdText, null);
                List<Model.BDStyleDetail> models = new List<Model.BDStyleDetail>();

                int i = 0;
                while (dr.Read())
                {
                    Model.BDStyleDetail model = this.CreateModel<Model.BDStyleDetail>(dr);
                    models.Add(model);
                    i++;
                }

                result.AffectCount = i;
                result.Message = "获取列表成功";
                result.ResultStatus = 0;
                result.ReturnValue = models;
            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }
            finally
            {
                if (dr != null)
                    dr.Dispose();
            }
            return result;
        }