private void BindData()
{
List<SYCRM.Model.Festivals> listMF = new List<SYCRM.Model.Festivals>();
SYCRM.BLL.Festivals BF = new SYCRM.BLL.Festivals();
string strWhere = " status=1 ";
if (!tb_KeyWords.Text.Trim().Equals(""))
{
strWhere += " and [FName] like '%" + tb_KeyWords.Text.Trim() + "%'";
}
listMF = BF.GetModelList(strWhere);
GridViewList.DataSource = listMF;
GridViewList.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
SYCRM.Model.Festivals MF = new SYCRM.Model.Festivals();
SYCRM.BLL.Festivals BF = new SYCRM.BLL.Festivals();
DateTime temp = new DateTime();
if (DateTime.TryParse(tbFDate.Text.Trim(), out temp))
{
MF.FName = tbFName.Text;
MF.FDateTime = temp; ;
MF.Status = 1;
BF.Add(MF);
tbFName.Text = "";
tbFDate.Text = "";
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "添加成功!", "<script>alert('添加成功!');window.location.href='Festivals.aspx'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
List<SYCRM.Model.Festivals> listMF = new List<SYCRM.Model.Festivals>();
SYCRM.BLL.Festivals BF = new SYCRM.BLL.Festivals();
string strWhere = " status=1 ";
listMF = BF.GetModelList(strWhere);
DateTime dtnow = DateTime.Now;
foreach (SYCRM.Model.Festivals f in listMF)
{
DateTime dt = f.FDateTime.Value;
if (dt.Year==dtnow.Year&& dt.Month == dtnow.Month)
{
if (dt.Day >= dtnow.Day && dt.Day <= dtnow.Day + 3)
{
ltrAlert.Text += f.FName + "(" + dt.Year + "年" + dt.Month + "月" + dt.Day + "日)快到了! ";
}
}
}
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
CheckBox cb;
SYCRM.BLL.Festivals BF = new SYCRM.BLL.Festivals();
for (int i = 0; i < GridViewList.Rows.Count; i++)
{
cb = (CheckBox)GridViewList.Rows[i].FindControl("CBSelect");
if (cb.Checked)
{
try
{
SYCRM.Model.Festivals mf = BF.GetModel(new Guid(GridViewList.DataKeys[i].Value.ToString()));
mf.Status = 2;
BF.Update(mf);
}
catch
{
}
}
}
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "节日成功删除!", "<script>alert('节日成功删除!');window.location.href='Festivals.aspx'</script>");
}
