/// <summary>
/// 获取司机信息（只能选择加工厂通用人员）
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetJgcTyUser(TbUserRequest request, string ProcessFactoryCode)
{
request.rows = 50;
var data = _carInfo.GetJgcTyUser(request, ProcessFactoryCode);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取司机信息（只能选择加工厂通用人员）
/// </summary>
public PageModel GetJgcTyUser(TbUserRequest request, string ProcessFactoryCode)
{
string where = "";
if (!string.IsNullOrWhiteSpace(request.keyword))
{
where += " and u.UserCode like '%" + request.keyword + "%' or u.UserName like '%" + request.keyword + "%'";
}
if (!string.IsNullOrWhiteSpace(ProcessFactoryCode))
{
where += " and OrgId='" + ProcessFactoryCode + "' ";
}
try
{
string sql = @"select distinct u.UserCode,u.UserId,u.UserName,u.UserSex as CollarState,u.UserClosed as InsertUserCode,OrgId,ProjectId from TbUserRole
left join TbUser u on u.UserId=TbUserRole.UserCode
where DeptId in(select DepartmentId from TbDepartment where DepartmentName='加工厂部门（通用）')
and ProjectId='6245721945602523136' " + where + @"
group by u.UserCode,u.UserId,u.UserName,u.UserSex,u.UserClosed,OrgId,ProjectId";
List <Parameter> parameter = new List <Parameter>();
var model = Repository <TbUser> .FromSqlToPageTable(sql, parameter, request.rows, request.page, "UserCode", "asc");
return(model);
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage GetWorkAreaUser([FromUri] TbUserRequest request, string CompanyCode)
{
try
{
var data = _deBus.GetWorkAreaUser(request, CompanyCode);
return(AjaxResult.Success(data).ToJsonApi());
}
catch (Exception)
{
return(AjaxResult.Error("操作失败").ToJsonApi());
}
}
/// <summary>
/// 获取该站点所属工区的用户
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ActionResult GetWorkAreaUser(TbUserRequest request, string CompanyCode)
{
var data = _deBus.GetWorkAreaUser(request, CompanyCode);
return(Content(data.ToJson()));
}
/// <summary>
/// 根据站点查询站点用户
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetSiteUser(TbUserRequest ur)
{
var data = _deBus.GetSiteUser(ur);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取该组织机构下的所有用户
/// </summary>
/// <returns></returns>
public ActionResult GetCompanyUser(TbUserRequest request, string UserName, string CompanyCode, string DepartmentProjectId)
{
var data = ui.GetCompanyUser(request, UserName, CompanyCode, DepartmentProjectId);
return(Content(data.ToJson()));
}
public ActionResult GetGridJson(TbUserRequest request)
{
var data = ui.GetDataListForPage(request);
return(Content(data.ToJson()));
}
