小法师丶法-CSDN博客

原创 .net JQ AJAX 请求 FromForm 接收格式

.net core 请求，后台接收数据

2024-05-22 14:03:33 151

原创 .net JQ AJAX 请求 FromBody 接收格式

.net core FromBody 接收前台的ajax 数据

2024-05-22 13:59:27 267

ISNULL(COLUMNPROPERTY(col.id, col.name, ‘Scale’), 0) AS 小数位数 ,ISNULL(ep.[value], ‘’) AS 列说明 ,ISNULL(comm.text, ‘’) AS 默认值。col.colorder AS 序号 ,col.length AS 长度 ,col.name AS 列名 ,t.name AS 数据类型 ,END AS 允许空 ,END AS 标识 ,END AS 主键 ,END AS 表名,

2023-07-29 16:04:24 806

原创 linq 左连接日志记录

var list = from a in ooKhtablejoin b in ooGeTiHu on a.Selfemploy equals b.Guid into abfrom abb in ab.DefaultIfEmpty()select new {a?.khname,a?.khID,abb?.Name};

2023-04-04 16:28:58 141

原创 C# .net List 转datatable

【代码】C# .net List 转datatable。

2023-03-08 14:32:13 439

原创 C# dataGridView 导出表格 xls NPOI 2.4.1 版本

【代码】C# dataGridView 导出表格 xls。

2023-02-15 12:32:33 621

原创 SQL 判断表里面的字段是否存在

判断表里面的字段是否存在。

2023-02-08 13:57:48 886

原创 sql分页，日志

SQL 分页记录

2023-01-26 12:35:48 71

原创 layui 刷新父界面列表方法，不整体刷新界面

/刷新他爸爸的界面里面的tablelist。

2023-01-18 16:35:34 3320

原创 layui table 刷新，重新加载

【代码】layui table 刷新，重新加载。

2023-01-18 11:01:24 2452

原创 .net C# 日期比较

TimeSpan ts1 = new TimeSpan(Convert.ToDateTime(ooKaQi_Token.CreateTime).Ticks);TimeSpan ts2 = new TimeSpan(DateTime.Now.Ticks);TimeSpan ts = ts1.Subtract(ts2).Duration();string dateDiff = ts.Days.ToString() + “天” + ts.Hours.ToString() + “小时” + ts.Minute

2022-12-04 20:55:57 472

原创 C# Post 传输 json格式

【代码】C# Post 传输 json格式。

2022-11-27 07:59:08 1082

原创 winfrom 打印图片，打印A4纸大小，自适应

代码】winfrom 打印图片，打印A4纸大小，自适应。

2022-08-10 10:09:16 884

原创 dataGridView1获取选中多行，不是复选框

代码】dataGridView1获取选中多行，不是复选框。

2022-08-09 13:27:33 1274

原创 C# winfrom dataGridView1全选反选

for (int i = 0; i < dataGridView1.Rows.Count; i++) { //判断当前行是否被选中 if ((bool)dataGridView1.Rows[i].Cells[0].EditedFormattedValue == true) //设置每一行的选择框为未选中 dataGridView1.Rows[i].Cells[0...

2022-05-20 09:13:38 490

原创 C# 父窗体跳转子窗体，子窗体刷新父窗体方法

//父窗体跳转子窗体 DlgBorrowAuditPass ooDlgBorrowAuditPass = new DlgBorrowAuditPass(Convert.ToInt32(id)); ooDlgBorrowAuditPass.Owner = this; ooDlgBorrowAuditPass.ShowDialog(); //子窗体信息处理成功关闭子窗体 Me...

2022-05-12 15:02:38 855

原创 .net C# 163邮件发送邮箱

MailMessage mail = new MailMessage(); //using System.Net.Mail;mail.From = new MailAddress(“@163.com"); //发送人邮箱地址mail.To.Add("@163.com”); //收件人邮箱地址mail.Subject = name; //标题mail.SubjectEncoding = Encoding.UTF8;mail.Body = ex.ToString(); //正文mail.P

2022-05-04 21:14:16 936

原创 SQL server 高效分页

SELECT w2.n, w1.* FROM XsXXTable w1, (SELECT TOP 130 row_number() OVER (ORDER BY xstim DESC) n, XsID FROM XsTable ) w2 WHERE w1.XsID = w2.XsID AND w2.n > 100 ORDER BY w2.n ASC

2022-04-25 22:40:59 383

原创 .net 重定向 301 SEO MVC

string url = Request.Url.ToString();if (!url.Contains(“location”))//本地访问不处理{if (!url.Contains(“www.”))//如果不是本地不带www.直接走301 重定向流程{Response.Clear();Response.StatusCode = 301;Response.Status = “301 Moved Permanently”;Response.AddHeader(“Location”, “

2022-04-21 10:29:34 122

原创 C# DataGridView 导出excel 一颗赛哦导出表格 Winfrom

private void button3_Click(object sender, EventArgs e) { string[] args = new string[1]; args[0] = ""; SaveAsExcel(dataGridView1, args); } public static void SaveAsExcel(DataGridView dgv, string[] args) //另存新档按钮导出成...

2022-04-12 20:00:37 141

原创 sql server 分页转载备份用

SQL Server 2019 分页查询DECLARE @page int ,@limit int --@page当前页，@limit 分页大小set @page =1; set @limit =10;SELECT * FROM AquariusOther.dbo.Unit_UserBasicInfoWHERE IsDeleted = 0order by ReportDate descOFFSET (@page -1)*10 ROWS FETCH NEXT @limit ROWS ONLY

2022-04-08 00:08:50 85

原创 MSSQL SQL 分页

select top 10 *from (select row_number()over(order by CreateTime asc) as rownumber,*from FYLog) temp_rowwhere rownumber>30000;SELECT w2.n, w1.* FROM FYLog w1,(SELECT TOP 10050 row_number() OVER (ORDER BY CreateTime DESC, LogId DESC) n, LogId FROM F

2022-04-08 00:04:33 450

原创 C#WINFROM 选中全部

for (int i = 0; i < dataGridView1.Rows.Count; i++){//判断当前行是否被选中if ((bool)dataGridView1.Rows[i].Cells[0].EditedFormattedValue == true)//设置每一行的选择框为未选中dataGridView1.Rows[i].Cells[0].Value = false;else//设置每一行的选择框为选中dataGridView1.Rows[i].Cells[0].Val

2022-03-31 09:30:01 85

原创 JQ ajax 循环 table遍历 .net

function XianHuoList() {$.ajax({type: “POST”,dataType: “Json”,//服务器返回的数据类型url: “/ajaxjson/XianHuoList”,data: {Name: $("#names").val(), //KSClassGuid: $("#KSClassGuid").val(), }, beforeSend: function () {

2022-03-10 09:14:27 980

原创 .net LINQ 分组求和单表 MVC c#

var list = from a in oQuListModellist //数据源 group a by new { a.khid, a.khname, a.khq, a.th } into g select new { g.Key, g.Key.khid, ...

2022-02-14 16:09:50 357

原创 .net ASCII 排序一般做为接口排序用的

public static Dictionary<string, string> AsciiDictionary(Dictionary<string, string> sArray) { Dictionary<string, string> asciiDic = new Dictionary<string, string>(); string[] arrKeys = sArray.Keys.ToArray();...

2021-09-28 14:07:35 313

原创 dataGridView1 显示行号序号最左面显示

private void dataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e) { var grid = sender as DataGridView; var rowIdx = (e.RowIndex + 1).ToString(); var centerFormat = new StringFormat() { ...

2021-08-23 10:56:51 673

原创 .net 读取Excel .xls DataTable

/// <summary> /// 产品导入 /// </summary> /// <returns></returns> public string ProDuctDR() { int DrCon = 0; string NameEX = ""; DataTable dt = new DataTable(); dt = ExcelToDS(Ser...

2021-07-08 09:55:55 129

原创 C# 读取csv datatable

public static DataTable OpenCSV(string filePath)//从csv读取数据返回table { System.Text.Encoding encoding = GetType(filePath); //Encoding.ASCII;// DataTable dt = new DataTable(); System.IO.FileStream fs = new System.IO.FileStream(fi...

2021-07-01 09:49:16 586

原创手机上传图片压缩

压缩图片demo // 对图片进行压缩function compress() {let fileObj = document.getElementById(‘file’).files[0] //上传文件的对象let reader = new FileReader()reader.readAsDataURL(fileObj)reader.onload = function(e) {let image = new Image() //新建一个img标签（还没嵌入...

2021-04-30 10:23:57 134

原创 MUI 上下啦分页触发列表AJAX 无整理比较乱

@{Layout = null;} 装车 <link href="~/mui-master/examples/hello-mui/css/mui.min.css" rel="stylesheet" /><link href="~/mui-master/examples/hello-mui/css/app.css" rel="stylesh

2021-03-15 12:54:28 113

原创 JQ JS 光标定位到文本框

<textarea placeholder="扫码区域" class="layui-textarea" id="content"></textarea> document.getElementById("content").focus();

2021-03-01 11:09:04 942

原创 .net post 模拟登录提交获取 cookie

string url = "https://www.baidu.com"; HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url); string postdata = "phone=111111&password=2222222"; byte[] requestBytes = System.Text.Encoding.UTF8.GetBytes(postdata...

2021-02-20 14:00:10 335

原创 .net post 模拟提交信息

if (!IsPostBack) { string url = "https://www.ccccccc.com"; HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url); string postdata = "tel=11111111111"; byte[] requestBytes = System.Text.E...

2021-01-21 21:36:21 282

原创 MSSQL MSQL 删除所有的表

use vrksdeclare @table varchar(600)while (select count(*) from sysobjects where type=‘u’)>=1beginset @table=(select top 1 name from sysobjects where type=‘u’)set @table='drop table '+@tableexec(@table)end

2021-01-20 10:40:42 172

原创 .net C# MVC前台CHTML 调用控制器的方法【本控制器】

@{ string sa9 = ViewBag.pclass.Titles(1569); @sa9; } public string Titles(int ID) { string Name = ""; ...

2021-01-17 14:37:57 1103

原创 .net生产二维码 ThoughtWorks.QRCode

using ThoughtWorks.QRCode.Codec; 引用这个如果没有下载下来项目右键 NUGET 输入ThoughtWorks.QRCode #region 生成二维码 public string Ewmscs(string dingdan) { Bitmap bt; string enCodeString = dingdan; QRCodeEncoder qrCodeEncoder = new QRCodeEn

2021-01-07 09:49:06 181

原创下拉框Select 默认选中

$("#XiangMuGuid option[value=" + data.XiangMuGuid + "]").attr("selected", true); $("#KaiPiaoType option[value=" + data.KaiPiaoType + "]").attr("selected", true);

2020-12-28 16:35:39 510

原创 .net C# 创建TXT文本信息 MVC

/// <summary> /// 文本记录 /// </summary> /// <param name="code"></param> /// <param name="name"></param> public static void Txt(string code, string name) { string fileLogPath = AppDomain....

2020-12-18 20:56:54 449 2

空空如也

空空如也