weixin_48464248的博客

原创 Redis在MVC的存值取值

view: function Insert() { var obj = { Name:$("#name").val(), Mubiao:$("#mubiao").val(), Gufen:$("#gufen").val(), Money:$("#money").val(), Shouyi: $("#shouyi").val(), key:"num"

原创 Dapper分页显示+API

原创 存储过程加事务添加

creat 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(@orde

原创 –存储过程分页

–存储过程分页 go alter proc Page_New ( @PageIndex int, @PageSize int, @PageCount int out ) as begin declare @count int --总条数 select top(@PageSize) * from (select ROW_NUMBER() over(order by d.Id) as num,* from DayWord d join DayType dt on d.Dtid = dt.Did) as temp

原创 html简单的显示和删除

原创 html简单的添加

原创 api控制器加导入导出的

using System; using System.Collections.Generic; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using System.Data.SqlClient; using System.Data; using ClassLibrary1; using WebApplication1.Models; using System.Web.UI.WebCon

原创 初级存储过程

create table DayWord ( Id int primary key identity, Dnum varchar(50), Dtid int foreign key references DayType(Did), Dtitle varchar(50), DsubName varchar(50), Dtime varchar(50), SubTime datetime, Dinfo varchar(50) ) create table DayType ( Did int primary ke