摘要: select * from yourtable order by cast(yourcol as int); 阅读全文
posted @ 2017-09-12 11:05 chang1234 阅读(169) 评论(0) 推荐(0)
摘要: entAnnuaModel.annuaOutGuaranteeInfos = entAnnuaModel.annuaOutGuaranteeInfos.Select(i => { i.annuaId = string.IsNullOrEmpty(i.annuaId) ? "" : i.annuaId 阅读全文
posted @ 2017-09-04 17:37 chang1234 阅读(1003) 评论(0) 推荐(0)
摘要: DECLARE @functionIdf int DECLARE @namef varchar(500) DECLARE My_Cursor CURSOR --定义游标FOR (SELECT [functionId],[name] FROM [dbo].[BT_FunctionRelevanceAP 阅读全文
posted @ 2017-08-29 18:26 chang1234 阅读(195) 评论(0) 推荐(0)
摘要: public AllDesColumnEntity GetAllColumnList() { AllDesColumnEntity list = new AllDesColumnEntity(); string sql = @"SELECT function_id, property_valuena 阅读全文
posted @ 2017-08-24 17:43 chang1234 阅读(356) 评论(0) 推荐(0)
摘要: XmlDocument doc = new XmlDocument(); string str = HttpRuntime.AppDomainAppPath.ToString(); doc.Load(str + "//test.XML"); XmlElement rootElem = doc.Doc 阅读全文
posted @ 2017-08-23 15:48 chang1234 阅读(98) 评论(0) 推荐(0)
摘要: var jObject = Newtonsoft.Json.Linq.JObject.Parse(ids); foreach (KeyValuePair<string, JToken> keyValuePair in jObject) { Debug.WriteLine(keyValuePair.K 阅读全文
posted @ 2017-08-22 10:50 chang1234 阅读(404) 评论(0) 推荐(0)
摘要: /// <summary> /// 是否为日期型字符串 /// </summary> /// <param name="StrSource">日期字符串(2008-05-08)</param> /// <returns></returns> public static bool IsDate(str 阅读全文
posted @ 2017-08-15 15:59 chang1234 阅读(2121) 评论(0) 推荐(0)
摘要: protected void Button1_Click(object sender, EventArgs e) { /* 微软为Response对象提供了一个新的方法TransmitFile来解决使用Response.BinaryWrite 下载超过400mb的文件时导致Aspnet_wp.exe 阅读全文
posted @ 2017-08-11 09:42 chang1234 阅读(4373) 评论(0) 推荐(1)
摘要: SQL SERVER高并发解决方案主要是从以下几个方面: 1.SQL语句优化: A.尽可能的精确查询条件及查询字段,缩小查询范围(包括使用分页查询); B.查询条件中尽可能少用:like,(not)in,(not)is null,order by,distinct,count(*),!=,; C.不 阅读全文
posted @ 2017-07-26 17:34 chang1234 阅读(1004) 评论(0) 推荐(0)
摘要: http://www.bejson.com/ ,https://c.runoob.com/examples/page/2(各种) postman (post调试插件) telerik fiddler web debugger http://www.webyang.net/Html/web/artic 阅读全文
posted @ 2017-07-19 10:09 chang1234 阅读(140) 评论(0) 推荐(0)