查询用户VIP管理信息

查询用户VIP管理信息
主要对网站平台vip用户管理 审核通过，开始结束时间自动添加；vip用户可以优先投标，也可以优先发布招标信息。显示用户基本信息，包含的字段：用户名、客服名称、vip期限、开始时间、结束时间、状态、是否缴费、操作、

顶部导航栏有着四个信息，第一个是查看vip会员列表信息，第二个待审核信息，第三个是已审信息，第四个是审核失败的信息。点击操作栏的查看；可以看见有用户名称，客服名称，vip期限，开始时间，结束时间，状态，是否缴费，审核时间，审核备注等vip用户信息。

说这么多让我们来看一下查询用户信息的控制器查询代码，我们先来到控制器
public ActionResult SelectVIP(BsgridPage bsgridPage)
.{
List listVIP = new List();
List listVipInformation = (from tbVipMember in myModels.S_VipMember
join tbUser in myModels.S_User on tbVipMember.MemberID equals tbUser.UserID
Join tbAuditState in myModels.B_AuditState on tbVipMember.MemberID equals tbAuditState.AuditStateID
select new VipMember
{
UserID = tbUser.UserID, AuditID = tbVipMember.AuditID,
MemberID = tbVipMember.MemberID,
AddCostTime = tbVipMember.AddCostTime,
UserName = tbUser.UserName,
ServiceName = tbVipMember.ServiceName,
VIPDeadline = tbVipMember.VIPDeadline,
StartTime = tbVipMember.StartTime.ToString(),
OverTime = tbVipMember.OverTime.ToString(),
Type = tbVipMember.Type,
PayNo = tbVipMember.PayNo,
AuditStateID = tbAuditState.AuditStateID,
AuditState = tbAuditState.AuditState,
}).ToList();

int count = listVipInformation.Count;
for (int i = 0; i < count; i++)
{
string AuditState = “”;
var AuditStatusA = listVipInformation[i].AuditStateID;
if (AuditStatusA == 1)
{
AuditState = “审核中”;
}
if (AuditStatusA == 2)
{
AuditState = “VIP会员”;
}
if (AuditStatusA == 3)
{
AuditState = “审核失败”;
}
if (AuditStatusA == 4)
{
AuditState = “撤回”;
}
listVIP.Add(new VipMember
{
UserID = listVipInformation[i].UserID,
UserName = listVipInformation[i].UserName,
ServiceName = listVipInformation[i].ServiceName,
VIPDeadline = listVipInformation[i].VIPDeadline,
StartTime = listVipInformation[i].StartTime,
OverTime = listVipInformation[i].OverTime,
Type = listVipInformation[i].Type,
PayNo = listVipInformation[i].PayNo,
AuditStateID = listVipInformation[i].AuditStateID,
AuditState = AuditState,
MemberID = listVipInformation[i].MemberID,
AddCostTime = listVipInformation[i].AddCostTime,
AuditID = listVipInformation[i].AuditID,
});
}

int totalRow = listvip.Count();
List list = listvip
.OrderBy(m => m.UserID)
.Skip(bsgridPage.GetStartIndex())
.Take(bsgridPage.pageSize).ToList();
Bsgrid bsgrid = new Bsgrid()
{
success = true,
totalRows = totalRow,
curPage = bsgridPage.curPage,
data = list
};
return Json(bsgrid, JsonRequestBehavior.AllowGet);
}
查询后的数据；