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