Пример #1
0
        /// <summary>
        /// C用户 用户登录
        /// </summary>
        /// <param name="loginInfo">登录账户</param>
        /// <returns>用户信息</returns>
        public UserViewModel UserLogin(UserLoginInfo loginInfo)
        {
            const string sql = @"select a.*,b.provname,c.cityname,d.countyname from user_info as a
                left join base_province as b on a.provid=b.innerid
                left join base_city as c on a.cityid=c.innerid
                left join base_county as d on a.countyid=d.innerid where a.mobile=@mobile and a.password=@password;";

            try
            {
                var model = Helper.Query<UserViewModel>(sql, new
                {
                    mobile = loginInfo.Mobile,
                    password = loginInfo.Password
                }).FirstOrDefault();
                return model;
            }
            catch (Exception ex)
            {
                LoggerFactories.CreateLogger().Write("C用户获取会员详情1:", TraceEventType.Error, ex);
                return null;
            }
        }