using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; using Terra.YaoGan.Common; using Terra.YaoGan.Model; namespace Terra.YaoGan.Service { public class UserInfoService { UserInfoModel info = new UserInfoModel(); public UserInfoModel GetInfo(string UserName,string Password) { info.UserName = UserName; info.PassWord = Password; string sql =string.Format("select * from UserInfo where UserName='{0}' and PassWord='{1}'",UserName,Password); sqlserverDBhelper db = new sqlserverDBhelper(); DataTable dt=db.QueryTable(sql); if (dt.Rows.Count > 0) { info.State = dt.Rows[0]["State"].ToString(); return info; }else { return null; } } public UserInfoModel CheckuserInfo(string UserName, string Password) { //验证登陆信息 string userName =MD5EnDe.MD5Decrypt(UserName); string passWord =MD5EnDe.MD5Decrypt(Password); return GetInfo(userName, passWord); } } }