/// <summary> /// 当点击修改密码时触发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button_submit_onclick(object sender, EventArgs e) { try { COMMON.common commons = new Dianda.COMMON.common(); //获取到登陆人员的基本信息 Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; BLL.USER_Users user_bll = new Dianda.BLL.USER_Users(); //登陆用户的原始密码(即登陆密码) string oldpwd = user_model.PASSWORD.ToString(); //用户输入的旧密码 string pwd1 = commons.GetMD5(TB_OLDPWD.Text.ToString().Trim()); //用户输入的新密码 string newpwd = commons.GetMD5(TB_NEWPWD1.Text.ToString().Trim()); //如果旧密码输入的是正确的,则修改密码 if (pwd1.Equals(oldpwd)) { user_model.PASSWORD = newpwd; user_bll.Update(user_model); string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"密码修改成功! \");window.close();</script>"; Response.Write(coutws); //添加操作日志 Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt(); bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "修改密码", user_model.REALNAME + "(" + user_model.USERNAME + ")" + "密码修改成功"); //添加操作日志 } else { Label_tag.Text = "对不起,您的旧密码输入不正确! 请重新输入"; TB_OLDPWD.Text = ""; TB_OLDPWD.Focus(); } } catch { Label_tag.Text = "对不起,密码修改过程中发生错误!请稍后再试"; } }
protected void Button_add_Click(object sender, EventArgs e) { //便签实体类 Dianda.Model.Personal_Notepad notepadModel = new Dianda.Model.Personal_Notepad(); //便签操作类 Dianda.BLL.Personal_Notepad notepadBll = new Dianda.BLL.Personal_Notepad(); //通用操作类 Dianda.COMMON.common commonId = new Dianda.COMMON.common(); try { if (TextBox_noteContent.Text.Equals("") || TextBox_noteContent.Text.Equals("便签内容不能为空")) { Label_notice.Text = "便签内容不能为空"; } else { Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; //便签内容 notepadModel.NAMES = TextBox_noteContent.Text.ToString(); //便签状态 notepadModel.DELFLAG = 0; //建立便签时间 notepadModel.DATETIME = DateTime.Now; //用户ID notepadModel.UserID = user_model.ID.ToString(); //添加数据到数据库 notepadBll.Add(notepadModel); //添加到日志` Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt(); bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "添加便签", "添加成功"); // Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "a", "location.href='test.aspx';alert('添加成功');", true); Label_notice.Text = "添加成功!"; } } catch (Exception) { // Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "a", "altert('添加失败');parent.parent.location.reload();", true); Label_notice.Text = "添加失败!"; } }
//点击进入登陆 protected void ImageButton_login_Click(object sender, ImageClickEventArgs e) { try { Session["isDepartment"] = "个人"; string TextBox_username_1 = TextBox_username.Text.ToString(); string TextBox_pwd_1 = TextBox_pwd.Text.ToString(); COMMON.common commonse = new Dianda.COMMON.common(); string username = commonse.SafeString(TextBox_username_1); string pwd = commonse.SafeString(TextBox_pwd_1); List <Model.USER_Users> muserlist = bUser.GetModelList(" USERNAME='******' and PASSWORD='******' and DELFLAG=0"); if (muserlist.Count > 0) { //说明登录成功 mUser = muserlist[0]; //设置Session["USER_Users"]中的TEMP4为用户的当前默认部门(为了在部门首页上做部门的切换使用)。 string departments = mUser.DepartMentID.ToString(); if (departments.Contains(",")) { string[] dearray = departments.Split(','); mUser.TEMP4 = dearray[0].ToString(); } else { mUser.TEMP4 = departments; } Session["USER_Users"] = mUser; Session["LoginID"] = mUser.ID.ToString(); //*************************如果登陆成功,需要获取该登陆者负责或参与的项目, modify by wangjh on 2010-11-02 begin Web.Admin.personalProjectManage.MakeProjectSession makeprojectsession = new Dianda.Web.Admin.personalProjectManage.MakeProjectSession(); makeprojectsession.getMyProjectList(this); // //负责的项目 // //string sql1 = " SELECT ID,NAMES FROM vProject_Projects WHERE LeaderID='" + mUser.ID + "' and DELFLAG=0 and (Status=1 or Status=3 or Status=5) "; // string sql1 = " SELECT ID,NAMES,DELFLAG,Status FROM vProject_Projects WHERE LeaderID='" + mUser.ID + "' and (Status=1 or Status=3 or Status=5) "; // //由于在我的项目中需要添加一个已删除的项目,所以在加载项目时也需要将删除的显示出来,故作以上修改(and DELFLAG=0 删除了) // DataTable dt1 = pageControl.doSql(sql1).Tables[0]; // //参与的项目 //// string sql2 = " SELECT ID,NAMES FROM vProject_Projects WHERE DELFLAG=0 and id in(select Projectid from Project_UserList where userid='" + mUser.ID + "' and status='1') "; // string sql2 = " SELECT ID,NAMES,DELFLAG,Status FROM vProject_Projects WHERE id in(select Projectid from Project_UserList where userid='" + mUser.ID + "' and status='1') "; // //由于在我的项目中需要添加一个已删除的项目,所以在加载项目时也需要将删除的显示出来,故作以上修改(DELFLAG=0 and 删除了) // DataTable dt2 = pageControl.doSql(sql2).Tables[0]; // //合并两个相同结构的DATATABLE // DataTable Newdt = common.CombineTheSameDatatable(dt1,dt2); // //将一个DATATABLE中的重复项去除掉 // if (null != Newdt) // { // Newdt = common.makeDistinceTable(Newdt, "ID"); // Session["Project_Projects"] = Newdt; // } //*************************如果登陆成功,需要获取该登陆者负责或参与的项目, modify by wangjh on 2010-11-02 end //写日志 BLL.SYS_LogsExt bslog = new Dianda.BLL.SYS_LogsExt(); bslog.addlogs(mUser.REALNAME.ToString() + "(" + mUser.USERNAME.ToString() + ")", "登录系统", "登录系统:成功"); //写日志 //根据用户的用户组来生成用户的权限数据 ///构造用户的全部权限 DataTable sessionData = sessionPower(mUser.ID.ToString()); string[] arrays = getPowerSession(sessionData, mUser.ID.ToString()); mUserPower.specialRole = arrays[3].ToString(); mUserPower.buttomID = arrays[2].ToString(); mUserPower.menuRole = arrays[1].ToString(); mUserPower.pageurl = arrays[0].ToString(); mUserPower.userid = mUser.ID.ToString(); mUserPower.isYinLeader = arrays[4].ToString(); //"0";//表示该用户是用印管理的领导(根据特定的权限点来判断该用户是否是领导) Session["Session_Power"] = mUserPower; //付全文 2013-4-16 消息权限 string strSql = "select roles from user_role where name='消息-取消通知公告' and Types='菜单权限' and delflag =0"; DataTable dt = pageControl.doSql(strSql).Tables[0]; string roles = null; foreach (DataRow row in dt.Rows) { roles = row["roles"].ToString(); } Session["Session_Role"] = roles; ///构造用户的全部权限 string url = "/Admin/person_Index.aspx"; string coutws = "<script language=\"javascript\" type=\"text/javascript\">location.href='" + url + "';</script>"; Response.Write(coutws); } else { //登录失败 Session["USER_Users"] = ""; string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"登录失败,请核实您的用户名和密码\");location.href='login.aspx';</script>"; Response.Write(coutws); } } catch { //登录失败 Session["USER_Users"] = ""; string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"登录失败,请核实您的用户名和密码\");location.href='login.aspx';</script>"; Response.Write(coutws); } }
/// <summary> /// 构造查询条件 /// </summary> /// <returns></returns> protected string SQLCondition_tag(string types, string condition) { //1-全部、2-审批提醒、3-项目任务、4-共享文档、5-申请反馈、 //6-通知公告、7-个人消息、8-项目消息、9-部门消息、10-历史消息 //放入回收站 //Image del_image = (Image)GridView1.Rows[].Cells[].FindControl("del_image"); StringBuilder sbSql = new StringBuilder(); sbSql.Append(" 1=1 "); string strNewsType = types; if (strNewsType == "1") { //1-全部 sbSql.Append(" "); mUserPower = (Model.userPower)Session["Session_Power"]; if (mUserPower.specialRole.Contains("or")) { sbSql.Append(" and (" + mUserPower.specialRole.ToString() + " or Receive='" + ((Model.USER_Users)Session["USER_Users"]).ID + "') "); } else { sbSql.Append(" AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'"); } // searchrtable.Visible = false;//搜索的功能不显示 } if (strNewsType == "2") { //2-审批提醒 mUserPower = (Model.userPower)Session["Session_Power"]; if (mUserPower.specialRole.Contains("or")) { sbSql.Append(" and " + mUserPower.specialRole.ToString() + ""); } else { sbSql.Append(" and IsRead='3'"); } //searchrtable.Visible = false;//搜索的功能不显示 } if (strNewsType == "3") { //3-项目任务 sbSql.Append("and NewsType='项目任务' AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'"); // searchrtable.Visible = false;//搜索的功能不显示 } if (strNewsType == "4") { //4-共享文档 sbSql.Append(" and NewsType='共享文档' AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'"); // searchrtable.Visible = false;//搜索的功能不显示 } if (strNewsType == "5") { //5-申请反馈、 sbSql.Append(" and (NewsType='申请情况' or NewsType='项目审核' or NewsType='经费预约反馈') AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'"); // searchrtable.Visible = false;//搜索的功能不显示 } if (strNewsType == "6") { //6-通知公告、 sbSql.Append("and NewsType='通知公告' AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'"); // searchrtable.Visible = false;//搜索的功能不显示 } if (strNewsType == "789") { //7-个人消息、 sbSql.Append(" and (NewsType='个人消息' or NewsType='项目消息' or NewsType='部门消息') AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'"); // searchrtable.Visible = false;//搜索的功能不显示 } if (strNewsType == "10") { //10-历史消息、 sbSql.Append(" "); mUserPower = (Model.userPower)Session["Session_Power"]; if (Session["starttime_session"] == null)//没有搜索条件时 { if (mUserPower.specialRole.Contains("or")) { sbSql.Append(" and (" + mUserPower.specialRole.ToString() + " or Receive='" + ((Model.USER_Users)Session["USER_Users"]).ID + "') "); } else { sbSql.Append(" AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'"); } } //else//有搜索条件时 //{ // DateTime starttimes = DateTime.Parse(Session["starttime_session"].ToString()); // DateTime endtimes = DateTime.Parse(Session["endtime_session"].ToString()).AddDays(1); // if (mUserPower.specialRole.Contains("or")) // { // sbSql.Append(" and (" + mUserPower.specialRole.ToString() + " or Receive='" + ((Model.USER_Users)Session["USER_Users"]).ID + "') and DATETIME>='" + starttimes + "' and DATETIME<='" + endtimes + "'"); // } // else // { // sbSql.Append(" AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "' and DATETIME>='" + starttimes + "' and DATETIME<='" + endtimes + "'"); // } //} } if (Session["starttime_session"] != null && DropDownList1.SelectedValue != "time")//有搜索条件时 { DateTime starttimes = DateTime.Parse(Session["starttime_session"].ToString()); DateTime endtimes = DateTime.Parse(Session["endtime_session"].ToString()).AddDays(1); COMMON.common com = new Dianda.COMMON.common(); sbSql.Append("and DATETIME>='" + starttimes + "' and DATETIME<='" + endtimes + "'" + "and URLS like '%" + com.SafeString(Keyword.Text) + "%'"); sbSql.Append("and DELFLAG=1");//现在搜索的都是放入回收站的消息 } else { sbSql.Append("and DELFLAG=0"); } if (!string.IsNullOrEmpty(condition)) { sbSql.Append(" and NewsType <> '" + condition + "'"); } return(sbSql.ToString()); }