public IHttpActionResult UserSkillList(SkillQueryParm parm) { try { int resultcount = 0; RYService rys = new RYService(); var list = rys.Search(parm, out resultcount); return(Json(new { code = 1, msg = "ok", list = list, resultcount = resultcount })); } catch (Exception) { throw; } }
public IEnumerable <zxjc_ryxx_jn> Search(SkillQueryParm parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append(" SELECT ta.gcdm, ta.user_code,(select user_name from sec_users where user_code = ta.user_code) as user_name, ta.jnbh, ta.jnxx, ta.scx, ta.gwh,(select work_name from ZXJC_GXZD where work_no = ta.gwh) as gwmc, ta.sfhg, ta.lrr, ta.lrsj, ta.jnfl, ta.jnsj"); sql.Append(" FROM zxjc_ryxx_jn ta where 1 = 1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (user_code like :key or jnbh like :key) "); p.Add(":key", "%" + parm.keyword + "%", OracleMappingType.Varchar2, System.Data.ParameterDirection.Input); } if (parm.explist.Count > 0) { sql.Append(" and "); foreach (var item in parm.explist) { sql.Append($"{item.left}"); if (item.oper == "like") { sql.Append($" {item.colname} {item.oper} '%{item.value}%' {item.logic} "); } else { sql.Append($" {item.colname} {item.oper} '{item.value}' {item.logic} "); } sql.Append($"{item.right}"); } } using (var conn = new OraDBHelper(constr).Conn) { var q = conn.Query <zxjc_ryxx_jn>(sql.ToString(), p) .OrderBy(t => t.jnbh) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } } catch (Exception e) { log.Error(e.Message); throw; } }