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