protected void Page_Load(object sender, EventArgs e) { this.id = DTRequest.GetQueryInt("id", 0); if (this.id < 1) { JscriptMsg("传输参数不正确!", "back", "Error"); return; } if (!new BLL.advert().Exists(this.id)) { JscriptMsg("信息不存在或已被删除!", "back", "Error"); return; } if (!Page.IsPostBack) { model = new BLL.advert().GetModel(id); } }
private bool DoAdd() { bool result = true; Model.advert model = new Model.advert(); BLL.advert bll = new BLL.advert(); model.title = txtTitle.Text.Trim(); model.type = int.Parse(rblType.SelectedValue); model.price = decimal.Parse(txtPrice.Text.Trim()); model.remark = txtRemark.Text.Trim(); model.view_num = int.Parse(txtViewNum.Text.Trim()); model.view_width = int.Parse(txtViewWidth.Text.Trim()); model.view_height = int.Parse(txtViewHeight.Text.Trim()); model.target = rblTarget.SelectedValue; if (bll.Add(model) < 1) { result = false; } return result; }
private bool DoAdd() { bool result = false; Model.advert model = new Model.advert(); BLL.advert bll = new BLL.advert(); model.title = txtTitle.Text.Trim(); model.type = int.Parse(rblType.SelectedValue); model.price = decimal.Parse(txtPrice.Text.Trim()); model.remark = txtRemark.Text.Trim(); model.view_num = int.Parse(txtViewNum.Text.Trim()); model.view_width = int.Parse(txtViewWidth.Text.Trim()); model.view_height = int.Parse(txtViewHeight.Text.Trim()); model.target = rblTarget.SelectedValue; model.belongchannel = int.Parse(rblBelongChannel.SelectedValue); if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加广告位:" + model.title); //记录日志 result = true; } return result; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.advert GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,title,type,price,remark,view_num,view_width,view_height,target,add_time from " + databaseprefix + "advert "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.advert model = new Model.advert(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "") { model.type = int.Parse(ds.Tables[0].Rows[0]["type"].ToString()); } if (ds.Tables[0].Rows[0]["price"] != null && ds.Tables[0].Rows[0]["price"].ToString() != "") { model.price = decimal.Parse(ds.Tables[0].Rows[0]["price"].ToString()); } if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "") { model.remark = ds.Tables[0].Rows[0]["remark"].ToString(); } if (ds.Tables[0].Rows[0]["view_num"] != null && ds.Tables[0].Rows[0]["view_num"].ToString() != "") { model.view_num = int.Parse(ds.Tables[0].Rows[0]["view_num"].ToString()); } if (ds.Tables[0].Rows[0]["view_width"] != null && ds.Tables[0].Rows[0]["view_width"].ToString() != "") { model.view_width = int.Parse(ds.Tables[0].Rows[0]["view_width"].ToString()); } if (ds.Tables[0].Rows[0]["view_height"] != null && ds.Tables[0].Rows[0]["view_height"].ToString() != "") { model.view_height = int.Parse(ds.Tables[0].Rows[0]["view_height"].ToString()); } model.target = ds.Tables[0].Rows[0]["target"].ToString(); if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.advert model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.advert model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.advert GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,title,type,price,remark,view_num,view_width,view_height,target,add_time from " + databaseprefix + "advert "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; Model.advert model = new Model.advert(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "") { model.type = int.Parse(ds.Tables[0].Rows[0]["type"].ToString()); } if (ds.Tables[0].Rows[0]["price"] != null && ds.Tables[0].Rows[0]["price"].ToString() != "") { model.price = decimal.Parse(ds.Tables[0].Rows[0]["price"].ToString()); } if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "") { model.remark = ds.Tables[0].Rows[0]["remark"].ToString(); } if (ds.Tables[0].Rows[0]["view_num"] != null && ds.Tables[0].Rows[0]["view_num"].ToString() != "") { model.view_num = int.Parse(ds.Tables[0].Rows[0]["view_num"].ToString()); } if (ds.Tables[0].Rows[0]["view_width"] != null && ds.Tables[0].Rows[0]["view_width"].ToString() != "") { model.view_width = int.Parse(ds.Tables[0].Rows[0]["view_width"].ToString()); } if (ds.Tables[0].Rows[0]["view_height"] != null && ds.Tables[0].Rows[0]["view_height"].ToString() != "") { model.view_height = int.Parse(ds.Tables[0].Rows[0]["view_height"].ToString()); } model.target = ds.Tables[0].Rows[0]["target"].ToString(); if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } return(model); } else { return(null); } }