protected void Page_Load(object sender, EventArgs e)
{
oldProjectWithtotal opt = new oldProjectWithtotal();
DataModal dm = new DataModal();
if (!(Request.Params["page"] == null || Request.Params["page"] == ""))
{
try
{
page = Convert.ToInt32(Request.Params["page"]);
}
catch (Exception ex)
{
page = 1;
}
}
int pageSize = 25;
if (Request.Params["type"] == null || Request.Params["type"] == "")
{
type = 0;
}
else
{
type = Convert.ToInt32(Request.Params["type"]);
}
opt = dm.GetProjectsWithTotal(type,page, pageSize,"opType","desc");
this.OpsRepeater.DataSource = opt.rows;
this.OpsRepeater.DataBind();
pages = (opt.total % pageSize) > 0 ? (opt.total / pageSize) + 1 : (opt.total / pageSize);
}
protected void Page_Load(object sender, EventArgs e)
{
DataModal dm = new DataModal();
this.newsRepeate.DataSource = dm.GetNewsList(1,6).newsList;
this.newsRepeate.DataBind();
oldProjectWithtotal opt = new oldProjectWithtotal();
opt = dm.GetProjectsWithTotal(0,1,6, "opType", "desc");
this.OpsRepeater.DataSource = opt.rows;
this.OpsRepeater.DataBind();
}
/// <summary>
/// 获取以往项目列表，带有总数目
/// </summary>
/// <param name="opType">旧项目分类</param>
/// <param name="page">页数</param>
/// <param name="pageSize">每页数量</param>
/// <param name="sort">排序元</param>
/// <param name="sordtOrder">排序顺序</param>
/// <returns></returns>
public oldProjectWithtotal GetProjectsWithTotal(int opType,int page,int pageSize,string sort,string sordtOrder)
{
string optype_;
if (opType == 0)
{
optype_ = " ";
}
else
{
optype_ = " and opType = " + opType.ToString() + " ";
}
oldProjectWithtotal opt = new oldProjectWithtotal();
conn.Open();
cmd.CommandText = "select count(opID) from oldProjects_tb where 1 = 1 " + optype_;
opt.total =Convert.ToInt32( cmd.ExecuteScalar());
if (page == 1)
{
//cmd.CommandText = "select * from oldProjects_tb where opType=" + optype_;
cmd.CommandText = "select top " + pageSize +
" oldProjects_tb.opID,oldProjects_tb.opTitle,oldProjects_tb.opImg,oldProjects_tb.opIntro,oldProjects_tb.opYear,oldProjects_tb.opLeader,oldProjects_tb.opType,opTypeTB.typeName from ( oldProjects_tb left join opTypeTB on oldProjects_tb.opType=opTypeTB.typeID ) where 1=1 "
+ optype_+" order by "
+ sort + " " + sordtOrder + " ";
}
else
{
cmd.CommandText = "select top " + pageSize +
" oldProjects_tb.opID,oldProjects_tb.opTitle,oldProjects_tb.opImg,oldProjects_tb.opIntro,oldProjects_tb.opYear,oldProjects_tb.opLeader,oldProjects_tb.opType,opTypeTBtypeName from (oldProjects_tb left join opTypeTB on oldProjects_tb.opType=opTypeTB.typeID ) where 1=1 "
+ optype_ + " and opID not in ( select top " + (page - 1) * pageSize +
" and opID from oldProjects_tb order by " + sort + " " + sordtOrder + " ) order by " + sort + " " + sordtOrder + " ";
}
dr = cmd.ExecuteReader();
List<oldProject> oplist = new List<oldProject>();
while (dr.Read())
{
oldProject op = new oldProject();
op.opID = Convert.ToInt32(dr["opID"]);
op.opTitle = dr["opTitle"].ToString();
op.opYear = dr["opYear"].ToString();
op.opLeader = dr["opLeader"].ToString();
op.opType = Convert.ToInt32(dr["opType"]);
op.opTypeName = dr["typeName"].ToString();
op.opImg = dr["opImg"].ToString().Trim();
op.opIntro = dr["opIntro"].ToString();
oplist.Add(op);
}
conn.Close();
opt.rows = oplist;
return opt;
}
