📄 stock.htm
字号:
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<style>
<!--
table.MsoTableGrid
{border:1.0pt solid windowtext;
font-size:10.0pt;
font-family:"Times New Roman"}
p.MsoNormal
{mso-style-parent:"";
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
margin-left:0in; margin-right:0in; margin-top:0in}
-->
</style>
</head>
<body>
<p class="MsoNormal" style="text-align: center">
<img border="0" src="dragon.jpg" width="100" height="56"></p>
<p class="MsoNormal" style="text-align: center"><b><i><u><font face="Book Antiqua" color="#800080" size="2">
Dragon Supermarket Shopping System</font></u></i></b></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .25in">
<font face="Comic Sans MS" style="font-size: 9pt"><b><u>Stock
Management</u></b></font></p>
<p class="MsoNormal" style="text-align: justify">
<font face="Comic Sans MS" style="font-size: 9pt"><b>
<u><span style="text-decoration: none; "> </span></u></b></font></p>
<p class="MsoNormal" style="text-align: justify; margin-left: .25in">
<font face="Comic Sans MS" style="font-size: 9pt">This module will be
accessed by the user with <b>Stock_Manager </b>priority / role. The user can
manage product category information, update stock and generate reports.
The tables involved include <i>ProductCategories, Products, Stock </i>and <i>
Orders<b>. </b></i>The <b>Stock Management </b>menu provides the following
options: </font></p>
<p class="MsoNormal" style="text-align: justify; margin-left: .25in">
</p>
<p class="MsoNormal" style="text-align: justify; margin-left: .25in">
<font face="Comic Sans MS" style="font-size: 9pt"><b>Stock
Management</b></font></p>
<p class="MsoNormal" style="text-align: justify; margin-left: .5in">
<font face="Comic Sans MS" style="font-size: 9pt">Update stock
whenever goods are purchased<i>; </i>Quantity on Hand is
updated in products table.</font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .75in">
</p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .75in">
<font face="Comic Sans MS" style="font-size: 9pt">Every stock has a unique stock id; For
example, consider a consignment of mobile phones is received from a supplier; </font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .75in">
<font face="Comic Sans MS" style="font-size: 9pt">Assume that the stock consists of 10 numbers
of Nokia 6610 and 5 numbers of Nokia 3100. Then both the products </font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .75in">
<font face="Comic Sans MS" style="font-size: 9pt">will be added to stock separately, hence two
records will be added to stock table with separate stock id for each.</font></p>
<p class="MsoNormal" style="text-align: justify; margin-left: .25in">
<font face="Comic Sans MS" style="font-size: 9pt"><b> </b></font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .5in">
<span style="font-style: normal; font-variant: normal; font-weight: normal; font-family: Comic Sans MS">
<font style="font-size: 9pt"> </font> </span>
<font face="Comic Sans MS" style="font-size: 9pt"><b>Search </b></font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .75in">
<font face="Comic Sans MS" style="font-size: 9pt">o</font><span style="font-style: normal; font-variant: normal; font-weight: normal; font-family: Comic Sans MS"><font style="font-size: 9pt">
</font>
</span><font face="Comic Sans MS" style="font-size: 9pt">For products
based on category, product name and so on</font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .75in">
<font face="Comic Sans MS" style="font-size: 9pt">o</font><span style="font-style: normal; font-variant: normal; font-weight: normal; font-family: Comic Sans MS"><font style="font-size: 9pt">
</font>
</span><font face="Comic Sans MS" style="font-size: 9pt">For Stock of
products on Stock Id, period and so on</font></p>
<p class="MsoNormal" style="text-align: justify; margin-left: .5in">
<font face="Comic Sans MS" style="font-size: 9pt"> </font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .5in">
<span style="font-style: normal; font-variant: normal; font-weight: normal; font-family: Comic Sans MS">
<font style="font-size: 9pt"> </font></span><font face="Comic Sans MS" style="font-size: 9pt"><b>Reports</b></font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .75in">
<font face="Comic Sans MS" style="font-size: 9pt">o</font><span style="font-style: normal; font-variant: normal; font-weight: normal; font-family: Comic Sans MS"><font style="font-size: 9pt">
</font>
</span><font face="Comic Sans MS" style="font-size: 9pt">Generating
Stock reports based on supplier, product category, product name, stock and
period </font></p>
<p class="MsoNormal" style="text-align: justify; text-indent: -.25in; margin-left: .75in">
<font face="Comic Sans MS" style="font-size: 9pt">o</font><span style="font-style: normal; font-variant: normal; font-weight: normal; font-family: Comic Sans MS"><font style="font-size: 9pt">
</font>
</span><font face="Comic Sans MS" style="font-size: 9pt">Generating
Product reports based on supplier, product category and product name
</font></p>
<p class="MsoNormal" style="text-align: justify">
<font face="Comic Sans MS" style="font-size: 9pt">
</font></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -