/// <summary>
/// 分页查询用户列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResult GetUserListBySearch(Business_PersonDepartmrnt_Search searchParam, GridParams para)
{
if (para.sortdatafield == null)
{
para.sortdatafield = "UserID";
para.sortorder = "desc";
}
para.pagenum = para.pagenum + 1;//页0，+1
//List<DeparTment_1> departmenteList = _dl.GetDepartmentList(searchParam, para);
var model = _ul.GetUserPageList(searchParam, para);
var result = new ConfigurableJsonResult {
Data = model, JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
// return Json(model, JsonRequestBehavior.AllowGet);
return(result);
}
/// <summary>
/// 分页查询用户列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <v_Business_PersonnelDepartment_Information> GetUserPageList(Business_PersonDepartmrnt_Search searchParam, GridParams para)
{
return(_us.GetUserPageList(searchParam, para));
}
/// <summary>
/// 分页查询人员列表信息
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <v_Business_PersonnelDepartment_Information> GetUserPageList(Business_PersonDepartmrnt_Search searchParam, GridParams para)
{
using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance())
{
var jsonResult = new JsonResultModel <v_Business_PersonnelDepartment_Information>();
var currentUserInfo = CurrentUser.GetCurrentUser();
string ownfleet = string.Empty;
//是系统管理员
if (currentUserInfo.LoginName.ToLower() == "sysadmin")
{
ownfleet = searchParam.OwnedFleet != Guid.Empty ? searchParam.OwnedFleet.ToString() : dbMsSql.Queryable <Master_Organization>().Where(i => i.ParentVguid == null).Select(i => i.Vguid).SingleOrDefault().ToString();
}
else //非系统管理员
{
//查出当前登录人的部门[dbo].[Sys_Role_Module]
Guid dep = Guid.Parse(currentUserInfo.Department);
ownfleet = dep.ToString();
var listDep = dbMsSql.SqlQuery <Guid>("SELECT * FROM dbo.TF_OrganizationFDetail('" + dep + "')"); //找到该部门以及其所有子部门
if (searchParam.OwnedFleet != Guid.Empty)
{
ownfleet = !listDep.Contains(searchParam.OwnedFleet) ? dep.ToString() : searchParam.OwnedFleet.ToString();
}
}
var labelStr = string.Empty;
if (!string.IsNullOrEmpty(searchParam.LabelName))
{
var labelArr = searchParam.LabelName.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < labelArr.Length; i++)
{
labelArr[i] = "'" + labelArr[i].Trim() + "'";
}
labelStr = string.Join(",", labelArr);
}
string sql = "exec usp_Business_PersonnelDepartment_Information @UserName,@JobNumber,@OwnedFleet,@ServiceNumber,@IDNumber,@Status,@Phone,@Start,@End,@Count output,@LabelName";
var pars = SqlSugarTool.GetParameters(new
{
UserName = searchParam.name ?? "",
JobNumber = searchParam.JobNumber ?? "",
OwnedFleet = ownfleet,
ServiceNumber = searchParam.ServiceNumber ?? "",
IDNumber = searchParam.IDNumber ?? "",
Status = searchParam.TranslationApprovalStatus ?? "",
Phone = searchParam.PhoneNumber ?? "",
Start = (para.pagenum - 1) * para.pagesize + 1,
End = para.pagenum * para.pagesize,
Count = 0,
LabelName = labelStr
}); //将匿名对象转成SqlParameter
dbMsSql.IsClearParameters = false; //禁止清除参数
pars[9].Direction = ParameterDirection.Output; //将Count设为 output
var query = dbMsSql.SqlQuery <v_Business_PersonnelDepartment_Information>(sql, pars);
dbMsSql.IsClearParameters = true; //启动请动清除参数
var outPutValue = pars[9].Value.ObjToInt(); //获取output @Count的值
jsonResult.TotalRows = outPutValue;
jsonResult.Rows = query;
//存入操作日志表
string logData = JsonHelper.ModelToJson(jsonResult);
_ll.SaveLog(3, 5, CurrentUser.GetCurrentUser().LoginName, searchParam.name + searchParam.JobNumber + searchParam.ServiceNumber + searchParam.UserID, logData);
return(jsonResult);
}
}
