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