黒貓警长-CSDN博客

//去除Json日期格式的T function TimeFormat(time) { var d = time ? new Date(time) : new Date(); var year = d.getFullYear(); var month = d.getMonth() + 1; var day = d.getDate(); var hours = d.getHours(); var min = d.getMinutes(); var seconds = d.ge

2022-04-16 17:14:12 1091

原创 SQL检索在视图或者存储过程中有没有使用当前表

select distinct object_name(id) from syscomments where id in (select id from sysobjects where type in('V','P')) and text like '%表名%'

2022-03-24 17:13:53 365

原创 JQuery设置下拉框变成可输入文本框

引入jquery-editable-select.css 跟jquery-editable-select.js//下拉框<select id="editSelect" class="editSelectform-control"></select>//加载下拉框狂$(function () { $.ajax({ type: "POST", contentType: "application/json", url: "

2022-02-16 13:20:05 1945

原创 c#给微信公众号发送通知

//给微信公众号发送通知 [HttpGet] public string SendWeChatMsg() { string OpenID = ""; //Appid string appid = ""; //secret string secret = ""; if (OpenID != "") .

2021-07-20 09:50:03 1592

原创高德地图使用JS根据经纬度画出乡镇轮廓

2021-04-16 16:45:04 1641

原创 C#本机IP地址

string AddressIP = string.Empty; foreach (IPAddress _IPAddress in Dns.GetHostEntry(Dns.GetHostName()).AddressList) { if (_IPAddress.AddressFamily.ToString() == "InterNetwork") { ...

2021-03-17 15:52:26 737

原创 C#MVC使用NPOI导出Excel

/// <summary> /// 批量导出需要导出的列表 /// </summary> /// <returns></returns> ///Action必须用FileResult public FileResult Export() { //先获取要导出的数据 var data = db.Query...

2021-03-01 09:45:19 240

原创 C#WebApi下载文件

//前台请求接口<a href="http://localhost:43640/api/UserInfo/Values/DownloadFile">下载文件</a> /// <summary> /// 下载文件 /// </summary> [HttpGet] public HttpResponseMessage DownloadFile() {

2021-02-22 16:36:24 5890 1

原创 C#使用SQL语句备份跟恢复数据库

//备份数据库 [HttpGet] public bool BackupDB(string UserName) { bool a = false; SqlConnection conn = new SqlConnection(DbHelper.ConnectionString); SqlCommand cmdBK = new SqlCommand(); ...

2021-02-04 09:38:06 261

原创 C#返回Json字符串

/// <summary> /// 返回成json格式 /// </summary> /// <param name="obj">要返回的json字符串</param> /// <returns></returns> public static HttpResponseMessage toJson(Object obj) {...

2021-01-29 09:07:28 1127

原创 MUI上拉加载数据

<div class="mui-content"> <div class="ferret"> <div class="mui-input-row mui-search"> <input type="search" class="mui-input-clear" placeholder="" id="search"> </div> .

2021-01-29 08:56:27 184

原创 MUI弹出确认框

function Confirm(id) { var btnArray = ['取消', '确认']; mui.confirm('内容', '标题', btnArray, function (e) { if (e.index == 1) { alert("确认"); } else { mui.toast("取消"); ..

2021-01-29 08:47:44 1306

原创 JS获取URL地址栏参数

//获取地址栏参数 function getUrlParms(name) { var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)"); var r = window.location.search.substr(1).match(reg); if (r != null) return unescape(r[2]); return nul

2021-01-20 14:16:13 246

原创 JS转换Json的Date时间戳

//转换Json "/Date(1602691200000)/"类型 Date时间戳 function DateFormat(jsondate) { jsondate = jsondate.replace("/Date(", "").replace(")/", ""); if (jsondate.indexOf("+") > 0) { jsondate = jsondate.substring(0, jsondate.indexO...

2021-01-14 09:41:59 633

原创 JS滑动图片验证

HTML<div class="container"> <div id="captcha" style="position: relative"></div> </div>CSS <style type="text/css"> .container { width: 310px; margin: 100px auto; }

2020-11-25 09:13:47 498

原创 C#发送邮件

导入命名空间：using System.Net.Mail; [HttpGet] public bool SendEmail() { try { MailMessage mail = new MailMessage("发件人邮箱", "收件人邮箱"); //邮件标题 mail.Subject = "测试";

2020-11-24 14:29:37 203

原创 SQLServer存储过程基本语法

存储过程基本语法--判断存储过程是否存在，如果存在了就先删除再创建if (exists (select * from sys.objects where name = 'Pro_User')) drop proc Pro_Usergocreate proc Pro_User as declare @Name varchar(20), @Id varchar(50)begin --逻辑代码 select * from UserInfo where Name=Nam

2020-11-23 10:59:29 710

原创 LayUI根据条件判断是否显示按钮

{{# if(d.A_Id == "" || d.A_Id == null){ }} <a class="layui-btn layui-btn-xs" lay-event="SAuthority" id="shouquan">授权</a> <a class="layui-btn layui-btn-xs" lay-event="UpdAuthority"&gt...

2020-11-23 09:51:49 3913

原创 C#WebApI发送短信

新建一个C#类用来存放榛子科技的SDKusing System;using System.Collections.Generic;using System.IO;using System.Net;using System.Text;using System.Web;using System.Security.Cryptography.X509Certificates;using System.Net.Security;namespace ZhenziSms{ public cl

2020-11-20 16:39:41 408

原创 ZTree权限修改时选中复选框

function TreeView(id) { $.ajax({ type: "get", url: Url + "/UserInfo/RoleAuthority/UpdTree", data: { id: id }, dataType: 'json', async: true, success: function (response)//获取要选中

2020-11-19 09:23:49 204

原创 Webapi+Dapper+Layui多表分页查询

//js的URL请求接口 public HttpResponseMessage GetList() { HttpContext context = HttpContext.Current; var pagesize = Convert.ToInt32(context.Request.QueryString["limit"].ToString()); var pageindex = Conve...

2020-11-18 14:15:33 577

原创 WebApi+Layui增删改查

2020-11-18 14:05:26 941 3

原创 LayUI使用Echarts实现统计图

引入 echarts.min.js包<div id="main" style="width: 1000px;height:700px;"></div><script> layui.use(['form', 'laydate', 'layer'], function () { var laydate = layui.table; var form = layui.form; var layer = layui.l

2020-11-18 13:44:48 7429