public static OnlineSkiPass[] GetUnusedOnlineSkiPass()
{
DataTable dt = DBHelper.GetDataTable(" select code from order_online left join card on card_no = code where card.type = '雪票' and code <> '' and code is not null and pay_state = 1 and used = 0 order by [id] desc ");
OnlineSkiPass[] passArr = new OnlineSkiPass[dt.Rows.Count];
for (int i = 0; i < passArr.Length; i++)
{
passArr[i] = new OnlineSkiPass(dt.Rows[i]["code"].ToString());
}
dt.Dispose();
return(passArr);
}
public static OnlineSkiPass[] GetLastWeekOnlineSkiPass1()
{
DataTable dt = DBHelper.GetDataTable(" select code from order_online left join card on card_no = code where card.type = '雪票' and code <> '' and code is not null and pay_state = 1 and card.create_date >= '" + DateTime.Now.AddDays(-30).ToShortDateString() + "' order by [id] desc ");
OnlineSkiPass[] passArr = new OnlineSkiPass[dt.Rows.Count];
for (int i = 0; i < passArr.Length; i++)
{
passArr[i] = new OnlineSkiPass(dt.Rows[i]["code"].ToString());
}
dt.Dispose();
return(passArr);
}
public static OnlineSkiPass[] GetOnlieSkiPassByOwnerOpenId(string openId)
{
DataTable dt = DBHelper.GetDataTable(" select * from order_online where type = '雪票' and code <> '' and code is not null and open_id = '"
+ openId.Trim() + "' and pay_state = 1 "
+ " and exists ( select 'a' from [card] where card_no = order_online.code and [type]='雪票' ) order by [id] desc ");
OnlineSkiPass[] passArr = new OnlineSkiPass[dt.Rows.Count];
for (int i = 0; i < passArr.Length; i++)
{
passArr[i] = new OnlineSkiPass(dt.Rows[i]["code"].ToString());
}
dt.Dispose();
return(passArr);
}
