/// <summary>
/// 修改用户
/// </summary>
/// <param name="Account">用户实体对象</param>
/// <returns></returns>
public int Update_Account(UserModel user)
{
return dal.Update_Account(user);
}
/// <summary>
/// 添加账号
/// </summary>
/// <param name="Group">账号对象</param>
/// <returns></returns>
public int Insert_Account(UserModel user)
{
return dal.Insert_Account(user);
}
/// <summary>
/// 获取用户对象
/// </summary>
/// <param name="acountName">用户编号</param>
/// <returns></returns>
public UserModel Get_UserModel(int ID)
{
string strWhere = "Power_Accounts.ID=" + ID;
DataSet ds = Get_AccountList(strWhere);
UserModel user = new UserModel();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
user.ID = int.Parse(dt.Rows[0]["ID"].ToString());
user.AccountNO = dt.Rows[0]["AccountNO"].ToString();
user.AcountName = dt.Rows[0]["AcountName"].ToString();
user.TrueName = dt.Rows[0]["TrueName"].ToString();
user.GroupID = int.Parse(dt.Rows[0]["GroupID"].ToString());
user.DEPT_ID = int.Parse(dt.Rows[0]["DEPT_ID"].ToString());
user.Remark = dt.Rows[0]["Remark"].ToString();
user.BYNAME = dt.Rows[0]["BYNAME"].ToString();
user.Sex = bool.Parse(dt.Rows[0]["Sex"].ToString());
user.BIRTHDAY = dt.Rows[0]["BIRTHDAY"].ToString().Equals("") ? DateTime.Parse("1900-01-01 00:00:00") : DateTime.Parse(dt.Rows[0]["BIRTHDAY"].ToString());
user.MOBIL_NO = dt.Rows[0]["MOBIL_NO"].ToString();
user.MOBIL_NO_HIDDEN = bool.Parse(dt.Rows[0]["MOBIL_NO_HIDDEN"].ToString());
return user;
}
else
{
return null;
}
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="Account">用户实体对象</param>
/// <returns></returns>
public int Update_Account(UserModel user)
{
SqlParameter[] paras =
{
new SqlParameter("@ID",SqlDbType.Int),
new SqlParameter("@TrueName",SqlDbType.NVarChar,20),
new SqlParameter("@AccountNO",SqlDbType.NVarChar,20),
new SqlParameter("@GroupID",SqlDbType.Int),
new SqlParameter("@DEPT_ID",SqlDbType.Int),
new SqlParameter("@Remark",SqlDbType.NVarChar,500),
new SqlParameter("@BYNAME",SqlDbType.NVarChar,20),
new SqlParameter("@Sex",SqlDbType.Bit),
new SqlParameter("@BIRTHDAY",SqlDbType.DateTime),
new SqlParameter("@MOBIL_NO",SqlDbType.NVarChar,50),
new SqlParameter("@MOBIL_NO_HIDDEN",SqlDbType.Bit),
};
paras[0].Value = user.ID;
paras[1].Value = user.TrueName;
paras[2].Value = user.AccountNO;
paras[3].Value = user.GroupID;
paras[4].Value = user.DEPT_ID;
paras[5].Value = user.Remark;
paras[6].Value = user.BYNAME;
paras[7].Value = user.Sex;
paras[8].Value = user.BIRTHDAY;
paras[9].Value = user.MOBIL_NO;
paras[10].Value = user.MOBIL_NO_HIDDEN;
try
{
int iReturn;
int i = DbHelperSQL.RunProcedure("Power_Update_Account", paras, out iReturn);
return iReturn;
}
catch
{
return -1;
}
}
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;
}
}
}