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>");
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public SYCRM.Model.Festivals GetModel(Guid Id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 * from Festivals ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.UniqueIdentifier)};
parameters[0].Value = Id;
SYCRM.Model.Festivals model=new SYCRM.Model.Festivals();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["Id"].ToString()!="")
{
model.Id=new Guid(ds.Tables[0].Rows[0]["Id"].ToString());
}
if(ds.Tables[0].Rows[0]["Status"].ToString()!="")
{
model.Status=int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
model.FName=ds.Tables[0].Rows[0]["FName"].ToString();
if(ds.Tables[0].Rows[0]["FDateTime"].ToString()!="")
{
model.FDateTime=DateTime.Parse(ds.Tables[0].Rows[0]["FDateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Code"].ToString() != "")
{
model.Code = int.Parse(ds.Tables[0].Rows[0]["Code"].ToString());
}
return model;
}
else
{
return null;
}
}
