protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
//生成随机验证码
txtCrePar.Text = RndNum(Convert.ToInt16(4));
//加载时，绑定Reapter控件，显示新闻列表;
string sql = "select infoId,infoTitle,typeName,infoBrowserCount,infoStat from uv_ips_infoDetail where 1=1 ";
sql += "and typeStat='1' "; //类别状态正常
sql += "and infoStat='3' "; //查询已发布的信息
sql += "and infoEndtime<getdate() "; //下架日期在当前日期之后
sql += "order by infoTop,infoPublishtime"; //排序
UtIpsInfoDetail utIpsInfoDetail = new UtIpsInfoDetail();
DataTable dt = utIpsInfoDetail.getInfoListBySql(sql);
rpInfoList.DataSource = dt.DefaultView;
rpInfoList.DataBind();
}
}
private void data2Page(string sql)
{
DataTable dtInfo = utIpsInfoDetail.getInfoListBySql(sql);
//修改info状态
for (int i = 0; i < dtInfo.Rows.Count; i++)
{
DataRow dr = dtInfo.Rows[i];
if (dr["infoStat"].ToString() == "1")
{
dr["infoStat"] = "未审核";
}
else if (dr["infoStat"].ToString() == "2")
{
dr["infoStat"] = "审核未通过";
}
else if (dr["infoStat"].ToString() == "3")
{
dr["infoStat"] = "审核通过";
}
}
//info绑定控件
rpInfoList.DataSource = dtInfo;
rpInfoList.DataBind();
sql = "select id,name from ut_ips_infoType where stat=1";
DataTable dtInfoType = utIpsInfoType.getInfoTypeBySql(sql);
//添加"请选择..."
DataRow drInfoType = dtInfoType.NewRow();
drInfoType["id"] = 0;
drInfoType["name"] = "请选择...";
dtInfoType.Rows.InsertAt(drInfoType, 0);
//infoType绑定到控件
ddlInfoType.DataSource = dtInfoType;
ddlInfoType.DataTextField = "name";
ddlInfoType.DataValueField = "id";
ddlInfoType.DataBind();
}