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 ReturnMessage Vip(dynamic _in)
{
ReturnMessage result = new ReturnMessage();
string inUid = _in.vip_id;
int inLevel = _in.vip_level;
// 用户id不存在
var sUid = from m in dbContext.user_data
where m.user_id == inUid
select m;
if (sUid.FirstOrDefault() == null)
{
result.code = 0;
result.message = "用户id不存在";
return(result);
}
var sVip = from m in dbContext.vip_data
where m.vip_id == inUid
select m;
DateTime nowTime = DateTime.Now;
// 之前不是vip
if (sVip.FirstOrDefault() == null)
{
vip_data newVal = new vip_data {
vip_id = inUid, vip_level = inLevel
};
newVal.begin_time = string.Format("{0:yyyy-MM-dd}", nowTime);
nowTime = nowTime.AddDays(30);
newVal.end_time = string.Format("{0:yyyy-MM-dd}", nowTime);
dbContext.vip_data.Add(newVal);
dbContext.SaveChanges();
result.code = 1;
result.message = "添加成功";
return(result);
}
// 用户已经是vip
else
{
result.code = 0;
result.message = "用户已是vip";
return(result);
}
}
