/// <summary>
/// 用户登录判断
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="userPwd">密码(MD5)</param>
/// <param name="sIP">浏览器IP</param>
/// <param name="sBrowser">浏览器类型</param>
/// <returns></returns>
public ManageUserModel Login(string userName, string userPwd, string sIP, string sBrowser)
{
Sys_Manage_User manageUser = new Sys_Manage_User();
ManageUserModel AccModel = new ManageUserModel();
AccModel.LoginStatus = false;
string sPassWord = "";
StringBuilder strSql = new StringBuilder();
strSql.Append("select top(1) Id,UserName,P_session,LoginCounter,phone,name,PassWord,MenuPermission from Sys_Manage_User where [state]=1 and UserName=@userName;");
manageUser = DapperHelper.GetModel <Sys_Manage_User>(strSql.ToString(), new { userName = userName });
if (manageUser != null)
{
AccModel.UserID = manageUser.Id;
AccModel.UserName = manageUser.UserName;
AccModel.PowerSession = Convert.ToInt32(manageUser.P_session);
AccModel.LoginCnt = Convert.ToInt32(manageUser.LoginCounter);
AccModel.Phone = manageUser.phone;
AccModel.Name = manageUser.name;
AccModel.MenuPermission = manageUser.MenuPermission;
sPassWord = manageUser.PassWord;
//判断是否一致
if (sPassWord == userPwd)
{
//登录成功
AccModel.LoginStatus = true;
Sys_ManageLogDAL logDal = new Sys_ManageLogDAL();
logDal.LoginLog(AccModel.UserID, sIP, sBrowser);
}
}
return(AccModel);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Sys_Manage_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Manage_User set ");
strSql.Append(" UserName = @UserName , ");
strSql.Append(" PassWord = @PassWord , ");
strSql.Append(" P_session = @P_session , ");
strSql.Append(" LoginCounter = @LoginCounter , ");
strSql.Append(" LastLoginTime = @LastLoginTime , ");
strSql.Append(" phone = @phone , ");
strSql.Append(" name = @name , ");
strSql.Append(" simcard = @simcard , ");
strSql.Append(" state = @state , ");
strSql.Append(" WeixinOpenid = @WeixinOpenid , ");
strSql.Append(" WeiXinType = @WeiXinType ");
strSql.Append(" where Id=@Id ");
int row = DapperHelper.Execute(strSql.ToString(), model);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加账号
/// </summary>
/// <param name="account"></param>
/// <param name="pw"></param>
/// <param name="name"></param>
/// <param name="phone"></param>
/// <param name="session"></param>
/// <returns></returns>
public static int AddManageUser(string account, string pw, string name, string phone, int session)
{
Sys_Manage_User model = new Sys_Manage_User();
model.UserName = account;
model.PassWord = CommonLib.Helper.Md5Hash(pw);
model.P_session = session;
model.LoginCounter = 0;
model.LastLoginTime = DateTime.Now;
model.phone = phone;
model.name = name;
model.simcard = "";
model.state = 1;
model.WeiXinType = 0;
model.Id = BLL.Base.Sys_Manage_UserBaseBLL.Add(model);
return(model.Id);
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Sys_Manage_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_Manage_User(");
strSql.Append("UserName,PassWord,P_session,LoginCounter,LastLoginTime,phone,name,simcard,state,WeixinOpenid,WeiXinType");
strSql.Append(") values (");
strSql.Append("@UserName,@PassWord,@P_session,@LoginCounter,@LastLoginTime,@phone,@name,@simcard,@state,@WeixinOpenid,@WeiXinType");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
object obj = DapperHelper.ExecuteScalar(strSql.ToString(), model);
if (obj != null)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
/// <summary>
/// 得到一个账号信息
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public ManageUserModel GetManageUserModel(int uid)
{
Sys_Manage_User manageUser = new Sys_Manage_User();
ManageUserModel AccModel = new ManageUserModel();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top(1) Id,UserName,P_session,LoginCounter,phone,name,PassWord,MenuPermission from Sys_Manage_User where [state]=1 and Id=@uid;");
manageUser = DapperHelper.GetModel <Sys_Manage_User>(strSql.ToString(), new { uid = uid });
if (manageUser != null)
{
AccModel.UserID = manageUser.Id;
AccModel.UserName = manageUser.UserName;
AccModel.PowerSession = Convert.ToInt32(manageUser.P_session);
AccModel.LoginCnt = Convert.ToInt32(manageUser.LoginCounter);
AccModel.Phone = manageUser.phone;
AccModel.Name = manageUser.name;
AccModel.MenuPermission = manageUser.MenuPermission;
}
return(AccModel);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(Sys_Manage_User model)
{
Sys_Manage_UserBaseDAL dal = new Sys_Manage_UserBaseDAL();
return(dal.Update(model));
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(Sys_Manage_User model)
{
Sys_Manage_UserBaseDAL dal = new Sys_Manage_UserBaseDAL();
return(dal.Add(model));
}
