WAi_KB-CSDN博客

原创 Web API Redis存储

ProdudctDal produdctDal = new ProdudctDal(); public List<ProductInfo> Show(int pageIndex, int pagesize, string name) { //实例化一个集合 var list = new List<ProductInfo>(); #region MyRegion // //...

2020-08-06 11:32:37 226

public void Export(){try{List userInfos = new List();userInfos.Add(new UserInfo() { UserName = “张三”, Age = 10 });userInfos.Add(new UserInfo() { UserName = “张三”, Age = 10 });userInfos.Add(new UserInfo() { UserName = “张三”, Age = 10 });userInfos.Add(n

2020-08-05 20:47:17 255

原创万能分页存储过程

–分页显示存储过程if(exists(select * from sys.objects where name=‘pr_ShowPage’))drop proc pr_ShowPagegocreate proc pr_ShowPage(@where nvarchar(500),@pageIndex int,@pageSize int,@totalCount int output,@pageCount int output)asbegindeclare @strcount nva

2020-08-05 20:41:30 161

原创 MVC 视图显示分页

<a href="javascript:showPage('First')" style="margin-left:280px">首页</a> <a href="javascript:showPage('Preve')">上一页</a> 当前第<label id="pageIndex">1</label>页/共<label id="pageCount">1</label&...

2020-08-05 20:33:50 213 1

原创 DapperApi实现

using System;using System.Collections.Generic;using System.Data.SqlClient;using System.Linq;using System.Text;using System.Threading.Tasks;using Dapper;using Model;namespace DAL{public class UserDAL{public List Show(){using (SqlConnection con

2020-07-10 08:05:04 161

原创添加页面

@{ViewData[“Title”] = “Privacy Policy”;}@添加@$(function () { showtype();});function showtype() { $.ajax({ url: "http://localhost:49726/api/shop/shoptype", datatype: "json", success: function (result) { va

2020-06-09 20:55:58 323

原创显示详情

@{ViewData[“Title”] = “Detail”;}@显示详情@$(function () { show();});function show() { var id = location.search.split("?")[1].split("=")[1]; $.ajax({ url: "http://localhost:49726/api/shop/ShopDetail?id=" + id, dataType: "json"

2020-06-09 20:54:33 219

原创分页的显示视图

@{ViewData[“Title”] = “Show”;}Showclass="table table-hover"> <td>产品ID</td> <td>产品名称</td> <td>投资金额</td> <td>投资收益</td> <td>投资时间</td> <td>

2020-06-09 20:44:08 357

原创 EF Code First数据库迁移+实现Dal

using DataModel;using System;using System.Collections.Generic;using System.Text;using Dapper;using System.Data.SqlClient;using System.Linq;namespace Service{public class HKServer : IHKServer{ /// <summary> /// 充值 /// </summar

2020-06-09 20:08:15 242

原创 sql用事务做添加

alter proc Buy(@ProductNo char(14),@SkuId int,@account nvarchar(20),@buyNumber int) as begin --使用事务 begin tran declare @error int declare @orderNo char(14) declare @amount float select @orderNo=OrderNo from [order] where OrderAccount=@account --查询编号 if(@or

2020-06-09 13:43:21 386

WAi_KB的博客