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