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