摘要: RESTORE DATABASE chugui FROM DISK = 'F:\ftp\红田\2.bak' WITH MOVE 'chugui' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\chugui', MOVE 'chugui_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\chugui_log&# 阅读全文
posted @ 2013-12-27 10:21 zhushang 阅读(352) 评论(0) 推荐(0)
摘要: 解决方法一:设置默认文档解决方法二:重新注册一下asp.net 4.0 返回的错误表明IIS缺少针对无后缀的MVC请求的映射,ASP.NET处理程序无法接收到请求。要解决这个问题,首先确保ASP.NET MVC3已安装好,然后检查站点的处理程序映射,看是否存在下列映射:ExtensionlessUrlHandler-Integrated-4.0ExtensionlessUrlHandler-ISAPI-4.0_32bitExtensionlessUrlHandler-ISAPI-4.0_64bit如果映射存在,请检查应用程序是否分配给了.NET Framework4.0的应用程序池。如果映射不 阅读全文
posted @ 2013-12-26 16:09 zhushang 阅读(649) 评论(0) 推荐(0)
摘要: KindEditor js设置值 editor = KindEditor.instances[0]; 找到文档中第一个KindEditor编辑器 editor.html(“htmls”);KindEditor 上传本地图片时图片被剪切问题解决: clickFn: function (url, title, width, height, border, align) { var serverZpath = "http://192.168.1.111:8067/"; serverZpath +... 阅读全文
posted @ 2013-12-24 11:31 zhushang 阅读(932) 评论(0) 推荐(0)
摘要: ParameterExpression c = Expression.Parameter(typeof(Pic), "c"); Expression condition = Expression.Constant(false); Expression> end; if (search != "" && search != null) { string[] b = search.Split('^'); foreach (str... 阅读全文
posted @ 2013-12-06 19:33 zhushang 阅读(1480) 评论(0) 推荐(0)
摘要: 1,最简单的方法 放入 ViewBag 中2,在model层,在model层封装一个包含多个对象的对象3,在controller层封装一个字典,每一个key对应一个对象 阅读全文
posted @ 2013-11-30 16:47 zhushang 阅读(623) 评论(0) 推荐(0)
摘要: 错误如图:解决方法:一般是你的文件名写错了,注意后缀xls,和.xlsx的区别 阅读全文
posted @ 2013-11-30 14:49 zhushang 阅读(296) 评论(0) 推荐(0)
摘要: order by常用的使用方式我就不提了项目的需求千变万化让我们看看下面几个怪排序需求--先创建一个表create table ai(id int not null,no varchar(10) not null)go--往表中插入数据insert into aiselect 105,'2'union allselect 105,'1'union allselect 103,'1'union allselect 105,'4'go--查询效果如下:select * from aigoid no----------- ------- 阅读全文
posted @ 2013-11-18 11:41 zhushang 阅读(919) 评论(0) 推荐(0)
摘要: --1.空间数据with Geoas(select id, lon, lat, geography::Parse('POINT('+lon+space(1)+lat+')') as g from ( select 1 as id,'-16.96732' as lon,'36.943' as lat union all select 1,'-16.58963','36.943' )awhere lon is not null and lat is no... 阅读全文
posted @ 2013-11-14 09:48 zhushang 阅读(296) 评论(0) 推荐(0)
摘要: SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: -- Create date: -- Description: -- =============================================alter PROCEDURE pro_GetPhoneAppsByRadarASBEGIN -- SET NOCOUNT ON added to prevent extra result sets fro... 阅读全文
posted @ 2013-11-09 09:48 zhushang 阅读(277) 评论(0) 推荐(0)
摘要: private const double EARTH_RADIUS = 6378.137;//地球半径 private static double rad(double d) { return d * Math.PI / 180.0; } public static double GetDistance(double lat1, double lng1, double lat2, double lng2) { double radLat1 = rad(lat1); ... 阅读全文
posted @ 2013-11-07 20:05 zhushang 阅读(422) 评论(0) 推荐(0)