随笔 - 5  文章 - 0 评论 - 23 trackbacks - 2
<2009年1月>
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

与我联系

搜索

 

常用链接

留言簿

我参加的小组

我的标签

随笔档案(5)

相册

最新评论

阅读排行榜

评论排行榜

官方网页:http://www.highdots.com/css-tab-designer/

 

 

性质:免费-英文版

 

 

   

posted @ 2008-07-30 12:02 小龙3 阅读(505) | 评论 (3)编辑
        该工具内置了对DB Tools for oracle,MS Enterprise Manager,MS SQL Server Management Studio,MS SQL Server Management Studio Express,MS Query Analyzer,VS 2003,VS 2005,Notepad和SQL Plus W的支持。由于该工具是通过外挂程序的方式实现SQL intellisense功能,所以理论上支持N多编辑器



下载:http://www.cnblogs.com/Files/idragonet/sqlassist_setup%203.5.21+SN.7z

SQL Assistant 3.5.21 
SN:879694-XG6EBNU-ELBT-6552

经过测试SN在Ver:3.5.21可用
posted @ 2008-06-14 20:23 小龙3 阅读(143) | 评论 (0)编辑
BugFree是借鉴微软公司软件研发理念、免费且开放源代码、基于Web的精简版缺陷管理系统。它是目前唯一“克隆”微软内部Bug管理工具 Product Stuido(以前叫Raid)的自由软件。BugFree是用PHP+MySQL写,在Linux和Windows平台上都可以运行,我们推荐的使用环境是LAMP(Linux+Apache+MySQL+PHP)。

官方网站:http://www.bugfree.org.cn/

 


1、安装

2008-01-28 BugFree 2.0 RTM build 下载地址:http://www.bugfree.org.cn/download/bugfree2.0.1128_rtm.tar.gz
配置好PHP环境和MYSQL

出现比较多的问题是SQL安装脚本无法正确执行,出现如下错误:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' CREATE TABLE `bugfree_BugInfo` ( `BugID` mediumint(7) unsigned NOT NULL a' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''', `OpenedBy` varchar(30) NOT NULL default '', `OpenedDate` datetime NOT NU' at line 13
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''', `AssignedTo` varchar(30) NOT NULL default '', `AssignedDate` datetime NO' at line 14
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''', PRIMARY KEY (`ActionID`), KEY `Action` (`ActionTarget`,`IdValue`) ) TYP' at line 8
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''', `NewValue` text '', PRIMARY KEY (`HistoryID`), KEY `ActionID` (`Actio' at line 5
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''', `GroupACL` text '', `AddDate` datetime NOT NULL default '0000-00-00 00:0' at line 4
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''', `AddDate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ' at line 6


解决方法:下载本人修改好的BugFree2.0 SQL脚本:http://www.cnblogs.com/Files/idragonet/CreateTable.rar



2.为什么“自定义显示”的字段不能保存,过一段时间又恢复成默认?

BugFree把字段显示设置保存在COOKIE里,并且COOKIE有效期是10小时(36000秒),所以10小时后你的字段显示设置又变成默认。

解决方法:修改文件 Include\FuncModel.inc.php

找到3123行,“@setcookie($Mode . "CustomFields", $_...............................”,

改为:“        @setcookie($Mode . "CustomFields", $_POST['FieldsToShow'], time()+360000000);”



说明:360000000是秒,也就是100000小时后COOKIE超时。



3.设置邮件发送
修改文件 Include\Config.inc.php

修改配置如下(仅供参考):

/* 8. Mail setting. */
$_CFG['Mail']['On']       = true;
$_CFG['Mail']['FromAddress'] = "username@163.com";
$_CFG['Mail']['FromName'] = 'BugFree';
$_CFG['Mail']['ReportTo'] = array();   // Where bug statistics message sened to. If empty, to all users.
$_CFG['Mail']['SendMethod']   = 'SMTP'; // MAIL|SENDMAIL|SMTP|QMAIL

/* 9. SMTP param setting. */
$_CFG['Mail']['SendParam']['Host']     = 'smtp.163.com';    // The server to connect. Default is localhost
$_CFG['Mail']['SendParam']['SMTPAuth'] = true; // Whether or not to use SMTP authentication. Default is FALSE
$_CFG['Mail']['SendParam']['Username'] = 'username';    // The username to use for SMTP authentication.
$_CFG['Mail']['SendParam']['Password'] = 'password';    // The password to use for SMTP authentication.
posted @ 2008-06-04 11:33 小龙3 阅读(239) | 评论 (0)编辑
官方网站:http://www.dotproject.net (需要国外代理访问)

下载地址:http://www.cnblogs.com/Files/idragonet/dotproject-2_1_1.zip
简体中文语言包:http://www.no1focus.com/archives/software/dotprojectzh.html

MYSQL 一定要用:UTF-8编码方式,否则无法保存中文!!
posted @ 2008-06-03 18:36 小龙3 阅读(573) | 评论 (6)编辑
这只是分页显示控件,分页读取数据还得自己写(如:分页存储过程)


1、SmartPager (开源、支持.NET2.0)
主页:http://www.codeproject.com/KB/aspnet/SmartPager.aspx
效果截图:




2、AspNetPager (开源、支持.NET2.0)
主页:http://www.webdiyer.com/AspNetPager/default.aspx
在线演示:http://www.webdiyer.com/AspNetPager/demo/default.aspx
效果截图:
posted @ 2008-06-01 10:47 小龙3 阅读(988) | 评论 (3)编辑