public dataReturnMessage UidDelete(string uid) { dataReturnMessage result = new dataReturnMessage(); var sUid = from m in dbContext.user_data where m.user_id == uid select m; //用户不存在 if (sUid.FirstOrDefault() == null) { result.code = 0; result.message = "用户不存在"; result.data = null; return(result); } var oldData = sUid.First(); //删除用户 dbContext.user_data.Remove(oldData); dbContext.SaveChanges(); result.code = 1; result.message = "删除成功"; result.data = null; return(result); }
public dataReturnMessage Users(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.user_data where m.user_name.Contains(str) select m; int num = sAll.Count(); sAll = sAll.Skip((pageNum - 1) * pageSize).Take(pageSize); result.code = 1; result.message = "查询成功"; result.data = new totalUsers(); result.data.total = num; result.data.page_num = pageNum; result.data.users = new user_data[pageSize]; int i = 0; foreach (var p in sAll) { result.data.users[i++] = p; } return(result); }
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); }
public dataReturnMessage Permission(int vip_level) { dataReturnMessage result = new dataReturnMessage(); // 查询成功 var sPms = from m in dbContext.vip_permission where m.vip_level <= vip_level orderby m.vip_level descending // 从大到小排序 select m; vip_permission[] right = new vip_permission[sPms.Count()]; int i = 0; foreach (var p in sPms) { right[i++] = p; } result.code = 1; result.message = "查询成功"; result.data = right; return(result); }
public dataReturnMessage Uid(string uid) { dataReturnMessage result = new dataReturnMessage(); // 用户id不存在 var sUid = from m in dbContext.user_data where m.user_id == uid select m; if (sUid.FirstOrDefault() == null) { result.code = 0; result.message = "用户id不存在"; result.data = null; return(result); } // 查询成功 result.data = sUid.First(); result.code = 1; result.message = "查询成功"; return(result); }
public dataReturnMessage VipDelete(string uid) { dataReturnMessage result = new dataReturnMessage(); var sVip = from m in dbContext.vip_data where m.vip_id == uid select m; // 用户id不存在 if (sVip.FirstOrDefault() == null) { result.code = 0; result.message = "用户id不存在"; return(result); } // 删除成功 var oldData = sVip.First(); dbContext.vip_data.Remove(oldData); dbContext.SaveChanges(); result.code = 1; result.message = "删除成功"; result.data = null; return(result); }