private void GetTieZiInfoPageList()
{
decimal TieZiId = ReDecimal("TieZiId");
int CurrentPage = ReInt("CurrentPage");
bool AddHot = ReBool("AddHot", true);
bool OnlyLz = ReBool("OnlyLz", false);
StringBuilder s = new StringBuilder();
s.Append(" TieZiId='" + TieZiId + "' ");
s.Append(" or ParentTieZiId='" + TieZiId + "' ");
s.Append(" and Invalid=0 ");
s.Append(" order by CHARINDEX(CONVERT(VARCHAR(20),TieZiId) , '" + TieZiId + "') desc, ");
if (OnlyLz)
{
string lz = DAL.DalComm.ExStr(" select CreateUser from BBS.dbo.TieZi where TieZiId='" + TieZiId + "' ");
s.Append("CHARINDEX(CONVERT(VARCHAR(50),CreateUser) , '" + lz + "') desc,");
}
s.Append(" CreateTime ");
BLL.BBSBLL bll = new BLL.BBSBLL();
if (AddHot)
{
bll.AddHot(TieZiId);
}
DataSet ds = bll.GetTieZiPageList(s.ToString(), CurrentPage, 10, "*");
DataTable dt = ds.Tables[2];
if (dt.Rows.Count > 0)
{
dt.Columns.Add("huiying");
s.Clear();
List <string> ls = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
if (i != 0)
{
ls.Add(" select top 5 * from BBS.dbo.TieZiView where ParentTieZiId='" + dr["TieZiId"] + "' ");
}
}
string sqlstr = string.Join(" UNION ALL ", ls);
if (sqlstr.Trim() != "")
{
DataTable dtHuiYing = DAL.DalComm.BackData(sqlstr).Tables[0];
foreach (DataRow dr in dt.Rows)
{
StringBuilder w = new StringBuilder();
DataTable dthy = Common.DataSetting.TableSelect(" ParentTieZiId='" + dr["TieZiId"] + "' ", dtHuiYing);
dr["huiying"] = JsonHelper.ToJson(dthy);
}
}
}
RePage(ds);
}
