62,025
社区成员
发帖
与我相关
我的任务
分享
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<tr>
<td>
<asp:CheckBox ID="chk" runat="server" Text='<%#Eval("NewId")%>' onclick="if(checked){this.parentNode.parentNode.style.backgroundColor='#E3EFF9'}else{this.parentNode.parentNode.style.backgroundColor=''}" />
<asp:Literal ID="iid" runat="server" Visible="false" Text='<%#Eval("NewId")%>'></asp:Literal>
</td>
<td>
<a href="<%#Eval("NewRurl")%>" target="_blank"> <%#Eval("NewTitle")%></a>
</td>
<td>
<%#Eval("NewClassName")%>
</td>
<td>
<%#JobBase.IfMean("-1", Eval("NewType").ToString(), "<span style=\"color:Green;\">正常</span>", "<span style=\" color:Red;\">推荐</span>")%>
</td>
<td>
<%#yulan(Eval("NewRurl").ToString()) %>
</td>
<td>
<%#Convert.ToDateTime(Eval("NewCreateTime").ToString()).ToString("yyyy-MM-dd")%>
</td>
<td>
<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%#Eval("NewId")%>'
CommandName="del" OnCommand="godo" OnClientClick="javascript:return confirm('确定执行?');">删除</asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CommandArgument='<%#Eval("NewId")%>'
CommandName="up" OnCommand="godo" OnClientClick="javascript:return confirm('确定执行?');">状态</asp:LinkButton>
<a href='Edit_news.aspx?id=<%#Eval("NewId")%>' target="main">修改</a>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
/// <summary>
/// 获取内容信息分页数据集
/// </summary>
/// <param name="PageNo">页数</param>
/// <param name="PageCount">每页显示记录数</param>
/// <param name="Where">查询条件</param>
/// <param name="Sort">排序条件</param>
/// <returns></returns>
public List<Book> GetBookPageRecords(int PageNo, int PageCount, string Where, string Sort)
{
List<Book> blist = new List<Book>();
try
{
DataTable dt = new DataTable();
m_dh.ClearParameters();
m_dh.AddParameter("@PageNo", SqlDbType.Int, PageNo);
m_dh.AddParameter("@PageCount", SqlDbType.Int, PageCount);
m_dh.AddParameter("@where", SqlDbType.NVarChar, 4000, Where);
m_dh.AddParameter("@sort", SqlDbType.NVarChar, 50, Sort);
dt = m_dh.GetDataSet("Get_Book_PageRecords");
if (dt.Rows.Count > 0)
{
blist = new List<Book>();
}
foreach (DataRow row in dt.Rows)
{
Book b = new Book();
b.MSBID = Convert.ToInt32(row["MSBID"]);
b.MsbTitle = row["Msb_Title"].ToString();
b.MsbContent = row["Msb_Content"].ToString();
b.MsbNumber = row["Msb_Number"].ToString();
b.MsbIsReply = Convert.ToInt32(row["Msb_IsReply"]);
b.MsbReply = row["Msb_Reply"].ToString();
b.MsbReplyTime = Convert.ToDateTime(row["Msb_ReplyTime"]);
b.MsbCreateTime = Convert.ToDateTime(row["Msb_CreateTime"]);
blist.Add(b);
}
}
catch (Exception e)
{
Common.PrintErr("GetBookPageRecords", "获取留言信息分页数据集错误,请联系开发商", e.Message);
}
return blist;
}
}