protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
{
int userId = (Convert.ToInt32(Request.Params["id"]));
BLL.dept placeBll = new BLL.dept();
ddrPlace.DataTextField = "deptName";
ddrPlace.DataValueField = "deptId";
ddrPlace.DataSource = placeBll.GetList("");
ddrPlace.DataBind();
ddrPlace.Items.Insert(0, new ListItem("请选择", "0"));
BLL.role roleBll = new BLL.role();
ddrRole.DataTextField = "roleName";
ddrRole.DataValueField = "roleId";
ddrRole.DataSource = roleBll.GetList("roleId<>1");
ddrRole.DataBind();
try
{
ShowInfo(userId);
}
catch (Exception ex)
{ }
}
}
}
/// <summary>
/// 绑定上级部门列表
/// </summary>
/// <param name="ddl"></param>
/// <returns></returns>
public static bool AddDeptPaeent(DropDownList ddl)
{
try
{
ddl.Items.Clear();
BLL.dept deptBll = new BLL.dept();
DataTable dt = deptBll.GetList("parentId=0").Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
ddl.Items.Add(new ListItem(dt.Rows[i]["deptName"].ToString(), dt.Rows[i]["deptId"].ToString()));
DataTable dt2 = deptBll.GetList("parentId=" + dt.Rows[i]["deptId"].ToString()).Tables[0];
for (int j = 0; j < dt2.Rows.Count; j++)
{
ddl.Items.Add(new ListItem("┣" + dt2.Rows[j]["deptName"].ToString(), dt2.Rows[j]["deptId"].ToString()));
DataTable dt3 = deptBll.GetList("parentId=" + dt2.Rows[j]["deptId"].ToString()).Tables[0];
for (int k = 0; k < dt3.Rows.Count; k++)
{
ddl.Items.Add(new ListItem("┣╍" + dt3.Rows[k]["deptName"].ToString(), dt3.Rows[k]["deptId"].ToString()));
}
}
}
ddl.Items.Insert(0, new ListItem("无上级", "0"));
return(true);
}
catch
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append("roleId=2 ");
if (Common.Cookie.GetValue(StatusHelpercs.Cookie_Admin_IsAdmin) != "1")
{
BLL.dept pBll = new BLL.dept();
strWhere.Append(" and deptId in (" + pBll.GetAllChild(int.Parse(Request.Cookies["deptId"].Value)) + ") ");
}
rptList.DataSource = bll.GetList(strWhere.ToString() + " order by addTime desc");
rptList.DataBind();
}
if (RequsetAjax("del"))
{
//删除
try
{
string userId = Request.Form["userId"].ToString();
bll.Delete(int.Parse(userId));
Response.Write("{\"status\":1,\"msg\":\"成功！\"}");
}
catch { Response.Write("{\"status\":0,\"msg\":\"失败！\"}"); }
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BLL.dept pBll = new BLL.dept();
string placeSql = "";
string roleSql = "roleId<>1";
if (Request.Cookies["isAdmin"].Value != "1")
{
placeSql = " deptId in (" + pBll.GetAllChild(int.Parse(Request.Cookies["deptId"].Value)) + ") ";
roleSql = "roleId>2";
}
ClassHelper.AddDeptList(ddrPlace);
BLL.role roleBll = new BLL.role();
ddrRole.DataTextField = "roleName";
ddrRole.DataValueField = "roleId";
ddrRole.DataSource = roleBll.GetList(roleSql);
ddrRole.DataBind();
ddrRole.Items.Insert(0, new ListItem("请选择", "0"));
ddrRole.SelectedValue = "2";
ddrRole.Enabled = false;
}
}
/// <summary>
/// 绑定上级部门列表
/// </summary>
/// <param name="ddl"></param>
/// <returns></returns>
public static bool AddDeptPaeent(DropDownList ddl)
{
try
{
ddl.Items.Clear();
BLL.dept deptBll = new BLL.dept();
DataTable dt = deptBll.GetList("parentId=0").Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
ddl.Items.Add(new ListItem(dt.Rows[i]["deptName"].ToString(), dt.Rows[i]["deptId"].ToString()));
DataTable dt2 = deptBll.GetList("parentId=" + dt.Rows[i]["deptId"].ToString()).Tables[0];
for (int j = 0; j < dt2.Rows.Count; j++)
{
ddl.Items.Add(new ListItem("┣" + dt2.Rows[j]["deptName"].ToString(), dt2.Rows[j]["deptId"].ToString()));
DataTable dt3 = deptBll.GetList("parentId=" + dt2.Rows[j]["deptId"].ToString()).Tables[0];
for (int k = 0; k < dt3.Rows.Count; k++)
{
ddl.Items.Add(new ListItem("┣╍" + dt3.Rows[k]["deptName"].ToString(), dt3.Rows[k]["deptId"].ToString()));
}
}
}
ddl.Items.Insert(0, new ListItem("无上级", "0"));
return true;
}
catch
{
return false;
}
}
private void TreeBind(DropDownList ddl)
{
BLL.dept bll = new BLL.dept();
DataTable dt = bll.GetList("").Tables[0];
ddl.Items.Clear();
ddl.Items.Add(new ListItem("请选择部门...", ""));
foreach (DataRow dr in dt.Rows)
{
ddl.Items.Add(new ListItem(dr["dept_name"].ToString(), dr["id"].ToString()));
}
}
private void TreeBind(string strWhere)
{
BLL.dept bll = new BLL.dept();
DataTable dt = bll.GetList(0, strWhere, "id desc").Tables[0];
this.ddlDeptId.Items.Clear();
this.ddlDeptId.Items.Add(new ListItem("所有部门", ""));
foreach (DataRow dr in dt.Rows)
{
this.ddlDeptId.Items.Add(new ListItem(dr["dept_name"].ToString(), dr["id"].ToString()));
}
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
this.txtKeywords.Text = this.keywords;
BLL.dept bll = new BLL.dept();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("dept_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_dept", DTEnums.ActionEnum.Delete.ToString()); //检查权限
BLL.dept bll = new BLL.dept();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked && GetAdminInfo().id != id)
{
bll.Delete(id);
}
}
JscriptMsg("批量删除成功啦！", Utils.CombUrlTxt("dept_list.aspx", "keywords={0}", this.keywords), "Success");
}
private bool DoEdit(int _id)
{
bool result = true;
BLL.dept bll = new BLL.dept();
Model.dept model = bll.GetModel(_id);
model.dept_name = txtDeptName.Text.Trim();
if (!bll.Update(model))
{
result = false;
}
return(result);
}
private bool DoAdd()
{
bool result = true;
Model.dept model = new Model.dept();
BLL.dept bll = new BLL.dept();
model.dept_name = txtDeptName.Text.Trim();
model.add_time = DateTime.Now;
if (bll.Add(model) < 1)
{
result = false;
}
return(result);
}
public void BindData()
{
#region
//if (!Context.User.Identity.IsAuthenticated)
//{
// return;
//}
//AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name);
//if (user.HasPermissionID(PermId_Modify))
//{
// gridView.Columns[6].Visible = true;
//}
//if (user.HasPermissionID(PermId_Delete))
//{
// gridView.Columns[7].Visible = true;
//}
#endregion
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
strWhere.Append("roleId=2 ");
if (txtKeyword.Text.Trim() != "")
{
strWhere.AppendFormat(" and userName like '%{0}%'", txtKeyword.Text.Trim());
}
if (Request.Cookies["isAdmin"].Value != "1")
{
BLL.dept pBll = new BLL.dept();
strWhere.Append(" and deptId in (" + pBll.GetAllChild(int.Parse(Request.Cookies["deptId"].Value)) + ") ");
}
ds = bll.GetList(strWhere.ToString());
string[] arr = { "冻结", "正常" };
Common.CommonHelper.AddDtColumns(ds.Tables[0], "status", arr);
gridView.DataSource = ds;
gridView.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BLL.dept pBll = new BLL.dept();
string placeSql = "";
string roleSql = "roleId<>1";
if (Request.Cookies["isAdmin"].Value != "1")
{
placeSql = " deptId in (" + pBll.GetAllChild(int.Parse(Request.Cookies["deptId"].Value)) + ") ";
roleSql = "roleId>2";
}
ClassHelper.AddDeptList(ddrPlace);
BLL.role roleBll = new BLL.role();
ddrRole.DataTextField = "roleName";
ddrRole.DataValueField = "roleId";
ddrRole.DataSource = roleBll.GetList(roleSql);
ddrRole.DataBind();
ddrRole.Items.Insert(0, new ListItem("请选择", "0"));
}
}
private void ShowInfo(int _id)
{
BLL.dept bll = new BLL.dept();
Model.dept model = bll.GetModel(_id);
txtDeptName.Text = model.dept_name;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
{
int userId=(Convert.ToInt32(Request.Params["id"]));
BLL.dept placeBll = new BLL.dept();
ddrPlace.DataTextField = "deptName";
ddrPlace.DataValueField = "deptId";
ddrPlace.DataSource = placeBll.GetList("");
ddrPlace.DataBind();
ddrPlace.Items.Insert(0,new ListItem("请选择","0"));
BLL.role roleBll = new BLL.role();
ddrRole.DataTextField = "roleName";
ddrRole.DataValueField = "roleId";
ddrRole.DataSource = roleBll.GetList("roleId<>1");
ddrRole.DataBind();
try
{
ShowInfo(userId);
}
catch (Exception ex)
{ }
}
}
}
