/// <summary> /// 获取推送任务 /// </summary> /// <returns></returns> public static List <LoginExceptionEn> getLoginExceptionTask() { using (DBSession db = new DBSession()) { string sql = "select * from wechat_loginexceptioninfo where issend<3"; return(db.QueryEntity <LoginExceptionEn>(sql)); } }
/// <summary> /// 获取推送任务 /// </summary> /// <returns></returns> public static List <SubcribeInfoEn> getSubscribeTask() { using (DBSession db = new DBSession()) { string sql = @"select ws.*,lo.busiunitname,lo.contractno,lo.FirstLadingBillno,lo.SecondLadingBillno,lo.LandLadingno,lo.totalno,lo.divideno,lo.busitype from wechat_subscribe ws left join list_order lo on ws.ordercode=lo.code where lo.isinvalid=0 and ws.isinvalid=0 and ws.TriggerStatus=1"; return(db.QueryEntity <SubcribeInfoEn>(sql)); } }
/// <summary> /// 资讯动态 /// </summary> /// <returns></returns> public List <WebNoticeEn> getTwoNotice() { using (DBSession db = new DBSession()) { string sql = @"select * from ( select wn.*,nc.name as typename from web_notice wn left join newscategory nc on wn.type=nc.id where publishdate is not null and isinvalid=0 and type in (4,5,6) order by publishdate desc) where rownum<3 "; return(db.QueryEntity <WebNoticeEn>(sql)); } }