qq_37985261-CSDN博客

转载删除所有表数据

DECLARE @strSQL NVARCHAR(MAX)SET @strSQL=''SELECT @strSQL=@strSQL+' drop table ['+name +'];'from sysobjectsWHERE [type]='U'and (name like 'edi_%')and name not in('EdiFinancialInterface','Ed...

2019-03-13 15:49:48 1032

转载地图坐标系互转

public class GpsUtil{ public static double pi = 3.1415926535897932384626; public static double x_pi = 3.14159265358979324 * 3000.0 / 180.0; public static double a = 6378245.0; public...

2018-09-10 15:01:31 221

原创 SQL语句

USE [FRD]GO/****** Object: StoredProcedure [dbo].[PayMoneySearch] Script Date: 07/15/2018 10:49:05 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[PayMoneySearch](@s...

2018-07-15 10:50:06 298

原创返回值out sql

USE [YunNanHw]GO/****** Object: StoredProcedure [dbo].[AbnormalityLocation] Script Date: 06/27/2018 16:23:19 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =========================...

2018-06-27 16:23:34 299

原创 sql 根据字段拆分查询in 语句

USE [YunNanHw]GO/****** Object: StoredProcedure [dbo].[AbnormalityLocationNew] Script Date: 06/27/2018 16:20:30 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ======================...

2018-06-27 16:23:00 1369

原创存储过程带有参数返回值和游标的

USE [YunNanHw]GO/****** Object: StoredProcedure [dbo].[EventReport] Script Date: 06/07/2018 08:47:57 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO ALTER proc [dbo].[EventReport] (...

2018-06-07 08:49:07 1026

原创存储过程分页

USE [FRD]GO/****** Object: StoredProcedure [dbo].[ProdunctCount] Script Date: 06/07/2018 08:43:33 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[ProdunctCount](@cu...

2018-06-07 08:45:50 419

原创 Subsonic 执行存储过程

StoredProcedure spd = new StoredProcedure("PayMoneySearch"); spd.Command.AddParameter("@starttime", c.GetQueryStr(qList, "PudDate")); spd.Command.AddParameter("@endtime", c.G...

2018-06-06 09:19:43 192

原创 mvc 视图 js 循环取list数据

var list =@Html.Raw(JsonConvert.SerializeObject(ViewBag.list)); for (var qwe = 0; qwe < '@ViewBag.list.Count'; qwe++) {@using Newtonsoft.Json;

2018-06-01 11:28:40 1960

原创 js经常用到的方法

1，判断js一个值是否为空if(value == '' || value == undefined || value == null){ alert("为空"); return false;}

2018-05-28 11:59:17 139

原创 List去重、遍历循环类属性和值、数组比较、集合根据属性倒叙

/// <summary> /// 获取员工全年考核记录朱常玮 2018年5月23日 /// </summary> /// <param name="queryStr"></param> /// <returns></returns> [H

2018-05-24 15:06:40 726

原创 case when then 语句

SELECT Id, TypeName, ParentId, DepartId, CusId, ImageUrl, Ext1, Ext2, Ext3,(SELECT COUNT(*)FROM dbo.VPartInfo WHERE( case when a.ParentId = '0' then VPartInfo.BigType else VPartInfo.SmallType END...

2018-05-24 13:05:43 433

原创高效分页

SELECT TOP 15 * FROM (SELECT ROW_NUMBER () OVER (ORDER BY VDepartAdminPower.ID DESC) AS rownumber,VDepartAdminPower.*FROM VDepartAdminPower WHERE ( [DepartRelationId] like '%201608031119253248-95...

2018-05-23 17:36:55 203

实例：初始化数据create table employee (empid int ,deptid int ,salary decimal(10,2))insert into employee values(1,10,5500.00)insert into employee values(2,10,4500.00)insert into employee values(3,20,1900.00)in...

2018-05-23 17:11:55 484

原创统计年龄段的人数（存储过程）

USE [YunNanHuanWei]GO/****** Object: StoredProcedure [dbo].[UserAge] Script Date: 05/23/2018 13:24:43 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[UserAge](--多个年龄...

2018-05-23 16:49:11 1809

原创气体仪器(服务)

using System;using System.Collections.Generic;using System.ComponentModel;using System.Configuration;using System.Data;using System.Diagnostics;using System.IO;using System.Linq;using System.N...

2018-05-23 10:57:35 267

原创气体仪器WinForm代码（服务器端）

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Net;using System.Net.Sockets;using System.Text;...

2018-05-23 10:55:06 180

原创 crc16验证（硬件使用）

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace SocketServer{ public class CRC16 { /// <summary> ...

2018-05-23 10:50:58 368

原创 subsonic 权限代码拼Like语句

public static SqlQuery PhoneDataPowerFilter(SqlQuery sq, string Admin) { if (LoginInfo.RoleID != "1") { Sys_Admin admin = new Sys_Admin(Admin); ...

2018-05-23 10:36:45 187

原创通用方法整合

using cn.jpush.api.common;using cn.jpush.api.push.mode;using cn.jpush.api.push.notification;using cn.jpush.api.common.resp;using System;using System.Collections.Generic;using System.Configuratio...

2018-05-23 10:35:52 231

原创钉钉通用接口

using Newtonsoft.Json;using System;using System.Collections.Generic;using System.Configuration;using System.IO;using System.Linq;using System.Net;using System.Security.Cryptography;using Syste...

2018-05-23 10:35:05 2713

qq_37985261的博客