/// <summary>
/// 查询外包单位
/// </summary>
/// <param name="pagination"></param>
/// <param name="queryJson"></param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["outprojectname"].IsEmpty())
{
pagination.conditionJson += string.Format(" and t.outsourcingname like'%{0}%'", queryParam["outprojectname"].ToString());
}
//省级统计跳转使用--请勿删除
if (!queryParam["fullName"].IsEmpty())
{
if (queryParam["fullName"].ToString() == "全部")
{
}
else
{
if (!queryParam["orgCode"].IsEmpty())
{
pagination.conditionJson += string.Format(" and b.encode like'%{0}%'", queryParam["orgCode"].ToString());
}
}
}
if (!queryParam["outorin"].IsEmpty())
{
pagination.conditionJson += string.Format(" and t.outorin ='{0}'", queryParam["outorin"].ToString());
}
if (!queryParam["Time"].IsEmpty())
{
var startTime = DateTime.Parse(queryParam["Time"].ToString());
var endTime = startTime.AddMonths(1).AddDays(-1);
pagination.conditionJson += string.Format(" and (to_char(t.outintime,'yyyy-MM-dd')<='{0}' and t.outintime is not null) and (to_char(t.leavetime,'yyyy-MM-dd')>= '{1}' or t.leavetime is null )", endTime.ToString("yyyy-MM-dd"), startTime.ToString("yyyy-MM-dd"));
}
DataTable dt = this.BaseRepository().FindTableByProcPager(pagination, dataType);
var csjf = dataitem.GetEntity("csjf");
var jf = csjf == null ? "100" : csjf.ItemValue;
dt.Columns.Add("score", typeof(string));
foreach (DataRow item in dt.Rows)
{
if (string.IsNullOrEmpty(item["managerid"].ToString()))
{
item["score"] = "";
}
else
{
item["score"] = userscoreservice.GetUserScore(userservice.GetUserInfoByAccount(item["managerid"].ToString()).UserId, "2018") + Convert.ToInt32(jf);
}
}
return(dt);
}
/// <summary>
/// 流程配置条件提供程序
/// </summary>
/// <param name="orgid"></param>
/// <param name="deptmentid"></param>
/// <param name="roleid"></param>
///<param name="roleid"></param>
/// <param name="useraccounts"></param>
/// <returns></returns>
public IList <UserInfoEntity> GetUserListByAnyCondition(string orgid, string deptmentcode, string rolecode, string majorclassify = "")
{
string sql = string.Format(@"select distinct a.* from v_userinfo a
left join base_department b on a.departmentcode = b.encode
left join base_userrelation c on a.userid = c.userid
left join base_role d on c.objectid = d.roleid
where 1=1 and a.organizeid ='{0}' and a.userid <> 'System' and a.enabledmark = 1 and a.deletemark=0 and a.ispresence ='是' ", orgid);
//角色 判定依据是 传入的用户为空
if (!rolecode.IsEmpty())
{
string lastrole = "'" + rolecode.Replace(",", "','") + "'";
sql += string.Format(" and ( d.encode in ({0})", lastrole);
//专业分类
if (!majorclassify.IsEmpty())
{
string specialtytype = string.Empty;
//判断是否启用专业分类 (整改责任单位关联人员专用)
var isenablemajorclassify = idataitemdetailservice.GetDataItemListByItemCode("'ChangeDeptRelevancePerson'").Where(p => p.ItemValue == orgid).Count() > 0;
if (isenablemajorclassify)
{
var majorEntity = idataitemdetailservice.GetEntity(majorclassify);
if (null != majorEntity)
{
specialtytype = majorEntity.ItemValue;
}
if (!string.IsNullOrEmpty(specialtytype))
{
sql += string.Format(" or (a.rolename like '%专工%' and (','||a.specialtytype||',') like '%,{0},%')", specialtytype);
}
}
}
sql += ")";
}
//部门
if (!deptmentcode.IsEmpty())
{
sql += string.Format(" and (a.departmentcode = '{0}' or a.departmentid='{0}') ", deptmentcode);
}
sql += string.Format(" order by a.sortcode ");
var list = this.BaseRepository().FindList(sql).ToList();
return(list);
}
/// <summary>
/// 明细实体
/// </summary>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public DataItemDetailEntity GetEntity(string keyValue)
{
return(service.GetEntity(keyValue));
}
