public static string QueryFristNews()
{
string r = "";
NB_NewsBll sicb = new NB_NewsBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
string dw = "";
if (iv.u.dcode.Trim() != "")
{
dw = " and dcode = '" + iv.u.dcode.Substring(0, 8) + "'";
}
else
{
}
List <NB_News> lnb = sicb.QueryList(" and cdate>'" + iv.u.ecdate + "' and ((nvrange='all' " + dw + " ) or (nvrange='seldep' and id in(select nid from NB_DepNews where dcode='" + iv.u.dcode + "') ))and id not in(select nid from NB_NewsReader where ename='" + iv.u.ename + "') order by id desc");
if (lnb != null)
{
r = js.Serialize(lnb[0]);
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList CustQueryRoleList(string curpage, string pagesize)
{
ArrayList r = new ArrayList();
BusiEventButtonBll bebb = new BusiEventButtonBll();
NB_NewsBll sub = new NB_NewsBll();
List <NB_News> lsr = new List <NB_News>();
StringBuilder where = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
int rcount = 0;
int pcount = 0;
if (iv.u.rcode != "xtgl")
{
where.AppendFormat(" and ( id in(select nid from NB_DepNews where dcode='{0}') or rtype='a' ) ", iv.u.dcode);
}
lsr = sub.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), where.ToString(), "id desc", ref rcount, ref pcount);
if (lsr != null)
{
r.Add(pcount);
foreach (NB_News s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.id);
al.Add(s.ntitle);
al.Add(s.ntype);
al.Add(s.nstate == true ? "显示" : "关闭");
al.Add(s.maker);
al.Add(s.cdate);
al.Add(bebb.QueryBtnListItems("0175", iv.u.rcode, "LX", s.id.ToString()));
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList CustQueryListAll(string curpage, string pagesize)
{
ArrayList r = new ArrayList();
BusiEventButtonBll bebb = new BusiEventButtonBll();
NB_NewsBll sub = new NB_NewsBll();
List <NB_News> lsr = new List <NB_News>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
int rcount = 0;
int pcount = 0;
lsr = sub.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), " ", "id desc", ref rcount, ref pcount);
if (lsr != null)
{
r.Add(pcount);
foreach (NB_News s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.id);
al.Add(s.ntitle);
al.Add(s.ntype);
al.Add(s.nstate == true ? "显示" : "关闭");
al.Add(s.maker);
al.Add(s.cdate);
al.Add(bebb.QueryBtnListItems("0176", iv.u.rcode, "LX", s.id.ToString()));
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}