【文章內(nèi)容簡(jiǎn)介】 fo where pro_code=@pro_codeed and place_code=@place_codeed 借出信息管理 SQL 語(yǔ)句 create procedure FindAllList_o as select LIST_CODE 借出單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 借出時(shí)間 ,PRO_CODE 借出物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code like 39。o%39。 歸還信息管理 SQL 語(yǔ)句 create procedure FindAllList_i as select LIST_CODE 歸還單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 歸還時(shí)間 ,PRO_CODE 歸還物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code like 39。i%39。 庫(kù)存信息管理 SQL 語(yǔ)句 create procedure FindAllStore as select PRO_CODE 入 庫(kù) 物 品 編 碼 ,STORE_PRO_NUM 庫(kù)存數(shù)量 ,STORE_UP_NUM 庫(kù)存上限 ,STORE_DOWN_NUM 庫(kù)存下限 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from store_info create 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) as insert 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) as update 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_CODEED where pro_code=@pro_codeed and place_code=@place_codeed create proc InsertStore_List @PRO_CODEED VARCHAR(5),@STORE_PRO_NUMED INT,@UNITED VARCHAR(4),@PLACE_CODEED VARCHAR(5) as insert 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) as update store_info set PRO_CODE=@PRO_CODEED,STORE_PRO_NUM=@STORE_PRO_NUMED,UNIT=@UNITED,PLACE_CODE=@PLACE_CODEED where pro_code=@pro_codeed and place_code=@place_codeed create proc DeleteStore @PRO_CODEED VARCHAR(5),@PLACE_CODEED VARCHAR(5) as delete from store_info where pro_code=@pro_codeed and place_code=@place_codeed 庫(kù)盤(pán)點(diǎn)作業(yè)管理 SQL 語(yǔ)句 create proc ModifyStore_ProNum @PRO_CODEED VARCHAR(5),@PLACE_CODEED VARCHAR(5),@STORE_PRO_NUMED INT as update store_info set STORE_PRO_NUM=@STORE_PRO_NUMED where pro_code=@pro_codeed and place_code=@place_codeed create proc FindStore_Pro @PRO_CODEED VARCHAR(5) as select * from store_info where pro_code=@pro_codeed create proc FindAllStore_Operate as select PRO_CODE 入 庫(kù) 物 品 編 碼 ,STORE_PRO_NUM 庫(kù)存數(shù)量 ,STORE_UP_NUM 庫(kù)存上限 ,STORE_DOWN_NUM 庫(kù)存下限 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from store_info 入庫(kù)信息查詢(xún) create proc FindAllList_1_time @LIST_DATEED1 datetime,@LIST_DATEED2 datetime as select LIST_CODE 入庫(kù)單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 入庫(kù)時(shí)間 ,PRO_CODE 入庫(kù)物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code like 39。1%39。 and list_date between @list_dateed1 and @list_dateed2 create proc FindAllList_1_Pro_code @PRO_CODEED varchar(5) as select LIST_CODE 入庫(kù)單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 入庫(kù)時(shí)間 ,PRO_CODE 入庫(kù)物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code like 39。1%39。 and pro_code=@pro_codeed create proc FindAllList_1_Ope_id @OPERATOR_IDED VARCHAR(5) as select LIST_CODE 入庫(kù)單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 入庫(kù)時(shí)間 ,PRO_CODE 入庫(kù)物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code like 39。1%39。 and operator_id=@operator_ided create proc FindList_1_ListCode @LIST_CODEED VARCHAR(5) as select LIST_CODE 入庫(kù)單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 入庫(kù)時(shí)間 ,PRO_CODE 入庫(kù)物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code=@list_codeed 出庫(kù)信息查詢(xún) create proc FindAllList_0_time @LIST_DATEED1 datetime,@LIST_DATEED2 datetime as select LIST_CODE 入庫(kù)單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 入庫(kù)時(shí)間 ,PRO_CODE 入庫(kù)物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code like 39。0%39。 and list_date between @list_dateed1 and @list_dateed2 create proc FindAllList_0_Pro_code @PRO_CODEED varchar(5) as select LIST_CODE 入庫(kù)單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 入庫(kù)時(shí)間 ,PRO_CODE 入庫(kù)物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code like 39。0%39。 and pro_code=@pro_codeed create proc FindAllList_0_Ope_id @OPERATOR_IDED VARCHAR(5) as select LIST_CODE 入庫(kù)單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 入庫(kù)時(shí)間 ,PRO_CODE 入庫(kù)物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code like 39。0%39。 and operator_id=@operator_ided create proc FindList_0_ListCode @LIST_CODEED VARCHAR(5) as select LIST_CODE 出庫(kù)單編號(hào) ,OPERATOR_ID 操作員代號(hào) ,LIST_DATE 出庫(kù)時(shí)間 ,PRO_CODE 出庫(kù)物品編碼 ,PRO_NUM 物品數(shù)量 ,UNIT 物品單位 ,PLACE_CODE 庫(kù)位代號(hào) from list_info where list_code=@list_codeed 用戶(hù)信息表管理 SQL 語(yǔ)句 create proc InsertUser @DUSER_NAMEED VARCHAR(30),@USER_PWDED VARCHAR(30),@USER_LEVELED VARCHAR(10) as insert into user_table(DUSER_NAME,USER_PWD,USER_LEVEL) values(@DUSER_NAMEED,@USER_PWDED,@USER_LEVELED) create proc UpdateUser @DUSER_NAMEED VARCHAR(30),@USER_PWDED VARCHAR(30),@USER_LEVELED VARCHAR(10) as update user_table set DUSER_NAME=@DUSER_NAMEED,USER_PWD=@USER_PWDED,USER_LEVEL=@USER_LEVELED where DUSER_NAME=@DUSER_NAMEED create proc DeleteUser @DUSER_NAMEED VARCHAR(30) as delete from user_table where DUSER_NAME=@DUSER_NAMEED create proc FindAllUser as select DUSER_NAME 用戶(hù)名 ,USER_PWD 用戶(hù)密碼 ,USER_LEVEL 用戶(hù)級(jí)別 from user_table create proc UpdateUser_Psw @DUSER_NAMEED VARCHAR(30),@USER_PWDED VARCHAR(30) as update user_table set DUSER_NAME=@DUSER_NAMEED,USER_PWD=@USER_PWDED where DUSER_NAME=@DUSE