private void regNewsletter(HttpContext context) { int result = 0; string email = context.Request["email"]; if (!string.IsNullOrEmpty(email)) { Model.Newsletter model = new Model.Newsletter(); BLL.Newsletter bll_newsletter = BLL.Newsletter.Instance; model.Id = 0; model.Email = email; model.Status = 0; result = bll_newsletter.Update(model); } context.Response.Write(result); }
public List<Model.Newsletter> GetList(Int32 _Id, string _Email, int _Status, int _Start, int _Limit) { List<Model.Newsletter> result = new List<Model.Newsletter>(); try { string cmdText = "Newsletter_Select"; SqlParameter[] p = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Email", SqlDbType.NVarChar, 250), 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 = _Email; p[2].Value = _Status; p[3].Value = _Start; p[4].Value = _Limit; DataTable dt = db.ExcuteSelectReturnDataTable(cmdText, CommandType.StoredProcedure, p); if (null != dt && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { Model.Newsletter model = new Model.Newsletter(); model.Ind = Convert.ToInt32(dr["Ind"]); model.Id = Convert.ToInt32(dr["Id"]); model.Email = dr["Email"].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; }