//数据绑定 void Bind() { int uid = Str2Int(q("id"), 0); JumbotOA.Entity.UserEntity model = new JumbotOA.Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(uid); this.txtUname.Text = model.Uname; }
//添加 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { int PId = 4; Entity.UserEntity userEntity = new Entity.UserEntity(); Entity.PowerEntity powerEntity = new BLL.PowerBLL().GetEntity(PId); userEntity.Pid = PId; userEntity.Uname = this.txtUname.Text; userEntity.Position = this.txtPosition.Text; userEntity.Setting = powerEntity.Setting; userEntity.Did = Str2Int(this.ddlDid.SelectedValue, 0); userEntity.Upwd = JumbotOA.Utils.MD5.Lower32(this.txtPwd.Text.Trim()); if (this.txtIpaddress.Text != "") { userEntity.Uipaddress = this.txtIpaddress.Text; } int i = new JumbotOA.BLL.UserBLL().Add(userEntity); if (i > 0) { Addadminlog("添加用户"); } else { FinalMessage("相同的用户已经存在", "", 1); } }
//添加信息 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.LearningEntity model = new Entity.LearningEntity(); model.Sauthor = UserName; model.Stitle = this.txtTitle.Text; model.Sdate = DateTime.Now; model.Spath = this.FCKeditor1.Value; model.Did = UserDepartmentId; int i = new JumbotOA.BLL.LearningBLL().Add(model); if (i > 0) { JumbotOA.BLL.UserBLL user = new JumbotOA.BLL.UserBLL(); DataTable dt=new DataTable (); string aa = ""; if(UserPowerId<=3) dt=user.GetList("").Tables[0]; else dt= user.GetList("Did=" + UserDepartmentId).Tables[0]; for(int j=0;j<dt.Rows.Count;j++) { aa +=dt.Rows[j]["Uid"].ToString()+","; } JumbotOA.BLL.OA_SysMessageIn.ADDsysMessage(2, "," + aa, "[新资料]" + txtTitle.Text, JumbotOA.Utils.Strings.Left(JumbotOA.Utils.Strings.delhtml(FCKeditor1.Value.ToString()),53), "My_Learning_Show.aspx?id=" + i.ToString()); string addtype = "添加学习资料"; Addlog(addtype); aa = ""; } }
//添加信息 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.LearningEntity model = new Entity.LearningEntity(); model.Sauthor = UserName; model.Stitle = this.txtTitle.Text; model.Sdate = DateTime.Now; model.Spath = this.FCKeditor1.Value; model.Did = UserDepartmentId; int i = new JumbotOA.BLL.LearningBLL().Add(model); if (i > 0) { JumbotOA.BLL.UserBLL user = new JumbotOA.BLL.UserBLL(); DataTable dt = new DataTable(); string aa = ""; if (UserPowerId <= 3) { dt = user.GetList("").Tables[0]; } else { dt = user.GetList("Did=" + UserDepartmentId).Tables[0]; } for (int j = 0; j < dt.Rows.Count; j++) { aa += dt.Rows[j]["Uid"].ToString() + ","; } JumbotOA.BLL.OA_SysMessageIn.ADDsysMessage(2, "," + aa, "[新资料]" + txtTitle.Text, JumbotOA.Utils.Strings.Left(JumbotOA.Utils.Strings.delhtml(FCKeditor1.Value.ToString()), 53), "My_Learning_Show.aspx?id=" + i.ToString()); string addtype = "添加学习资料"; Addlog(addtype); aa = ""; } }
//添加 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { int PId = 1; Entity.UserEntity userEntity = new Entity.UserEntity(); Entity.PowerEntity powerEntity = new BLL.PowerBLL().GetEntity(PId); userEntity.Pid = PId; userEntity.Uname = this.txtUname.Text; userEntity.Position = this.txtPosition.Text; userEntity.Setting = powerEntity.Setting; userEntity.Upwd = JumbotOA.Utils.MD5.Lower32(this.txtPwd.Text.Trim()); if (this.txtIpaddress.Text != "") { userEntity.Uipaddress = this.txtIpaddress.Text; } int i = new JumbotOA.BLL.UserBLL().Add(userEntity); if (i > 0) { Addadminlog("添加用户"); } else { FinalMessage("相同的用户已经存在", "", 1); } }
//判断是否自动登录 void Autologin() { if (JumbotOA.Utils.Cookie.GetValue("oa_user") != null) { if (JumbotOA.Utils.Cookie.GetValue("oa_user", "ip") == Request.UserHostAddress) { JumbotOA.Entity.UserEntity model = new JumbotOA.Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(Convert.ToInt32(JumbotOA.Utils.Cookie.GetValue("oa_user", "id"))); int pid = model.Pid; new BLL.UserBLL().UpdateTime(model.Uid); switch (pid) { case 1: Response.Redirect("Home1.aspx"); break; case 2: Response.Redirect("Home2.aspx"); break; case 3: Response.Redirect("Home3.aspx"); break; case 4: Response.Redirect("Home4.aspx"); break; } } } }
protected void dropuser() { JumbotOA.BLL.UserBLL user = new JumbotOA.BLL.UserBLL(); touser.DataSource = user.GetList("Did in(1,2,3)").Tables[0]; touser.DataTextField = "Uname"; touser.DataValueField = "Uname"; touser.DataBind(); }
//个人密码修改 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.UserEntity model = new Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(UserId); model.Upwd = JumbotOA.Utils.MD5.Lower32(this.txtAgainpwd.Text.Trim()); new JumbotOA.BLL.UserBLL().Update(model); FinalMessage("操作成功", "Password_Edit.aspx", 0); }
//绑定 void Bind() { Entity.UserEntity model = new Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(UserId); this.txtUname.Text = model.Uname; ViewState["pid"] = model.Pid.ToString(); this.txtUname.ReadOnly = true; }
//更新 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.UserEntity model = new Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(Str2Int(q("id"), 0)); model.Upwd = JumbotOA.Utils.MD5.Lower32(this.txtAgainpwd.Text.Trim()); new JumbotOA.BLL.UserBLL().Update(model); Addadminlog("修改用户密码"); }
// 登录 protected void ibLogin_Click(object sender, ImageClickEventArgs e) { // 记录其IP地址,下次登录时验证,IP为空则记录,IP不为空则验证 string uname = this.tbUname.Value; string upwd = this.tbPwd.Value; string uid = new JumbotOA.BLL.UserBLL().Existslongin(uname, JumbotOA.Utils.MD5.Lower32(upwd)); if (uid != "") { JumbotOA.Entity.UserEntity model = new JumbotOA.Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(int.Parse(uid)); if (model.Uipaddress != "") { if (model.Uipaddress != Page.Request.UserHostAddress) { Response.Write("<script>alert('非法IP,请在本机登陆!');</script>"); Response.End(); } } int iExpires = 0; //设置Cookies System.Collections.Specialized.NameValueCollection myCol = new System.Collections.Specialized.NameValueCollection(); myCol.Add("id", uid.ToString()); myCol.Add("name", uname); myCol.Add("ip", Request.UserHostAddress); new BLL.UserBLL().UpdateTime(model.Uid); int pid = model.Pid; myCol.Add("Powerid", pid.ToString()); JumbotOA.Utils.Cookie.SetObj("oa_user", 60 * 60 * 15 * iExpires, myCol, "", "/"); switch (pid) { case 1: Response.Redirect("Home1.aspx"); //管理员 break; case 2: Response.Redirect("Home2.aspx"); //管理组织层 break; case 3: Response.Redirect("Home3.aspx"); //网站编辑 break; case 4: Response.Redirect("Home4.aspx"); //美工和程序员 break; } } else { this.tbUname.Value = ""; this.tbPwd.Value = ""; System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('请正确填写用户名和密码!');</script>"); } }
//获取角色 string Getposi(int uid) { string sql = "select * from [OA_Power] where Pid = (select Pid FROM [OA_User] where uid ='" + uid + "')"; Entity.PowerEntity posi = new Entity.PowerEntity(); posi = new JumbotOA.BLL.UserBLL().Getpomodel(sql); string pname = posi.PName; return(pname); }
//更新 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.UserEntity model = new Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(Str2Int(q("id"), 0)); // model.Position = this.txtPosition.Text; model.Setting = "," + f("user_setting") + ","; model.Pid = Convert.ToInt32(DropDownList2.SelectedValue.ToString()); model.Did = Convert.ToInt32(DropDownList1.SelectedValue.ToString()); model.Uipaddress = this.txtIpaddress.Text; new JumbotOA.BLL.UserBLL().Update(model); Addadminlog("修改用户权限"); }
// 登录 protected void ibLogin_Click(object sender, ImageClickEventArgs e) { // 记录其IP地址,下次登录时验证,IP为空则记录,IP不为空则验证 string uname = this.tbUname.Value; string upwd = this.tbPwd.Value; string uid = new JumbotOA.BLL.UserBLL().Existslongin(uname, JumbotOA.Utils.MD5.Lower32(upwd)); if (uid != "") { JumbotOA.Entity.UserEntity model = new JumbotOA.Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(int.Parse(uid)); if (model.Uipaddress != "") { if (model.Uipaddress != Page.Request.UserHostAddress) { Response.Write("<script>alert('非法IP,请在本机登陆!');</script>"); Response.End(); } } int iExpires = 0; //设置Cookies System.Collections.Specialized.NameValueCollection myCol = new System.Collections.Specialized.NameValueCollection(); myCol.Add("id", uid.ToString()); myCol.Add("name", uname); myCol.Add("ip", Request.UserHostAddress); new BLL.UserBLL().UpdateTime(model.Uid); int pid = model.Pid; myCol.Add("Powerid",pid.ToString()); JumbotOA.Utils.Cookie.SetObj("oa_user", 60 * 60 * 15 * iExpires, myCol, "", "/"); switch (pid) { case 1: Response.Redirect("Home1.aspx");//管理员 break; case 2: Response.Redirect("Home2.aspx");//管理组织层 break; case 3: Response.Redirect("Home3.aspx");//网站编辑 break; case 4: Response.Redirect("Home4.aspx");//美工和程序员 break; } } else { this.tbUname.Value = ""; this.tbPwd.Value = ""; System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('请正确填写用户名和密码!');</script>"); } }
//ddlUname绑定 void BindMyEmployeeInfo() { DataSet ds = new JumbotOA.BLL.UserBLL().GetList(" pid=4" + wherestr2); DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { this.ddlUname.Items.Add(new ListItem(dt.Rows[i]["Uname"].ToString(), dt.Rows[i]["UId"].ToString())); } dt.Clear(); dt.Dispose(); ds.Clear(); ds.Dispose(); }
//checkboxlist的绑定 void ddlWorkerbind() { this.txtBegintime.Text = DateTime.Now.ToString(); JumbotOA.BLL.UserBLL user = new JumbotOA.BLL.UserBLL(); DataTable table = user.GetList(wherestr2).Tables[0]; for (int i = 0; i < table.Rows.Count; i++) { ListItem item = new ListItem(); item.Value = table.Rows[i]["Uid"].ToString(); DataSet ds = new JumbotOA.BLL.TaskBLL().GetList(" uid = " + Convert.ToInt32(table.Rows[i]["Uid"].ToString()) + " and worktime > '" + Convert.ToDateTime(this.txtBegintime.Text) + "' and [Workprogress]in(2,5,6,7,8)"); if (ds.Tables[0].Rows.Count != 0) { item.Text = table.Rows[i]["Uname"].ToString() + "<font style=\"color:#FF0000\">(" + ds.Tables[0].Rows.Count + ")</font>"; } else { item.Text = table.Rows[i]["Uname"].ToString(); } ddlWorker.Items.Add(item); } }
void showdp() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); int uid = Convert.ToInt32(com.getsid("fid")); if (uid != -1) { int dpid = new JumbotOA.BLL.UserBLL().GetEntity(uid).Did; DropDownList1.SelectedValue = dpid.ToString(); DropDownList1.Enabled = false; this.DropDownList2.DataSource = new JumbotOA.BLL.UserBLL().GetList("Did=" + DropDownList1.SelectedValue.ToString()); this.DropDownList2.DataTextField = "Uname"; this.DropDownList2.DataValueField = "Uid"; this.DropDownList2.DataBind(); DropDownList2.SelectedValue = uid.ToString(); DropDownList2.Enabled = false; } else { DropDownList1.Enabled = true; DropDownList2.Enabled = true; } }
//添加信息 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.PlacardEntity model = new Entity.PlacardEntity(); model.Pauthor = UserName; model.Ptitle = this.txtTitle.Text; model.Pdate = DateTime.Now; model.Ptext = this.FCKeditor1.Value; int i = new JumbotOA.BLL.PlacardBLL().Add(model); if (i > 0) { JumbotOA.BLL.UserBLL user = new JumbotOA.BLL.UserBLL(); DataTable dt=user.GetList("").Tables[0]; string aa = ""; for (int j = 0; j <dt.Rows.Count ; j++) { aa += dt.Rows[j]["Uid"].ToString()+","; } JumbotOA.BLL.OA_SysMessageIn.ADDsysMessage(1, "," + aa, "[新通知]" + txtTitle.Text, JumbotOA.Utils.Strings.Left(JumbotOA.Utils.Strings.delhtml(FCKeditor1.Value.ToString()), 53), "My_Placard_Show.aspx?id=" + i.ToString()); aa = ""; string addtype = "添加通知公告"; Addlog(addtype); } }
//添加信息 protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.PlacardEntity model = new Entity.PlacardEntity(); model.Pauthor = UserName; model.Ptitle = this.txtTitle.Text; model.Pdate = DateTime.Now; model.Ptext = this.FCKeditor1.Value; int i = new JumbotOA.BLL.PlacardBLL().Add(model); if (i > 0) { JumbotOA.BLL.UserBLL user = new JumbotOA.BLL.UserBLL(); DataTable dt = user.GetList("").Tables[0]; string aa = ""; for (int j = 0; j < dt.Rows.Count; j++) { aa += dt.Rows[j]["Uid"].ToString() + ","; } JumbotOA.BLL.OA_SysMessageIn.ADDsysMessage(1, "," + aa, "[新通知]" + txtTitle.Text, JumbotOA.Utils.Strings.Left(JumbotOA.Utils.Strings.delhtml(FCKeditor1.Value.ToString()), 53), "My_Placard_Show.aspx?id=" + i.ToString()); aa = ""; string addtype = "添加通知公告"; Addlog(addtype); } }
public string GetUserNameById(string uid) { JumbotOA.Entity.UserEntity user = new JumbotOA.BLL.UserBLL().GetEntity(Str2Int(uid)); return user.Uname; }
public string GetUserNameById(string uid) { JumbotOA.Entity.UserEntity user = new JumbotOA.BLL.UserBLL().GetEntity(Str2Int(uid)); return(user.Uname); }
//数据绑定 void Bind() { int uid = Str2Int(q("id"), 0); department(); roless(); JumbotOA.Entity.UserEntity model = new JumbotOA.Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(uid); this.txtUname.Text = model.Uname; this.txtUname.ReadOnly = true; // this.txtPosition.Text = model.Position; //职位 this.txtIpaddress.Text = model.Uipaddress; string user_setting = ""; string[,] menu = null; if (pidtxt.Text != "") { Entity.PowerEntity powerEntity = new BLL.PowerBLL().GetEntity(Convert.ToInt32(pidtxt.Text.Trim())); user_setting = powerEntity.Setting; int pid = Convert.ToInt32(pidtxt.Text); if (depid.Text != "") { DropDownList1.SelectedValue = depid.Text.ToString(); } else { DropDownList1.SelectedValue = model.Did.ToString(); } DropDownList2.SelectedValue = pid.ToString(); if (pid == 1) { menu = powerMenu1(); } if (pid == 2) { menu = powerMenu2(); } else if (pid == 3) { menu = powerMenu3(); } else if (pid == 4) { menu = powerMenu4(); } } else { DropDownList1.SelectedValue = model.Did.ToString(); DropDownList2.SelectedValue = model.Pid.ToString(); user_setting = model.Setting; if (model.Pid == 1) { menu = powerMenu1(); } if (model.Pid == 2) { menu = powerMenu2(); } else if (model.Pid == 3) { menu = powerMenu3(); } else if (model.Pid == 4) { menu = powerMenu4(); } } StringBuilder sb = new StringBuilder(); sb.Append("<table cellspacing=\"0\" width=\"100%\" cellpadding=\"0\" align=\"center\">"); for (int i = 0; i < menu.GetLength(0); i++) { sb.Append("<tr><td width=\"260\" align=\"right\"><strong>" + menu[i, 0] + "</strong></td>"); sb.Append("<td width=\"*\">"); for (int j = 1; j < menu.GetLength(1); j++) { if (menu[i, j] == null) { break; } string[] _split = menu[i, j].Split('|'); sb.Append("<span style='float:left;height:30px;margin-left:10px;padding-top:5px;' scope='col'><input id=\"user_setting_" + i + "_" + j + "\" type=checkbox class='checkbox' name=\"user_setting\" value=\""); string tPower = _split[1]; sb.Append(tPower + "\""); if (_split.Length > 2 && _split[2] == "1") { sb.Append(" onclick='if(!this.checked){this.checked=true;}else{this.checked=false;}'"); } if (user_setting.Contains("," + tPower + ",")) { sb.Append(" checked"); } sb.Append("><label for=\"user_setting_" + i + "_" + j + "\">" + _split[0] + "</label>"); sb.Append("</span>\r\n"); } sb.Append("</td></tr>"); } sb.Append("</td></tr>"); sb.Append("</table>"); this.ltMasterSetting.Text = sb.ToString(); }
//获取角色 string Getposi(int uid) { string sql = "select * from [OA_Power] where Pid = (select Pid FROM [OA_User] where uid ='" + uid + "')"; Entity.PowerEntity posi = new Entity.PowerEntity(); posi = new JumbotOA.BLL.UserBLL().Getpomodel(sql); string pname = posi.PName; return pname; }
//通过参数获取被更改的用户名 string Getoname(int id) { Entity.UserEntity model = new Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(id); return(model.Uname); }
//通过参数获取被更改的用户名 string Getoname(int id) { Entity.UserEntity model = new Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(id); return model.Uname; }
//checkboxlist的绑定 void ddlWorkerbind() { this.txtBegintime.Text = DateTime.Now.ToString(); JumbotOA.BLL.UserBLL user=new JumbotOA.BLL.UserBLL (); DataTable table= user.GetList(wherestr2).Tables[0]; for(int i=0;i<table.Rows.Count;i++) { ListItem item = new ListItem(); item.Value = table.Rows[i]["Uid"].ToString(); DataSet ds = new JumbotOA.BLL.TaskBLL().GetList(" uid = " + Convert.ToInt32(table.Rows[i]["Uid"].ToString()) + " and worktime > '" + Convert.ToDateTime(this.txtBegintime.Text) + "' and [Workprogress]in(2,5,6,7,8)"); if (ds.Tables[0].Rows.Count != 0) item.Text =table.Rows[i]["Uname"].ToString()+ "<font style=\"color:#FF0000\">(" + ds.Tables[0].Rows.Count + ")</font>"; else item.Text = table.Rows[i]["Uname"].ToString(); ddlWorker.Items.Add(item); } }
//数据绑定 void Bind() { int uid = Str2Int(q("id"), 0); department(); roless(); JumbotOA.Entity.UserEntity model = new JumbotOA.Entity.UserEntity(); model = new JumbotOA.BLL.UserBLL().GetEntity(uid); this.txtUname.Text = model.Uname; this.txtUname.ReadOnly = true; // this.txtPosition.Text = model.Position; //职位 this.txtIpaddress.Text = model.Uipaddress; string user_setting = ""; string[,] menu = null; if (pidtxt.Text != "") { Entity.PowerEntity powerEntity = new BLL.PowerBLL().GetEntity(Convert.ToInt32(pidtxt.Text.Trim())); user_setting = powerEntity.Setting; int pid = Convert.ToInt32(pidtxt.Text); if (depid.Text != "") DropDownList1.SelectedValue = depid.Text.ToString(); else { DropDownList1.SelectedValue = model.Did.ToString(); } DropDownList2.SelectedValue = pid.ToString(); if(pid==1) menu = powerMenu1(); if (pid == 2) menu = powerMenu2(); else if (pid == 3) menu = powerMenu3(); else if (pid == 4) menu = powerMenu4(); } else { DropDownList1.SelectedValue = model.Did.ToString(); DropDownList2.SelectedValue = model.Pid.ToString(); user_setting = model.Setting; if (model.Pid == 1) menu = powerMenu1(); if (model.Pid == 2) menu = powerMenu2(); else if (model.Pid == 3) menu = powerMenu3(); else if (model.Pid == 4) menu = powerMenu4(); } StringBuilder sb = new StringBuilder(); sb.Append("<table cellspacing=\"0\" width=\"100%\" cellpadding=\"0\" align=\"center\">"); for (int i = 0; i < menu.GetLength(0); i++) { sb.Append("<tr><td width=\"260\" align=\"right\"><strong>" + menu[i, 0] + "</strong></td>"); sb.Append("<td width=\"*\">"); for (int j = 1; j < menu.GetLength(1); j++) { if (menu[i, j] == null) break; string[] _split = menu[i, j].Split('|'); sb.Append("<span style='float:left;height:30px;margin-left:10px;padding-top:5px;' scope='col'><input id=\"user_setting_" + i + "_" + j + "\" type=checkbox class='checkbox' name=\"user_setting\" value=\""); string tPower = _split[1]; sb.Append(tPower + "\""); if (_split.Length > 2 && _split[2] == "1") sb.Append(" onclick='if(!this.checked){this.checked=true;}else{this.checked=false;}'"); if (user_setting.Contains("," + tPower + ",")) sb.Append(" checked"); sb.Append("><label for=\"user_setting_" + i + "_" + j + "\">" + _split[0] + "</label>"); sb.Append("</span>\r\n"); } sb.Append("</td></tr>"); } sb.Append("</td></tr>"); sb.Append("</table>"); this.ltMasterSetting.Text = sb.ToString(); }