<![CDATA[梦的热土]]>http://www.mdrt.org.cn/PJBlog32010-06-17T13:24:02+08:00<![CDATA[Access通用类（适合不断变化数据库名的项目）]]>jbkadminhttp://www.mdrt.org.cn/anyshe@126.com2010-06-17T13:24:02+08:002010-06-17T13:24:02+08:00代码 using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data; using System.Data.OleDb; using System.Data.SqlClient;
/// <summary> ///AccessDBHelper 的摘要说明 /// </summary> public class AccessDBHelper { private string connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Jet Oledb:Database Password=mingmei114;Data Source=";
public OleDbConnection Connection { get { if (connection == null) { connection = new OleDbConnection(connectionString); connection.Open(); } else if (connection.State == System.Data.ConnectionState.Closed) { connection.Open(); } else if (connection.State == System.Data.ConnectionState.Broken) { connection.Close(); connection.Open(); } return connection; } }
public int ExecuteCommand(string safeSql) { OleDbCommand cmd = new OleDbCommand(safeSql,Connection); int result = cmd.ExecuteNonQuery(); return result; }
public int ExecuteCommand(string sql, params SqlParameter[] values) { OleDbCommand cmd = new OleDbCommand(sql, Connection); cmd.Parameters.AddRange(values); return cmd.ExecuteNonQuery(); }
public int GetScalar(string safeSql) { OleDbCommand cmd = new OleDbCommand(safeSql, Connection); int result = Convert.ToInt32(cmd.ExecuteScalar()); return result; }
public int GetScalar(string sql, SqlParameter[] values) { OleDbCommand cmd = new OleDbCommand(sql, Connection); cmd.Parameters.AddRange(values); int result = Convert.ToInt32(cmd.ExecuteScalar()); return result; }
public OleDbDataReader GetReader(string safeSql) { OleDbCommand cmd = new OleDbCommand(safeSql, Connection); OleDbDataReader reader = cmd.ExecuteReader(); return reader; }
public DataTable GetDataSet(string safeSql) { DataSet ds = new DataSet(); OleDbCommand cmd = new OleDbCommand(safeSql, Connection); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(ds); return ds.Tables[0]; }
public DataTable GetDataSet(string sql, SqlParameter[] values) { DataSet ds = new DataSet(); OleDbCommand cmd = new OleDbCommand(sql, Connection); cmd.Parameters.AddRange(values); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(ds); return ds.Tables[0]; }
jqModal is a plugin for jQuery to help you display notices, dialogs, and modal windows in a web browser. It is flexible and tiny, akin to a "Swiss Army Knife", and makes a great base as a general purpose windowing framework.
Features;
* Designer Frieldly - Use *your* HTML+CSS for Layout and Styling * Translator/i18n friendly - No hardcoded English strings * Developer friendly - Extensible through callbacks to make anything (gallery slideshows, video-conferencing, etc.) possible * Simple support for remotely loaded content (aka "AJAX") * Multiple Modal Support (including Modal-in-Modal)
Why?
There is no shortage of dialog scripts that "dazzle" their audience. Some will try to walk your dog. These scripts are often rooted in unnecessary effects, are rigid, and extremely cumbersome. This is not where jqModal is headed! I wanted to write a simple modal framework. Something lightweight yet powerful and flexible. We'll demonstrate the dazzling dogwalks later... for now, you are encouraged to pioneer your own effects by harnessing the power of jQuery and jqModal!
If you like jqModal, please consider a dontation to support its development: When?
Download the Plugin (jqModal.js - 2.97k) [jQuery >= 1.1.3.1+] Download the Styling (jqModal.css - 496 bytes)
[PREVIOUS RELEASES] available here.
[OPTIONAL] Drag'n'Resize Plugin (jqDnR.js - 874 bytes) - It is recommended to combine DnR and jqModal javascript files into one to reduce server overhead.
** file sizes reflect uncompressed source with header removed Image Caching; Some browsers do not preload background images and image elements if they are hidden (have a parent whose display is set to none or hidden). This could effect the responsiveness of your dialogs. This page uses an OPTIONAL workaround to get around this issue. It preloads dialog decoration images for faster display. See the code used by clicking the HTML tab below; HTML
<!-- optional: image cacheing. Any images contained in this div will be loaded offscreen, and thus cached -->
<style type="text/css"> /* Caching CSS created with the help of; Klaus Hartl <klaus.hartl@stilbuero.de> */ @media projection, screen { div.imgCache { position: absolute; left: -8000px; top: -8000px; } div.imgCache img { display:block; } } @media print { div.imgCache { display: none; } } </style>
Usage Typically, to add popup dialogs, frames, windows, or what-have-yous to your website you must;
1. Add dialog placeholder(s) to your page Dialog placeholders are usually hidden <div> containers placed as children of the <body> element. CSS is used for styling and position. Dialogs are displayed("shown") when a trigger event occurs. Their contents(message/image/etc.) can be inline (hardcoded in the HTML) or added via ajax when the dialog is shown. 2. Initialize your dialog(s) jqModal must be called on each dialog element before it can be shown using the $.jqm() function. You can customize your dialogs by passing parameters as an argument (e.g. $('#dialog').jqm({modal: true, trigger: 'a.showDialog'});).
NOTE: $.jqm() should only be called ONCE per dialog element! In special cases you may want to change a dialog's parameters. Subsequent calls to $.jqm() will update the dialog(s) parameters. 3. Trigger your dialog Dialogs are automatically shown when a "trigger" element is clicked. You can also manually trigger a dialog by executing the $.jqmShow() function on it.
Functions
jqm Initialize element(s) to be used as a jqModal. Accepts a parameters object. If element(s) are already initialized, the call will update their parameters.
$('#dialog').jqm(); $('.dialogs').jqm({ajax:'@href',modal:true}); jqmShow Show jqModal element(s).
$('#dialog').jqmHide(); $('.dialogs').jqmHide(); jqmAddTrigger Adds the passed element(s) as a "show" trigger. Clicking them will show the jqModal. Accepts;
* (string) A jQuery Selector * (object) A jQuery Collection * (object) A DOM element
$('#dialog').jqmAddTrigger('.openDialog'); $('.dialogs').jqmAddTrigger($('#openDialogs a')); jqmAddClose Adds the passed element(s) as a "close" trigger. Clicking them will hide the jqModal. Accepts;
* (string) A jQuery Selector * (object) A jQuery Collection * (object) A DOM element
Parameters Parameters allow tailoring the behavior of any jqModal to your needs. They are passed on-the-fly as an object to the $.jqm function.
NOTE; you can overide the default setting of a parameter by modifying the $.jqm.params global. For instance, to have ALL dialogs appear as modal dialogs (without passing modal as "true"), execute $.jqm.params.modal = true before any calls to the $.jqm() function.
overlay The overlay transparency as a percentage. If 0 the overlay is disabled, and the page will remain interactive. If 100 the overlay will be 100% opaque.
(integer) - default: 50 overlayClass Name of CSS class applied to the overlay.
(string) - default: 'jqmOverlay' closeClass When a dialog is shown, elements that have a CSS class of closeClass will close the dialog when clicked. For instance; If your dialog contains an <img class="closeClass" src="close.gif">, the dialog will close when this image is clicked. You can use $.jqmHide() to close a dialog manually.
(string|false) - default: 'jqmClose' trigger Elements matching trigger will show the dialog when clicked. They are assigned when $.jqm() is called. Triggers can be;
* (string) A jQuery Selector * (object) A DOM element (e.g. $.jqm({trigger: document.getElementByID("showDialog")}) * (false) The call to $.jqm() will not look for trigger elements.
(string|object|false) - default: '.jqModal' ajax If passed, dialog contents will be loaded remotely via ajax. You can pass the URL (e.g. $.jqm({ajax:'remote/dialog.html'}) or extract it from an attribute of the triggering element. For instance, $(.jqm({ajax:'@href'}) would grab contents from bar.html if the triggering element was <a href="foo/bar.html">Open Dialog</a>. If a more complicated loading routine is desired, the onShow() callback should be leveraged.
(string|false) - default: false ajaxText
NOTE: ajaxText is applicable only if the ajax parameter is passed. Text to display while waiting for ajax returned content. May include HTML (such as an loading image). E.g. $.jqm({ajaxText: '<marquee style="width: 1.5em;">.. ... .</marquee>'});
(string) - default: '' target
NOTE: target is applicable only if the ajax parameter is passed. If passed, the ajax return will be loaded into the target element. The target element MUST EXIST as a child of the dialog. Target can be;
* (string) A jQuery Selector * (object) A DOM element (e.g. $.jqm({target: $('#dialog div.contents')[0]}) * (false) ajax return overwrites dialog's innerHTML
(string|false) - default: false modal Restricts input (mouse clicks, keypresses) to the dialog. NOTE: If false, and if overlay is enabled, CLICKING THE OVERLAY WILL CLOSE THE DIALOG.
(boolean) - default: false toTop When true; places the dialog element as a direct child of <body> when shown. This was added to help overcome z-Index stacking order issues. See the toTop demo to learn what to do if your overlay covers the entire page *including* the modal dialog!
(boolean) - default: false [Callbacks] Callbacks allow advanced customization of jqModal dialogs. Each callback is passed the "hash" object consisting of the following properties;
* w: (jQuery object) The dialog element * c: (object) The config object (dialog's parameters) * o: (jQuery object) The overlay * t: (DOM object) The triggering element
onShow (callback) Called when a dialog is to be shown. Be sure to show (set visible) the dialog.
// onShow : show+make the window translucent var myOpen=function(hash){ hash.w.css('opacity',0.88).show(); }; $('#dialog').jqm({onShow:myOpen});
(function|false) - default: false onHide (callback) Called when a dialog is to be hidden. Be sure to remove the overlay (if enabled).
// onHide : fade the window out, remove overlay after fade. var myClose=function(hash) { hash.w.fadeOut('2000',function(){ hash.o.remove(); }); }; $('#dialog').jqm({onHide:myClose});
(function|false) - default: false onLoad (callback) Called right after ajax content is loaded.
// onLoad : assign Mike Alsup's most excellent ajaxForm plugin to the returned form element(s). var myLoad = function(hash){ $('form',hash.w).ajaxForm(); }; $('#dialog').jqm({onLoad:myLoad});
(function|false) - default: false
See the README for further information.
Examples 1. Defaults -- view Out-of-box behavior. The window and its content is taken "inline" from the element with an ID of 'dialog'. The dialog is "triggered" (shown) when element(s) with class jqModal are clicked. No parameters are passed, no fancy window decorations used. Close READ ME --> This is a "vanilla plain" jqModal window. Behavior and appeareance extend far beyond this. The demonstrations on this page will show off a few possibilites. I recommend walking through each one to get an understanding of jqModal before using it.
You can view the sourcecode of examples by clicking the Javascript, CSS, and HTML tabs. Be sure to checkout the documentation too!
NOTE; You can close windows by clicking the tinted background known as the "overlay". Clicking the overlay will have no effect if the "modal" parameter is passed, or if the overlay is disabled. Javascript
$().ready(function() { $('#dialog').jqm(); });
CSS
/* jqModal base Styling courtesy of; Brice Burgess <bhb@iceburg.net> */
/* The Window's CSS z-index value is respected (takes priority). If none is supplied, the Window's z-index value will be set to 3000 by default (in jqModal.js). You can change this value by either; a) supplying one via CSS b) passing the "zIndex" parameter. E.g. (window).jqm({zIndex: 500}); */
/* Fixed posistioning emulation for IE6 Star selector used to hide definition from browsers other than IE6 For valid CSS, use a conditional include instead */ * html .jqmWindow { position: absolute; top: expression((document.documentElement.scrollTop || document.body.scrollTop) + Math.round(17 * (document.documentElement.offsetHeight || document.body.clientHeight) / 100) + 'px'); }
<a href="#" class="jqmClose">Close</a> <hr> <em>READ ME</em> --> This is a "vanilla plain" jqModal window. Behavior and appeareance extend far beyond this. The demonstrations on this page will show off a few possibilites. I recommend walking through each one to get an understanding of jqModal <em>before</em> using it.
<br /><br /> You can view the sourcecode of examples by clicking the Javascript, CSS, and HTML tabs. Be sure to checkout the <a href="README">documentation</a> too!
<br /><br /> <em>NOTE</em>; You can close windows by clicking the tinted background known as the "overlay". Clicking the overlay will have no effect if the "modal" parameter is passed, or if the overlay is disabled. </div>
2. AJAX -- view This example demonstrates the ajax parameter. The window's content is pulled from a remote source (Relative URL: examples/2.html) when its trigger is clicked. The trigger parameter is used assign a "show trigger" to element(s) with class ex2trigger. Please wait... loading Javascript
/* jqModal base Styling courtesy of; Brice Burgess <bhb@iceburg.net> */
/* The Window's CSS z-index value is respected (takes priority). If none is supplied, the Window's z-index value will be set to 3000 by default (in jqModal.js). You can change this value by either; a) supplying one via CSS b) passing the "zIndex" parameter. E.g. (window).jqm({zIndex: 500}); */
/* Fixed posistioning emulation for IE6 Star selector used to hide definition from browsers other than IE6 For valid CSS, use a conditional include instead */ * html .jqmWindow { position: absolute; top: expression((document.documentElement.scrollTop || document.body.scrollTop) + Math.round(17 * (document.documentElement.offsetHeight || document.body.clientHeight) / 100) + 'px'); }
3. Styling -- a. view (dialog), b. view (alert), c. view (notice) This example demonstrates the ease in which stylish windows are constructed. All HTML and CSS is abstracted from the plugin which allows a designer unprecedented flexibility. Notice how custom overlays, ajax targets, and callbacks are used. I hope to eventually provide a repository of dialog themes. Interested in contributing? -- see note @ bottom of page.
Dialog Title Styled windows or dialogs are easy!
This particular theme was done for poMMo -- feel free to borrow the styling, or use it as a reference when creating your own. CSS and Markup is available under the HTML + CSS tabs of example 3a. Javascript
$().ready(function() { $('#ex3a').jqm({ trigger: '#ex3aTrigger', overlay: 30, /* 0-100 (int) : 0 is off/transparent, 100 is opaque */ overlayClass: 'whiteOverlay'}) .jqDrag('.jqDrag'); /* make dialog draggable, assign handle to title */
/* Fixed posistioning emulation for IE6 Star selector used to hide definition from browsers other than IE6 For valid CSS, use a conditional include instead */ * html div.jqmDialog { position: absolute; top: expression((document.documentElement.scrollTop || document.body.scrollTop) + Math.round(17 * (document.documentElement.offsetHeight || document.body.clientHeight) / 100) + 'px'); }
<div class="jqmdMSG"> Styled windows or dialogs are easy!
<br /><br /> This particular theme was done for <a href="http://www.pommo.org">poMMo</a> -- feel free to borrow the styling, or use it as a reference when creating your own. CSS and Markup is available under the HTML + CSS tabs of example 3a. </div>
// select + reference "triggering element" -- will pass to $.jqm() var triggers = $('a.ex3bTrigger')[0];
// NOTE; we could have used document.getElementById(), or selected // multiple elemets with $(..selector..) and passed the trigger // as a jQuery object. or, just include the string '#ex3btrigger' // as the trigger parameter (as typically demonstrated).
// NOTE; we supply a target for the ajax return. This allows us // to keep the structure of the alert window. An element can // also be passed (see the documentation) as target.
/* Fixed posistioning emulation for IE6 Star selector used to hide definition from browsers other than IE6 For valid CSS, use a conditional include instead */ * html div.jqmAlert { position: absolute; top: expression((document.documentElement.scrollTop || document.body.scrollTop) + Math.round(17 * (document.documentElement.offsetHeight || document.body.clientHeight) / 100) + 'px'); }
Pine, spruce, or other evergreen wood should never be used in barbecues. These woods, when burning or smoking, can add harmful tar and resins to the food. Only hardwoods should be used for smoking and grilling, such as oak, pecan, hickory, maple, cherry, alder, apple, or mesquite, depending on the type of meat being cooked. close resize Javascript
// this example shows the use of onShow and onHide callbacks. Make // sure to read the documentation for futher instructions, and // an explanation of the "hash" argument.
<div class="jqmnContent"> <p>Pine, spruce, or other evergreen wood should never be used in barbecues. These woods, when burning or smoking, can add harmful tar and resins to the food. Only hardwoods should be used for smoking and grilling, such as oak, pecan, hickory, maple, cherry, alder, apple, or mesquite, depending on the type of meat being cooked.</p> </div>
3c (alert) - onShow, onHide callbacks. 4. Modal, Nested Modal -- a. view (4a.html), b. view (4b.html) Focus can be forced on a dialog, making it a true "modal" dialog. Also exemplified is the ajax attribute selector (using @href). Any DOM attribute can be used to extract the ajax url (see the documentation). Modal Dialog
Please wait... loading Modal Dialog
You bet!
Notice that you can only interact with this modal. If you click outside of it, focus will return to the form input element.
When this window is closed, the focus lock will resume on the calling modal window. This will repeat until there are no more modals open.
Use the "z-index" to control overlay and window overlap. See the documentation. Javascript
$().ready(function() {
// notice that you can pass an element as the target // in addition to a string selector. var t = $('#ex4 div.jqmdMSG');
$('#ex4').jqm({ trigger: 'a.ex4Trigger', ajax: '@href', /* Extract ajax URL from the 'href' attribute of triggering element */ target: t, modal: true, /* FORCE FOCUS */ onHide: function(h) { t.html('Please Wait...'); // Clear Content HTML on Hide. h.o.remove(); // remove overlay h.w.fadeOut(888); // hide window
// Close Button Highlighting Javascript provided in ex3a.
// Work around for IE's lack of :focus CSS selector if($.browser.msie) $('input') .focus(function(){$(this).addClass('iefocus');}) .blur(function(){$(this).removeClass('iefocus');});
});
CSS
/* jqmModal dialog CSS inherited from Example 3a ... */
div.jqmdAbove { z-index: 5000; top: 8%; } /* used by 4c -- nested modal */
5. Multi-Show/Hide -- a. view (show all), b. view (hide all), c. view (show+hide some) Triggers can cotrol more than 1 jqModal. You can assign new show or hide triggers to any jqModal element with $.jqmAddTrigger and $.jqmAddClose. Square A Square B Square D Square C Javascript
$().ready(function() { var show = $('#ex5show'); var hide = $('#ex5hide');
6. FUN! Overrides -- a. view (alert), b. view (confirm) It is now time to show a real-world use for jqModal -- overriding the standard alert() and confirm dialogs! Note; due to the single threaded nature of javascript, the confirm() function must be passed a callback -- it does NOT return true/false. Warning! Close Confirmation por favor... Close
Continue? Javascript
/* Overriding Javascript's Alert Dialog */
function alert(msg) { $('#alert') .jqmShow() .find('div.jqmAlertContent') .html(msg); }
// trigger an alert whenever links of class alert are pressed. $('a.alert').click(function() { alert('You Have triggered an alert!'); return false; }); });
/* Overriding Javascript's Confirm Dialog */
// NOTE; A callback must be passed. It is executed on "cotinue". // This differs from the standard confirm() function, which returns // only true or false!
// If the callback is a string, it will be considered a "URL", and // followed.
// If the callback is a function, it will be executed.
// trigger a confirm whenever links of class alert are pressed. $('a.confirm').click(function() { confirm('About to visit: '+this.href+' !',this.href); return false; }); });
/* Fixed posistioning emulation for IE6 Star selector used to hide definition from browsers other than IE6 For valid CSS, use a conditional include instead */ * html div.jqmConfirm { position: absolute; top: expression((document.documentElement.scrollTop || document.body.scrollTop) + Math.round(17 * (document.documentElement.offsetHeight || document.body.clientHeight) / 100) + 'px'); }
7. External Site (iframe) usage (with added bling-in-the-box) Alexandre Plennevaux has posted a tutorial on effectively using jqModal to load external sites into a popup dialog. His method updates an iframe inside a dialog with the HREF attribute of the triggering element. It is an excellent example of real-world jqModal usage. As an added bonus; the bling-factor is furthered by showing off some fancy animated transistions! Be sure to check out his demonstration. Etc.
Previous Releases All revisions of jqModal are available are available here.
Known Issues, Pending Fixes
* Update jqDnR, make squares draggable * Demonstrate an enhanced slideshow * Incorporate "smart" modal focus routine * Abstract IE6 workarounds from base CSS, use conditional includes
R14 Changes
Changes include smart detection of the triggering element. This allows you to call $.jqmShow() and $.jqmHide() within the event context of a non-initialized triggering element, and that element will mask a proper initialized trigger.
This (very minor) change is intended to improve the plugin's natural behavior -- that is; to behave as expected. It will make "live querying" modal triggers easier for some.
A simple example of the new behavior is shown below. It will show and load the remote content of all anchor links into the modal window whenever they are clicked.
// initialize modal, // load the container with a remote return based on the 'href' // attribute of triggering element(s)
$('#jqModal').jqm({ajax:'@href'});
// open the modal whenever anchor links on the page are clicked $('a').live('click',function(){ $('#jqModal').jqmShow(); });
}); </script>
R13 Changes
* Minor code optimizations * Fixed potential exception in modal focus routine * Overlays of modal dialogs are no longer automatically styled with a "wait" cursor. Use CSS to control * Exposed overiding of default parameter values via the $.jqm.params global
R12 Changes
* Now dual licensed under the MIT and GPL licenses * Compatibility with jQuery 1.2.6 * Removed zIndex parameter * Subsequent $.jqm calls now update configuration * AJAX target is now cleared before load * Added ajaxText parameter
R11 Changes
* added toTop argument to break z-Index container restraints (demo) * improved focus method tolerance * overlay now takes z-Index stacking order precedence
Earlier Release Changes
R10 Changes;
* focus element re-calculated every modal click to prevent IE error * ie6 sets body width to 100% * Require fixed pushStack,$.browser.version -- jQuery 1.1.3.1 MINIMUM! * compressible with a javascript packer * HTTPS/SSL served iFrame content will not throw warnings in IE
R8,R9 Changes
* Updated CSS, Sync up. * Fixed IE crash when ajax loaded elements used as trigger(s) * IE6 - overlay now covers dialog only, allowing page interaction when overlay: 0
R7 Changes
* Added $.jqmShow, $.jqmHide to manually hide/show dialogs * Added $.jqmAddTrigger and $.jqmAddClose to bind show/hide to elements * Added onLoad callback (called after ajax return) * Added support for handling multiple dialogs @ once across ALL functions * Removed auto-fire parameter, replaced via $(e).jqm().jqmShow() * Removed $.jqmClose() * Removed "wrapClass" parameter, updated base CSS * CSS z-index value takes priority over "zIndex" parameter * Triggers can hide, show, or hide AND show jqModals * Overlays+IE6 iframe are now fixed positioned - support for ie6 quirks + standards mode * Internal Improvements, no event data
]]>http://www.mdrt.org.cn/default.asp?id=35<![CDATA[屏蔽XP欢迎屏幕提示未读邮件]]>jbkadminhttp://www.mdrt.org.cn/anyshe@126.com2010-06-11T09:09:53+08:002010-06-11T09:09:53+08:00 在UnreadMail下面创建一个Message ExpiryDays子键并将它设置为0可以禁止XP的欢迎屏幕显示未读邮件。不过修改注册表不是很方便，用TweakUI修改既简单又安全。安装并启动 TweakUI，依次选择Logon→Unread mail，清除Show unread mail on Welcome screen选项。]]>http://www.mdrt.org.cn/default.asp?id=34<![CDATA[Compare two images with C#]]>jbkadminhttp://www.mdrt.org.cn/anyshe@126.com2010-05-27T15:34:16+08:002010-05-27T15:34:16+08:00 public enum CompareResult { ciCompareOk, ciPixelMismatch, ciSizeMismatch }; public static CompareResult Compare(Image bmp1, Image bmp2) { CompareResult cr = CompareResult.ciCompareOk;
//Test to see if we have the same size of image
if (bmp1.Size != bmp2.Size) { cr = CompareResult.ciSizeMismatch; } else { //Convert each image to a byte array
System.Drawing.ImageConverter ic = new System.Drawing.ImageConverter(); byte[] btImage1 = new byte[1]; btImage1 = (byte[])ic.ConvertTo(bmp1, btImage1.GetType()); byte[] btImage2 = new byte[1]; btImage2 = (byte[])ic.ConvertTo(bmp2, btImage2.GetType());