控制器： private readonly VipViewModel _model =
new VipViewModel();
public static string Msg;// GET: SystemManage/RenZheng
[HttpGet]
public ActionResult Index(
int page =
1)
{
#region 数据填充到自定义Model
var db =
Congfig.MySqlConn;
const string sql =
"SELECT S,W FROM SW";
var result =
db.ExecuteDataReader(sql);
MySqlConnection con =
new MySqlConnection(
"server=012.345.678.910;port=0123;User Id=UserID;password=Pwd;database=DB");
MySqlDataAdapter da =
new MySqlDataAdapter(sql, con);
DataSet ds =
new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[
0];
//获取另一数据库（MYSQL）的数据
//从数据库中读取
var categoryList =
new List<Comm2ViewModel>
();
for (
int i =
0; i < dt.Rows.Count; i++
)
{
categoryList.Add(new Comm2ViewModel() { Id = dt.Rows[i][
0].ToString(), Name = dt.Rows[i][
1].ToString() });
}
_model.Comm2List = categoryList;
//填充
#endregion
var pageSize = Request[
"pagesize"] ==
null ?
10 :
int.Parse(Request[
"pagesize"]);
OQLCompare Fun(OQLCompare cmp, Users u)
{
cmp = cmp.Comparer(u.IsDelete,
"=",
false);
cmp = cmp.Comparer(u.Status,
"=",
1);
//申请认证的用户
return cmp;
}
var total = Curd.GetRecordCounts((OQLCompareFunc<Users>
)Fun);
_model.UsersList = OQL.FromObject<Users>().Select().Where(Fun).OrderBy((o, b) =>
o.Desc(b.Id)).Limit(pageSize, page, total).ToList();
ViewBag.Paging = Paging.PageNavigate(pageSize, page, total,
"");
ViewBag.Msg =
Msg;
Msg =
"";
ViewBag.DeleteUrl =
"地址";
return View(_model);
}
View视图：@model ../.Models.VipViewModel <!--这里是引用的自定义Model,地址根据实际来改-->
<table class="table">
<thead>
<tr>
<th>Id
</th>
<th>公司名称
</th>
<th>职位
</th>
<th>认证姓名
</th>
<th>联系电话
</th>
<th>社区
</th>
<th>房间号
</th>
<th>增加日期
</th>
<th>操作
</th>
</tr>
</thead>
<tbody>
@if (Model.UsersList.Count > 0)
{
foreach (var item in Model.UsersList)
{
<tr>
<td>
<p>@item.Id
</p>
</td>
<td>
<p>@item.CompanyName
</p>
</td>
<td>
<p>@item.Type
</p>
</td>
<td>
<p>@item.Name
</p>
</td>
<td>
<p>@item.Phone
</p>
</td>
<td>
@{
foreach (var item2 in Model.Comm2List)
{
if (item2.Id == item.Community2)
{
<p>@item2.Name
</p>
break;
}
}
}
</td>
<td>
<p>@item.Community
</p>
</td>
<td>
<p>@item.CreateTime.ToString("F")
</p>
</td>
<td>
<div class="operate">
<a href="" class="gray">通过认证
</a>
<a href="javascript:;" class="red" onclick="">拒绝认证
</a>
</div>
</td>
</tr>
}
}
</tbody>
</table>
VipViewModel：
public class VipViewModel
{
public List<Users> UsersList {
get;
set; }
public List<Comm2ViewModel> Comm2List {
get;
set; }
}
Comm2ViewModel：
public class Comm2ViewModel
{
public string Id {
get;
set; }
public string Name {
get;
set; }
}
最后附上结构：
转载于:https://www.cnblogs.com/SeNaiTes/p/8889492.html
相关资源：基于asp.net mvc5及bootstrap的管理后台
