API 代码
using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using DAL; using Model; using Microsoft.AspNetCore.Cors; using Newtonsoft.Json; namespace Test_Month6.API.Controllers { [EnableCors("any")] [Route("UserHK")] [ApiController] public class UserHKController : ControllerBase { JWTHelper jwt = new JWTHelper(); //依赖注入 private IDAL _dal; public UserHKController(IDAL dal) { _dal = dal; } /// <summary> /// 登录 /// </summary> /// <param name="info"></param> /// <returns></returns> [HttpPost] [Route("login")] public string Login([FromForm]UserInfo info) { UserInfo model = _dal.Login(info); if (model != null) { Dictionary<string, object> keys = new Dictionary<string, object>(); keys.Add("ID", model.ID); keys.Add("User_Name", model.User_Name); keys.Add("User_PassWord", model.User_PassWord); string token = jwt.GetToken(keys, 300000); return token; } return null; } /// <summary> /// 显示还款列表 /// </summary> /// <param name="token"></param> /// <returns></returns> [HttpGet] [Route("list")] public async Task<List<UserHK>> Select(string token) { List<UserHK> list = new List<UserHK>(); string json = jwt.GetPayload(token); //序列化 UserHK user = JsonConvert.DeserializeObject<UserHK>(json); if (user != null) { list = await Task.Run(() => { return _dal.Select(user.ID); }); } foreach (var item in list) { item.date = item.HKDate.ToString("yyyy-MM-dd"); } return list; } /// <summary> /// 显示账户信息 /// </summary> /// <param name="token"></param> /// <returns></returns> [HttpGet] [Route("zhanghu")] public async Task<List<ZhangHuInfo>> ZhangHus(string token) { List<ZhangHuInfo> zhanghu = new List<ZhangHuInfo>(); string json = jwt.GetPayload(token); ZhangHuInfo zhang = JsonConvert.DeserializeObject<ZhangHuInfo>(json); if (zhang != null) { zhanghu = await Task.Run(() => { return _dal.GetZhang(zhang.ID); }); } return zhanghu; } /// <summary> /// 还款 /// </summary> /// <param name="token"></param> /// <param name="hkId"></param> /// <returns></returns> [HttpPost] [Route("hk")] public int HK([FromForm]HK_Model model) { string json = jwt.GetPayload(model.token); UserInfo user = JsonConvert.DeserializeObject<UserInfo>(json); if(user != null) { return _dal.HK(user.ID,model.ID); } else { return -1; } } [HttpPost] [Route("chongzhi")] public int ChongZhi([FromForm]chongzhi_Model model) { string json = jwt.GetPayload(model.token); UserInfo user = JsonConvert.DeserializeObject<UserInfo>(json); if (user != null) { return _dal.ChongZhi(user.ID,model.money); } else { return -1; } } } }
DAL 代码
using Model; using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using Dapper; using System.Linq; namespace DAL { public class Dal : IDAL { /// <summary> /// 充值 /// </summary> /// <param name="UserId"></param> /// <param name="money"></param> /// <returns></returns> public int ChongZhi(int UserId, decimal money) { using (SqlConnection connection = new SqlConnection("Data Source=DESKTOP-O7U2DEC;Initial Catalog=Test_MonthTest6;User ID=sa;PassWord=990621")) { return connection.Execute($"update ZhangHuInfo set ZhangYE=ZhangYE+{money} where User_ID={UserId}"); } } /// <summary> /// 显示账户余额信息 /// </summary> /// <param name="UserId"></param> /// <returns></returns> public List<ZhangHuInfo> GetZhang(int UserId) { using (SqlConnection connection = new SqlConnection("Data Source=DESKTOP-O7U2DEC;Initial Catalog=Test_MonthTest6;User ID=sa;PassWord=990621")) { string sql = $"select * from ZhangHuInfo where User_ID ={UserId}"; return connection.Query<ZhangHuInfo>(sql).ToList(); } } /// <summary> /// 环框功能 /// </summary> /// <param name="UserId"></param> /// <param name="hkId"></param> /// <returns></returns> public int HK(int UserId, int hkId) { using (SqlConnection connection = new SqlConnection("Data Source=DESKTOP-O7U2DEC;Initial Catalog=Test_MonthTest6;User ID=sa;PassWord=990621")) { //求需要还多少钱 object b = connection.ExecuteScalar($"select HKBenJin+HKLiXi from UserHK where ID = {hkId}"); //求余额还有多少钱 object yue = connection.ExecuteScalar($"select ZhangYE from ZhangHuInfo where User_ID = {UserId}"); if((decimal)b <= (decimal)yue) { //减少余额 int code = connection.Execute($"update ZhangHuInfo set ZhangYE = ZhangYE-{b} where User_ID = 1"); if(code > 0) { return connection.Execute($"update UserHK set HKState = 0 where ID = {hkId}"); } else { return 0; } } else { return -1; } } } /// <summary> /// 登录 /// </summary> /// <param name="info"></param> /// <returns></returns> public UserInfo Login(UserInfo info) { using (SqlConnection connection = new SqlConnection("Data Source=DESKTOP-O7U2DEC;Initial Catalog=Test_MonthTest6;User ID=sa;PassWord=990621")) { string sql = $"select * from UserInfo where User_Name = '{info.User_Name}' and User_PassWord = '{info.User_PassWord}'"; return connection.Query<UserInfo>(sql).FirstOrDefault(); } } /// <summary> /// 显示 /// </summary> /// <param name="UserId"></param> /// <returns></returns> public List<UserHK> Select(int UserId) { using (SqlConnection connection = new SqlConnection("Data Source=DESKTOP-O7U2DEC;Initial Catalog=Test_MonthTest6;User ID=sa;PassWord=990621")) { string sql = $"select * from UserHK where User_ID ={UserId}"; return connection.Query<UserHK>(sql).ToList(); } } } }
Login.cshtml
@{ ViewData["Title"] = "Login"; } <style> body { background-image: url(/Content/Imgs/2001513.jpg); background-size: cover; background-repeat: no-repeat } .box { 300px; height: 300px; margin: 0 auto; margin-top: 130px } #userName { margin-top: 20px; 200px; height: 35px; border-radius: 6px; } #userPwd { margin-top: 20px; 200px; height: 35px; border-radius: 6px; } #btn_save { margin-top: 20px; 200px; font-size: 18px } </style> <body> <div class="box"> <input type="text" id="userName" placeholder="用户名/手机号" /> <input type="password" id="userPwd" placeholder="密码" /><br /> <input type="button" id="btn_save" value="登录" class="btn btn-primary" /> </div> </body> <script src="~/lib/jquery/dist/jquery.js"></script> <script> //加密登录 $('#btn_save').click(function () { var obj = { "User_Name" : $('#userName').val(), "User_PassWord" : $('#userPwd').val() }; $.ajax({ url: 'http://localhost:59661/UserHK/login', data: obj, type:'post', contentType: 'application/x-www-form-urlencoded', accepts: "application/x-www-form-urlencoded", dataType:'text', success: function (data) { if (data != null) { alert('登录成功'); localStorage["userName"] = data; window.location.href = "/Default/Show"; } else { alert('登录失败'); } } }); }); </script>
Show.cshtml
@{ ViewData["Title"] = "Show"; } <style> body { background-image: url(/Content/Imgs/2003368.jpg); } .box { 950px; height: 450px; margin: 0 auto; background-color: white; margin-top: 100px; background: rgba(255, 255, 255, 0.40); } .right { 100%; height: 100%; float: right; } .up { 270px; height: 130px; background-color: aqua; margin-bottom: 25px; padding-top: 15px; background: rgba(0, 255, 255, 0.40); } .down table tr td { border: solid 1px; height: 20px; 120px; font-size: 15px; text-align: center } .down { 1000px; } </style> <body> <div class="box"> <div class="right"> <div class="up"> <span><b style="margin-left:150px">可用余额</b></span><br /> <span style="color:red;margin-left:155px">￥ <span style="color:red" id="balance"> </span></span><br /> <input style="height:25px;120px;margin-top:20px" type="text" hidden="hidden" id="money" /> <input type="button" id="cz" value="充值" class="btn btn-warning" style="60px;height:30px;line-height:18px;margin-top:15px" /> <input type="button" value="提现" style="60px;height:30px;line-height:18px;margin-top:15px" class="btn btn-secondary" /> </div> <div class="down"> <table> <tr> <td>还款期数</td> <td>还款日期</td> <td>应还本金</td> <td>应还利息</td> <td>还款总额</td> <td>还款状态</td> </tr> <tbody id="tb"></tbody> </table> </div> </div> </div> </body> <script src="~/lib/jquery/dist/jquery.js"></script> <script> $(function () { show(); }) //获取加密的数据 var token = localStorage["userName"]; function show() { $('#tb').empty(); $.ajax({ url: 'http://localhost:59661/UserHK/zhanghu', type: 'get', dataType: 'json', data: { token: token }, success: function (data) { var tr = ''; $.each(data, function (index, item) { tr += '<span style="color:red" id="balance">' + item.zhangYE + '</span>'; }); $('#balance').html(tr); } }); $.ajax({ url: 'http://localhost:59661/UserHK/list', type: 'get', dataType: 'json', data: { token: token }, //contentType: 'application/x-www-form-urlencoded', //accepts: "application/x-www-form-urlencoded", success: function (data) { console.log(data); var tr = ''; $.each(data, function (index, item) { tr += '<tr><td>' + item.hkqs + '</td>'; tr += '<td>' + item.date + '</td>'; tr += '<td>' + item.hkBenJin + '</td>'; tr += '<td>' + item.hkLiXi + '</td>'; tr += '<td>' + (item.hkLiXi + item.hkBenJin) + '</td>'; if (item.hkState == 0) { tr += '<td>已还清</td>'; } else if (item.hkState == 1) { tr += "<td><a href='#' onclick='Repay(" + item.id + ")'>还款</a></td>"; } else { tr += '<td>还清</td>'; } }); $('#tb').append(tr); } }); } function Repay(id) { var obj = { "ID": id, "token": token }; $.ajax({ url: 'http://localhost:59661/UserHK/hk', data: obj, type: 'post', contentType: 'application/x-www-form-urlencoded', accepts: "application/x-www-form-urlencoded", dataType: 'text', success: function (data) { if (data > 0) { alert('还款成功'); show(); } else if(data == -1){ alert('余额不足请充值'); $("#money").removeAttr("hidden"); } else { alert('还款失败'); } } }); } $('#cz').click(function () { var obj = { "money": $('#money').val(), "token": token }; $.ajax({ url: 'http://localhost:59661/UserHK/chongzhi', data: obj, type: 'post', contentType: 'application/x-www-form-urlencoded', accepts: "application/x-www-form-urlencoded", dataType: 'text', success: function (data) { if (data != null) { alert('充值成功'); show(); $("#money").attr("hidden", "hidden") } else { alert('充值失败'); } } }); }); </script>