/// <summary> /// 得到一个对象实体 /// </summary> public TravelAgent.Model.LineHoliday GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,holidayName,holidaybgurl from LineHoliday "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; TravelAgent.Model.LineHoliday model = new TravelAgent.Model.LineHoliday(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.holidayName = ds.Tables[0].Rows[0]["holidayName"].ToString(); model.holidaybgurl = ds.Tables[0].Rows[0]["holidaybgurl"].ToString(); return(model); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { this.Title = Master.webinfo.WebName + "-" + Master.webinfo.SEOTitle; Master.AddMeta(Page.Master.Page, "keywords", Master.webinfo.SEOKeywords); Master.AddMeta(Page.Master.Page, "description", Master.webinfo.SEODescription); if (!this.IsPostBack) { holiday = HolidayBll.GetModel(Master.webinfo.Holiday); holidaybg = holiday != null ? holiday.holidaybgurl : ""; } }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { if (Request["tag"] != null) { string strTag = Request["tag"]; if (strTag == "holiday_save")//目的地设置 { int holiday_editid = Convert.ToInt32(Request["hidId"]); TravelAgent.Model.LineHoliday model = new TravelAgent.Model.LineHoliday(); model.holidayName = Request["txtThemeName"]; model.holidaybgurl = Request["txtImgUrl"]; try { if (holiday_editid != 0) { model.Id = holiday_editid; HolidayBll.Update(model); } else { HolidayBll.Add(model); } Response.Write("true"); } catch { Response.Write("false"); } } else if (strTag == "holiday_delete") { int holidayid = Convert.ToInt32(Request["holidayid"]); try { HolidayBll.Delete(holidayid); Response.Write("true"); } catch { Response.Write("false"); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { if (Request.QueryString["id"] != null) { TravelAgent.Model.LineHoliday model = Bll.GetModel(Convert.ToInt32(Request.QueryString["id"])); if (model != null) { this.txtThemeName.Text = model.holidayName; this.txtImgUrl.Text = model.holidaybgurl; this.hidId.Value = model.Id.ToString(); } } } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(TravelAgent.Model.LineHoliday model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LineHoliday("); strSql.Append("holidayName,holidaybgurl)"); strSql.Append(" values ("); strSql.Append("@holidayName,@holidaybgurl)"); SqlParameter[] parameters = { new SqlParameter("@holidayName", SqlDbType.NVarChar, 50), new SqlParameter("@holidaybgurl", SqlDbType.NVarChar, 255) }; parameters[0].Value = model.holidayName; parameters[1].Value = model.holidaybgurl; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TravelAgent.Model.LineHoliday model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LineHoliday set "); strSql.Append("holidayName=@holidayName,"); strSql.Append("holidaybgurl=@holidaybgurl"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@holidayName", SqlDbType.NVarChar, 50), new SqlParameter("@holidaybgurl", SqlDbType.NVarChar, 255), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.holidayName; parameters[1].Value = model.holidaybgurl; parameters[2].Value = model.Id; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TravelAgent.Model.LineHoliday model) { DAL.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TravelAgent.Model.LineHoliday model) { DAL.Add(model); return(DAL.GetMaxID("Id")); }