Zuansman的博客

原创 简单webform前端页面布局以及后台代码

<form id="form1" runat="server"> <div> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> <asp:Button runat="server" OnClick="Unnamed1_Click" Text="查询" /> <asp:Button runat="server" OnClick

原创 substring split使用方法

https://www.cnblogs.com/sunny3158/p/11598807.htmlsubstring split使用方法

原创 api 调用sql server 存储过程分页

public AllModel PageShow(string name,int pindex=1,int psize=3) { if (!string.IsNullOrEmpty(name)) { string where = "and SName like '%"+name+"%'"; SqlParameter[] paras = new SqlParameter[] { ne...

原创 存储过程分页

create proc Proc_ShowPage(@Where nvarchar(max),@Pindex int,@Psize int,@AllCount int output,@PageCount int output)asbegindeclare @totalsql nvarchar(max)set @totalsql=‘select @AllCount=count(1) from(select row_number() over(order by SId)num,* from

原创 模态窗

原创 导出

[HttpGet] public int Export(string FileName="123") { var users = user.GetUserInfos(); var types = type.GetUTypes(); List<AllModel> list = (from u in users join t in types on u.TId equa...

原创 .net framwork mvc子窗体页面

<meta name="viewport" content="width=device-width" /><title>Create</title><link href="~/Content/bootstrap.css" rel="stylesheet" /><script src="~/Scripts/jquery-3.4.1.js"></script><script language="JavaScript">

原创 .net framwork mvc子窗体操作的父窗体

<meta name="viewport" content="width=device-width" /><title>小窗体</title><script src="~/Scripts/jquery-3.4.1.js"></script><script language="JavaScript"> function openWin() { window.open("Create","_blank",'he

原创 分页api并导出

IDbConnection con = Dal.AbsConnection.GetDbConnection();[HttpGet][Route(“api/Page”)]public IHttpActionResult Paging(int PageIndex=1){var para = new DynamicParameters();para.Add("@TableName", “DayWord d join DayType dt on d.Dtid = dt.Did”);para.Add("

原创 AJAX分页以及导出

<meta charset="utf-8" /><title></title><link href="Content/bootstrap.css" rel="stylesheet" /><script src="Scripts/jquery-3.3.1.min.js"></script><link href="Content/pagination.css" rel="stylesheet" /><script