项目开始阶段（一）

作者：老岑

第一次尝试做项目，这是一个借贷系统。
我首先是把这个借贷系统的功能之类的想法先做一个模板出来，然后就拿来设置数据库，然后又要缕清表与表之间的关系，这是我的数据库表：

然后绑定数据库，再从数据里面把你每一个页面所需要的数据绑定起来
public ActionResult SlestBorrowMoney(LayuiTablePage layuiTablePage) { var
listStu = from tbBorrowMoney in myModels.B__BorrowMoney join tbKindType in
myModels.B__KindType on tbBorrowMoney.KindTypeID equals tbKindType.KindTypeID
join tbClinet in myModels.S_Client on tbBorrowMoney.ClientID equals
tbClinet.ClientID join tbUser in myModels.S_User on tbBorrowMoney.ClientID
equals tbUser.UserID join tbRepayment in myModels.B___Repayment on
tbBorrowMoney.RepaymentID equals tbRepayment.RepaymentID join tbPaymentMethod
in myModels.B___PaymentMethod on tbBorrowMoney.RepaymentID equals
tbPaymentMethod.PaymentMethodID orderby tbBorrowMoney.BorrowMoneyID descending
select new BorrowMoney { BorrowMoneyID = tbBorrowMoney.BorrowMoneyID,
KindTypeID = tbKindType.KindTypeID, ClientID = tbClinet.ClientID, RepaymentID =
tbRepayment.RepaymentID, UserID = tbUser.UserID,
PaymentMethodID=tbPaymentMethod.PaymentMethodID, Borrowing =
tbBorrowMoney.Borrowing, UserName = tbUser.UserName, BorrowingTitle =
tbBorrowMoney.BorrowingTitle, BorrowingBalance =
tbBorrowMoney.BorrowingBalance, RateInterest = tbBorrowMoney.RateInterest,
LifeLoan = tbBorrowMoney.LifeLoan, KindName = tbKindType.KindName,
PaymentMethodName = tbPaymentMethod.PaymentMethodName, SubmissionTime =
tbBorrowMoney.SubmissionTime.ToString(), AuditStatus =
tbBorrowMoney.AuditStatus }; var intTotalRow = listStu.Count();
List<BorrowMoney> list = listStu .Skip(layuiTablePage.GetStartIndex())
.Take(layuiTablePage.limit) .ToList(); //调用分页封装类 LayuiTableData<BorrowMoney>
layuiTableData = new LayuiTableData<BorrowMoney>(); layuiTableData.count =
intTotalRow;//行总数 layuiTableData.data = list;//具体显示数据 return
Json(layuiTableData, JsonRequestBehavior.AllowGet); }
就这样我就把第一个页面所需要的数据绑定好了…
待续。。。

• « 上一篇：Spark运行原理【史上最详细】
• » 下一篇：程序员6月书讯