weixin_47142884的博客

原创 添加上传图片前台显示

<table style="border-collapse:separate; border-spacing:100px 20px;"> <tr> <td>名称:</td> <td> <input id="foodname" type="text" /> </td> </tr...

原创 添加上传图片方法

private IWebHostEnvironment _hostEnvironment;public ValuesController1(IWebHostEnvironment hostEnvironment){_hostEnvironment = hostEnvironment;} [HttpPost] [Route("/ValuesController1/AddFood")] public int AddFood(string ff) { Fo.

原创 导出帮助类

using NPOI.HSSF.UserModel;using NPOI.SS.UserModel;using NPOI.XSSF.UserModel;using System;using System.Collections.Generic;using System.Data;using System.IO;/// /// 注意修改命名空间/// namespace WebApplicationMVC{public static class NPOIExcelHelper{//

原创 EF最新删除方法

public int Delete(int id){T t = new T();t = db.Set().Find(id);db.Set().Remove(t);return db.SaveChanges();}

原创 MVC控制器导出

public ActionResult ExportFile(){//判断是否有数据if (Session[“StuList”]!=null&& (Session[“StuList”] as List).Any()){var stulist = Session[“StuList”] as List;var dt = new DataTable();var props = typeof(StudentInfo).GetProperties();//添加列dt.Columns.

原创 MVC Dapper+缓存

1、MVC控制器using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc;namespace WebApplication37_MVC.Controllers{public class DefaultController : Controller{// GET: Defaultpublic ActionResult Index(){re.

原创 Redis缓存+Dapper，API方法

1、Dapper DAL层方法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(){u.

原创 导出API方法

[HttpGet]public int Export(string FileName=“123”){var users = user.GetUserInfos();var types = type.GetUTypes();List list = (from u in usersjoin t in types on u.TId equals t.TIdselect new AllModel(){UId = u.UId,UName = u.UName,UAge = u.UAge,TId

原创 添加显示分页修改反填MVC

1、控制器using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc;namespace WebMVC2.Controllers{public class UserController : Controller{// GET: Userpublic ActionResult Index(){return View();}public .

原创 上传和下载

1、//DAL层FileDAL类using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using Model;namespace DAL{public class FileDAL{/// /// 上传文件/// /// 文件模型/// public int OnLoad(FileInfo mod){str.

原创 EF迁移+应用

1、//NewDal类using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace DAL.EF_CodHelper{public class NewDal where T:class,new(){Model1 db = new Model1();public List Show(){return d.

原创 dapper帮助类

using System;using System.Collections.Generic;using System.Configuration;using System.Data;using System.Data.Common;using System.Data.SqlClient;using System.Linq;using Dapper;namespace DAL{public class DapperHelper{/// /// 数据库连接字符串/// privat

原创 使用MVC + CacheManager，调用Redis实现数据存储操作

1//FileOperation控制器using Day18ExamRedisMVC.Models;using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc;namespace Day18ExamRedisMVC.Controllers{public class FileOperationController : Controller{AP.

原创 红包方法

控制台应用using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using ServiceStack.Redis;namespace testRedis{class Program{static void Main(string[] args){double totalAmount = 100;int num =

原创 EF迁移创库+使用

using System;using System.Collections.Generic;using System.Data.Entity;using System.Linq;using System.Reflection;using System.Web;namespace G6.EFCode.DALS{public class EFHelper where T:class,new(){MyContext db = new MyContext();//实例化一个上下文对象///

原创 分配权限前台ajax显示

@{Layout = null;}<meta name="viewport" content="width=device-width" /><title>Main</title><link href="~/Content/bootstrap.css" rel="stylesheet" /><script src="~/Content/jquery-3.3.1.js"></script><style>

原创 分配权限MVC DAL+控制器

using System;using System.Collections.Generic;using System.Linq;using System.Web;using Day13ExamMVC.Models;namespace Day13ExamMVC.DAL{public class UserDAL{/// /// 列表显示/// /// public List ShowUserRole(){string sql = @“select u.UId,UName,RName

原创 验证码

<meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><meta http-equiv="X-UA-Compatible" content="ie=edge"><title>图片验证码</title><canvas id="canvas" width="120" height="40"><.

原创 二维码，条形码，显示页面

@{Layout = null;}<meta name="viewport" content="width=device-width" /><title>Index</title><script src="~/Scripts/jquery-3.4.1.min.js"></script><script src="~/Scripts/jquery.unobtrusive-ajax.min.js"></script>

原创 二维码，条形码MVC控制器

using System;using System.Collections.Generic;using System.Drawing;using System.IO;using System.Linq;using System.Web;using System.Web.Mvc;namespace G6.MVC.TwoCode.Controllers{public class CodeController : Controller{// GET: Codepublic ActionRe

原创 发布邮件MVC

<meta charset="utf-8" /><link href="bootstrap-3.3.7/css/bootstrap.css" rel="stylesheet" /><script src="Scripts/jquery-3.4.1.min.js"></script><script src="Scripts/jquery.unobtrusive-ajax.min.js"></script><script&g.

原创 发送邮件API控制器

using System;using System.Collections.Generic;using System.Linq;using System.Net;using System.Net.Http;using System.Threading.Tasks;using System.Web.Http;using G6.WeekTwo.Models;namespace G6.WeekTwo.Controllers{public class MailController : ApiCo

原创 MVC反射

//G3.IDAL层using System;using System.Collections.Generic;using G6.Model;namespace G3.IDAL{public interface IUserDAL{int AddUser(T model) where T:class,new(); List<T> GetList<T>() where T : class, new();}}//DBConnectionusing Syst

原创 MVC 添加、显示

原创 存储过程分页

create proc PageShow(@where nvarchar(max),@pageindex int,@pagesize int,@totalpage int output,@totalNum int output)asbegindeclare @totalsql nvarchar(max)set @totalsql=‘select @totalNum=COUNT() from(select ROW_NUMBER() over(order by CId) num , f

原创 MVC 显示

<script> var currentPage = 1; var totalPage = 1; $(function () { show(1); }); function show(page) { var obj = {}; obj.pageSize = 3; obj.currentPage = page; obj.yhfs = $("input[name='yhfs']:

原创 MVC Ajax添加

<script> function Add() { var obj = {}; obj.mc = $("#mc").val(); obj.Fenlei = $("#fenlei").val(); obj.sytj = $("#sytj").val(); obj.sysjCheck = $("input[name='xz']:checked").val(); obj.sysjAdd = $("

原创 API Linq分页显示，添加

using System;using System.Collections.Generic;using System.Linq;using System.Net;using System.Net.Http;using System.Web.Http;using DAL;using Models;namespace _1711B.Shopping.Controllers{public class ShoppingController : ApiController{ShoppingDA