protected void GetUser(int id) { BLL.BASE_USERGROUP ugbll = new BLL.BASE_USERGROUP(); DataView dvList = new DataView(ugbll.GetUserGroupList("").Tables[0]); LoadGroupList("0", 0, dvList); BLL.BASE_USER bll = new BLL.BASE_USER(); Entity.BASE_USER model = new Entity.BASE_USER(); model = bll.GetUserModel(id); uid.Text = id.ToString(); txt_name.Text = model.UserName; GroupList.SelectedValue = model.UserGroup.ToString(); txt_email.Text = model.Email; StateList.SelectedValue = model.Status.ToString(); Lab_time1.Text = model.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"); ArrayList rid = model.RoleID; for (int i = 0; i < rid.Count; i++) { string[] r = rid[i].ToString().Split(','); RoleList.Items.Add(new ListItem(r[1], r[0])); } //string stime = model.LastLoginTime.ToString("yyyy-MM-dd HH:mm:ss"); //if (stime != "0001-01-01 00:00:00") //{ // Lab_time2.Text = stime; //} }
public Entity.BASE_USER GetUser(string username, string pwd) { Entity.BASE_USER model = new Entity.BASE_USER(); var dt = dal.GetList(string.Format("USERNAME='******' AND USERPWD='{1}'", username, pwd)).Tables[0]; if (dt != null && dt.Rows.Count != 0) { model.BIRTHDAY = (DateTime)dt.Rows[0]["BIRTHDAY"]; model.DEGREE = dt.Rows[0]["DEGREE"].ToString(); model.DEPTID = Convert.ToInt32(dt.Rows[0]["DEPTID"].ToString()); model.FACE = dt.Rows[0]["FACE"].ToString(); model.IDNUMBER = dt.Rows[0]["IDNUMBER"].ToString(); model.JOBNUMBER = dt.Rows[0]["JOBNUMBER"].ToString(); model.PARENTID = Convert.ToInt32(dt.Rows[0]["PARENTID"].ToString()); model.PHONE = dt.Rows[0]["PHONE"].ToString(); model.PHOTO = dt.Rows[0]["PHOTO"].ToString(); model.PROF = dt.Rows[0]["PROF"].ToString(); model.REMARK = dt.Rows[0]["REMARK"].ToString(); model.SEX = Convert.ToInt32(dt.Rows[0]["SEX"].ToString()); model.STSTUS = Convert.ToInt32(dt.Rows[0]["STSTUS"].ToString()); model.USERID = Convert.ToInt32(dt.Rows[0]["USERID"].ToString()); model.USERNAME = dt.Rows[0]["USERNAME"].ToString(); model.USERPWD = dt.Rows[0]["USERPWD"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 创建一个新用户 /// </summary> /// <param name="model"></param> /// <returns></returns> public int CreateUser(Entity.BASE_USER model) { int ret = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Base_User("); strSql.Append("UserName,Password,Email,UserGroup,CreateTime,IsLimit)"); strSql.Append(" values ("); strSql.Append("@UserName,@Password,@Email,@UserGroup,@CreateTime,@IsLimit)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 128), new SqlParameter("@Password", SqlDbType.NVarChar, 128), new SqlParameter("@Email", SqlDbType.NVarChar, 100), new SqlParameter("@UserGroup", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@IsLimit", SqlDbType.Bit, 1) }; parameters[0].Value = model.UserName; parameters[1].Value = model.Password; parameters[2].Value = model.Email; parameters[3].Value = model.UserGroup; parameters[4].Value = DateTime.Now; parameters[5].Value = model.IsLimit; object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters); if (obj != null) { ret = int.Parse(obj.ToString()); } return(ret); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string _action = Request.QueryString["action"]; string _deptName = Request.QueryString["deptname"]; string _deptId = Request.QueryString["deptid"]; switch (_action) { case "add": this.LabName.Text = "添加单位用户信息"; ViewState["action"] = "ADD"; txtUnit.Text = _deptName; hfdUnitId.Value = _deptId; break; case "update": this.LabName.Text = "编辑单位用户信息"; ViewState["action"] = "EDIT"; string _userId = Request.QueryString["userid"]; txtUnit.Text = new BASE_DEPT().GetEntity(decimal.Parse(_deptId)).DPTNAME; hfdUnitId.Value = _deptId; int userid = Convert.ToInt32(_userId); ViewState["USERID"] = userid.ToString(); Entity.BASE_USER model = bll.GetUser(userid); SetEntity(model); break; } } }
/// <summary> /// 初始化信息实体 /// </summary> /// <returns></returns> private Entity.BASE_USER GetEntity() { Entity.BASE_USER model = new Entity.BASE_USER(); #region 需要字段 //model.USERID = Convert.ToDecimal(this.hidPrimary.Value); //主键,用户ID编号 //model.BIRTHDAY = DateTime.Parse(txtBIRTHDAY.Text); //model.DEGREE = txtDEGREE.Text; //DropDownList ddr = (DropDownList)this.Department1.FindControl("ddlDepartment");//找到用户控件中的子控件 //model.FACE = txtFACE.Text; //政治面貌 //model.IDNUMBER = txtIDNUMBER.Text; //身份证号码 //model.PROF = txtPROF.Text; //专业 //model.SEX = Convert.ToInt32(ddlSex.SelectedValue); //性别 //model.PHOTO = this.fileupPhoto.FileName; //人员照片 #endregion model.DEPTID = Convert.ToInt32(hfdUnitId.Value); model.JOBNUMBER = txtJOBNUMBER.Text; //工作证号 model.PHONE = txtPhone.Text; //联系电话 model.REMARK = txtRemark.Text; //备注 model.USERNAME = txtUserName.Text; //用户账号 model.USERPWD = Smart.Security.Encrypter.Encrypt(txtPassword.Text, ConfigurationManager.AppSettings["EncryptKey"]); //用户密码 model.STSTUS = 0; //状态 model.PARENTID = 0; //用户父ID编号(用于多个子账户) model.REALNAME = this.TxtRealName.Text; //真实姓名 return(model); }
/// <summary> /// 创建一个新用户 /// </summary> /// <param name="model"></param> /// <returns></returns> public int CreateUser(Entity.BASE_USER model) { if (!UserExists(model.UserName)) { return(dal.CreateUser(model)); } else { return(2); } }
/// <summary> /// 修改用户 /// </summary> /// <param name="model"></param> /// <returns></returns> private void Updatestate(int id) { Entity.BASE_USER model = bll.GetUser(id); model.STSTUS = 1; if (bll.Update(model)) { AjaxAlert(this.UpdatePanel1, "删除成功!"); } else { AjaxAlert(this.UpdatePanel1, "删除失败!"); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Entity.BASE_USER entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Base_User("); strSql.Append("UserName,Password,Email,Question,Answer,RoleID,UserGroup,CreateTime,LastLoginTime,Status,IsOnline,IsLimit"); strSql.Append(") values ("); strSql.Append("@UserName,@Password,@Email,@Question,@Answer,@RoleID,@UserGroup,@CreateTime,@LastLoginTime,@Status,@IsOnline,@IsLimit"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 128), new SqlParameter("@Password", SqlDbType.NVarChar, 128), new SqlParameter("@Email", SqlDbType.NVarChar, 100), new SqlParameter("@Question", SqlDbType.NVarChar, 100), new SqlParameter("@Answer", SqlDbType.NVarChar, 100), new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@UserGroup", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@IsOnline", SqlDbType.Bit, 1), new SqlParameter("@IsLimit", SqlDbType.Bit, 1) }; parameters[0].Value = entity.UserName; parameters[1].Value = entity.Password; parameters[2].Value = entity.Email; parameters[3].Value = entity.Question; parameters[4].Value = entity.Answer; parameters[5].Value = entity.RoleID; parameters[6].Value = entity.UserGroup; parameters[7].Value = entity.CreateTime; parameters[8].Value = entity.LastLoginTime; parameters[9].Value = entity.Status; parameters[10].Value = entity.IsOnline; parameters[11].Value = entity.IsLimit; object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 按钮事件:提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { if (CheckUserSubmitFrom()) { string _action = ViewState["action"].ToString(); if (_action == "ADD") //添加用户 { Entity.BASE_USER model = GetEntity(); //model.PHOTO = UpLoadPhoto(); bll.Add(model); //日志添加 LogAdd("用户管理", "添加用户"); //重新加载当前页 //Response.Redirect(Request.Url.AbsoluteUri, true); //添加完成后页面跳转 AjaxAlertAndRedirect(UpdatePanel1, "用户信息添加成功", "UserCenter.aspx?deptid=" + hfdUnitId.Value + "&deptName=" + txtUnit.Text); } else //修改用户 { Entity.BASE_USER model = GetEntity(); model.USERID = Convert.ToInt32(ViewState["USERID"].ToString()); //model.PHOTO = UpLoadPhoto(); if (bll.Update(model)) { //日志添加 LogAdd("用户管理", "修改用户"); //重新加载当前页 //Response.Redirect(Request.Url.AbsoluteUri, true); //添加完成后页面跳转 AjaxAlertAndRedirect(UpdatePanel1, "用户信息修改成功", "UserCenter.aspx?deptid=" + hfdUnitId.Value + "&deptName=" + txtUnit.Text); } else { AjaxAlert(this.UpdatePanel1, "用户信息修改失败"); } } } }
protected void Page_Load(object sender, EventArgs e) { userSession = (Utility.UserSession)Session["user"]; if (Request.QueryString["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); Entity.BASE_MESSAGE m = new Entity.BASE_MESSAGE(); m = bll.GetEntity(id); Entity.BASE_USER userModel = new Entity.BASE_USER(); userModel = bllUser.GetUser(Convert.ToInt32(m.SENDER)); txtAccept.Text = userModel.USERNAME; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Entity.BASE_USER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BASE_USER("); strSql.Append("IDNUMBER,JOBNUMBER,PHOTO,PROF,REMARK,STSTUS,PHONE,USERNAME,USERPWD,PARENTID,SEX,DEPTID,BIRTHDAY,DEGREE,FACE,REALNAME"); strSql.Append(") values ("); strSql.Append(":IDNUMBER,:JOBNUMBER,:PHOTO,:PROF,:REMARK,:STSTUS,:PHONE,:USERNAME,:USERPWD,:PARENTID,:SEX,:DEPTID,:BIRTHDAY,:DEGREE,:FACE,:REALNAME"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":IDNUMBER", OracleType.VarChar, 18), new OracleParameter(":JOBNUMBER", OracleType.VarChar, 50), new OracleParameter(":PHOTO", OracleType.VarChar, 200), new OracleParameter(":PROF", OracleType.VarChar, 50), new OracleParameter(":REMARK", OracleType.VarChar, 50), new OracleParameter(":STSTUS", OracleType.Number, 4), new OracleParameter(":PHONE", OracleType.VarChar, 50), new OracleParameter(":USERNAME", OracleType.VarChar, 50), new OracleParameter(":USERPWD", OracleType.VarChar, 32), new OracleParameter(":PARENTID", OracleType.Number, 4), new OracleParameter(":SEX", OracleType.Number, 4), new OracleParameter(":DEPTID", OracleType.Number, 4), new OracleParameter(":BIRTHDAY", OracleType.DateTime), new OracleParameter(":DEGREE", OracleType.VarChar, 50), new OracleParameter(":FACE", OracleType.VarChar, 50), new OracleParameter(":REALNAME", OracleType.VarChar, 50) }; parameters[0].Value = model.IDNUMBER; parameters[1].Value = model.JOBNUMBER; parameters[2].Value = model.PHOTO; parameters[3].Value = model.PROF; parameters[4].Value = model.REMARK; parameters[5].Value = model.STSTUS; parameters[6].Value = model.PHONE; parameters[7].Value = model.USERNAME; parameters[8].Value = model.USERPWD; parameters[9].Value = model.PARENTID; parameters[10].Value = model.SEX; parameters[11].Value = model.DEPTID; parameters[12].Value = model.BIRTHDAY; parameters[13].Value = model.DEGREE; parameters[14].Value = model.FACE; parameters[15].Value = model.REALNAME; return(OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters)); }
protected void btnSend_Click(object sender, EventArgs e) { litmsg.Visible = false; if (!CheckInput()) { return; } //split 接收者 string[] acceptUser = txtAccept.Text.Split(','); //发送 for (int i = 0; i < acceptUser.Length; i++) { Entity.BASE_MESSAGE m = new Entity.BASE_MESSAGE(); m.MESSAGEBODY = txtContent.Text.Trim(); m.SENDDATE = DateTime.Now; m.SENDER = userSession.USERID; m.STATE = 0; //根据用户ID获取Model Entity.BASE_USER userModel = new Entity.BASE_USER(); userModel = bllUser.GetUser(acceptUser[i].ToString()); m.TOUSER = userModel.USERID; //接收者 bll.Add(m); //短信提醒 if (chkSMSAlert.Checked) { string smsContent = ""; if (txtContent.Text.Length > 70) { smsContent = txtContent.Text.Substring(0, 65) + "..."; } Smart.Sms.SendSms.Send1086Com(userModel.PHONE, smsContent); } } //提示发送成功 litmsg.Visible = true; litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;float:left;'>消息发送成功!</div>"; txtAccept.Focus(); txtAccept.Text = ""; txtContent.Text = ""; chkSMSAlert.Checked = false; }
/// <summary> /// /// </summary> /// <param name="model"></param> private void SetEntity(Entity.BASE_USER model) { #region 多余字段 //txtBIRTHDAY.Text = model.BIRTHDAY.ToString("yyyy-MM-dd"); //txtDEGREE.Text = model.DEGREE; //txtFACE.Text = model.FACE; //txtIDNUMBER.Text = model.IDNUMBER; //txtPROF.Text = model.PROF; #endregion this.hidPrimary.Value = model.USERID.ToString(); txtJOBNUMBER.Text = model.JOBNUMBER; txtPhone.Text = model.PHONE; txtRemark.Text = model.REMARK; txtUserName.Text = model.USERNAME; txtPassword.Text = Smart.Security.Encrypter.Decrypt(model.USERPWD, ConfigurationManager.AppSettings["EncryptKey"]); TxtRealName.Text = model.REALNAME; }
/// <summary> /// 更新用户基本信息 /// </summary> /// <param name="mode"></param> /// <returns></returns> public int UpdateUser(Entity.BASE_USER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Base_User set UserName=@UserName,UserGroup=@UserGroup,Email=@Email,Status=@Status where UserID=@UserID"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 128), new SqlParameter("@UserGroup", SqlDbType.Int, 4), new SqlParameter("@Email", SqlDbType.NVarChar, 100), new SqlParameter("@Status", SqlDbType.Int, 4) }; parameters[0].Value = model.UserID; parameters[1].Value = model.UserName; parameters[2].Value = model.UserGroup; parameters[3].Value = model.Email; parameters[4].Value = model.Status; return(SqlServerHelper.ExecuteSql(strSql.ToString(), parameters)); }
protected void Btn_ok_Click(object sender, EventArgs e) { BLL.BASE_USER bll = new BLL.BASE_USER(); Entity.BASE_USER model = new Entity.BASE_USER(); model.UserID = int.Parse(uid.Text); model.UserName = txt_name.Text; model.UserGroup = int.Parse(GroupList.SelectedItem.Value); model.Email = txt_email.Text; model.Status = int.Parse(StateList.SelectedItem.Value); if (bll.UpdateUser(model) >= 1) { strinfo.InnerHtml = Smart.Utility.JScript.errinfo("用户信息更新成功!"); strinfo.Visible = true; } else { strinfo.InnerHtml = Smart.Utility.JScript.errinfo("用户信息更新失败!"); strinfo.Visible = true; } }
public void RegisterUser(Entity.BASE_USER entity) { userDal.Add(entity); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.BASE_USER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_USER set "); strSql.Append(" IDNUMBER = :IDNUMBER , "); strSql.Append(" JOBNUMBER = :JOBNUMBER , "); strSql.Append(" PHOTO = :PHOTO , "); strSql.Append(" PROF = :PROF , "); strSql.Append(" REMARK = :REMARK , "); strSql.Append(" STSTUS = :STSTUS , "); strSql.Append(" PHONE = :PHONE , "); strSql.Append(" USERNAME = :USERNAME , "); strSql.Append(" USERPWD = :USERPWD , "); strSql.Append(" PARENTID = :PARENTID , "); strSql.Append(" SEX = :SEX , "); strSql.Append(" DEPTID = :DEPTID , "); strSql.Append(" BIRTHDAY = :BIRTHDAY , "); strSql.Append(" DEGREE = :DEGREE , "); strSql.Append(" FACE = :FACE,"); strSql.Append(" REALNAME=:REALNAME "); strSql.Append(" where USERID=:USERID "); OracleParameter[] parameters = { new OracleParameter(":IDNUMBER", OracleType.VarChar, 18), new OracleParameter(":JOBNUMBER", OracleType.VarChar, 50), new OracleParameter(":PHOTO", OracleType.VarChar, 200), new OracleParameter(":PROF", OracleType.VarChar, 50), new OracleParameter(":REMARK", OracleType.VarChar, 50), new OracleParameter(":STSTUS", OracleType.Number, 4), new OracleParameter(":PHONE", OracleType.VarChar, 50), new OracleParameter(":USERNAME", OracleType.VarChar, 50), new OracleParameter(":USERPWD", OracleType.VarChar, 32), new OracleParameter(":PARENTID", OracleType.Number, 4), new OracleParameter(":SEX", OracleType.Number, 4), new OracleParameter(":DEPTID", OracleType.Number, 4), new OracleParameter(":BIRTHDAY", OracleType.DateTime), new OracleParameter(":DEGREE", OracleType.VarChar, 50), new OracleParameter(":FACE", OracleType.VarChar, 50), new OracleParameter(":REALNAME", OracleType.VarChar, 50), new OracleParameter(":USERID", OracleType.Number, 4) }; parameters[0].Value = model.IDNUMBER; parameters[1].Value = model.JOBNUMBER; parameters[2].Value = model.PHOTO; parameters[3].Value = model.PROF; parameters[4].Value = model.REMARK; parameters[5].Value = model.STSTUS; parameters[6].Value = model.PHONE; parameters[7].Value = model.USERNAME; parameters[8].Value = model.USERPWD; parameters[9].Value = model.PARENTID; parameters[10].Value = model.SEX; parameters[11].Value = model.DEPTID; parameters[12].Value = model.BIRTHDAY; parameters[13].Value = model.DEGREE; parameters[14].Value = model.FACE; parameters[15].Value = model.REALNAME; parameters[16].Value = model.USERID; int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int Add(Entity.BASE_USER model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="user">用户实体</param> /// <returns></returns> public bool Update(Entity.BASE_USER user) { return(dal.Update(user)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_USER GetEntity(decimal USERID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select USERID, IDNUMBER, JOBNUMBER, PHOTO, PROF, REMARK, STSTUS, PHONE, USERNAME, USERPWD, PARENTID, SEX, DEPTID, BIRTHDAY, DEGREE, FACE,REALNAME "); strSql.Append(" from BASE_USER "); strSql.Append(" where USERID=:USERID "); OracleParameter[] parameters = { new OracleParameter(":USERID", OracleType.Number, 4) }; parameters[0].Value = USERID; Entity.BASE_USER entity = new Entity.BASE_USER(); DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["USERID"].ToString() != "") { entity.USERID = decimal.Parse(dt.Rows[0]["USERID"].ToString()); } entity.IDNUMBER = dt.Rows[0]["IDNUMBER"].ToString(); entity.JOBNUMBER = dt.Rows[0]["JOBNUMBER"].ToString(); entity.PHOTO = dt.Rows[0]["PHOTO"].ToString(); entity.PROF = dt.Rows[0]["PROF"].ToString(); entity.REMARK = dt.Rows[0]["REMARK"].ToString(); if (dt.Rows[0]["STSTUS"].ToString() != "") { entity.STSTUS = decimal.Parse(dt.Rows[0]["STSTUS"].ToString()); } entity.PHONE = dt.Rows[0]["PHONE"].ToString(); entity.USERNAME = dt.Rows[0]["USERNAME"].ToString(); entity.USERPWD = dt.Rows[0]["USERPWD"].ToString(); if (dt.Rows[0]["PARENTID"].ToString() != "") { entity.PARENTID = decimal.Parse(dt.Rows[0]["PARENTID"].ToString()); } if (dt.Rows[0]["SEX"].ToString() != "") { entity.SEX = decimal.Parse(dt.Rows[0]["SEX"].ToString()); } if (dt.Rows[0]["DEPTID"].ToString() != "") { entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString()); } if (dt.Rows[0]["BIRTHDAY"].ToString() != "") { entity.BIRTHDAY = DateTime.Parse(dt.Rows[0]["BIRTHDAY"].ToString()); } entity.DEGREE = dt.Rows[0]["DEGREE"].ToString(); entity.FACE = dt.Rows[0]["FACE"].ToString(); entity.REALNAME = dt.Rows[0]["REALNAME"].ToString(); return(entity); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.BASE_USER entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Base_User set "); strSql.Append(" UserName = @UserName , "); strSql.Append(" Password = @Password , "); strSql.Append(" Email = @Email , "); strSql.Append(" Question = @Question , "); strSql.Append(" Answer = @Answer , "); strSql.Append(" RoleID = @RoleID , "); strSql.Append(" UserGroup = @UserGroup , "); strSql.Append(" CreateTime = @CreateTime , "); strSql.Append(" LastLoginTime = @LastLoginTime , "); strSql.Append(" Status = @Status , "); strSql.Append(" IsOnline = @IsOnline , "); strSql.Append(" IsLimit = @IsLimit "); strSql.Append(" where UserID=@UserID "); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 128), new SqlParameter("@Password", SqlDbType.NVarChar, 128), new SqlParameter("@Email", SqlDbType.NVarChar, 100), new SqlParameter("@Question", SqlDbType.NVarChar, 100), new SqlParameter("@Answer", SqlDbType.NVarChar, 100), new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@UserGroup", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@LastLoginTime", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@IsOnline", SqlDbType.Bit, 1), new SqlParameter("@IsLimit", SqlDbType.Bit, 1) }; parameters[12].Value = entity.UserID; parameters[13].Value = entity.UserName; parameters[14].Value = entity.Password; parameters[15].Value = entity.Email; parameters[16].Value = entity.Question; parameters[17].Value = entity.Answer; parameters[18].Value = entity.RoleID; parameters[19].Value = entity.UserGroup; parameters[20].Value = entity.CreateTime; parameters[21].Value = entity.LastLoginTime; parameters[22].Value = entity.Status; parameters[23].Value = entity.IsOnline; parameters[24].Value = entity.IsLimit; int rows = SqlServerHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据用户名得到用户对象实体 /// </summary> public Entity.BASE_USER GetUserModel(string UserName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from Base_User "); strSql.Append(" where UserName=@UserName "); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 128) }; parameters[0].Value = UserName; Entity.BASE_USER model = new Entity.BASE_USER(); DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); model.Password = ds.Tables[0].Rows[0]["Password"].ToString(); model.Email = ds.Tables[0].Rows[0]["Email"].ToString(); model.Question = ds.Tables[0].Rows[0]["Question"].ToString(); model.Answer = ds.Tables[0].Rows[0]["Answer"].ToString(); if (ds.Tables[0].Rows[0]["UserGroup"].ToString() != "") { model.UserGroup = int.Parse(ds.Tables[0].Rows[0]["UserGroup"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } if (ds.Tables[0].Rows[0]["LastLoginTime"].ToString() != "") { model.LastLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginTime"].ToString()); } if (ds.Tables[0].Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString()); } if (ds.Tables[0].Rows[0]["IsOnline"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsOnline"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsOnline"].ToString().ToLower() == "true")) { model.IsOnline = true; } else { model.IsOnline = false; } } if (ds.Tables[0].Rows[0]["IsLimit"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsLimit"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsLimit"].ToString().ToLower() == "true")) { model.IsLimit = true; } else { model.IsLimit = false; } } //读取角色 model.RoleID = GetUserRoleArray(model.UserID); return(model); } else { return(null); } }
/// <summary> /// 更新用户基本信息 /// </summary> /// <param name="mode"></param> /// <returns></returns> public int UpdateUser(Entity.BASE_USER model) { return(dal.UpdateUser(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_USER GetEntity(int UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select UserID, UserName, Password, Email, Question, Answer, RoleID, UserGroup, CreateTime, LastLoginTime, Status, IsOnline, IsLimit "); strSql.Append(" from Base_User "); strSql.Append(" where UserID=@UserID"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameters[0].Value = UserID; Entity.BASE_USER entity = new Entity.BASE_USER(); DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["UserID"].ToString() != "") { entity.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } entity.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); entity.Password = ds.Tables[0].Rows[0]["Password"].ToString(); entity.Email = ds.Tables[0].Rows[0]["Email"].ToString(); entity.Question = ds.Tables[0].Rows[0]["Question"].ToString(); entity.Answer = ds.Tables[0].Rows[0]["Answer"].ToString(); if (ds.Tables[0].Rows[0]["UserGroup"].ToString() != "") { entity.UserGroup = int.Parse(ds.Tables[0].Rows[0]["UserGroup"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { entity.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } if (ds.Tables[0].Rows[0]["LastLoginTime"].ToString() != "") { entity.LastLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginTime"].ToString()); } if (ds.Tables[0].Rows[0]["Status"].ToString() != "") { entity.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString()); } if (ds.Tables[0].Rows[0]["IsOnline"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsOnline"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsOnline"].ToString().ToLower() == "true")) { entity.IsOnline = true; } else { entity.IsOnline = false; } } if (ds.Tables[0].Rows[0]["IsLimit"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsLimit"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsLimit"].ToString().ToLower() == "true")) { entity.IsLimit = true; } else { entity.IsLimit = false; } } //读取角色 entity.RoleID = GetUserRoleArray(entity.UserID); return(entity); } else { return(null); } }
/// <summary> /// 绑定用户信息 /// </summary> /// <param name="userId">用户ID</param> private void BindingUserInfo(int userId) { BLL.BASE_USER_ROLE userRoleBLL = new BLL.BASE_USER_ROLE(); var dt = userRoleBLL.GetList(userId); //获取用户权限集合 #region 绑定用户基本信息 BLL.BASE_USER userBLL = new BLL.BASE_USER(); Entity.BASE_USER userModel = new Entity.BASE_USER(); userModel = userBLL.GetUser(userId); this.BIRTHDAY = userModel.BIRTHDAY; this.DEGREE = userModel.DEGREE; this.DEPTID = userModel.DEPTID; this.FACE = userModel.FACE; this.IDNUMBER = userModel.IDNUMBER; this.JOBNUMBER = userModel.JOBNUMBER; this.PARENTID = userModel.PARENTID; this.PHONE = userModel.PHONE; this.PHOTO = userModel.PHONE; this.PROF = userModel.PROF; this.REMARK = userModel.REMARK; this.SEX = userModel.SEX; this.STSTUS = userModel.STSTUS; this.USERID = userModel.USERID; this.USERNAME = userModel.USERNAME; this.USERPWD = userModel.USERPWD; #endregion //绑定部门 BLL.BASE_DEPT deptBLL = new BLL.BASE_DEPT(); _Department = deptBLL.GetEntity(userModel.DEPTID); /* #region 绑定角色信息 * var roles = userRoleBLL.Query( * string.Format("SELECT distinct ROLEID FROM base_user_role WHERE userid = {0}", * userId.ToString())); * BLL.BASE_ROLE roleBll = new BLL.BASE_ROLE(); * foreach (DataRow dr in roles.Rows) { * Entity.BASE_ROLE roleModel = new Entity.BASE_ROLE(); * roleModel = roleBll.GetEntity(Convert.ToInt32(dr["ROLEID"])); * * Utility.UserRole role = new UserRole(); * role.ROLEID = roleModel.ROLEID; * role.ROLEINFO = roleModel.ROLEINFO; * role.ROLENAME = roleModel.ROLENAME; * #region 绑定菜单 * var menus = userRoleBLL.GetList(string.Format("USERID={0} AND ROLEID={1}", * userId.ToString(), * roleModel.ROLEID.ToString())); * BLL.BASE_MENU bllMenu = new BLL.BASE_MENU(); * foreach (DataRow menuDr in menus.Rows) { * Entity.BASE_MENU menuModel = new Entity.BASE_MENU(); * menuModel = bllMenu.GetEntity(Convert.ToInt32(menuDr["MENUID"])); * * Utility.UserMenu menu = new UserMenu(); * menu.ICON = menuModel.ICON; * menu.MENUID = menuModel.MENUID; * menu.MENUINFO = menuModel.MENUINFO; * menu.MENUNAME = menuModel.MENUNAME; * menu.MENUURL = menuModel.MENUURL; * menu.PARENTID = menuModel.PARENTID; * menu.STATUS = menuModel.STATUS; * #region 绑定菜单的Action * var actions = userRoleBLL.GetList(string.Format("USERID={0} AND ROLEID={1} AND MENUID={2}", * userId.ToString(), * roleModel.ROLEID.ToString(), * menu.MENUID.ToString())); * BLL.BASE_ACTION actionBLL = new BLL.BASE_ACTION(); * foreach (DataRow actionDr in actions.Rows) { * Entity.BASE_ACTION actionModel = new Entity.BASE_ACTION(); * actionModel = actionBLL.GetEntity(Convert.ToInt32(actionDr["ACTIONID"].ToString())); * * menu.UserAction.Add(actionModel); //动作信息加载菜单中 * } #endregion * * role.UserMenu.Add(menu); //菜单加入角色组中 * } #endregion * * UserRole.Add(role); //角色组加入集合中 * } #endregion */ }