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