private void couponList()
{
int pageindex = this.GetFormValue("page", 1);//
int pageSize = this.GetFormValue("pagesize", 20);
int recordCount = 0;
CouponSearchWhere where = new CouponSearchWhere();
where.key = this.GetFormValue("name", "");
where.id = this.GetFormValue("shopid", 0);
where.useStatus = this.GetFormValue("type", -1);
where.startTime = this.GetFormValue("txtStartTime", "");
where.endTime = this.GetFormValue("txtEndTime", "");
List <AttendUserModel> result = UserService.Instance.GetCouponList(customerid, pageindex, pageSize, out recordCount, where);
int pageCount = recordCount / pageSize;
if (recordCount % pageSize != 0)
{
++pageCount;
}
this.Data["PageSize"] = pageSize;
this.Data["PageIndex"] = pageindex;
this.Data["Total"] = recordCount;
this.Data["PageCount"] = pageCount;
this.Data["Rows"] = result;
}
/// <summary>
/// 获取优惠券列表
/// </summary>
/// <param name="customerid"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="where"></param>
/// <returns></returns>
public List <AttendUserModel> GetCouponList(int customerid, int pageIndex, int pageSize, out int recordCount, CouponSearchWhere where)
{
return(dal.GetCouponList(customerid, pageIndex, pageSize, out recordCount, where));
}
/// <summary>
/// 获取优惠券列表
/// </summary>
/// <param name="customerid"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="where"></param>
/// <returns></returns>
public List <AttendUserModel> GetCouponList(int customerid, int pageIndex, int pageSize, out int recordCount, CouponSearchWhere where)
{
string sql = @"select * from Hot_AttendUser where isAttend=1 and customerid=@customerid";
if (where != null)
{
if (!string.IsNullOrEmpty(where.key))
{
sql += string.Format(" and (couponCode='{0}' or nickName like '%{0}%')", where.key);
}
if (where.id > 0)
{
sql += string.Format(" and shopUserId={0} ", where.id);
}
if (where.useStatus != -1)
{
sql += string.Format(" and useStatus={0} ", where.useStatus);
}
if (!string.IsNullOrEmpty(where.startTime))
{
sql += string.Format(" and CONVERT(nvarchar(10),updateTime,121)>='{0}' ", where.startTime);
}
if (!string.IsNullOrEmpty(where.endTime))
{
sql += string.Format(" and CONVERT(nvarchar(10),updateTime,121)<='{0}' ", where.endTime);
}
}
SqlParameter[] parameters =
{
new SqlParameter("@customerid", customerid)
};
string querySql = DbHelperSQL.buildPageSql(pageIndex, pageSize, sql, "updateTime", true);
string recordCountSql = DbHelperSQL.buildRecordCountSql(sql);
recordCount = Convert.ToInt32(DbHelperSQL.GetSingle(recordCountSql, parameters));
List <AttendUserModel> lst = new List <AttendUserModel>();
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(querySql, parameters))
{
lst = DbHelperSQL.GetEntityList <AttendUserModel>(dr);
}
return(lst);
}
