摘要：
/// <summary> /// 自动编译.net项目 /// </summary> /// <param name="proccessMsg">返回处理进程消息</param> /// <returns>返回是否成功</returns> public static bool VsAutoComplie(IList<string> proccessMsg) { string processPath = @"D:\Program Files\Microsoft Visual Stu 阅读全文
摘要：
一次性删除数据库所有表和所有存储过程 SQL语句删除所有的表：如果由于外键约束删除table失败，则先删除所有约束：--/第1步**********删除所有表的外键约束*************************/DECLARE c1 cursor for select 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; ' from sysobjects where xtype = 'F'open c1declare @c1 v 阅读全文
摘要：
取出分组的头一条记录SELECT * FROM (Select OrderId,Pro_Id,TotalPro_Count,RowCnt = ROW_NUMBER() OVER(PARTITION BY OrderId ORDER BY TotalPro_Count desc) From(SELECT OrderId, Pro_Id, Sum(Pro_Count) as TotalPro_Count FROM Order_Pro_ListWHERE OrderId IN(2011081013367,2011072613014,2011082315204,2011082315779)GROUP. 阅读全文
摘要：
VS2008快捷键大全调试快捷键F6: 生成解决方案Ctrl+F6: 生成当前项目F7: 查看代码Shift+F7: 查看窗体设计器F5: 启动调试Ctrl+F5: 开始执行(不调试)Shift+F5: 停止调试Ctrl+Shift+F5: 重启调试F9: 切换断点Ctrl+F9: 启用/停止断点Ctrl+Shift+F9: 删除全部断点F10: 逐过程Ctrl+F10: 运行到光标处F11: 逐语句编辑快捷键Shift+Alt+Enter: 切换全屏编辑Ctrl+B,T / Ctrl+K,K: 切换书签开关Ctrl+B,N / Ctrl+K,N: 移动到下一书签Ctrl+B,P: 移动到上一 阅读全文
摘要：
string path = @"D:\1.sql"; StreamReader sr = File.OpenText(path); DataTable dt = new DataTable(); dt.Columns.Add("UserName",typeof(string)); dt.Columns.Add("UserPwd", typeof(string)); dt.Columns.Add("Email", typeof(string)); int i = 0; int j = 0; while (!sr.En 阅读全文
摘要：
/// <summary> /// PUT 方法只要IIS开启写入就可以上传文件txt/html/gif 等图片（不能asp/aspx/shtm/cer/asa/stm/ /// 因此当网站提供IIS写入功能可以上传gif等文件然后替换原来的图片达到修改页面的目的 /// </summary> /// <param name="url"></param> /// <param name="local"></param> /// <returns></returns& 阅读全文
摘要：
<html><head> <script> function AddText(str) { var ubb = document.getElementById("text1"); var ubbLength = ubb.value.length; ubb.focus(); if (typeof document.selection != "undefined") { document.selection.createRange().text = str; } else { ubb.value = ubb.value.s 阅读全文
摘要：
//设置金额为两位小数function setAmount(obj) { var amount = $(obj).val() * 1.0; amount = amount.toFixed(2); if (isNaN(amount)) { amount = "0.00"; } $(obj).val(amount);} 阅读全文
摘要：
--以天为单位 select count( *) as customercount,str(DATEPART(YY,RegTime)) + N'年' + cast( DATEPART(mm,RegTime) as varchar(5) )+ N'月' + cast( DATEPART(dd,RegTime) as varchar(5) )+ N'日' as timetypeFROM CRM_Customer WHERE 1=1GROUP BY DATEPART(YY,RegTime),DATEPART(mm,RegTime),DATEPART(d 阅读全文
摘要：
/** Copyright (c) 2010 刘建华 (xmjiahua.com 258420235@qq.com)* * The above copyright notice shall be* included in all copies or substantial portions of the Software.* Example: <div style="height:1000p... 阅读全文