/// <summary>
/// 获取实体分页
/// </summary>
public DataTable GetRePostsList(RePostsTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
string table = " [RePosts] ";
string pk = " ID ";
string fields = " * ";
string filter = " 1=1 and status=1 ";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal);
#region 组织查询条件
if (!string.IsNullOrEmpty(TO.Content))
{
filter += string.Format(" and [Content] like '%{0}%' ", StringHelper.SQLFilter(TO.Content));
}
if (TO.FatherID != 0)
{
filter += string.Format(" and FatherID = '{0}' ", StringHelper.SQLFilter(TO.FatherID.ToString()));
}
#endregion
string sort = " ID DESC ";//排序
if (!string.IsNullOrEmpty(orderBy))
{
sort = orderBy;
}
SqlParameter[] parameters =
{
new SqlParameter("@Tables", SqlDbType.VarChar, 1000),
new SqlParameter("@PK", SqlDbType.VarChar, 100),
new SqlParameter("@Fields", SqlDbType.VarChar, 1000),
new SqlParameter("@Pageindex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@Filter", SqlDbType.VarChar, 1000),
new SqlParameter("@Sort", SqlDbType.VarChar, 200),
new SqlParameter("@RowCount", SqlDbType.Int)
};
parameters[0].Value = table;
parameters[1].Value = pk;
parameters[2].Value = fields;
parameters[3].Value = pageIndex;
parameters[4].Value = pageSize;
parameters[5].Value = filter;
parameters[6].Value = sort;
parameters[7].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.RunProcedure("SP_DividePage", parameters, "RePostsList");
rowCount = (int)parameters[7].Value;
return(ds.Tables[0]);
}
/// <summary>
/// 日志列表
/// </summary>
private void LogList()
{
RePostsBLL bll = new RePostsBLL();
StringBuilder sb = new StringBuilder();
RePostsTO sto = new RePostsTO();
if (!string.IsNullOrEmpty(Request["select"]))
{
sto.CID = type = Convert.ToInt32(Request["select"].Trim());
}
if (!string.IsNullOrEmpty(Request["title"]))
{
sto.Title = txt = Request["title"].Trim();
}
if (!string.IsNullOrEmpty(Request["remark"]))
{
sto.Content = remark = Request["remark"].Trim();
}
if (!string.IsNullOrEmpty(Request["ip"]))
{
sto.UserIP = ip = Request["ip"].Trim();
}
if (!string.IsNullOrEmpty(Request["time"]))
{
sto.Time = time = Request["time"].Trim();
}
if (!string.IsNullOrEmpty(Request["endtime"]))
{
sto.EndTime = endtime = Request["endtime"].Trim();
}
if (!string.IsNullOrEmpty(Request["sendUser"]))
{
sto.SendUser = sendUser = Request["sendUser"].Trim();
}
if (!string.IsNullOrEmpty(Request["backUser"]))
{
sto.ReUser = backUser = Request["backUser"].Trim();
}
if (!string.IsNullOrEmpty(Request["niming"]))
{
sto.isAnonymity = niming = Convert.ToInt32(Request["niming"].Trim());
}
else
{
sto.isAnonymity = 400;
}
if (!string.IsNullOrEmpty(Request["fankui"]))
{
sto.isFeedback = fankui = Convert.ToInt32(Request["fankui"].Trim());
}
else
{
sto.isFeedback = 400;
}
if (!string.IsNullOrEmpty(Request.QueryString["pageIndex"]))
{
pageIndex = int.Parse(Request.QueryString["pageIndex"]);
}
DataTable dt = bll.GetNewTab(sto, pageIndex, pageSize, "", out rowCount);
//分页
string url = "Searchlog.aspx?pageIndex={0}&typecid=1110&select=" + type + "&title=" + txt + "&remark=" + remark + "&ip=" + ip + "&time=" + time + "&sendUser="******"&backUser="******"&niming=" + niming + "&fankui=" + fankui;
strtt = DividePage.Pager(pageSize, rowCount, pageIndex, url);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
string status = dr["status"].ToString();
string strContent = StringHelper.FilterHTML(dr["remark"].ToString().Trim()).Trim();
if (strContent.Length == 0)
{
strContent = " ";
}
string topic_ftcolor = "";
if (Convert.ToInt32(dr["Ispos"]) == 1)
{
topic_ftcolor = " style=\"font-weight:bold\"";
}
sb.AppendFormat("<tbody><tr><td class=\"by\" title=\"{0}\" " + topic_ftcolor + ">[{1}]<a href=\"detail.aspx?pageIndex=1&fatherID={2}&num=0\" target=\"_back\">{3}</a></td>", dr["Title"], dr["Name"], dr["ID"],
HYTD.Common.StringHelper.SubString(dr["Title"].ToString(), 25));
sb.AppendFormat("<td class=\"by\" title=\"{0}\">{1} </td>", strContent,
HYTD.Common.StringHelper.SubString(strContent, 25));
//ispos 1表示发贴 0为回复内容
if (Convert.ToInt32(dr["Ispos"]) == 1)
{
sb.AppendFormat("<td class=\"num\">{0} <br />[{1}]</td>",
dr["SendUserName"], PublicEnum.GetEnumDescription <PublicEnum.PubliucIsVidicate>(dr["isAnonymity"].ToString()));
sb.AppendFormat("<td class=\"num\">{0} </td>", "");
}
else
{
sb.AppendFormat("<td class=\"num\">{0} <br />[{1}]</td>", dr["SendUserName"], PublicEnum.GetEnumDescription <PublicEnum.PubliucIsVidicate>(dr["isAnonymity"].ToString()));
sb.AppendFormat("<td class=\"num\">{0} <br />[{1}]</td>", dr["ReUserName"], PublicEnum.GetEnumDescription <PublicEnum.PubliucIsVidicate>(dr["isAnonymity"].ToString()));
}
sb.AppendFormat("<td class=\"num\">{0} </td>", PublicEnum.GetEnumDescription <PublicEnum.PubliucIsVidicate>(dr["isFeedback"].ToString()));
sb.AppendFormat("<td class=\"num\">{0} </td>", dr["retime"]);
sb.AppendFormat("<td class=\"num\">{0} </td>", dr["UserIP"]);
if (status == "1")
{
sb.AppendFormat("<td class=\"num\" style=\"width:40px\"><a href=\"javascript:;\" onclick=\"javascript:DeleteReplyforLog({0},{1})\">删除</a></td></tr></tbody>", dr["IDNew"], dr["tp"]);
}
else
{
sb.AppendFormat("<td class=\"num\" style=\"width:40px\"><a href=\"javascript:;\" onclick=\"javascript:RecoverReplyforLog({0},{1})\" style=\"color:red;\">恢复显示</a></td></tr></tbody>", dr["IDNew"], dr["tp"]);
}
}
script = sb.ToString();
}
else
{
script = "没有搜索到相关内容！";
}
//获取当前页
if (rowCount % pageSize == 0)
{
pageNum = rowCount / pageSize;
}
else
{
pageNum = (rowCount / pageSize) + 1;
}
}
/// <summary>
/// 自定义获得搜索数据列表
/// </summary>
/// <returns></returns>
public DataTable GetNewTab(RePostsTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
//2013-11-14 liuyh 增加可以按登陆名和姓名查询
string table = " (select 1 tp,Posts.status,Posts.id IDNew,Posts.id,Posts.CID as CID, Category.Name as Name,Posts.Title as Title, [Description] as remark, ReleaseUser as seuser, reuser='', ReleaseTime as retime, Posts.UserIP,Posts.isFeedback,isAnonymity,Ispos=1 ";
table += " ,u.Name senRealName,'' reRealName from Posts left join Category on Posts.CID=Category.ID left join [User] u on u.LoginName=Posts.ReleaseUser ";
//if (!string.IsNullOrEmpty(TO.SendUser))
//{
// table += string.Format(" where u.Name like '%{0}%' ", StringHelper.SQLFilter(TO.SendUser));
//}
table += "Union All select 2,RePosts.status,RePosts.id ,FatherID,RePosts.CID as CID, Category.Name as Name,Posts.Title as Title , Content as remark ,Posts.ReleaseUser ,ReUser as reuser, ReDatetime as retime, RePosts.UserIP,RePosts.isFeedback,RePosts.isAnonymity,Ispos=0 ";
table += " ,f.Name senRealName ,u.Name reRealName from RePosts left join Category on Category.ID=RePosts.CID left join Posts on RePosts.FatherID=Posts.ID left join [User] u on u.LoginName=RePosts.ReUser ";
//if (!string.IsNullOrEmpty(TO.ReUser))
//{
// table += string.Format(" where u.name like '%{0}%' ", StringHelper.SQLFilter(TO.ReUser));
//}
table += " left join [User] f on f.LoginName=Posts.ReleaseUser ) sbc ";
string pk = " Name ";
string fields = " *,(select top 1 name from [user] where LoginName=seuser) as 'SendUserName', (select top 1 name from [user] where LoginName=reuser) as 'ReUserName' ";
string filter = " 1=1 ";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal);
#region 组织查询条件
if (!string.IsNullOrEmpty(TO.Content))
{
filter += string.Format(" and remark like '%{0}%' ", StringHelper.SQLFilter(TO.Content));
}
if (TO.CID != 0)
{
filter += string.Format(" and CID ={0} ", TO.CID);
}
if (!string.IsNullOrEmpty(TO.Title))
{
filter += string.Format(" and Title like '%{0}%' ", StringHelper.SQLFilter(TO.Title));
}
if (!string.IsNullOrEmpty(TO.UserIP))
{
filter += string.Format(" and UserIP like '%{0}%' ", StringHelper.SQLFilter(TO.UserIP));
}
//if (!string.IsNullOrEmpty(TO.SendUser) && string.IsNullOrEmpty(TO.ReUser))
//{
// filter += string.Format(" and seuser like '%{0}%' and Ispos=1 ", StringHelper.SQLFilter(TO.SendUser));
//}
//else if (!string.IsNullOrEmpty(TO.ReUser) && string.IsNullOrEmpty(TO.SendUser))
//{
// filter += string.Format(" and reuser like '%{0}%' and Ispos=0 ", StringHelper.SQLFilter(TO.ReUser));
//}
if (!string.IsNullOrEmpty(TO.ReUser))
{
filter += string.Format(" and (reuser like '%{0}%' or reRealName like '%{0}%')", StringHelper.SQLFilter(TO.ReUser));
}
if (!string.IsNullOrEmpty(TO.SendUser))
{
filter += string.Format(" and (seuser like '%{0}%' or senRealName like '%{0}%') ", StringHelper.SQLFilter(TO.SendUser));
}
if (TO.isAnonymity != 400 && TO.isAnonymity != -1)
{
filter += string.Format(" and isAnonymity ={0} ", TO.isAnonymity);
}
if (TO.isFeedback != 400 && TO.isFeedback != -1)
{
filter += string.Format(" and isFeedback ={0} ", TO.isFeedback);
}
if (!string.IsNullOrEmpty(TO.Time))
{
filter += string.Format(" and convert(varchar(10),retime,120)>='{0}' ", StringHelper.SQLFilter(TO.Time));
}
if (!string.IsNullOrEmpty(TO.EndTime))
{
DateTime dtime = DateTime.MaxValue;
DateTime.TryParse(StringHelper.SQLFilter(TO.EndTime), out dtime);
filter += string.Format(" and convert(varchar(10),retime,120)<'{0}' ", dtime.AddDays(1).ToString("yyyy-MM-dd"));
}
#endregion
string sort = " retime DESC ";//排序
if (!string.IsNullOrEmpty(orderBy))
{
sort = orderBy;
}
SqlParameter[] parameters =
{
new SqlParameter("@Tables", SqlDbType.VarChar, 1000),
new SqlParameter("@PK", SqlDbType.VarChar, 100),
new SqlParameter("@Fields", SqlDbType.VarChar, 1000),
new SqlParameter("@Pageindex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@Filter", SqlDbType.VarChar, 1000),
new SqlParameter("@Sort", SqlDbType.VarChar, 200),
new SqlParameter("@RowCount", SqlDbType.Int)
};
parameters[0].Value = table;
parameters[1].Value = pk;
parameters[2].Value = fields;
parameters[3].Value = pageIndex;
parameters[4].Value = pageSize;
parameters[5].Value = filter;
parameters[6].Value = sort;
parameters[7].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.RunProcedure("SP_DividePage", parameters, "RePostsList");
rowCount = (int)parameters[7].Value;
return(ds.Tables[0]);
}
/// <summary>
/// 自定义获得搜索数据列表
/// </summary>
/// <returns></returns>
public DataTable GetNewTab(RePostsTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
return(service.GetNewTab(TO, pageIndex, pageSize, orderBy, out rowCount));
}
