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