//模块权限列表 protected string fRoleNames() { string ls_return = ""; string ls_userid = ""; string ls_roleids = ""; //加载 HyoaClass.Hyoa_jiaose Hyoa_jiaose = new HyoaClass.Hyoa_jiaose(); DataTable dt = Hyoa_jiaose.Getdocs(); //fdselectroleid if (this.Request.QueryString["selectjiaoseid"] != null) { this.fdselectroleid.Value = "," + this.Request.QueryString["selectjiaoseid"].ToString() + ","; } if(dt.Rows.Count>0) { for (var i = 0; i < dt.Rows.Count; i++) { //if (ls_roleids == "") //{ ls_return += "<td width=\"25%\">"; if (this.fdselectroleid.Value.IndexOf(","+dt.Rows[i]["id"].ToString()+",") >= 0) { //判断是否已经选中,如果选中了,则前面打勾 ls_return += "<input type=\"checkbox\" checked=true name=\"fRoleName\" value=\"" + dt.Rows[i]["id"].ToString() + "\" text=\"" + dt.Rows[i]["hy_jsname"].ToString() + "\" id=\"" + dt.Rows[i]["hy_jsname"].ToString() + "\">" + dt.Rows[i]["hy_jsname"].ToString(); } else { ls_return += "<input type=\"checkbox\" name=\"fRoleName\" value=\"" + dt.Rows[i]["id"].ToString() + "\" text=\"" + dt.Rows[i]["hy_jsname"].ToString() + "\" id=\"" + dt.Rows[i]["hy_jsname"].ToString() + "\">" + dt.Rows[i]["hy_jsname"].ToString(); } ls_return += "</td>"; //} //else //{ // if (ls_roleids.Contains(dt.Rows[i]["hy_roleid"].ToString())) // { // ls_return += "<td width=\"25%\"><input type=\"checkbox\" checked=\"checked\" name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\" text=\"" + dt.Rows[i]["hy_rolename"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString() + "</td>"; // } // else // { // ls_return += "<td width=\"25%\"><input type=\"checkbox\" name=\"fRoleName\" value=\"" + dt.Rows[i]["hy_roleid"].ToString() + "\" text=\"" + dt.Rows[i]["hy_rolename"].ToString() + "\">" + dt.Rows[i]["hy_rolename"].ToString() + "</td>"; // } //} if (((i + 1) % 4) == 0 && i < dt.Rows.Count) ls_return += "</tr><tr>"; } } dt.Clear(); return ls_return; }
protected void btndelinfo_Click(object sender, EventArgs e) { HyoaClass.Hyoa_jiaose Hyoa_jiaose = new HyoaClass.Hyoa_jiaose(); String[] v_uids = this.txtuids.Value.Split(','); for (var i = 0; i < v_uids.Length; i++) { if (v_uids[i] != "") { Hyoa_jiaose.id = v_uids[i]; Hyoa_jiaose.Delete(); } } this.txtuids.Value = ""; //DataPlay(1); DataPlay(System.Int32.Parse(this.curpage.Text)); }
private void DataPlay(int PageNo) { //判断当前用户是否有新建删除权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { this.isrole.Value = "1"; this.tdnewdoc.Visible = true; //新建 this.tddeldoc.Visible = true; //删除 } else { this.isrole.Value = "0"; this.tdnewdoc.Visible = false; //新建 this.tddeldoc.Visible = false; //删除 } //得到当前页号 this.curpage.Text = PageNo.ToString(); HyoaClass.Hyoa_jiaose Hyoa_jiaose = new HyoaClass.Hyoa_jiaose(); DataTable dt; dt = Hyoa_jiaose.Getdocs(); DataTable tempTable = dt.Clone(); for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++) { if (i > dt.Rows.Count - 1) break; DataRow dr = tempTable.NewRow(); for (int j = 0; j < dt.Columns.Count; j++) { dr[dt.Columns[j].ColumnName] = dt.Rows[i][j]; } tempTable.Rows.Add(dr); } int TotalRecord = dt.Rows.Count; this.sumts.Text = TotalRecord.ToString(); this.sumts2.Text = TotalRecord.ToString(); this.ShowTotalRecord.Text = TotalRecord.ToString(); //计算及显示总页数 int TotalPage; if (TotalRecord < System.Int32.Parse(PageSize.Text)) { TotalPage = 1; } else { if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0) { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1; } else { TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text); } } this.ShowTotalPage.Text = TotalPage.ToString(); this.rptlist.DataSource = tempTable; this.rptlist.DataBind(); dt.Clear(); }
//保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("../login.aspx"); string ls_tip = "保存成功!"; //新文档时 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); HyoaClass.Hyoa_jiaose Hyoa_jiaose = new HyoaClass.Hyoa_jiaose(); string lsrnd = ""; if (this.txtop.Value == "add") { lsrnd = Hyoa_global.GetRandom(); Hyoa_jiaose.id = lsrnd; Hyoa_jiaose.hy_jsname = this.txthy_jsname.Text; Hyoa_jiaose.hy_roleids = this.txthy_roleids.Text; Hyoa_jiaose.hy_rolenames = this.txthy_rolenames.Text; Hyoa_jiaose.hy_flowtacheids = this.txthy_flowtacheids.Text; Hyoa_jiaose.hy_flowtachenames = this.txthy_flowtachenames.Text; Hyoa_jiaose.hy_sort = float.Parse(this.txthy_sort.Text); Hyoa_jiaose.hy_bz = this.txthy_bz.Text; Hyoa_jiaose.Insert(); } else { Hyoa_jiaose.id = this.txtdocid.Value; Hyoa_jiaose.hy_jsname = this.txthy_jsname.Text; Hyoa_jiaose.hy_roleids = this.txthy_roleids.Text; Hyoa_jiaose.hy_rolenames = this.txthy_rolenames.Text; Hyoa_jiaose.hy_flowtacheids = this.txthy_flowtacheids.Text; Hyoa_jiaose.hy_flowtachenames = this.txthy_flowtachenames.Text; Hyoa_jiaose.hy_sort = float.Parse(this.txthy_sort.Text); Hyoa_jiaose.hy_bz = this.txthy_bz.Text; Hyoa_jiaose.Update(); //更新对应的ROLE //先找出该角色对应的人 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); DataTable dt = Hyoa_user.Getusersbyjiaoseid(this.txtdocid.Value); HyoaClass.Hyoa_roleuser Hyoa_roleuser = new HyoaClass.Hyoa_roleuser(); //for (int i = 0; i < dt.Rows.Count; i++) //{ // //将人员+老roleid的先删除 // string[] lv_roleid; // lv_roleid = this.txthy_roleids2.Text.Split(','); // for (int j = 0; j < lv_roleid.Length; j++) // { // if (lv_roleid[j] != "") // { // Hyoa_roleuser.Deletebyroleidanduserid(lv_roleid[j], dt.Rows[i]["hy_userid"].ToString()); // } // } // //将人员+新roleid的插入 // string[] lv_roleidnew; // lv_roleidnew = this.txthy_roleids.Text.Split(','); // for (int j = 0; j < lv_roleidnew.Length; j++) // { // if (lv_roleidnew[j] != "") // { // Hyoa_roleuser.ID = Hyoa_global.GetRandom(); // Hyoa_roleuser.hy_roleid = lv_roleidnew[j]; // Hyoa_roleuser.hy_userid = dt.Rows[i]["hy_userid"].ToString(); // Hyoa_roleuser.Insert(); // } // } //} ////更新对应的flowtache ////先找出该角色对应的人 //HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser(); //for (int i = 0; i < dt.Rows.Count; i++) //{ // //将人员+老flowtacheid的先删除 // string[] lv_flowtacheidid; // lv_flowtacheidid = this.txthy_flowtacheids2.Text.Split(','); // for (int j = 0; j < lv_flowtacheidid.Length; j++) // { // if (lv_flowtacheidid[j] != "") // { // string ls_temp = lv_flowtacheidid[j]; // string[] lv_temp = ls_temp.Split('_'); // if (lv_temp.Length == 2) // { // string ls_flowid = lv_temp[0]; // string ls_tacheid = lv_temp[1]; // Hyoa_flowtacheuser.Deletebyroleidtacheiduserid(ls_flowid, ls_tacheid, dt.Rows[i]["hy_userid"].ToString()); // } // } // } // //将人员+新flowtacheid的插入 // string[] lv_flowtacheididnew; // lv_flowtacheididnew = this.txthy_flowtacheids.Text.Split(','); // for (int j = 0; j < lv_flowtacheididnew.Length; j++) // { // if (lv_flowtacheididnew[j] != "") // { // string ls_temp = lv_flowtacheididnew[j]; // string[] lv_temp = ls_temp.Split('_'); // if (lv_temp.Length == 2) // { // string ls_flowid = lv_temp[0]; // string ls_tacheid = lv_temp[1]; // Hyoa_flowtacheuser.ID = Hyoa_global.GetRandom(); // Hyoa_flowtacheuser.hy_flowid = ls_flowid; // Hyoa_flowtacheuser.hy_tacheid = ls_tacheid; // Hyoa_flowtacheuser.hy_userid = dt.Rows[i]["hy_userid"].ToString(); // Hyoa_flowtacheuser.Insert(); // } // } // } //} } //处理完成后的提示及跳转 if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); } }
private void DataPlay() { //判断当前用户是否有保存的权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { this.btn_submit.Visible = true; //保存 } else { this.btn_submit.Visible = false; //保存 } if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 //旧文档 if (this.txtop.Value == "modify") { if (this.Request.QueryString["id"] != null) { //根据id得到信息 this.txtdocid.Value = this.Request.QueryString["id"].ToString(); HyoaClass.Hyoa_jiaose Hyoa_jiaose = new HyoaClass.Hyoa_jiaose(); DataTable dt = Hyoa_jiaose.Getdocbyid(this.txtdocid.Value); if (dt.Rows.Count > 0) { this.txthy_jsname.Text = dt.Rows[0]["hy_jsname"].ToString(); this.txthy_roleids.Text = dt.Rows[0]["hy_roleids"].ToString(); this.txthy_rolenames.Text = dt.Rows[0]["hy_rolenames"].ToString(); this.txthy_flowtacheids.Text = dt.Rows[0]["hy_flowtacheids"].ToString(); this.txthy_flowtachenames.Text = dt.Rows[0]["hy_flowtachenames"].ToString(); this.txthy_sort.Text = dt.Rows[0]["hy_sort"].ToString(); this.txthy_bz.Text = dt.Rows[0]["hy_bz"].ToString(); this.txthy_roleids2.Text = dt.Rows[0]["hy_roleids"].ToString(); this.txthy_rolenames2.Text = dt.Rows[0]["hy_rolenames"].ToString(); this.txthy_flowtacheids2.Text = dt.Rows[0]["hy_flowtacheids"].ToString(); this.txthy_flowtachenames2.Text = dt.Rows[0]["hy_flowtachenames"].ToString(); } } } } }
//保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("../login.aspx"); string ls_tip = "保存成功!"; //新文档时 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (this.txtop.Value == "add") { //先判断这个用户是否已经存在 DataTable dtjudge = Hyoa_user.Getuserbyuserid(this.txtuserid.Text); if (dtjudge.Rows.Count > 0) { Response.Write("<script>alert('该用户名已注册,请重新注册!');history.back();</script>"); return; } else { //判断是否超过用户数限制 HyoaClass_conn.Hyoa_nbheyi Hyoa_nbheyi = new HyoaClass_conn.Hyoa_nbheyi(); DataTable dt1 = Hyoa_nbheyi.Getfirstnbheyi(); Int32 li_user1 = 0; if (dt1.Rows.Count > 0) { li_user1 = System.Int32.Parse(dt1.Rows[0]["hy_usernum"].ToString()) + 1; } DataTable dt2 = Hyoa_user.Getusers_jzcw(); Int32 li_user2 = 0; li_user2 = System.Int32.Parse(dt2.Rows.Count.ToString()); if (li_user1 <= li_user2) { //删除最近注册的账号 Response.Write("<script>alert('您的系统注册用户数授权已满,请联系管理员或宁波合益!');</script>"); return; } Hyoa_user.id = Hyoa_global.GetRandom(); Hyoa_user.hy_loginuid = this.txtuserid.Text; Hyoa_user.hy_userid = this.txtuserid.Text; Hyoa_user.hy_deptid = this.hy_deptid.Text; Hyoa_user.hy_username = this.txtusername.Value; Hyoa_user.hy_post = this.txtposition.Value; Hyoa_user.hy_ifleader = this.ddlifleader.SelectedValue.ToString(); Hyoa_user.hy_officetel = this.txtofficetel.Value; Hyoa_user.hy_hometel = this.txthometel.Value; Hyoa_user.hy_mobile = this.txtmobile.Value; Hyoa_user.hy_virtualnumber = this.txtvirtualtel.Value; Hyoa_user.hy_sort = float.Parse(this.txtuserno.Value); Hyoa_user.hy_isenabled = this.ddlisenabled.SelectedValue.ToString(); Hyoa_user.hy_createtime = System.DateTime.Now.ToString(); Hyoa_user.hy_edittime = System.DateTime.Now.ToString(); Hyoa_user.hy_birthday = this.txtbirthday.Value; Hyoa_user.hy_ifsrtx = ""; Hyoa_user.hy_fjh = this.txtfjh.Value; Hyoa_user.hy_xb = this.ddlxb.SelectedValue; Hyoa_user.hy_zzmm = this.txtzzmm.Value; Hyoa_user.hy_xl = this.txtxl.Value; Hyoa_user.hy_byyx = this.txtbyyx.Value; Hyoa_user.hy_jdwsj = this.txtjdwsj.Value; Hyoa_user.hy_jtzz = this.txtjtzz.Value; Hyoa_user.hy_sfzhm = this.txtsfzhm.Value; Hyoa_user.hy_bz = ""; Hyoa_user.hy_jsids = this.txtjsids.Value; Hyoa_user.hy_jsnames = this.txtjsnames.Value; Hyoa_user.hy_field1 = ""; Hyoa_user.hy_field2 = this.ddlhy_field2.SelectedValue.ToString(); Hyoa_user.hy_field3 = ""; Hyoa_user.hy_field4 = ""; Hyoa_user.hy_field5 = ""; Hyoa_user.Insert(); //写新增人员系统日志start HyoaClass.Hyoa_log Hyoa_log = new HyoaClass.Hyoa_log(); Hyoa_log.ID = System.Guid.NewGuid().ToString(); Hyoa_log.hy_createtime = System.DateTime.Now.ToString(); string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } Hyoa_log.hy_oppip = userip; Hyoa_log.hy_opptype = "新增"; Hyoa_log.hy_oppcontent = "新增用户:" + this.txtusername.Value; Hyoa_log.hy_oppuserid = this.Session["hyuid"].ToString(); Hyoa_log.hy_oppusername = this.Session["hyuname"].ToString(); Hyoa_log.Insert(); } } else { Hyoa_user.id = this.txtid.Text; Hyoa_user.hy_loginuid = this.txtuserid.Text; Hyoa_user.hy_userid = this.txtuserid.Text; Hyoa_user.hy_deptid = this.hy_deptid.Text; Hyoa_user.hy_username = this.txtusername.Value; Hyoa_user.hy_post = this.txtposition.Value; Hyoa_user.hy_ifleader = this.ddlifleader.SelectedValue.ToString(); Hyoa_user.hy_officetel = this.txtofficetel.Value; Hyoa_user.hy_hometel = this.txthometel.Value; Hyoa_user.hy_mobile = this.txtmobile.Value; Hyoa_user.hy_virtualnumber = this.txtvirtualtel.Value; Hyoa_user.hy_sort = float.Parse(this.txtuserno.Value); Hyoa_user.hy_isenabled = this.ddlisenabled.SelectedValue.ToString(); Hyoa_user.hy_edittime = System.DateTime.Now.ToString(); Hyoa_user.hy_birthday = this.txtbirthday.Value; Hyoa_user.hy_ifsrtx = ""; Hyoa_user.hy_fjh = this.txtfjh.Value; Hyoa_user.hy_xb = this.ddlxb.SelectedValue; Hyoa_user.hy_zzmm = this.txtzzmm.Value; Hyoa_user.hy_xl = this.txtxl.Value; Hyoa_user.hy_byyx = this.txtbyyx.Value; Hyoa_user.hy_jdwsj = this.txtjdwsj.Value; Hyoa_user.hy_jtzz = this.txtjtzz.Value; Hyoa_user.hy_sfzhm = this.txtsfzhm.Value; Hyoa_user.hy_bz = ""; Hyoa_user.hy_jsids = this.txtjsids.Value; Hyoa_user.hy_jsnames = this.txtjsnames.Value; Hyoa_user.hy_field1 = ""; Hyoa_user.hy_field2 = this.ddlhy_field2.SelectedValue.ToString(); Hyoa_user.hy_field3 = ""; Hyoa_user.hy_field4 = ""; Hyoa_user.hy_field5 = ""; Hyoa_user.Update(); //写新增人员系统日志start HyoaClass.Hyoa_log Hyoa_log = new HyoaClass.Hyoa_log(); Hyoa_log.ID = System.Guid.NewGuid().ToString(); Hyoa_log.hy_createtime = System.DateTime.Now.ToString(); string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } Hyoa_log.hy_oppip = userip; Hyoa_log.hy_opptype = "修改"; Hyoa_log.hy_oppcontent = "修改用户:" + this.txtusername.Value; Hyoa_log.hy_oppuserid = this.Session["hyuid"].ToString(); Hyoa_log.hy_oppusername = this.Session["hyuname"].ToString(); Hyoa_log.Insert(); } //根据角色分配权限 if (this.txtjsids.Value != this.txtjsids2.Text) { //选择的角色有所变化,则需要更新 HyoaClass.Hyoa_jiaose Hyoa_jiaose = new HyoaClass.Hyoa_jiaose(); HyoaClass.Hyoa_roleuser Hyoa_roleuser = new HyoaClass.Hyoa_roleuser(); HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser(); ///////////////////删除老角色的权限/////////////////////////////////// string[] lv_deljiaoseid = this.txtjsids2.Text.Split(','); if (lv_deljiaoseid.Length > 0) { for (int i = 0; i < lv_deljiaoseid.Length; i++) { if (lv_deljiaoseid[i] != "") { DataTable dt = Hyoa_jiaose.Getdocbyid(lv_deljiaoseid[i]); if (dt.Rows.Count > 0) { //更新对应的ROLE if (dt.Rows[0]["hy_roleids"].ToString() != "") { string[] lv_roleid; lv_roleid = dt.Rows[0]["hy_roleids"].ToString().Split(','); for (int j = 0; j < lv_roleid.Length; j++) { if (lv_roleid[j] != "") { Hyoa_roleuser.Deletebyroleidanduserid(lv_roleid[j], this.txtuserid.Text); } } } //更新对应的flowtache if (dt.Rows[0]["hy_flowtacheids"].ToString() != "") { string[] lv_flowtacheidid; lv_flowtacheidid = dt.Rows[0]["hy_flowtacheids"].ToString().Split(','); for (int j = 0; j < lv_flowtacheidid.Length; j++) { if (lv_flowtacheidid[j] != "") { string ls_temp = lv_flowtacheidid[j]; string[] lv_temp = ls_temp.Split('_'); if (lv_temp.Length == 2) { string ls_flowid = lv_temp[0]; string ls_tacheid = lv_temp[1]; Hyoa_flowtacheuser.Deletebyroleidtacheiduserid(ls_flowid, ls_tacheid, this.txtuserid.Text); } } } } } } } } ///////////////////增加新角色的权限/////////////////////////////////// string[] lv_addjiaoseid = this.txtjsids.Value.Split(','); if (lv_addjiaoseid.Length > 0) { for (int i = 0; i < lv_addjiaoseid.Length; i++) { if (lv_addjiaoseid[i] != "") { DataTable dt = Hyoa_jiaose.Getdocbyid(lv_addjiaoseid[i]); if (dt.Rows.Count > 0) { //更新对应的ROLE if (dt.Rows[0]["hy_roleids"].ToString() != "") { string[] lv_roleid; lv_roleid = dt.Rows[0]["hy_roleids"].ToString().Split(','); for (int j = 0; j < lv_roleid.Length; j++) { if (lv_roleid[j] != "") { Hyoa_roleuser.ID = Hyoa_global.GetRandom(); Hyoa_roleuser.hy_roleid = lv_roleid[j]; Hyoa_roleuser.hy_userid = this.txtuserid.Text; Hyoa_roleuser.Insert(); } } } //更新对应的flowtache if (dt.Rows[0]["hy_flowtacheids"].ToString() != "") { string[] lv_flowtacheidid; lv_flowtacheidid = dt.Rows[0]["hy_flowtacheids"].ToString().Split(','); for (int j = 0; j < lv_flowtacheidid.Length; j++) { if (lv_flowtacheidid[j] != "") { string ls_temp = lv_flowtacheidid[j]; string[] lv_temp = ls_temp.Split('_'); if (lv_temp.Length == 2) { string ls_flowid = lv_temp[0]; string ls_tacheid = lv_temp[1]; Hyoa_flowtacheuser.ID = Hyoa_global.GetRandom(); Hyoa_flowtacheuser.hy_flowid = ls_flowid; Hyoa_flowtacheuser.hy_tacheid = ls_tacheid; Hyoa_flowtacheuser.hy_userid = this.txtuserid.Text; Hyoa_flowtacheuser.Insert(); } } } } } } } } } //处理完成后的提示及跳转 if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); } }