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) + "\")";
}
