protected void Page_Load(object sender, EventArgs e)
{
((MasterPage)Page.Master).imp = "class=\"active\"";
var pageNum = 1;
try {
if (!string.IsNullOrEmpty(Request.QueryString["Page"]))
{
pageNum = Convert.ToInt32(Request.QueryString["Page"]);
}
}
catch (Exception ex) {
pageNum = 1;
}
var sql = "select row_number() over(order by PIID DESC) as rownum, * from ProfInfo where Status=1";
Pager11.GetDataBind("Repeater", "rptList", sql, pageNum, 5, " ", "rownum", "Expert.aspx?");
}
protected void Page_Load(object sender, EventArgs e)
{
((MasterPage)Page.Master).imp = "class=\"active\"";
//rptCom.DataSource = _comInfoDal.GetList(" Status=1 order by CreateDate desc ", new List<SqlParameter>()).Tables[0];
//rptCom.DataBind();
var pageNum = 1;
try {
if (!string.IsNullOrEmpty(Request.QueryString["Page"]))
{
pageNum = Convert.ToInt32(Request.QueryString["Page"]);
}
}
catch (Exception ex) {
pageNum = 1;
}
var sql = "select row_number() over(order by CreateDate DESC) as rownum, AdvisoryList.*,OrgEmployees.EmplName from AdvisoryList JOIN OrgUsers ON OrgUsers.UId = AdvisoryList.UId JOIN OrgEmployees ON OrgEmployees.EmplId = OrgUsers.EmplId where AdvisoryList.Status=1 and AdvisoryList.MType=0";
Pager11.GetDataBind("Repeater", "rptList", sql, pageNum, 5, " ", "rownum", "Message.aspx?");
}
protected void Page_Load(object sender, EventArgs e)
{
((MasterPage)Page.Master).org = "class=\"active\"";
//rptCom.DataSource = _comInfoDal.GetList(" Status=1 order by CreateDate desc ", new List<SqlParameter>()).Tables[0];
//rptCom.DataBind();
var pageNum = 1;
try {
if (!string.IsNullOrEmpty(Request.QueryString["Page"]))
{
pageNum = Convert.ToInt32(Request.QueryString["Page"]);
}
}
catch (Exception ex) {
pageNum = 1;
}
var sql = "select row_number() over(order by OID DESC) as rownum, * from ProfOrg where Status=1";
Pager11.GetDataBind("Repeater", "rptList", sql, pageNum, 6, " ", "rownum", "Mechanism.aspx?");
}
protected void Page_Load(object sender, EventArgs e)
{
((MasterPage)Page.Master).index = "class=\"active\"";
var pageNum = 1;
try {
if (!string.IsNullOrEmpty(Request.QueryString["Page"])) //页数判断
{
pageNum = Convert.ToInt32(Request.QueryString["Page"]);
}
}
catch (Exception ex) {
pageNum = 1;
}
var sql = "select row_number() over(order by dbo.CMArticle.AddTime DESC) as rownum, dbo.CMArticle.* from dbo.CMArticle join dbo.CMColumn ON CMColumn.ColId = CMArticle.ColId where CMArticle.Status=1 AND CMColumn.ColName='客户评价'";
Database db = DatabaseFactory.CreateDatabase();
var sqlCount = "select count(*) from dbo.CMArticle join dbo.CMColumn ON CMColumn.ColId = CMArticle.ColId where CMArticle.Status=1 AND CMColumn.ColName='客户评价'";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCount);
object obj = db.ExecuteScalar(dbCommand);
Literal1.Text = obj.ToString();
Pager11.GetDataBind("Repeater", "rptList", sql, pageNum, 6, " ", "rownum", "CMessage.aspx?");
}