protected void btnSave_Click(object sender, EventArgs e)
{
if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"])
{
Response.Write("<script language=JavaScript>;parent.location.href='../Index.aspx';</script>");
Response.End();
}
if (txtName.Text.Trim() != null && txtName.Text.Trim() != "")
{
HD_HoliDay model = new HD_HoliDay();
HoliDayDAL dal = new HoliDayDAL();
model.Htitle = txtName.Text;
model.HstartTime = Convert.ToDateTime(starttime.Text);
model.HendTime = Convert.ToDateTime(endtime.Text);
model.Hcontent = hd_content.Value;
model.ID = strID;
model.Hisdel = 0;
model.SiteCode = Session["strSiteCode"].ToString();
if (dal.UpdateHoliday(model))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
else
{
MessageBox.Show(this, "请输入相关名称！");
}
}
/// <summary>
/// 节日添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddHoliday(HD_HoliDay model)
{
string sql = @"INSERT INTO [HD_HoliDay] ([ID],[SiteCode],[Htitle],[Himg],[Hcontent],[HstartTime],[HendTime],[HaddTime],[Hisdel])" +
" VALUES (@ID,@SiteCode,@Htitle,@Himg,@Hcontent,@HstartTime,@HendTime,@HaddTime,@Hisdel)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@SiteCode", model.SiteCode),
new System.Data.SqlClient.SqlParameter("@Htitle", model.Htitle),
new System.Data.SqlClient.SqlParameter("@Himg", model.Himg),
new System.Data.SqlClient.SqlParameter("@Hcontent", model.Hcontent),
new System.Data.SqlClient.SqlParameter("@HstartTime", model.HstartTime),
new System.Data.SqlClient.SqlParameter("@HendTime", model.HendTime),
new System.Data.SqlClient.SqlParameter("@HaddTime", DateTime.Now),
new System.Data.SqlClient.SqlParameter("@Hisdel", (model.Hisdel == 1?1:0))
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取活动详细
/// </summary>
void GetHolidayDetail()
{
if (strID.Trim() != null && strID.Trim() != "")
{
HoliDayDAL holidaydal = new HoliDayDAL();
HD_HoliDay holidaymodel = new HD_HoliDay();
DataSet ds = holidaydal.GetHoliDayDateil(strID);
string starttime = string.Empty; string endtime = string.Empty;
if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
holidaymodel = DataConvert.DataRowToModel <HD_HoliDay>(ds.Tables[0].Rows[0]);
}
if (holidaymodel.HstartTime < DateTime.Now)
{
starttime = holidaymodel.HstartTime.ToString();
}
else
{
starttime = "";
}
if (holidaymodel.HendTime < DateTime.Now)
{
endtime = "";
}
else
{
endtime = holidaymodel.HendTime.ToString();
}
//读取模板内容
string text = string.Empty;
text = System.IO.File.ReadAllText(Server.MapPath("Themes/HoliDay/HolidayRsg.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["title"] = "活动详细信息";
context.TempData["holidayDetail"] = holidaymodel;
context.TempData["starttime"] = starttime;
context.TempData["endtime"] = endtime;
context.TempData["sitecode"] = strSiteCode;
context.TempData["hid"] = strID;
context.TempData["footer"] = "奥琦微商易";
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
}
/// <summary>
/// 节日信息修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateHoliday(HD_HoliDay model)
{
string safesql = " update HD_HoliDay set ";
if (model.SiteCode != null && model.SiteCode != "")
{
safesql += " SiteCode='" + model.SiteCode + "',";
}
if (model.Htitle != null && model.Htitle != "")
{
safesql += " Htitle='" + model.Htitle + "',";
}
if (model.Himg != null && model.Himg != "")
{
safesql += " Himg='" + model.Himg + "',";
}
if (model.Hcontent != null && model.Hcontent != "")
{
safesql += " Hcontent='" + model.Hcontent + "',";
}
if (model.HstartTime != null && model.HstartTime.ToString() != "")
{
safesql += " HstartTime='" + model.HstartTime + "',";
}
if (model.HendTime != null && model.HendTime.ToString() != "")
{
safesql += " HendTime='" + model.HendTime + "',";
}
safesql += " Hisdel=" + (model.Hisdel == 1 ? 1 : 0);
safesql += " where ID='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
public void ShowActivityInfo(string strID)
{
HoliDayDAL dal = new HoliDayDAL();
DataSet ds = dal.GetHoliDayDateil(strID);
HD_HoliDay model = DataConvert.DataRowToModel <HD_HoliDay>(ds.Tables[0].Rows[0]);
txtName.Text = model.Htitle;
hd_content.Value = model.Hcontent;
starttime.Text = model.HstartTime.ToString();
endtime.Text = model.HendTime.ToString();
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
starttime.ReadOnly = true;
endtime.ReadOnly = true;
txtName.ReadOnly = true;
}
else
{
starttime.Attributes.Add("onclick", "WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})");
endtime.Attributes.Add("onclick", "WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})");
}
}
