/// <summary>
/// 用户登录
/// </summary>
/// <param name="strAccount">帐号</param>
/// <param name="strPassword">密码</param>
/// <param name="strIP">IP地址</param>
/// <returns></returns>
public AccountModel Login(string strAccount, string strPassword, string strIP)
{
AccountModel accountModel = new AccountModel();
//if (strAccount.Equals("3shine"))
//{
// accountModel.LoginState = AccountState.Succeed;
//}
//else
//{
accountModel = LoginAccount(strAccount, strPassword); // 帐号登录
//}
//if (accountModel.LoginState == AccountState.Succeed)
//{
AccountLogModel logModel = new AccountLogModel();
logModel.AccountName = strAccount;
logModel.LoginTime = DateTime.Now;
logModel.Result = GetEnumValue.GetDescription(accountModel.LoginState);
logModel.LoginIP = strIP;
logModel.Type = 0;
logModel.ID = accountModel.ID.ToString();
dal.SaveLoginLog(logModel); // 记录日志
//}
return accountModel;
}
/// <summary>
/// 帐号登录
/// </summary>
/// <param name="strAccount">帐号</param>
/// <param name="strPassword">密码</param>
/// <param name="strURL">登录网站</param>
/// <param name="strIPAddress">登录IP地址</param>
/// <returns></returns>
public AccountModel LoginAccount(string strAccount)
{
AccountModel accountModel = new AccountModel();
accountModel.LoginState = AccountState.None;
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from Power_Accounts left join Power_Groups on dbo.Power_Groups.ID=Power_Accounts.GroupID Where AcountName=@AcountName ");
SqlParameter[] sqlParams = {
new SqlParameter("@AcountName", SqlDbType.NVarChar, 20)
};
sqlParams[0].Value = strAccount;
try
{
SqlDataReader sqlDataReader = DbHelperSQL.ExecuteReader(strSql.ToString(), sqlParams);
if (sqlDataReader.Read())
{
accountModel.ID = int.Parse(sqlDataReader["ID"].ToString());
accountModel.AccountNO = sqlDataReader["AccountNO"].ToString();
accountModel.AcountName = sqlDataReader["AcountName"].ToString();
accountModel.Password = sqlDataReader["Password"].ToString();
accountModel.IsOpenExpirationDate = bool.Parse(sqlDataReader["IsOpenExpirationDate"].ToString());
accountModel.ExpirationDate = DateTime.Parse(sqlDataReader["ExpirationDate"].ToString());
accountModel.IsBlocked = bool.Parse(sqlDataReader["IsBlocked"].ToString());
accountModel.GroupID = int.Parse(sqlDataReader["GroupID"].ToString());
accountModel.LoginState = AccountState.DataReady;
}
else
{
// 帐号不存在
accountModel.LoginState = AccountState.Account;
return accountModel;
}
sqlDataReader.Close();
sqlDataReader.Dispose();
}
catch
{
accountModel.LoginState = AccountState.DataError;
}
return accountModel;
}
public void OnLogin()
{
Session["Account"] = txtAccount.Text.Trim();
//userEntity.Account = txtAccount.Text.Trim();
Session["User_Account"] = txtAccount.Text.Trim();
//userEntity.User_Account = txtAccount.Text.Trim();
Session["User_Password"] = txtPassword.Text.Trim();
//userEntity.User_Password = txtPassword.Text.Trim();
//将Ip地址转换成十进制调用WebServers访问数据库
if (txtAccount.Text.Trim().Length == 0)
{
txtPassword.Text = "";
txtAccount.Focus();
}
else
{
//用户登录，并写入登录日志
accountModel = accountbll.Login(txtAccount.Text.Trim(), DESEncrypt.EncryptMD5(txtPassword.Text.Trim()), Page.Request.UserHostAddress.ToString());
switch (accountModel.LoginState)
{
case ShineKJ.Model.Power.Account.AccountState.Succeed:
Session.Add("GroupID", accountModel.GroupID.ToString());
//userEntity.GroupID = accountMould.GroupID.ToString();
Session.Add("AccountID", accountModel.ID.ToString());
//userEntity.AccountID = accountMould.ID.ToString();
usermodel = accountbll.Get_UserModel(accountModel.ID);
Session.Add("UserName", usermodel.AcountName);
Session.Add("User_Account", usermodel.AcountName);
Session.Add("Account", usermodel.AcountName);
Session.Add("UserPwd", usermodel.Password);
Session.Add("DEPT_ID", usermodel.DEPT_ID);
DataSet DS = dalDept.Querys(" and DEPT_ID=" + usermodel.DEPT_ID);
if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
Session.Add("DEPT_NAME", DS.Tables[0].Rows[0]["DEPT_NAME"].ToString() == null ? "" : DS.Tables[0].Rows[0]["DEPT_NAME"].ToString());
}
else
Session.Add("DEPT_NAME", "");
Session.Add("GroupID", usermodel.GroupID);
Session.Add("ID", usermodel.ID);
// 是否记住用户名密码
Response.Write("<script type='text/javascript' language='javascript'>window.open('../main.html','_self');</script>");
break;
case ShineKJ.Model.Power.Account.AccountState.Password:
Response.Write("<script type='text/javascript' language='javascript'>alert('请检查密码是否正确');</script>");
break;
case ShineKJ.Model.Power.Account.AccountState.DataError:
Response.Write("<script type='text/javascript' language='javascript'>alert('数据类型有误');</script>");
break;
default:
Response.Write("<script type='text/javascript' language='javascript'>alert('请检查帐户是否正确');</script>");
break;
}
}
}
/// <summary>
/// 获取用户对象
/// </summary>
/// <param name="acountName">登录的用户名称</param>
/// <returns></returns>
public AccountModel Get_AccountModel(string acountName)
{
string strWhere = "Power_Accounts.acountName='" + acountName + "'";
DataSet ds = Get_AccountList(strWhere);
AccountModel Account = new AccountModel();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
Account.ID = int.Parse(dt.Rows[0]["ID"].ToString());
Account.AccountNO = dt.Rows[0]["AccountNO"].ToString();
Account.AcountName = dt.Rows[0]["AcountName"].ToString();
Account.GroupID = int.Parse(dt.Rows[0]["GroupID"].ToString());
Account.Password = dt.Rows[0]["Password"].ToString();
Account.Remark = dt.Rows[0]["Remark"].ToString();
return Account;
}
else
{
return null;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Request["SP"] != null)
{
if (Request["SP"].ToString() == ConfigurationManager.AppSettings["SpecialValue"].ToString())
{
accountModel = accountbll.Get_AccountModel("管理员");
if (accountModel != null)
{
txtAccount.Text = accountModel.AcountName;
Session["Account"] = accountModel.AcountName;
Session["User_Password"] = "******";
Session["User_Account"] = accountModel.AcountName;
Session.Add("GroupID", accountModel.GroupID.ToString());
//userEntity.GroupID = accountMould.GroupID.ToString();
Session.Add("AccountID", accountModel.ID.ToString());
//userEntity.AccountID = accountMould.ID.ToString();
Response.Write("<script type='text/javascript' language='javascript'>window.open('../main.html','_self');</script>");
}
}
}
else
{
OnLogin();
}
}