protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
list = cateBll.GetModelList(" ");
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
CartSon = SonBll.GetModel(Convert.ToInt32(Request.QueryString["id"]));
}
}
else
{
CartSon.CartoonSonName = Request.Form["CartName"];
CartSon.CartNum = Convert.ToInt32(Request.Form["CartNum"]);
CartSon.CartId = Convert.ToInt32(Request.Form["CategoriesId"]);
CartSon.CartoonSonIamge = Request.Form["hiddenfile"];
if (Convert.ToInt32(Request.Form["id"]) == 0)
{
CartSon.AddDateTime = DateTime.Now;
SonBll.Add(CartSon);
}
else
{
CartSon.Id = Convert.ToInt32(Request.Form["id"]);
CartSon.AddDateTime = Convert.ToDateTime(Request.Form["data"]);
SonBll.Update(CartSon);
}
Response.Redirect("/Admin/Cartonn/CartsonInfo.aspx?id="+CartSon.CartId);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public shaoqi.Model.CartSon DataRowToModel(DataRow row)
{
shaoqi.Model.CartSon model = new shaoqi.Model.CartSon();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["CartoonSonName"] != null)
{
model.CartoonSonName = row["CartoonSonName"].ToString();
}
if (row["CartNum"] != null && row["CartNum"].ToString() != "")
{
model.CartNum = int.Parse(row["CartNum"].ToString());
}
if (row["CartoonSonIamge"] != null)
{
model.CartoonSonIamge = row["CartoonSonIamge"].ToString();
}
if (row["CartId"] != null && row["CartId"].ToString() != "")
{
model.CartId = int.Parse(row["CartId"].ToString());
}
if (row["AddDateTime"] != null && row["AddDateTime"].ToString() != "")
{
model.AddDateTime = DateTime.Parse(row["AddDateTime"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public shaoqi.Model.CartSon GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,CartoonSonName,CartNum,CartoonSonIamge,CartId,AddDateTime from CartSon ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)
};
parameters[0].Value = Id;
shaoqi.Model.CartSon model = new shaoqi.Model.CartSon();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
