【正文】 e 單位價(jià)格,supplier_code 供應(yīng)商代碼,order_num 訂貨批量,order_time 訂貨提前期from pro_infoselect place_code 庫位號(hào),area_name 區(qū)域名,pro_code 物品編號(hào),shelf_num 貨架號(hào)碼,floor_num 層號(hào),line_num 列號(hào),height 貨格高度,length 貨格長度,width 貨格寬度from place_infoselect OPERATOR_ID 操作員ID,DNAME 姓名,LEVEL1 級別,SEX 性別,PHONE 聯(lián)系電話,ADDRESS 住址 from operator_infoselect LIST_CODE 入庫單編號(hào),OPERATOR_ID 操作員代號(hào),LIST_DATE 入庫時(shí)間,PRO_CODE 入庫物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫位代號(hào) from list_infoselect PRO_CODE 入庫物品編碼,STORE_PRO_NUM 庫存數(shù)量,STORE_UP_NUM 庫存上限,STORE_DOWN_NUM 庫存下限,UNIT 物品單位,PLACE_CODE 庫位代號(hào) from store_infoselect DUSER_NAME 用戶名,USER_PWD 用戶密碼,USER_LEVEL 用戶級別 from user_table這次已經(jīng)不是第一次做課程設(shè)計(jì)了，每次的感覺都不同，但有一點(diǎn)是相同的，那就是鍛煉了自己，提升了自己在課本與實(shí)踐中的結(jié)合，真正做到學(xué)以自用，從建立數(shù)據(jù)開始，對靈據(jù)庫設(shè)計(jì)理念及思想上有更高的認(rèn)識(shí)，從需求分析，到概念設(shè)計(jì)和邏輯設(shè)計(jì)，ER圖的表示，數(shù)據(jù)字典的創(chuàng)建，懂得了不少有關(guān)數(shù)據(jù)庫開發(fā)過程中的知識(shí)，在實(shí)驗(yàn)中建表，及其關(guān)系模式，關(guān)系代數(shù)的建立及理解，將SQL語的查詢語句用得淋漓盡致，增強(qiáng)了自己在數(shù)據(jù)庫中應(yīng)用SQL語言的靈活性，其中包括，插入、刪除、修改、查詢,牽涉表和表之間的聯(lián)系，主建與外主鍵的定義，約束項(xiàng)的設(shè)置，使邏輯更嚴(yán)密。 and pro_code=pro_codeed and place_code=place_codeed and list_date between list_dateed1 and list_dateed2查詢出庫基本信息表create proc FindAllList_0_Pro_code_Time_Place PRO_CODEED varchar(5),LIST_DATEED1 datetime,LIST_DATEED2 datetime,PLACE_CODEED VARCHAR(5)asselect LIST_CODE 出庫單編號(hào),OPERATOR_ID 操作員代號(hào),LIST_DATE 出庫時(shí)間,PRO_CODE 出庫物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫位代號(hào)from list_infowhere list_code like 39。 and pro_code=pro_codeed and place_code=place_codeed and list_date between list_dateed1 and list_dateed2 查詢?nèi)霂旎拘畔⒈韈reate proc FindAllList_1_Pro_code_Time_Place PRO_CODEED varchar(5),LIST_DATEED1 datetime,LIST_DATEED2 datetime,PLACE_CODEED VARCHAR(5)asselect LIST_CODE 入庫單編號(hào),OPERATOR_ID 操作員代號(hào),LIST_DATE 入庫時(shí)間,PRO_CODE 入庫物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫位代號(hào)from list_infowhere list_code like 39。,39。,0,1000,10,39。)insert into store_info(PRO_CODE,STORE_PRO_NUM,STORE_UP_NUM,STORE_DOWN_NUM,UNIT,PLACE_CODE) values(39。,39。,0,1000,10,39。)insert into user_table(DUSER_NAME,USER_PWD,USER_LEVEL) values(39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。)insert into place_info(place_code,area_name,pro_code) values(39。,39。,39。)輸入庫位信息insert into place_info(place_code,area_name,pro_code) values(39。)insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。)insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。)insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。)insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。)輸入物品信息insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。,39。,39。)insert into supplier_info(supplier_code,supplier_name,link_man,link_phone,supplier_address,remark) values(39。,39。,39。)insert into supplier_info(supplier_code,supplier_name,link_man,link_phone,supplier_address,remark) values(39。,39。 and list_date between list_dateed1 and list_dateed2create proc FindAllList_0_Pro_code PRO_CODEED varchar(5)asselect LIST_CODE 入庫單編號(hào),OPERATOR_ID 操作員代號(hào),LIST_DATE 入庫時(shí)間,PRO_CODE 入庫物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫位代號(hào)from list_infowhere list_code like 39。庫存信息管理SQL語句create procedure FindAllStore asselect PRO_CODE 入庫物品編碼,STORE_PRO_NUM 庫存數(shù)量,STORE_UP_NUM 庫存上限,STORE_DOWN_NUM 庫存下限,UNIT 物品單位,PLACE_CODE 庫位代號(hào)from store_infocreate proc InsertStore PRO_CODEED VARCHAR(5),STORE_PRO_NUMED INT,STORE_UP_NUMED INT,STORE_DOWN_NUMED INT,UNITED VARCHAR(4),PLACE_CODEED VARCHAR(5)asinsert into store_info(PRO_CODE,STORE_PRO_NUM,STORE_UP_NUM,STORE_DOWN_NUM,UNIT,PLACE_CODE) values(PRO_CODEED,STORE_PRO_NUMED,STORE_UP_NUMED,STORE_DOWN_NUMED,UNITED,PLACE_CODEED)create proc ModifyStore PRO_CODEED VARCHAR(5),STORE_PRO_NUMED INT,STORE_UP_NUMED INT,STORE_DOWN_NUMED INT,UNITED VARCHAR(4),PLACE_CODEED VARCHAR(5)asupdate store_info set PRO_CODE=PRO_CODEED,STORE_PRO_NUM=STORE_PRO_NUMED,STORE_UP_NUM=STORE_UP_NUMED,STORE_DOWN_NUM=STORE_DOWN_NUMED,UNIT=UNITED,PLACE_CODE=PLACE_CODEEDwhere pro_code=pro_codeed and place_code=place_codeedcreate proc InsertStore_List PRO_CODEED VARCHAR(5),STORE_PRO_NUMED INT,UNITED VARCHAR(4),PLACE_CODEED VARCHAR(5)asinsert into store_info(PRO_CODE,STORE_PRO_NUM,UNIT,PLACE_CODE) values(PRO_CODEED,STORE_PRO_NUMED,UNITED,PLACE_CODEED)create proc ModifyStore_List PRO_CODEED VARCHAR(5),STORE_PRO_NUMED INT,UNITED VARCHAR(4),PLACE_CODEED VARCHAR(5)asupdate store_info set PRO_CODE=PRO_CODEED,STORE_PRO_NUM=STORE_PRO_NUMED,UNIT=UNITED,PLACE_CODE=PLACE_CODEEDwhere pro_code=pro_codeed and place_code=place_codeedcreate proc DeleteStore PRO_CODEED VARCHAR(5),PLACE_CODEED VARCHAR(5)asdelete from store_info where pro_code=pro_codeed and place_code=place_codeed庫盤點(diǎn)作業(yè)管理SQL語句create proc ModifyStore_ProNum PRO_CODEED VARCHAR(5),PLACE_CODEED VARCHAR(5),STORE_PRO_NUMED INTasupdate store_info set STORE_PRO_NUM=STORE_PRO_NUMEDwhere pro_code=pro_codeed and place_code=place_codeedcreate proc FindStore_Pro PRO_CODEED VARCHAR(5)asselect * from store_info where pro_code=pro_codeedcreate proc FindAllStore_Operateas select PRO_CODE 入庫物品編碼,STORE_PRO_NUM 庫存數(shù)量,STORE_UP_NUM 庫存上限,STORE_DOWN_NUM 庫存下限,UNIT 物品單位,PLACE_CODE 庫位代號(hào) from store_info入庫信息查詢create proc FindAllList_1_time LIST_DATEED1 datetime,LIST_DATEED2 datetimeasselect LIST_CODE 入庫單編號(hào),OPERATOR_ID 操作員代號(hào),LIST_DATE 入庫時(shí)間,PRO_CODE 入庫物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫位代號(hào)from list_infowhere list_c