/// <summary> /// 绑定付费列表数据 /// </summary> private void BindPaymentList() { LoginInfo login = (LoginInfo)Session["login"]; string sqlstr = ""; sqlstr += FilterSql; string ids = LoginDataLimitManager.GetLimit(login.Id); if (string.IsNullOrEmpty(ids)) { sqlstr += " and makerID = " + login.Id; } else { sqlstr += " and makerID in (" + ids + ")"; } SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 017); Data data = new Data(); if (sps == null) { DataSet ds = data.DataPage("View_PaymentList", "id", "*", sqlstr, "requestDate", true, 10, 5, pages); RpPaymentList.DataSource = ds; RpPaymentList.DataBind(); } else { DataSet ds = data.DataPage("View_PaymentList", "id", "*", sqlstr, "requestDate", true, sps.Pageitem, sps.Pagecount, pages); RpPaymentList.DataSource = ds; RpPaymentList.DataBind(); } }
private void InitDataTree(int loginId) { List <string> treenodes = new List <string>(); IList <DepartmentInfo> departmentList = DepartmentInfoManager.getDepartmentInfoAll(); //IList<DepartmentInfo> departmentList = DepartmentInfoManager.getDepartmentInfoAllById(loginId); foreach (DepartmentInfo deparment in departmentList) { string node = string.Format("{{ 'id':'{0}', 'pId':'{1}', 'name':'{2}', 'open':'true','halfCheck':'false','isParent':'true','icon':'../../images/public/folder_user.gif'}}", "dp" + deparment.Departid, 0, deparment.Departcname); treenodes.Add(node); } IList <LoginInfo> loginList = LoginInfoManager.getLoginInfoAll(); string ids = "," + LoginDataLimitManager.GetLimit(loginId) + ","; foreach (LoginInfo login in loginList) { string node = string.Format("{{ 'id':'{0}', 'pId':'{1}', 'name':'{2}', 'checked':'{3}','icon':'../../images/public/group.gif'}}", login.Id, "dp" + login.Departid, login.Cname, ids.IndexOf("," + login.Id.ToString() + ",") < 0 ? false : true); treenodes.Add(node); } NodesData = string.Join(",", treenodes.ToArray()); }
private void bindDatasource() { string sqlstr = ""; sqlstr += Session["query"].ToString(); LoginInfo login = (LoginInfo)Session["login"]; string ids = LoginDataLimitManager.GetLimit(login.Id); if (string.IsNullOrEmpty(ids)) { sqlstr += " and invoiceCMan = " + login.Id; } else { sqlstr += " and invoiceCMan in (" + ids + "," + login.Id + ")"; } SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 016); if (sps == null) { Data data = new Data(); DataSet ds = data.DataPage("to_Invoice", "Id", "*", sqlstr, "Id", true, 5, 5, pages); rpInvoice.DataSource = ds; rpInvoice.DataBind(); } else { Data data = new Data(); DataSet ds = data.DataPage("to_Invoice", "Id", "*", sqlstr, "Id", true, sps.Pageitem, sps.Pagecount, pages); rpInvoice.DataSource = ds; rpInvoice.DataBind(); } }
/// <summary> /// 同步角色下的用户权限 /// </summary> /// <param name="menus">要同步的菜单权限</param> private void SetPersmissionByRole(List <MyTreeNode> menus) { int roleID = Convert.ToInt32(Request.QueryString["id"]); //角色下的用户ID,已“,”分隔 string users = LoginDataLimitManager.GetUsersByRole(roleID); if (users != string.Empty) { string[] usersArr = users.Split(','); //删除用户权限 for (int i = 0; i < usersArr.Length; i++) { LoginUserLimitManager.DeleteLoginLimitByUser(int.Parse(usersArr[i])); } LoginUserLimit userLimit = new LoginUserLimit(); //添加用户权限 for (int i = 0; i < usersArr.Length; i++) { for (int j = 0; j < menus.Count(); j++) { LoginUserLimitManager.InsertUserLimt(usersArr[i], menus[j].Id.ToString()); } } } }
protected void mgbtnreset_Click(object sender, ImageClickEventArgs e) { string sqlstr = ""; Session["query"] = null; LoginInfo login = (LoginInfo)Session["login"]; string ids = LoginDataLimitManager.GetLimit(login.Id); if (string.IsNullOrEmpty(ids)) { sqlstr += " and madefrom = " + login.Id; } else { sqlstr += " and madefrom in (" + ids + "," + login.Id + ")"; } SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 010); if (sps == null) { Data data = new Data(); DataSet ds = data.DataPage("Company", "Id", "*", sqlstr, "Id", true, 5, 5, pages); comList.DataSource = ds; comList.DataBind(); } else { Data data = new Data(); DataSet ds = data.DataPage("Company", "Id", "*", sqlstr, "Id", true, sps.Pageitem, sps.Pagecount, pages); comList.DataSource = ds; comList.DataBind(); } }
private void DeleteUserPremission(int userId) { LoginDataLimit ldlModel = new LoginDataLimit(); ldlModel.DataIds = ""; ldlModel.LoginId = userId; //删除用户数据权限 LoginDataLimitManager.Setlimit(ldlModel); //删除用户角色权限 LoginUserLimitManager.DeleteLoginLimitByUser(userId); }
/// <summary> /// 根据角色绑定用户信息 /// </summary> /// <param name="roleID">角色ID</param> private void RpUserListBindData(int roleID) { string userIDs = LoginDataLimitManager.GetUsersByRole(roleID); if (string.IsNullOrWhiteSpace(userIDs)) { return; } string strWhere = string.Format("id in ({0})", userIDs); DataTable dtUser = LoginInfoManager.getList(strWhere); RpUserList.DataSource = dtUser; RpUserList.DataBind(); }
private void InitDdlRoleList(int loginId) { IList <RoleInfo> roleList = RoleInfoManager.getRoleInfoAll(); RoleInfo role = new RoleInfo(); role.Roleid = 0; role.Rolenname = "自定义"; role.Remark = ""; roleList.Insert(0, role); DdlRoleList.DataTextField = "rolenname"; DdlRoleList.DataValueField = "roleid"; DdlRoleList.DataSource = roleList; DdlRoleList.DataBind(); string roleId = LoginDataLimitManager.GetRoleId(loginId); DdlRoleList.SelectedIndex = DdlRoleList.Items.IndexOf(DdlRoleList.Items.FindByValue(roleId)); }
/// <summary> /// 订单列表 /// </summary> private void OrderListBind() { string sqlstr = this.checkfile.Checked ? " " : " and fileStatus=0 "; sqlstr += Session["query"].ToString(); LoginInfo login = (LoginInfo)Session["login"]; string ids = LoginDataLimitManager.GetLimit(login.Id); if (string.IsNullOrEmpty(ids)) { sqlstr += " and (markid = " + login.Id + " or inputerId= " + login.Id + ") "; } else { sqlstr += " and (inputerId in (" + ids + ") or markid= " + login.Id + ") ";//0419修改,将查看数据权限更改为可查看操作员数据 } //sqlstr += " or inputerID = " + login.Id; //操作员也能看到其对应的订单信息 SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 013); Data data = new Data(); AspNetPager1.RecordCount = data.GetCount("ViewOrder", sqlstr); if (sps == null) { AspNetPager1.NumericButtonCount = 10; AspNetPager1.PageSize = 10; } else { AspNetPager1.NumericButtonCount = sps.Pagecount; AspNetPager1.PageSize = sps.Pageitem; } DataTable dt = data.GetList("ViewOrder", "makerTime", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr); cuslist.DataSource = dt; cuslist.DataBind(); LoadZtreeData(); }
/// <summary> /// 绑定业务员信息 /// </summary> private void LoadSalesman() { this.ddlsalesman.Items.Clear(); this.ddlsalesman.Items.Add(new ListItem("——请选择——", "0")); LoginInfo current = (LoginInfo)Session["login"]; string ids = LoginDataLimitManager.GetLimit(current.Id); if (string.IsNullOrEmpty(ids)) { this.ddlsalesman.Items.Add(new ListItem(current.Cname, current.Id.ToString())); } else { DataTable dt = LoginInfoManager.getList(" id in (" + ids + ")"); for (int i = 0; i < dt.Rows.Count; i++) { ListItem adItem = new ListItem(); adItem.Value = dt.Rows[i]["id"].ToString(); adItem.Text = dt.Rows[i]["cname"].ToString(); this.ddlsalesman.Items.Add(adItem); } } }
/// <summary> /// 查询显示所有报销明细数据 /// </summary> private void LoadAllAusDetial() { this.pages.Visible = true; double zje = 0; DataTable tbl = Exists(); string str = ""; int login = ((LoginInfo)Session["login"]).Id; string strlist = LoginDataLimitManager.GetLimit(login); if (strlist == null || strlist.Trim() == "") { str = " AND founderid in (" + login + ")"; } else { str = " AND founderid in (" + login + "," + strlist + ")"; } str += Session["query"]; int pitem = int.Parse(tbl.Rows[0]["pageitem"].ToString()); int pcount = int.Parse(tbl.Rows[0]["pagecount"].ToString()); EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data(); DataSet set = data.DataPage("View_AllAusDetial", "bxdh", "*", str, "applydate", true, pitem, pcount, pages); for (int i = 0; i < set.Tables[0].Rows.Count; i++) { zje += set.Tables[0].Rows[i]["ausmoney"].ToString() == "" ? 0.00 : Convert.ToDouble(set.Tables[0].Rows[i]["ausmoney"]); } this.rptdata.DataSource = set; this.rptdata.DataBind(); this.zje.Text = zje.ToString("0.00"); }
protected void mgbtnreset_Click1(object sender, ImageClickEventArgs e) { string sqlstr = ""; sqlstr += Session["query"].ToString(); LoginInfo login = (LoginInfo)Session["login"]; string ids = LoginDataLimitManager.GetLimit(login.Id); if (string.IsNullOrEmpty(ids)) { sqlstr += " and invoiceCMan = " + login.Id; } else { sqlstr += " and invoiceCMan in (" + ids + "," + login.Id + ")"; } SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 016); if (sps == null) { Data data = new Data(); DataSet ds = data.DataPage("to_Invoice", "Id", "*", sqlstr, "Id", true, 5, 5, pages); rpInvoice.DataSource = ds; rpInvoice.DataBind(); } else { Data data = new Data(); DataSet ds = data.DataPage("to_Invoice", "Id", "*", sqlstr, "Id", true, sps.Pageitem, sps.Pagecount, pages); rpInvoice.DataSource = ds; rpInvoice.DataBind(); } this.txtBeginDate.Value = ""; this.txtEndDate.Value = ""; this.txtInvoiceID.Value = ""; this.txtPrice.Value = ""; this.txtUnit.Value = ""; }
protected void BtnSave_Click(object sender, ImageClickEventArgs e) { List <MyTreeNode> dataList = HidData.Value == string.Empty ? null : ReadNode(HidData.Value); List <MyTreeNode> menuList = HidMenu.Value == string.Empty ? null : ReadNode(HidMenu.Value); List <MyTreeNode> noMenuList = HidNoMenu.Value == string.Empty ? null : ReadNode(HidNoMenu.Value); object loginId = Request.QueryString["id"]; int id = 0; if (loginId == null || !int.TryParse(loginId.ToString(), out id) || Convert.ToInt32(loginId) <= 0) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('参数错误')</script>"); return; } LoginDataLimit ldl = new LoginDataLimit(); if (dataList == null) { ldl.DataIds = string.Empty; } else { StringBuilder dataIds = new StringBuilder(); foreach (MyTreeNode node in dataList) { if (!node.IsParent) { dataIds.Append(node.Id); dataIds.Append(","); } } ldl.DataIds = dataIds.ToString().TrimEnd(','); } ldl.LoginId = Convert.ToInt32(loginId); ldl.RoleId = int.Parse(DdlRoleList.SelectedValue); if (LoginDataLimitManager.Setlimit(ldl)) { InitDataTree(Convert.ToInt32(loginId)); } IList <LoginUserLimit> lulList = LoginUserLimitManager.getAllNodeById(Convert.ToInt32(loginId)); ArrayList arrNodes = new ArrayList(); foreach (LoginUserLimit userLimit in lulList) { arrNodes.Add(userLimit.Nodeid.Nodeid.ToString()); } foreach (MyTreeNode mtn in menuList) { if (!arrNodes.Contains(mtn.Id.ToString())) { LoginUserLimitManager.InsertUserLimt(loginId.ToString(), mtn.Id.ToString()); } } foreach (MyTreeNode mtn in noMenuList) { if (arrNodes.Contains(mtn.Id.ToString())) { LoginUserLimitManager.DeleteUserLimit(loginId.ToString(), mtn.Id.ToString()); } } InitMenuTree(Convert.ToInt32(loginId)); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('保存成功');self.location.href='../SysSet/LoginSet.aspx'</script>"); }