【正文】 er_name 供應(yīng)商名稱,link_man 聯(lián)系人,link_phone 聯(lián)系電話,supplier_address 供應(yīng)商地址,remark 備注from supplier_infocreate proc InsertSupplier SUPPLIER_CODEED varchar(5),SUPPLIER_NAMEED varchar(25),LINK_MANED varchar(8),LINK_PHONEED varchar(15),SUPPLIER_ADDRESSED varchar(50),REMARKED varchar(255)asinsert into supplier_info(supplier_code,supplier_name,link_man,link_phone,supplier_address,remark) values(supplier_codeed,supplier_nameed,link_maned,link_phoneed,supplier_addressed,remarked)create proc ModifySupplier SUPPLIER_CODEED varchar(5),SUPPLIER_NAMEED varchar(25),LINK_MANED varchar(8),LINK_PHONEED varchar(15),SUPPLIER_ADDRESSED varchar(50),REMARKED varchar(255)asupdate supplier_info set supplier_code=supplier_codeed,supplier_name=supplier_nameed,link_man=link_maned,link_phone=link_phoneed,supplier_address=supplier_addressed,remark=remarkedwhere supplier_code=supplier_codeedcreate proc DeleteSupplier Supplier_codeed varchar(5)asdelete from supplier_info where supplier_code=supplier_codeed物品管理SQL語句create procedure FindAllProasselect pro_code 物品編碼,pro_name 物品名稱,unit 計量單位,pro_type 物品類型,pro_size 物品規(guī)格,pro_price 單位價格,supplier_code 供應(yīng)商代碼,order_num 訂貨批量,order_time 訂貨提前期from pro_infocreate proc InsertPro pro_codeed varchar(5),pro_nameed varchar(15),pro_typeed varchar(5),supplier_codeed varchar(5),united varchar(4),pro_sizeed varchar(15),order_numed int,pro_priceed int,order_timeed intasinsert into pro_info(pro_code,pro_name,pro_type,supplier_code,unit,pro_size,order_num,pro_price,order_time) values(pro_codeed,pro_nameed,pro_typeed,supplier_codeed,united,pro_sizeed,order_numed,pro_priceed,order_timeed)create proc ModifyPro pro_codeed varchar(5),pro_nameed varchar(15),pro_typeed varchar(5),supplier_codeed varchar(5),united varchar(4),pro_sizeed varchar(15),order_numed int,pro_priceed int,order_timeed intasupdate pro_info set pro_code=pro_codeed,pro_name=pro_nameed,pro_type=pro_typeed,supplier_code=supplier_codeed,unit=united,pro_size=pro_sizeed,order_num=order_numed,pro_price=pro_priceed,order_time=order_timeedwhere pro_code=pro_codeedcreate proc DeletePro pro_codeed varchar(5)asdelete from pro_info where pro_code=pro_codeed庫位管理SQL語句create proc InsertPlace PLACE_CODEED VARCHAR(5),AREA_NAMEED VARCHAR(10),PRO_CODEED VARCHAR(5),SHELF_NUMED INT,FLOOR_NUMED INT,LINE_NUMED INT,HEIGHTED INT,LENGTHED INT,WIDTHED INTasinsert into place_info(place_code,area_name,pro_code,shelf_num,floor_num,line_num,height,length,width) values(PLACE_CODEED,AREA_NAMEED,PRO_CODEED,SHELF_NUMED,FLOOR_NUMED,LINE_NUMED,HEIGHTED,LENGTHED,WIDTHED)create proc ModifyPlace PLACE_CODEED VARCHAR(5),AREA_NAMEED VARCHAR(10),PRO_CODEED VARCHAR(5),SHELF_NUMED INT,FLOOR_NUMED INT,LINE_NUMED INT,HEIGHTED INT,LENGTHED INT,WIDTHED INTasupdate place_info set place_code=place_codeed,area_name=area_nameed,pro_code=pro_codeed,shelf_num=shelf_numed,floor_num=floor_numed,line_num=line_numed,height=heighted,length=lengthed,width=widthedwhere place_code=place_codeedcreate proc DeletePlace place_codeed varchar(5)asdelete from place_info where place_code=place_codeedcreate procedure FindAllPlaceasselect place_code 庫位號,area_name 區(qū)域名,pro_code 物品編號,shelf_num 貨架號碼,floor_num 層號,line_num 列號,height 貨格高度,length 貨格長度,width 貨格寬度from place_info操作員信息管理SQL語句create proc InsertOperator OPERATOR_IDED VARCHAR(5),NAMEED VARCHAR(8),SEXED VARCHAR(2),LEVEL1ED VARCHAR(10),PHONEED VARCHAR(15),ADDRESSED VARCHAR(30)asinsert into operator_info(OPERATOR_ID,DNAME,SEX,LEVEL1,PHONE,ADDRESS) values(OPERATOR_IDED,NAMEED,SEXED,LEVEL1ED,PHONEED,ADDRESSED)create proc ModifyOperator OPERATOR_IDED VARCHAR(5),NAMEED VARCHAR(8),SEXED VARCHAR(2),LEVEL1ED VARCHAR(10),PHONEED VARCHAR(15),ADDRESSED VARCHAR(30)asupdate operator_info set OPERATOR_ID=OPERATOR_IDED,DNAME=NAMEED,SEX=SEXED,LEVEL1=LEVEL1ED,PHONE=PHONEED,ADDRESS=ADDRESSEDwhere operator_id=OPERATOR_IDEDcreate proc DeleteOperator operator_ided varchar(5)asdelete from operator_info where operator_id=operator_idedcreate procedure FindAllOperatorasselect OPERATOR_ID 操作員ID,DNAME 姓名,LEVEL1 級別,SEX 性別,PHONE 聯(lián)系電話,ADDRESS 住址from operator_info入庫信息管理SQL語句create procedure FindAllList asselect LIST_CODE 入庫單編號,OPERATOR_ID 操作員代號,LIST_DATE 入庫時間,PRO_CODE 入庫物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫位代號from list_infocreate procedure FindAllList_1 asselect LIST_CODE 入庫單編號,OPERATOR_ID 操作員代號,LIST_DATE 入庫時間,PRO_CODE 入庫物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫位代號from list_infowhere list_code like 39。C:\Program Files\Microsoft SQL Server\MSSQL\DATA\39。Material_DB_Log39。C:\Program Files\Microsoft SQL Server\MSSQL\DATA\39。Material_DB239。C:\Program Files\Microsoft SQL Server\MSSQL\DATA\39。Material_DB139。查詢庫存異常情況存儲過程查詢庫存異常情況存儲過程是以設(shè)置庫存上下限數(shù)據(jù)，對實時庫存情況進(jìn)行計算，返回低于庫存下限或高于上限的貨品數(shù)據(jù)設(shè)計思路： 根據(jù)庫存上下限的數(shù)據(jù)，限定計算實時庫存的貨品范圍； 判斷是否已存在盤點數(shù)據(jù)，如否則根據(jù)已有的入倉數(shù)據(jù)和出倉數(shù)據(jù)，計算現(xiàn)庫存數(shù)量，返回低于庫存下限或高于上限的貨品數(shù)據(jù)集，程序結(jié)束； 如已存在盤點數(shù)據(jù)，則根據(jù)當(dāng)前時間點找到最近一期的盤點數(shù)據(jù)，再根據(jù)從該期盤點時間到當(dāng)前時間點所有的入倉數(shù)據(jù)和出倉數(shù)據(jù)，計算現(xiàn)庫存數(shù)量，返回低于庫存下限或高于上限的貨品數(shù)據(jù)集，程序結(jié)束。實時庫存情況存儲過程實時庫存情況存儲過程與庫存盤點存儲過程設(shè)計思路類似，但計算結(jié)果不需寫到數(shù)據(jù)表，直接以數(shù)據(jù)集形式返回。 庫存分析報警：1． 庫存上下限設(shè)置：可以設(shè)定倉庫庫存中各項貨品的庫存上下限。2． 單據(jù)查詢：可以隨時查詢?nèi)霂?、出庫、盤點等各種貨物單據(jù)。3． 貨品盤點管理：可以自動生成盤點單號，貨品選擇方便快捷。倉庫貨物進(jìn)出管理：1． 貨品入倉管理：可以自動生成入庫單號，貨品及客戶選擇方便快捷，不限制每筆入庫單貨物筆數(shù)。2． 貨品檔案管理：檔案信息包括貨品名稱、編號、貨品描述、計量單位、備注說明。 關(guān)鍵字：SQL，Delphi，倉庫管理，系統(tǒng)系統(tǒng)功能的基本要求：1）產(chǎn)品入庫管理，可以填寫入庫單，確認(rèn)產(chǎn)品入庫；2）產(chǎn)品出庫管理，可以填寫出庫單，確認(rèn)出庫；3）借出管理，憑借條