public dataReturnMessage Vip(string vid)
{
dataReturnMessage result = new dataReturnMessage();
// 用户id不存在
var sUid = from m in dbContext.user_data
where m.user_id == vid
select m;
if (sUid.FirstOrDefault() == null)
{
result.code = 0;
result.message = "用户id不存在";
result.data = null;
return(result);
}
// 用户不是vip
var sVipId = from m in dbContext.vip_data
where m.vip_id == vid
select m;
if (sVipId.FirstOrDefault() == null)
{
result.code = 0;
result.message = "用户不是vip";
result.data = null;
return(result);
}
vip_data vip = sVipId.First();
user_data user = sUid.First();
// 用户vip过期
DateTime nowTime = DateTime.Now;
if (Convert.ToDateTime(vip.end_time) < nowTime)
{
result.code = 0;
result.message = "vip已过期";
dbContext.vip_data.Remove(vip);
dbContext.SaveChanges();
return(result);
}
// 查询成功
result.code = 1;
result.message = "查询成功";
vipReturnData data = new vipReturnData {
vip_id = vid, user_name = user.user_name, start_time = vip.begin_time, end_time = vip.end_time, vip_level = vip.vip_level
};
result.data = data;
return(result);
}
public dataReturnMessage VipPage(dynamic _in)
{
dataReturnMessage result = new dataReturnMessage();
int pageNum = _in.page_num;
int pageSize = _in.page_size;
string str = _in.query;
var sAll = from m in dbContext.vip_data
join n in dbContext.user_data on m.vip_id equals n.user_id
where n.user_name.Contains(str)
select new
{
vip_id = m.vip_id,
user_name = n.user_name,
vip_level = m.vip_level,
begin_time = m.begin_time,
end_time = m.end_time
};
int num = sAll.Count();
sAll = sAll.Skip((pageNum - 1) * pageSize).Take(pageSize);
result.code = 1;
result.message = "查询成功";
result.data = new totalVip();
result.data.total = num;
result.data.page_num = pageNum;
result.data.vip_data = new vipReturnData[pageSize];
vipReturnData vip_data = new vipReturnData();
int i = 0;
foreach (var p in sAll)
{
result.data.vip_data[i] = new vipReturnData {
user_name = p.user_name, vip_id = p.vip_id, vip_level = p.vip_level, start_time = p.begin_time, end_time = p.end_time
};
++i;
}
return(result);
}
