/// <summary>
/// 获取子账号，非员工
/// </summary>
/// <param name="parentId"></param>
/// <param name="req"></param>
/// <param name="size"></param>
/// <returns></returns>
public List <AllInOne_UserPermissionView> GetStaff(int parentId, UserGetReq req, int size)
{
var search = req.search ?? "";
var order = req.orderField;
var desc = Convert.ToBoolean(req.isDesc);
var index = Convert.ToInt32(req.pageIndex);
var orderStr = $"order by {order} ";
if (desc)
{
orderStr += " desc ";
}
else
{
orderStr += " asc ";
}
var dict = new Dictionary <string, string>
{
{ "@search", $"%{search}%" }
};
var condition = " isStaff=1 and isdeleted=0 and parentId=" + parentId;
if (!search.IsNullOrEmpty())
{
condition += " and (name like @search or pername like @search) ";
}
return(SqlHelper.Instance.GetViewCommon <AllInOne_UserPermissionView>("id", "AllInOne_UserPermissionView", condition, index, size, orderStr, order, dict));
}
public string GetStaffList(UserGetReq req)
{
var lv = Convert.ToInt32(Session["lv"]);
var id = Convert.ToInt32(Session["userId"]);
var r = AllFunc.Instance.GetStaff(id, req, lv);
return(JsonConvert.SerializeObject(r));
}
/// <summary>
/// 获取子账号的总数
/// </summary>
/// <param name="parentId"></param>
/// <param name="req"></param>
/// <returns></returns>
public int GetSonCount(int parentId, UserGetReq req)
{
var search = req.search ?? "";
var dict = new Dictionary <string, string>
{
{ "@search", $"%{search}%" }
};
var condition = " isStaff=0 and isdeleted=0 and parentId=" + parentId;
if (!search.IsNullOrEmpty())
{
condition += " and (name like @search ) ";
}
var list = SqlHelper.Instance.GetDistinctCount <AllInOne_UserPermissionView>("AllInOne_UserPermissionView", condition, dict);
return(list.Count());
}
