/// <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"));
}
