protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["id"] = null;
}
CorporateNewsDetails = new CommonModel();
CorporateNewsType = new CommonTypeModel();
CorporateNewsDetails.id = Request["id"] != null ? Request["id"].ToString() : "";
//根据id查询出新闻内容
sqlCmd.CommandText = @"select * from product where id = @DetailId";
sqlCmd.Parameters.Add("@DetailId", DbType.String);
sqlCmd.Parameters["@DetailId"].Value = CorporateNewsDetails.id;
IDataReader reader = sqlCmd.ExecuteReader();
if (reader.Read())
{
CorporateNewsDetails = GenerateModel(reader)[0];
}
reader.Close();
//查询出category
sqlCmd.CommandText = @"select * from category where id = @CategoryId";
sqlCmd.Parameters.Add("@CategoryId", DbType.Int16);
sqlCmd.Parameters["@CategoryId"].Value = ToInt(CorporateNewsDetails.categoryid);
reader = sqlCmd.ExecuteReader();
if (reader.Read())
{
CorporateNewsType.description = reader["description"].ToString();
}
reader.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
ProductType = new CommonTypeModel();
ProductType.id = Request["id"] != null?ToInt(Request["id"]) : 0;;
ProductType.categoryid = Request["cid"] != null?ToInt(Request["cid"]) : 0;
PageChanged(null, null);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["categoryid"] = null;
}
ProductTypeCollection = new List <CommonTypeModel>();
ProductType = new CommonTypeModel();
//ProductType.categoryid = ToInt(Session["categoryid"]);
ProductType.categoryid = Request["id"] != null?ToInt(Request["id"]) : 3;
sqlCmd.CommandText = @"select * from type where categoryid = @CategoryId";
sqlCmd.Parameters.Add("@CategoryId", DbType.Int16);
sqlCmd.Parameters["@CategoryId"].Value = ProductType.categoryid;
IDataReader reader = sqlCmd.ExecuteReader();
while (reader.Read())
{
ProductTypeCollection.Add(new CommonTypeModel()
{
id = ToInt(reader["id"]),
categoryid = ToInt(reader["categoryid"]),
description = reader["description"].ToString()
});
}
reader.Close();
sqlCmd.CommandText = @"select * from category where id = @CategoryId";
sqlCmd.Parameters.Add("@CategoryId", DbType.Int16);
sqlCmd.Parameters["@CategoryId"].Value = ProductType.categoryid;
reader = sqlCmd.ExecuteReader();
if (reader.Read())
{
ProductType.description = reader["description"].ToString();
}
reader.Close();
}
