[求助仓库管理设计

yuzeshui

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">设计要求</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt; TEXT-INDENT: -36pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt;"><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">1<span style="FONT: 7pt 'Times New Roman';">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">元器件库存管理表</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp; </font></span></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">管理员姓名</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp; </font></span></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 45pt;"><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">横排为元件名称</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp; </font></span></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">竖列</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">A </font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">存量</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">B</font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">进量</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">C</font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">取货</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">D</font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">取货人姓名</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">E</font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">F</font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">备注</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 45pt;"><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">元件名称初次输入以后以进货为主输入为辅助的。</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 45pt;"><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">进量与取货要调用进量取货表，存量要求每天打开软件自动对昨天的进行计算</span><span style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">
                        </font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">生成昨天的统计表格，和今天的新表。要求一日一张表格，作出</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">3</font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">个备份，一月一生成一表格文件，但保持原表，一年汇总一次，完成整个报表，生成新的有汇总数据的库存表格。</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 45pt;"><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">B</font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">，</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><font face="Times New Roman">C</font></span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">只计算进量取货表的总数，下拉进取的具体内容。</span><span lang="EN-US" style="FONT-SIZE: 18pt; mso-bidi-font-size: 12.0pt;"><p></p></span></p><p><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">对库存量设置告警，依据单个产品用元件种类数量表的</span><span lang="EN-US" style="FONT-SIZE: 18pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">N</span><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">被设置。 </span></p><p><span style="FONT-SIZE: 18pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">后面再补发</span></p>[em08]

yuzeshui

<p>有斑竹吗</p><p></p>

wuzhijian

你至少要把表格框架设计起来!需要什么方面要求不懂就一样一样问嘛!动动嘴就希望别人把你搞好.那不现实!

jorry

我也觉得。要不找专业人员开发系统嘛。

wuzhijian

我在论坛这段时间学习心得~高手可以帮你解决问题!但不会帮你做全套表!因为人家没有义务帮你上班赚钱不是吗?

yuzeshui

<p>好的</p><p>我想知道在一个表格进行操作后在另一个表格里进行记录，同时该表格打印后刷新为空。都要涉及到什么操作</p><p></p><p></p>

wuzhijian

用VBA,做好附件后。去程序开发版问！

yuzeshui

<p>日期每天自动添一个单元格 用什么啊</p>