/// <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());
}
