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