protected void btnAdd_Click(object sender, EventArgs e)
{
SYCRM.Model.MessageTemplate MT = new SYCRM.Model.MessageTemplate();
SYCRM.BLL.MessageTemplate BMT = new SYCRM.BLL.MessageTemplate();
MT.Name = tbTemplateName.Text;
MT.Content = tbTemplateContent.Text;
MT.status = 1;
BMT.Add(MT);
tbTemplateName.Text = "";
tbTemplateContent.Text ="";
BindData();
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "添加成功!", "<script>alert('添加成功!');window.location.href='smsTemplate.aspx'</script>");
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public SYCRM.Model.MessageTemplate GetModel(Guid Id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 * from MessageTemplate ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.UniqueIdentifier)};
parameters[0].Value = Id;
SYCRM.Model.MessageTemplate model=new SYCRM.Model.MessageTemplate();
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());
}
model.Name=ds.Tables[0].Rows[0]["Name"].ToString();
model.Content=ds.Tables[0].Rows[0]["Content"].ToString();
if(ds.Tables[0].Rows[0]["status"].ToString()!="")
{
model.status=int.Parse(ds.Tables[0].Rows[0]["status"].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;
}
}
