using IWareDataAccess.EF;
|
using IWareDataAccess.Entity.Sys;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace IWareDataAccess.Sys.USER
|
{
|
public static class UserSqlFunc
|
{
|
/// <summary>
|
/// 登录
|
/// </summary>
|
/// <param name="userName"></param>
|
/// <param name="password"></param>
|
/// <returns></returns>
|
public static View_SYS_USER Login(string userName, string password, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
if (string.IsNullOrEmpty(userName))
|
{
|
msg = "请输入用户";
|
return null;
|
}
|
if (string.IsNullOrEmpty(password))
|
{
|
msg = "请输入密码";
|
return null;
|
}
|
|
//var psd= Helper.Helper.ParseMd5(password);
|
|
var user = edm.View_SYS_USER.FirstOrDefault(x => x.userName == userName);
|
if (user != null)
|
{
|
if (user.passWord != password)
|
{
|
msg = "输入密码不正确";
|
return null;
|
}else
|
{
|
|
return user;
|
}
|
}
|
else
|
{
|
msg = "输入用户不存在";
|
return null;
|
}
|
|
}
|
}
|
}
|
}
|