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