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; }