/// <summary>
/// 更新充值卡状态
/// </summary>
/// <param name="sysNo">充值卡编号</param>
/// <param name="status">充值卡状态</param>
/// <returns></returns>
public static bool UpdateStatus(int sysNo, PayCardStatus status)
{
DataCommand cmd = DataCommandManager.GetDataCommand("PayCard_UpdateStatus");
cmd.SetParameterValue("@SysNo", sysNo);
cmd.SetParameterValue("@Status", (int)status);
cmd.ExecuteNonQuery();
return true;
}
/// <summary>
/// 查询充值卡
/// </summary>
/// <param name="pageIndex">取第几页</param>
/// <param name="pageSize">每页显示几条</param>
/// <param name="category">卡类型，全部则为null</param>
/// <param name="status">状态，全部则为null</param>
/// <param name="beginTime">有效期起，不限制时间则为null</param>
/// <param name="endTime">有效期止，不限制时间则为null</param>
/// <returns></returns>
public static PageList<List<PayCard>> QueryPayCard(int pageIndex, int pageSize, PayCardCategory? category, PayCardStatus? status, DateTime? beginTime, DateTime? endTime)
{
pageIndex -= 1;
if (pageIndex < 0)
pageIndex = 0;
int nCategory = category == null ? 0 : (int)category;
int nStatus = status == null ? -1 : (int)status.Value;
DateTime dtBegin = beginTime == null ? DateTime.Now.AddYears(-100) : beginTime.Value;
DateTime dtEnd = endTime == null ? DateTime.Now.AddYears(100) : endTime.Value;
return PayCardDA.QueryPayCard(pageIndex, pageSize, nCategory, nStatus, dtBegin, dtEnd);
}
