public IEnumerable <base_gwbj1> Search(sys_page parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append("select ta.gcdm, ta.scx, ta.gwh,(select work_name from zxjc_gxzd where work_no = ta.gwh) as gwmc, ta.wlbm,(SELECT wljc FROM base_wlxx where wlbm = ta.wlbm) as wlmc,ta.lxpd, ta.lxlx, ta.dxsl, ta.gwpb, ta.qwwbm, ta.wlsx, ta.zcqld,"); sql.Append(" ta.psfs, ta.gdbh, ta.gdc, ta.zgkc, ta.sfdy, ta.bz, ta.lrr, ta.lrsj, ta.jx_no, ta.gzzx"); sql.Append(" from base_gwbj1 ta where 1=1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (gwh like :key or wlbm like :key or lower(jx_no) like :key) "); p.Add(":key", "%" + parm.keyword.ToLower() + "%", OracleMappingType.NVarchar2, System.Data.ParameterDirection.Input); } if (parm.explist.Count > 0) { sql.Append(" and "); sql.Append(Tool.ComQueryExp(parm.explist)); } var q = this.Conn.Query <base_gwbj1>(sql.ToString(), p) .OrderBy(t => t.wlbm) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } catch (Exception e) { log.Error(e.Message); throw; } }
/// <summary> /// 技通分配列表 /// </summary> /// <param name="parm"></param> /// <param name="resultcount"></param> /// <returns></returns> public IEnumerable <zxjc_t_jstcfp> Search(sys_page parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append(" select ta.jtid, ta.gcdm, ta.scx, ta.gwh,(select work_name from ZXJC_GXZD where work_no=ta.gwh) as gwmc,ta.jx_no, ta.status_no, ta.bz, ta.lrr1, ta.lrsj1, ta.lrr2, ta.lrsj2 "); sql.Append(" from ZXJC_T_JSTCFP ta where 1 = 1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (ta.jtid like :key or ta.jx_no like :key or ta.status_no like :key) "); p.Add(":key", "%" + parm.keyword + "%", OracleMappingType.Varchar2, System.Data.ParameterDirection.Input); } var q = Conn.Query <zxjc_t_jstcfp>(sql.ToString(), p) .OrderBy(t => t.jtid) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } catch (Exception e) { log.Error(e.Message); throw; } }
//public override int Modify(zxjc_djxx entity) //{ // try // { // StringBuilder sql = new StringBuilder(); // sql.Append("update zxjc_djxx set gcdm=:gcdm,"); // sql.Append(" scx=:scx,"); // sql.Append(" gwh =:gwh,"); // sql.Append(" jx_no =:jx_no,"); // sql.Append(" status_no =:status_no,"); // sql.Append(" djno =:djno,"); // sql.Append(" djxx =:djxx,"); // sql.Append(" djjg =:djjg,"); // sql.Append(" bz =:bz where id=:id "); // using (var conn = new OraDBHelper(constr).Conn) // { // return conn.Execute(sql.ToString(), entity); // } // } // catch (Exception e) // { // log.Error(e.Message); // throw; // } //} public IEnumerable <zxjc_djxx> Search(sys_page parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append("select id,gcdm,scx,gwh,jx_no,status_no,djno,djxx,djjg,bz,lrr,lrsj from zxjc_djxx where 1=1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (djxx like :key or jx_no like :key or djno like :key) "); p.Add(":key", "%" + parm.keyword + "%", OracleMappingType.Varchar2, System.Data.ParameterDirection.Input); } if (parm.explist.Count > 0) { sql.Append(" and "); sql.Append(Tool.ComQueryExp(parm.explist)); } using (var conn = new OraDBHelper(constr).Conn) { var q = conn.Query <zxjc_djxx>(sql.ToString(), p) .OrderBy(t => t.djno) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } } catch (Exception e) { log.Error(e.Message); throw; } }
public IEnumerable <sys_role> Find(sys_page parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append(" select id,code,status,title,adduser,addtime,addusername from sys_role where 1=1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (title like :keyword or code like :keyword) "); p.Add(":keyword", "%" + parm.keyword + "%", OracleMappingType.NVarchar2, ParameterDirection.Input); } using (var db = new OraDBHelper()) { var query = db.Conn.Query <sys_role>(sql.ToString(), p) .OrderByDescending(t => t.id) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = query.TotalItemCount; return(query); } } catch (Exception e) { log.Error(e.Message); throw; } }
public IEnumerable <zxjc_t_ydjl> Search(sys_page parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append("select ydid,jtid,gcdm,scx,gwh,order_no,engine_no,user_name,ydsj,lrr,lrsj from zxjc_t_ydjl where 1=1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (order_no like :key or engine_no like :key or user_name like :key) "); p.Add(":key", "%" + parm.keyword + "%", OracleMappingType.Varchar2, System.Data.ParameterDirection.Input); } if (parm.explist.Count > 0) { sql.Append(" and "); sql.Append(Tool.ComQueryExp(parm.explist)); } var q = Conn.Query <zxjc_t_ydjl>(sql.ToString(), p) .OrderByDescending(t => t.ydid) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } catch (Exception e) { log.Error(e.Message); throw; } }
public IEnumerable <zxjc_t_jstc> Search(sys_page parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append("select jtid,jcbh,jcmc,jcms,wjlj,jwdx,scry,scpc,scsj,yxqx1,yxqx2,gcdm,fp_flg,fp_sj,fpr,wjfl,scx from zxjc_t_jstc where 1=1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (jcmc like :key or jcbh like :key or jcms like :key) "); p.Add(":key", "%" + parm.keyword + "%", OracleMappingType.Varchar2, System.Data.ParameterDirection.Input); } if (parm.explist.Count > 0) { sql.Append(" and "); sql.Append(Tool.ComQueryExp(parm.explist)); } using (var conn = new OraDBHelper(constr).Conn) { var q = conn.Query <zxjc_t_jstc>(sql.ToString(), p) .OrderByDescending(t => t.jcbh) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } } catch (Exception e) { log.Error(e.Message); throw; } }
public IEnumerable <zxjc_t_tstc> Search(sys_page parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append("select tcid,tcbh,tcms,gcdm,scx,gwh,(select work_name from zxjc_gxzd where work_no = gwh) as gwmc,jx_no,status_no,yxbz,lrr,lrsj from zxjc_t_tstc where 1=1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (tcbh like :key or jx_no like :key or status_no like :key) "); p.Add(":key", "%" + parm.keyword + "%", OracleMappingType.Varchar2, System.Data.ParameterDirection.Input); } if (parm.explist.Count > 0) { sql.Append(" and "); sql.Append(Tool.ComQueryExp(parm.explist)); } var q = Conn.Query <zxjc_t_tstc>(sql.ToString(), p) .OrderByDescending(t => t.tcid) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } catch (Exception e) { log.Error(e.Message); throw; } }
public IHttpActionResult List(sys_page parm) { try { int resultcount = 0; return(Json(new { code = 1, msg = "ok", resultcount = resultcount })); } catch (Exception) { throw; } }
public void queryrole() { int cnt = 0; var p = new sys_page() { keyword = "管理", pageindex = 1, pagesize = 20 }; RoleService rs = new RoleService(); var list = rs.Find(p, out cnt); }
public IHttpActionResult List(sys_page parm) { try { int resultcount = 0; DZGYService dzgys = new DZGYService(); var list = dzgys.Search(parm, out resultcount); return(Json(new { code = 1, msg = "ok", list = list, resultcount = resultcount })); } catch (Exception) { throw; } }
public IHttpActionResult JtydList(sys_page parm) { try { int resultcount = 0; JTYDService jtyds = new JTYDService(); var list = jtyds.Search(parm, out resultcount); return(Json(new { code = 1, msg = "ok", list = list, resultcount = resultcount })); } catch (Exception) { throw; } }
public IHttpActionResult All_List() { try { int cnt; RoleService rs = new RoleService(); sys_page page = new sys_page(); page.pageindex = 1; page.pagesize = int.MaxValue; var list = rs.Find(page, out cnt); return(Json(new { code = 1, msg = "ok", list = list })); } catch (Exception e) { return(Json(new { code = 0, msg = e.Message })); } }
public IEnumerable <zxjc_t_dzgy> Search(sys_page parm, out int resultcount) { try { OracleDynamicParameters p = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append(" select ta.gyid,"); sql.Append(" ta.gybh,"); sql.Append(" ta.gymc,"); sql.Append(" ta.gyms,"); sql.Append(" ta.gcdm,"); sql.Append(" ta.scx,"); sql.Append(" ta.gwh,"); sql.Append(" (select work_name from zxjc_gxzd where work_no = ta.gwh ) as gwmc,"); sql.Append(" ta.jx_no,"); sql.Append(" ta.status_no,"); sql.Append(" ta.wjlj,"); sql.Append(" ta.jwdx,"); sql.Append(" ta.scry,"); sql.Append(" ta.scpc,"); sql.Append(" ta.scsj,"); sql.Append(" ta.bbbh"); sql.Append(" from ZXJC_T_DZGY ta where 1=1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and (ta.gybh like :key or ta.gymc like :key or ta.gyms like :key or lower(ta.jx_no) like :key ) "); p.Add(":key", "%" + parm.keyword + "%", OracleMappingType.NVarchar2, System.Data.ParameterDirection.Input); } if (parm.explist.Count > 0) { sql.Append(" and "); sql.Append(Tool.ComQueryExp(parm.explist)); } var q = Conn.Query <zxjc_t_dzgy>(sql.ToString(), p) .OrderByDescending(t => t.gybh) .ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } catch (Exception) { throw; } }
public IEnumerable <sys_menu> Find(sys_page parm, out int resultcount) { try { OracleDynamicParameters para = new OracleDynamicParameters(); StringBuilder sql = new StringBuilder(); sql.Append("select * from sys_menu where 1=1 "); if (!string.IsNullOrEmpty(parm.keyword)) { sql.Append(" and title like :title "); para.Add(":title", parm.keyword, OracleMappingType.Varchar2, ParameterDirection.Input); } if (!string.IsNullOrEmpty(parm.keyword)) { para.Add(":index", parm.pageindex, OracleMappingType.Int32, ParameterDirection.Input); } if (!string.IsNullOrEmpty(parm.keyword)) { para.Add(":pagesize", parm.pagesize, OracleMappingType.Int32, ParameterDirection.Input); } if (!string.IsNullOrEmpty(parm.keyword)) { para.Add(":resultcount", parm.resultcount, OracleMappingType.Int32, ParameterDirection.Output); } using (var db = new OraDBHelper()) { var resutl = db.Conn.Query <sys_menu>(sql.ToString(), para); var q = resutl.OrderByDescending(t => t.id).ToPagedList(parm.pageindex, parm.pagesize); resultcount = q.TotalItemCount; return(q); } } catch (Exception e) { log.Error(e.Message); throw; } }