/// <summary>
/// 根据卡片类别调用名称和用户名，检查用户卡片是否有效
/// </summary>
/// <param name="callIndex">卡片类别调用名称</param>
/// <param name="username">用户名</param>
/// <returns></returns>
public bool CheckUserCard(string callIndex, string username)
{
bool check = false;
BLL.Card cardBll = new BLL.Card();
BLL.CardCategory cardCategoryBll = new BLL.CardCategory();
BLL.UserCard ucBLL = new BLL.UserCard();
BLL.users usersBll = new BLL.users();
var user = usersBll.GetModel(username);
var cardCategory = cardCategoryBll.GetModel(callIndex);
var uclist = ucBLL.GetModelList("UserId=" + user.id);
var cardList = cardBll.GetModelList("CardCategoryId=" + cardCategory.CardCategoryId);
List <Model.UserCard> ucl = (from uc in uclist
join c in cardList on uc.CardId equals c.CardId
select new Model.UserCard()
{
UserId = uc.UserId,
CardId = uc.CardId,
UserCardId = uc.UserCardId,
CardCategoryId = cardCategory.CardCategoryId
}).ToList();
foreach (var uc in ucl)
{
var card = cardBll.GetModel(uc.CardId);
if (card.StartDate <= DateTime.Now && card.EndDate >= DateTime.Now)
{
check = true;
}
}
return(check);
}
/// <summary>
/// 获取用户的有效期内的卡片
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public List <Model.Card> GetCards(string username)
{
BLL.Card cardBll = new BLL.Card();
BLL.CardCategory cardCategoryBll = new BLL.CardCategory();
BLL.UserCard ucBLL = new BLL.UserCard();
BLL.users usersBll = new BLL.users();
var user = usersBll.GetModel(username);
var uclist = ucBLL.GetModelList("UserId=" + user.id);
var categoryIdlist = from uc in uclist
group uc by uc.CardCategoryId into g
select new { id = g.Key };
List <Model.Card> cardList = new List <Model.Card>();
foreach (var i in categoryIdlist)
{
var cc = cardCategoryBll.GetModel(i.id);
var card = GetUsersCard(cc.CallIndex, user.user_name);
if (card != null)
{
cardList.Add(card);
}
}
return(cardList);
}
/// <summary>
/// 获取用户的所有的卡片
/// </summary>
/// <param name="username"></param>
/// <param name="token"></param>
/// <returns></returns>
public List <Model.Card> GetAllCards(string username)
{
BLL.Card cardBll = new BLL.Card();
BLL.CardCategory cardCategoryBll = new BLL.CardCategory();
BLL.UserCard ucBLL = new BLL.UserCard();
BLL.users usersBll = new BLL.users();
var user = usersBll.GetModel(username);
var uclist = ucBLL.GetModelList("UserId=" + user.id);
List <Model.Card> cardList = new List <Model.Card>();
foreach (var uc in uclist)
{
cardList.Add(cardBll.GetModel(uc.CardId));
}
return(cardList);
}
/// <summary>
/// 根据卡片类别调用名称和用户名，获取卡片信息
/// </summary>
/// <param name="callIndex"></param>
/// <param name="username"></param>
/// <returns></returns>
public Model.Card GetUsersCard(string callIndex, string username)
{
BLL.Card cardBll = new BLL.Card();
BLL.CardCategory cardCategoryBll = new BLL.CardCategory();
BLL.UserCard ucBLL = new BLL.UserCard();
BLL.users usersBll = new BLL.users();
var user = usersBll.GetModel(username);
var cardCategory = cardCategoryBll.GetModel(callIndex);
var uclist = ucBLL.GetModelList("UserId=" + user.id);
var cardList = cardBll.GetModelList("CardCategoryId=" + cardCategory.CardCategoryId);
List <Model.UserCard> ucl = (from uc in uclist
join c in cardList on uc.CardId equals c.CardId
select new Model.UserCard()
{
UserId = uc.UserId,
CardId = uc.CardId,
UserCardId = uc.UserCardId,
CardCategoryId = cardCategory.CardCategoryId
}).ToList();
Model.Card tcard = null;
foreach (var uc in ucl)
{
Model.Card card = cardBll.GetModel(uc.CardId);
if (card.StartDate <= DateTime.Now && card.EndDate >= DateTime.Now)
{
if (tcard != null)
{
if (tcard.EndDate < card.EndDate)
{
tcard = card;
}
}
else
{
tcard = card;
}
}
}
return(tcard);
}