📄 database.html

📁 its it tracker and used for track
💻 HTML
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>ITracker Help</title>
</head>
<body>
    <p style="text-align:center;width:500px;"><span style="font-size:20pt;font-weight:bold;">ITracker Database Help</span><br />
        <a href="default.html">Help Home</a> | <a href="site.html">Site/Page Help</a> | <a href="business.html">Business Help</a> | <a href="database.html">Database Help</a>
    </p>
    <p style="text-align:center;width:500px;">
    The Data Access Layer of the application is designed around a Microsoft SQLExpress engine but, thanks to the (n)tier 
    approach and the seperation of application into seperate projects, you could easily alter or even drop the
    existing layer and replace it with one of your own.
    </p>
    <p style="width:500px;">
    Like the Business Layer the Data Access Layer is represented by 2 files, both extremely similar so I'm only going to 
    go into details on one of them, the VendorDataService.vb file and it's self named class.<br />
    As you can see by this diagram the class consists of 6 functions with 4 being public and 2 being private.<br />
    <img onclick="window.open('../images/ITrackerDataAccessDiagram.jpg');" src="../images/ITrackerDataAccessDiagram.jpg" alt="Click for full sized diagram" style="cursor:hand;" />
    <br />
    The 4 public functions match up to the same functions in the Business Layer. The Fetch, FetchList, Save and Search 
    functions in the Business Layer are simple calls to these functions, which in turn are nothing more then SQL wrappers
    to the underlying database. The exception is the Save function. It has no direct access to the database, instead it 
    simply checks for the ID property/value and redirects the call to either the Insert or Update functions as needed. This
    allows you to, if you felt so inclined, to add extra code/checks/whatever you wanted, and only on a particular function.<br />
    <b>The DataBase</b> is, as mentioned, a Microsoft SQLExpress database but you could easily change this with nearly any database
    out there or even switch it out to use XML if you wanted. As long as you leave the method names the same, and the return types, 
    the other layers of the application would never even need to know. For the sake of documentation I've included the diagram
    of the two database table.<br />
    <img onclick="window.open('../images/ITrackerDatabaseDiagram.jpg');" src="../images/ITrackerDatabaseDiagram.jpg" alt="Click for full sized diagram" style="cursor:hand;" />
    <br />
    </p>
    <p style="text-align:center;width:500px;">
        ~
        <br />
        Curt Christianson<br />
        <a href="mailto:darkfalz@darkfalz.com">darkfalz@darkfalz.com</a><br />
        www.Darkfalz.com<br />
        www.DF-Software.com<br />
        
    </p>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -