一下操作时在模板信息表的搭建完成之后的操作:
https://blog.csdn.net/Reswall/article/details/88966093
搭建完模板信息表以后在 进行信息数据的回显
总页面入口 显示要显示的模板以及数据表的配置,和分页的配置
@Html.Partial("ArticleListModel",Html.InfoDataList (new {Table="t_app_phone_emp_info",OrderBy = "thedate desc" },null,null,pageInfo))
然后在模板信息页接住 Model变量 进行循环
@{
var dataList= Model;
Console.WriteLine(dataList);
}
@foreach (var item in dataList)
{
<div class="table-style">
<div class="firstDiv">
<div style="display: inline-block; width:800px">
<span class="span1">@item.Name </span>
<span class="span2">@item.Position</span>
<span class="span3">公司领导</span>
</div>
<div style="display: inline-block; ">
<span class=" "><img src="../../../../Upload/Images/icon_fjh.png"> 房间号:@item.Job_room </span>
</div>
</div>
<div class="secondDiv">
<div class="junfengchangdu junfengchangduFirst"> <span class=""><img class="margin" src="../../../../Upload/Images/icon_yx.png">办公室电话:@item.Phone </span></div>
<div class="junfengchangdu"> <span class=""><img class="margin" src="../../../../Upload/Images/icon_dh.png">手机号码:@item.Mobile_phone </span></div>
<div style="display: inline-block; "> <span class=""><img class="margin" src="../../../../Upload/Images/icon_yx.png">邮箱(Email):@item.Email </span></div>
</div>
</div>
}
excel 数据源导入sqlServer的制定表中数据 具体步骤需要百度
之后是在mysql里导入数据 导入数据的时候需要配置 印象编辑 (启用标识列插入)等操作