private void ShowInfo()
{
Model.EmailTemplate model = new Model.EmailTemplate();
model = bll.GetModel(this.id, -1, 1, 1);
if (null != model && model.Id > 0)
{
txtTitle.Text = model.Title;
txtContent.Value = model.Content;
cbStatus.SelectedValue = model.Status.ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (iMascotModelDataContext SaveTheDateDB = new iMascotModelDataContext(SaveTheDateConnection))
{
var Item = SaveTheDateDB.EmailTemplates.FirstOrDefault(ab => ab.TemplateID == int.Parse(DropDownList1.SelectedValue));
if (Item == null)
{
Model.EmailTemplate emailTemplate = new Model.EmailTemplate
{
TemplateID = int.Parse(DropDownList1.SelectedValue),
MailSubject = txtMailSubject.Text,
MailBody = CKEditor1.Text
};
SaveTheDateDB.EmailTemplates.InsertOnSubmit(emailTemplate);
}
else
{
Item.MailBody = CKEditor1.Text;
Item.MailSubject = txtMailSubject.Text;
}
SaveTheDateDB.SubmitChanges();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string title = txtTitle.Text.Trim();
string content = txtContent.Value;
int status = Convert.ToInt16(cbStatus.SelectedValue);
Model.EmailTemplate model = new Model.EmailTemplate();
model.Id = this.id;
model.Title = title;
model.Content = content;
model.Status = status;
int _RowEffects = bll.Update(model);
if (_RowEffects > 0)
{
JscriptMsg(_RowEffects.ToString(), "MailTemplate.aspx", "Success");
}
else
{
JscriptMsg(_RowEffects.ToString(), "", "Error");
}
}
public List<Model.EmailTemplate> GetList(Int64 _Id, int _Status, int _Start, int _Limit)
{
List<Model.EmailTemplate> result = new List<Model.EmailTemplate>();
try
{
SqlParameter[] p = {
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Start", SqlDbType.Int, 4),
new SqlParameter("@Limit", SqlDbType.Int, 4)
};
p[0].Value = _Id;
p[1].Value = _Status;
p[2].Value = _Start;
p[3].Value = _Limit;
DataTable dt = db.ExcuteSelectReturnDataTable("EmailTemplate_Select", CommandType.StoredProcedure, p);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Model.EmailTemplate model = new Model.EmailTemplate();
model.Ind = Convert.ToInt32(dr["Ind"]);
model.Id = Convert.ToInt32(dr["Id"]);
model.Title = dr["Title"].ToString();
model.Content = dr["Content"].ToString();
model.Status = Convert.ToInt32(dr["Status"]);
model.StatusText = dr["StatusText"].ToString();
model.CreateTime = dr["CreateTime"].ToString();
model.TotalRow = Convert.ToInt32(dr["TotalRow"]);
result.Add(model);
}
}
}
catch (Exception ex)
{
PTSLog.Error(ex.Message);
}
return result;
}
