摘要: DELIMITER $$ 和 DELIMITER ;DROP PROCEDURE IF EXISTS `pro_follow_getBookBeforeExpired`$$DECLARE p_ServiceCode VARCHAR(50);SET p_ServiceCode = 'YYGH';IF ... 阅读全文
posted @ 2015-04-27 09:08 xachary 阅读(287) 评论(0) 推荐(0) 编辑
摘要: SELECT TABLE_NAME, TABLE_COMMENT -- 指定信息列FROM `information_schema`.`tables` AWHERE A.`TABLE_SCHEMA` = '库名'AND A.`TABLE_COMMENT` = '' -- 其余条件 阅读全文
posted @ 2015-02-12 14:38 xachary 阅读(429) 评论(0) 推荐(0) 编辑
摘要: SHOW OPEN TABLES WHERE In_use > 0;SHOW FULL PROCESSLIST;KILL 53678;USE table1;SET profiling = 1;SHOW PROFILES;SET profiling = 0;SHOW TABLES;SHOW PROFI... 阅读全文
posted @ 2015-01-27 16:11 xachary 阅读(231) 评论(0) 推荐(0) 编辑
摘要: 用的是破解版的O2S.Components.PDFRender4NET.dll 插件, 简单引用即可 public static class PdfToImage { public static MemoryStream GetPdfImagePageStream(stri... 阅读全文
posted @ 2015-01-04 11:58 xachary 阅读(2283) 评论(1) 推荐(0) 编辑
摘要: UPDATE `TB_CM_Dic` SET `ParentID` = (SELECT `ID` FROM (SELECT * FROM `TB_CM_Dic`) AS B WHERE `DicName` = '药品类别')WHERE `ID` = ( SELECT `ID` FROM(... 阅读全文
posted @ 2014-12-25 11:39 xachary 阅读(1589) 评论(0) 推荐(0) 编辑
摘要: Mark://实现IClonable接口并重写Clone方法就可以实现深克隆了 #region ICloneable 成员 public object Clone() { MemoryStream ms = new MemoryStre... 阅读全文
posted @ 2014-12-11 11:44 xachary 阅读(163) 评论(0) 推荐(0) 编辑
摘要: (query as System.Data.Objects.ObjectQuery).ToTraceString() 阅读全文
posted @ 2014-12-11 08:25 xachary 阅读(161) 评论(0) 推荐(0) 编辑
摘要: 1. 打开VS20122. 新建工程(单元测试工程或控制台程序都可以, 看需求)3. 工具->NuGet程序包管理器->程序包管理器控制台4. 输入"Install-Package Selenium.WebDriver"安装程序包5.输入"Install-Package Selenium.WebDr... 阅读全文
posted @ 2014-12-09 15:36 xachary 阅读(480) 评论(0) 推荐(0) 编辑
摘要: 亲测有效://对象克隆 function clone(obj) { // Handle the 3 simple types, and null or undefined if (null == obj || "object" != type... 阅读全文
posted @ 2014-12-03 09:45 xachary 阅读(214) 评论(0) 推荐(0) 编辑
摘要: 推荐://js对象转换为 JSON 文本var text = '[{"id":1,"name":"C","size":"","date":"02/19/2010","children":[{"id":2,"name":"Program Files","size":"120 MB","date":"0. 阅读全文
posted @ 2014-12-02 09:24 xachary 阅读(202) 评论(0) 推荐(0) 编辑