protected void GetLogData() { string strWhere = "1=1"; SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: break; case 1: strWhere += " and username != 'yu'"; break; case 2: strWhere += " and username != 'yu' and maindeptid=" + SessionBox.GetUserSession().DeptNumber; ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; ddlDept.Enabled = false; break; default: strWhere += " and username != 'yu' and maindeptid=" + SessionBox.GetUserSession().DeptNumber; ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; ddlDept.Enabled = false; break; } if (ddlDept.SelectedValue != "-1") { strWhere += " and maindeptid=" + ddlDept.SelectedValue; } if (ddlKQ.SelectedValue != "-1") { strWhere += " and DEPTNUMBER=" + ddlKQ.SelectedValue; } if (txtIP.Text.Trim() != "") { strWhere += " and IP like '%" + txtIP.Text.Trim() + "%'"; } if (txtName.Text.Trim() != "") { strWhere += " and Name like '%" + txtName.Text.Trim() + "%'"; } if (txtUser.Text.Trim() != "") { strWhere += " and UserName like '%" + txtUser.Text.Trim() + "%'"; } if (txtPsnNo.Text.Trim() != "") { strWhere += " and personnumber like '%" + txtPsnNo.Text.Trim() + "%'"; } strWhere += " and activetime between to_date('" + dateBegin.Date.ToShortDateString() + "','YYYY-MM-DD') and to_date('" + dateEnd.Date.ToShortDateString() + "','YYYY-MM-DD')"; string strSql = "select * from vuserlog where " + strWhere; gvLogManage.DataSource = OracleHelper.Query(strSql); gvLogManage.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Login.aspx"); } else { //初始化模块权限 UserHandle.InitModule(this.PageTag); //是否有浏览权限 if (UserHandle.ValidationHandle(PermissionTag.Browse)) { GridViewCommandColumn colEdit = (GridViewCommandColumn)gridRole.Columns["编辑"]; if (!UserHandle.ValidationHandle(PermissionTag.Add)) { colEdit.NewButton.Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.Edit)) { colEdit.EditButton.Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.Delete)) { colEdit.DeleteButton.Visible = false; } SF_Role r = rbll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: Session["WhereRole"] = " "; break; case 1: Session["WhereRole"] = string.Format("levelid >={0}", rolelevel); break; case 2: Session["WhereRole"] = string.Format("MAINDEPTID='{0}'", maindeptid); gridRole.Columns["创建单位"].Visible = false; break; default: Session["WhereRole"] = string.Format("MAINDEPTID='{0}'", maindeptid); gridRole.Columns["创建单位"].Visible = false; break; } BindRole(); } } } //if(rolelevel > 1) //{ // Session["WhereRole"] = string.Format("MAINDEPTID='{0}'",maindeptid); //} }
protected void BindRole(string userID) { User bll = new User(); lstOldRole.Items.Clear(); lstSelectedRole.Items.Clear(); List <string> rid = bll.GetUserRoleArray(int.Parse(userID)); string strwhere = ""; for (int i = 0; i < rid.Count; i++) { string[] r = rid[i].ToString().Split(','); lstSelectedRole.Items.Add(new ListItem(r[1], r[0])); strwhere += r[0] + ","; } if (strwhere != "") { txtOldRole.Text = strwhere.Substring(0, strwhere.Length - 1); strwhere = "not RoleID in(" + txtOldRole.Text + ")"; } Role bll2 = new Role(); SF_Role r2 = bll2.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); switch ((int)r2.LevelID) { case 0: lstOldRole.DataSource = bll2.GetRoleList(strwhere, ""); lstOldRole.DataTextField = "RoleName"; lstOldRole.DataValueField = "RoleID"; lstOldRole.DataBind(); break; case 1: lstOldRole.DataSource = bll2.GetRoleList(strwhere + " and levelid >= 1", ""); lstOldRole.DataTextField = "RoleName"; lstOldRole.DataValueField = "RoleID"; lstOldRole.DataBind(); break; case 2: lstOldRole.DataSource = bll2.GetRoleList(strwhere + string.Format(" and MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", r2.LevelID.ToString()), ""); lstOldRole.DataTextField = "RoleName"; lstOldRole.DataValueField = "RoleID"; lstOldRole.DataBind(); //Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); break; default: lstOldRole.DataSource = bll2.GetRoleList(strwhere + string.Format(" and MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", r2.LevelID.ToString()), ""); lstOldRole.DataTextField = "RoleName"; lstOldRole.DataValueField = "RoleID"; lstOldRole.DataBind(); //Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); break; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Login.aspx"); } else { SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = (int)r.LevelID; roledeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: Session["WhereRole"] = string.Format("levelid >={0}", rolelevel); break; case 1: Session["WhereRole"] = string.Format("levelid >={0}", rolelevel); break; case 2: Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); break; default: Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); break; } //if (rolelevel > 1) //{ // Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); // //Session["WhereUserGroup"] = "usergroupid not in(2,3,23)"; // //Session["maindeptid"] = SessionBox.GetUserSession().DeptNumber; // //Session["deptid"] = SessionBox.GetUserSession().DeptNumber.Remove(4); //} //List<string> lstRole = new List<string>(); //lstRole.Add("2"); //lstRole.Add("46"); //if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "31") //{ // Session["WhereRole"] = " "; //} //else if (lstRole.Contains(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])) //{ // Session["WhereRole"] = "roleid != 31"; //} //else //{ // Session["WhereRole"] = "roleid NOT in(2,31,46)"; //} } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Login.aspx"); } else { SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = (int)r.LevelID; roledeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: Session["WhereRole"] = string.Format("levelid >={0}", rolelevel); break; case 1: Session["WhereRole"] = string.Format("levelid >={0}", rolelevel); break; case 2: Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); break; default: Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); break; } //List<string> lstRole = new List<string>(); //lstRole.Add("2"); //lstRole.Add("46"); //if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "31") //{ // Session["WhereRole"] = " "; //} //else if (lstRole.Contains(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])) //{ // Session["WhereRole"] = "roleid != 31"; //} //else //{ // Session["WhereRole"] = "roleid NOT in(2,31,46)"; //} } } if (Session["UserIDList"] != null) { lblRole.Text = ""; } btnAdd.Enabled = lstOldRole.SelectedIndex >= 0 ? true : false; btnRemove.Enabled = lstSelectedRole.SelectedIndex >= 0 ? true : false; }
protected void gridRole_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { SF_Role r = rbll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; e.NewValues["LEVELID"] = rolelevel; if (rolelevel > 1) { e.NewValues["MAINDEPTID"] = maindeptid; } else { e.NewValues["MAINDEPTID"] = "000000000"; } }
private void BindRole() { Session["WhereRole"] = null; string strWhere = "1=1"; SF_Role r = rbll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: strWhere += string.Format(" and levelid >={0}", rolelevel); break; case 1: strWhere += string.Format(" and levelid >={0}", rolelevel); break; case 2: strWhere += string.Format(" and MAINDEPTID='{0}'", maindeptid); break; default: strWhere += string.Format(" and MAINDEPTID='{0}'", maindeptid); break; } //if (rolelevel > 1) //{ // strWhere += string.Format("MAINDEPTID='{0}'", maindeptid); //} if (txtRoleAbout.Text.Trim() != "") { strWhere += string.Format(" and roleabout like '%{0}%'", txtRoleAbout.Text.Trim()); } if (txtRoleName.Text.Trim() != "") { strWhere += string.Format(" and rolename like '%{0}%'", txtRoleName.Text.Trim()); } //var ds = rbll.GetRoleList(strWhere, " ORDER BY CreateTime DESC"); ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = strWhere; ObjectDataSource1.SelectParameters["strOrder"].DefaultValue = " ORDER BY CreateTime DESC"; gridRole.DataSourceID = ObjectDataSource1.ID; gridRole.DataBind(); gridRole.KeyFieldName = "ROLEID"; }
/// <summary> /// 绑定用户数据 /// </summary> protected void InitData() { string strWhere = "1=1"; SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: BindDll(ddlDept, "(substr(deptnumber,1,2)='23' or substr(deptnumber,1,2)='24' or substr(deptnumber,1,2)='13' or substr(deptnumber,1,3)='552' or substr(deptnumber,1,4)='5503') and substr(deptnumber,5,5)='00000'", "DEPTNAME", "DEPTNUMBER"); break; case 1: strWhere += " and username != 'yu'"; BindDll(ddlDept, "(substr(deptnumber,1,2)='23' or substr(deptnumber,1,2)='24' or substr(deptnumber,1,2)='13' or substr(deptnumber,1,3)='552' or substr(deptnumber,1,4)='5503') and substr(deptnumber,5,5)='00000'", "DEPTNAME", "DEPTNUMBER"); break; case 2: strWhere += " and username != 'yu' and Maindeptid=" + SessionBox.GetUserSession().DeptNumber; BindDll(ddlDept, "(substr(deptnumber,1,2)='23' or substr(deptnumber,1,2)='24' or substr(deptnumber,1,2)='13' or substr(deptnumber,1,3)='552' or substr(deptnumber,1,4)='5503') and substr(deptnumber,5,5)='00000'", "DEPTNAME", "DEPTNUMBER"); ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; BindDll(ddlKQ, "ID", ddlDept.SelectedItem.Value.Remove(4), "NAME", "ID"); ddlDept.Enabled = false; break; default: strWhere += " and username != 'yu' and Maindeptid=" + SessionBox.GetUserSession().DeptNumber; BindDll(ddlDept, "(substr(deptnumber,1,2)='23' or substr(deptnumber,1,2)='24' or substr(deptnumber,1,2)='13' or substr(deptnumber,1,3)='552' or substr(deptnumber,1,4)='5503') and substr(deptnumber,5,5)='00000'", "DEPTNAME", "DEPTNUMBER"); ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; BindDll(ddlKQ, "ID", ddlDept.SelectedItem.Value.Remove(4), "NAME", "ID"); ddlDept.Enabled = false; break; } dateBegin.Date = DateTime.Parse(System.DateTime.Now.Year + "-" + System.DateTime.Now.Month + "-01"); dateEnd.Date = DateTime.Today.AddDays(1); strWhere += " and activetime between to_date('" + dateBegin.Date.ToShortDateString() + "','YYYY-MM-DD') and to_date('" + dateEnd.Date.ToShortDateString() + "','YYYY-MM-DD')"; string strSql = "select * from vuserlog where " + strWhere; gvLogManage.DataSource = OracleHelper.Query(strSql); gvLogManage.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Login.aspx"); } else { SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = (int)r.LevelID; roledeptid = SessionBox.GetUserSession().DeptNumber; if (rolelevel > 1) { Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); Session["WhereUserGroup"] = "usergroupid not in(2,3,23)"; Session["maindeptid"] = SessionBox.GetUserSession().DeptNumber; Session["deptid"] = SessionBox.GetUserSession().DeptNumber.Remove(4); } InitData(); } } }
protected void BindOrder() { string strWhere = "1=1"; SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: break; case 1: strWhere += " and userid != 1"; break; case 2: strWhere += " and userid != 1 and DEPTNUMBER=" + SessionBox.GetUserSession().DeptNumber; ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; ddlDept.Enabled = false; break; default: strWhere += " and userid != 1 and DEPTNUMBER=" + SessionBox.GetUserSession().DeptNumber; ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; ddlDept.Enabled = false; break; } if (ddlUserGroup.SelectedValue != "-1") { strWhere += " and USERGROUPID=" + ddlUserGroup.SelectedValue; } if (ddlRole.SelectedValue != "-1") { strWhere += " and ROLENAME like '%" + ddlRole.SelectedItem.Text + "%'"; } if (ddlDept.SelectedValue != "-1") { strWhere += " and DEPTNUMBER=" + ddlDept.SelectedValue; } if (ddlKQ.SelectedValue != "-1") { strWhere += " and DEPTID in (select deptnumber from department start with deptnumber = " + ddlKQ.SelectedValue + " connect by prior deptnumber = fatherid)"; } //if (ddlIsOnline.SelectedValue != "-1") //{ // strWhere += " and isonline=" + ddlIsOnline.SelectedValue; //} if (ddlUserStatus.SelectedValue != "-1") { strWhere += " and userstatus=" + ddlUserStatus.SelectedValue; } if (txtName.Text.Trim() != "") { strWhere += " and Name like '%" + txtName.Text.Trim() + "%'"; } if (txtUser.Text.Trim() != "") { strWhere += " and UserName like '%" + txtUser.Text.Trim() + "%'"; } if (txtPsnNo.Text.Trim() != "") { strWhere += " and personnumber like '%" + txtPsnNo.Text.Trim() + "%'"; } var ds = bll.GetUserList2(strWhere, " ORDER BY CreateTime DESC"); ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = strWhere; ObjectDataSource1.SelectParameters["strOrder"].DefaultValue = " ORDER BY CreateTime DESC"; if (ds.Tables[0].Rows.Count == 0) { GridViewMsg.InnerText = "无记录"; } else { GridViewMsg.InnerText = "共有" + ds.Tables[0].Rows.Count + "条记录"; } gridUser.DataSourceID = ObjectDataSource1.ID; //gvUserList.DataSource = ds; gridUser.DataBind(); gridUser.KeyFieldName = "USERID"; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Aspose.Cells.License license = new Aspose.Cells.License(); //license.SetLicense("License.lic"); if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Login.aspx"); } else { SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = (int)r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: //Session["WhereRole"] = string.Format(" levelid >={0}", rolelevel); InitRole(string.Format(" levelid >={0}", rolelevel)); InitUserGroup(""); break; case 1: //Session["WhereRole"] = string.Format(" levelid >={0}", rolelevel); InitRole(string.Format(" levelid >={0}", rolelevel)); InitUserGroup(""); break; case 2: //Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); //Session["WhereUserGroup"] = "usergroupid not in(2,3,23)"; InitRole(string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString())); InitUserGroup("usergroupid not in(2,3,23)"); break; default: //Session["WhereRole"] = string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString()); //Session["WhereUserGroup"] = "usergroupid not in(2,3,23)"; InitRole(string.Format("MAINDEPTID='{0}' or (maindeptid='{1}' and levelid>={2})", SessionBox.GetUserSession().DeptNumber, "000000000", rolelevel.ToString())); InitUserGroup("usergroupid not in(2,3,23)"); break; } UserHandle.InitModule(this.PageTag); //初始化此模块的权限。 if (UserHandle.ValidationHandle(PermissionTag.Browse)) //是否有浏览权限 { //UserHandle.BindDropDownList(ddlUserGroup, 0); //DevExpress.Web.ASPxGridView.GridViewCommandColumn colEdit = (DevExpress.Web.ASPxGridView.GridViewCommandColumn)gridUser.Columns["编辑"]; //DevExpress.Web.ASPxGridView.GridViewCommandColumn colDel = (DevExpress.Web.ASPxGridView.GridViewCommandColumn)gridUser.Columns["删除"]; if (!UserHandle.ValidationHandle(PermissionTag.Add)) { btnAddUser.Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.Edit)) { gridUser.Columns["编辑"].Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.Delete)) { gridUser.Columns["删除"].Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.Search)) { btnSearch.Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.BatchEditRole)) { btnEditRole.Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.BatchEditUsergroup)) { btnEditUsergroup.Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.ResetPassword)) { gridUser.Columns["密码重置"].Visible = false; } if (!UserHandle.ValidationHandle(PermissionTag.ImportUser)) { btnBatchAddUser.Visible = false; } } else { Session["ErrorNum"] = "0"; Response.Redirect("~/Error.aspx"); } InitData(); } } }
/// <summary> /// 绑定用户数据 /// </summary> protected void InitData() { string strWhere = "1=1"; SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: //BindDll(ddlDept, "deptnumber like'%00000' and deptname like'%公司'", "DEPTNAME", "DEPTNUMBER"); BindDll(ddlDept, "(substr(deptnumber,1,2)='23' or substr(deptnumber,1,2)='24' or substr(deptnumber,1,2)='13' or substr(deptnumber,1,2)='55' or substr(deptnumber,1,4)='5503' or substr(deptnumber,1,4)='5504' or substr(deptnumber,1,4)='5513' or substr(deptnumber,1,4)='5564') and substr(deptnumber,5,5)='00000'", "DEPTNAME", "DEPTNUMBER"); break; case 1: strWhere += " and userid != 1"; //BindDll(ddlDept, "deptnumber like'%00000' and deptname like'%公司'", "DEPTNAME", "DEPTNUMBER"); BindDll(ddlDept, "(substr(deptnumber,1,2)='23' or substr(deptnumber,1,2)='24' or substr(deptnumber,1,2)='13' or substr(deptnumber,1,2)='55' or substr(deptnumber,1,4)='5503' or substr(deptnumber,1,4)='5504' or substr(deptnumber,1,4)='5513' or substr(deptnumber,1,4)='5564') and substr(deptnumber,5,5)='00000'", "DEPTNAME", "DEPTNUMBER"); break; case 2: strWhere += " and userid != 1 and DEPTNUMBER=" + SessionBox.GetUserSession().DeptNumber; //BindDll(ddlDept, "deptnumber like'%00000' and deptname like'%公司'", "DEPTNAME", "DEPTNUMBER"); BindDll(ddlDept, "(substr(deptnumber,1,2)='23' or substr(deptnumber,1,2)='24' or substr(deptnumber,1,2)='13' or substr(deptnumber,1,2)='55' or substr(deptnumber,1,4)='5503' or substr(deptnumber,1,4)='5504' or substr(deptnumber,1,4)='5513' or substr(deptnumber,1,4)='5564') and substr(deptnumber,5,5)='00000'", "DEPTNAME", "DEPTNUMBER"); ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; BindDll(ddlKQ, "ID", ddlDept.SelectedItem.Value.Remove(4), "NAME", "ID"); ddlDept.Enabled = false; break; default: strWhere += " and userid != 1 and DEPTNUMBER=" + SessionBox.GetUserSession().DeptNumber; BindDll(ddlDept, "(substr(deptnumber,1,2)='23' or substr(deptnumber,1,2)='24' or substr(deptnumber,1,2)='13' or substr(deptnumber,1,2)='55' or substr(deptnumber,1,4)='5503' or substr(deptnumber,1,4)='5504' or substr(deptnumber,1,4)='5513' or substr(deptnumber,1,4)='5564') and substr(deptnumber,5,5)='00000'", "DEPTNAME", "DEPTNUMBER"); ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; BindDll(ddlKQ, "ID", ddlDept.SelectedItem.Value.Remove(4), "NAME", "ID"); ddlDept.Enabled = false; break; } //string strWhere = "1=1"; //if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "31") //{ // //Session["WhereUser"] = "******"; //} //else if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "2" || SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "46") //{ // //Session["WhereUser"] = "******"; // //Session["WhereRole"] = "roleid NOT in(31)"; // strWhere += " and userid != 1"; //} //else //{ // //Session["WhereRole"] = "roleid NOT in(2,31,46)"; // //Session["WhereUserGroup"] = "usergroupid not in(2,3,23)"; // //Session["WhereUser"] = "******" + SessionBox.GetUserSession().DeptNumber; // strWhere += " and userid != 1 and DEPTNUMBER=" + SessionBox.GetUserSession().DeptNumber; // ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; // ddlDept.Enabled = false; //} Session["WhereRole"] = "ROLESTATUS=1"; var ds = bll.GetUserList2(strWhere, " ORDER BY CreateTime DESC"); ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = strWhere; ObjectDataSource1.SelectParameters["strOrder"].DefaultValue = " ORDER BY CreateTime DESC"; if (ds.Tables[0].Rows.Count == 0) { GridViewMsg.InnerText = "无记录"; } else { GridViewMsg.InnerText = "共有" + ds.Tables[0].Rows.Count + "条记录"; } gridUser.DataSourceID = ObjectDataSource1.ID; //gvUserList.DataSource = ds; gridUser.DataBind(); gridUser.KeyFieldName = "USERID"; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Login.aspx"); } else { SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = (int)r.LevelID; roledeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: Session["WhereRole"] = "ROLESTATUS=1"; break; case 1: Session["WhereRole"] = string.Format("levelid >={0} and ROLESTATUS=1", rolelevel); break; case 2: Session["WhereRole"] = string.Format("MAINDEPTID='{0}' and ROLESTATUS=1", roledeptid); break; default: Session["WhereRole"] = string.Format("MAINDEPTID='{0}' and ROLESTATUS=1", roledeptid); break; } //if (rolelevel > 1) //{ // Session["WhereRole"] = string.Format("MAINDEPTID='{0}'", SessionBox.GetUserSession().DeptNumber); //} //List<string> lstRole = new List<string>(); //lstRole.Add("2"); //lstRole.Add("46"); //if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "31") //{ // Session["WhereRole"] = " "; //} //else if (lstRole.Contains(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])) //{ // Session["WhereRole"] = "roleid != 31"; //} //else //{ // Session["WhereRole"] = "roleid NOT in(2,31,46)"; //} //初始化模块权限 UserHandle.InitModule(this.PageTag); if (UserHandle.ValidationHandle(PermissionTag.Browse))//是否有浏览权限 { BindModule(); if (!UserHandle.ValidationHandle(PermissionTag.Edit)) { gvModuleOperator.Columns[2].Visible = false; } } else { Session["ErrorNum"] = "0"; Response.Redirect("~/Error.aspx"); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!SessionBox.CheckUserSession()) { Response.Redirect("~/Login.aspx"); } else { SF_Role r = Rolebll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0])); rolelevel = (int)r.LevelID; Session["rolelevel"] = r.LevelID; maindeptid = SessionBox.GetUserSession().DeptNumber; switch ((int)rolelevel) { case 0: BindGridView(0, "PERSON", _pageSize, "", "", ""); AspNetPager1.RecordCount = p.PersonCount(); BindDll(ddlDept, "ID", @"24\d\d0{5}", "NAME", "ID"); break; case 1: BindGridView(0, "PERSON", _pageSize, "", "", ""); AspNetPager1.RecordCount = p.PersonCount(); BindDll(ddlDept, "ID", @"24\d\d0{5}", "NAME", "ID"); break; case 2: BindGridView(0, "PERSON", _pageSize, string.Format("maindeptid='{0}'", SessionBox.GetUserSession().DeptNumber), "", ""); AspNetPager1.RecordCount = p.PersonCount(); BindDll(ddlDept, "ID", @"24\d\d0{5}", "NAME", "ID"); ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; BindDll(ddlKQ, "ID", ddlDept.SelectedItem.Value.Remove(4), "NAME", "ID"); ddlKQ.Items.Insert(0, new ListItem("--全部--", "-1")); ddlDept.Enabled = false; break; default: BindGridView(0, "PERSON", _pageSize, string.Format("maindeptid='{0}'", SessionBox.GetUserSession().DeptNumber), "", ""); AspNetPager1.RecordCount = p.PersonCount(); BindDll(ddlDept, "ID", @"24\d\d0{5}", "NAME", "ID"); ddlDept.SelectedValue = SessionBox.GetUserSession().DeptNumber; BindDll(ddlKQ, "ID", ddlDept.SelectedItem.Value.Remove(4), "NAME", "ID"); ddlKQ.Items.Insert(0, new ListItem("--全部--", "-1")); ddlDept.Enabled = false; break; } //初始化模块权限 UserHandle.InitModule(this.PageTag); //是否有浏览权限 if (UserHandle.ValidationHandle(PermissionTag.Browse)) { GridViewCommandColumn colEdit = (GridViewCommandColumn)gvPerson.Columns["操作"]; if (!UserHandle.ValidationHandle(PermissionTag.Edit)) { colEdit.EditButton.Visible = false; } } } } //adsPosition.Where = "Maindeptid == \"" + SessionBox.GetUserSession().DeptNumber + "\""; //adsDept.Where = "Deptnumber.StartsWith(\"" + SessionBox.GetUserSession().DeptNumber.Remove(4) + "\")"; }