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