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);
|
}
|
|
|
|
}
|
}
|