/// <summary> /// 供应商用户登录 /// </summary> /// <param name="supplierNum"></param> /// <param name="userName"></param> /// <param name="password"></param> /// <param name="message"></param> /// <returns></returns> public static SupplierUser Sign(string userName, string password, out string message) { SupplierUser user = GetUserByLoginName(userName); //供应商用户不存在包括: 1)用户不存在 2)用户类型表明非供应商用户 3)该供应商下无该用户 if (user == null) { message = "该供应商用户不存在!"; return(null); } else if (user.UserStatus != 1) { message = "该用户已被锁定!"; return(null); } else if (user.Password != password) { if (++user.FailLogin == 3) { user.UserStatus = 2; } message = "密码不正确!"; return(null); } else { message = ""; if (user.FailLogin > 0) { user.FailLogin = 0; } return(user); } }
/// <summary> /// 创建供应商-用户关联实体 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static SupplierUser CreateSupplierUser(IDataReader rdr) { SupplierUser info = new SupplierUser(); info.UserID = rdr.GetInt32(0); info.LoginName = rdr.GetString(1); info.Password = rdr.GetString(2); info.EmployeeName = rdr.GetString(3); info.PasswordExpireTime = rdr.GetDateTime(4); info.UserStatus = rdr.GetInt32(5); info.FailLogin = rdr.GetInt32(6); info.SupplierNum = rdr.GetString(7); info.SupplierName = rdr.GetString(8); info.SupplierType = rdr.GetInt32(9); info.SupplierAddress = rdr.GetString(10); return(info); }