【文章內(nèi)容簡(jiǎn)介】 _DATE 借出時(shí)間,PRO_CODE 借出物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫(kù)位代號(hào)from list_infowhere list_code like 39。o%39。歸還信息管理SQL語(yǔ)句create procedure FindAllList_i asselect LIST_CODE 歸還單編號(hào),OPERATOR_ID 操作員代號(hào),LIST_DATE 歸還時(shí)間,PRO_CODE 歸還物品編碼,PRO_NUM 物品數(shù)量,UNIT 物品單位,PLACE_CODE 庫(kù)位代號(hào)from list_infowhere list_code like 39。i%39。庫(kù)存信息管理SQL語(yǔ)句create procedure FindAllStore asselect PRO_CODE 入庫(kù)物品編碼,STORE_PRO_NUM 庫(kù)存數(shù)量,STORE_UP_NUM 庫(kù)存上限,STORE_DOWN_NUM 庫(kù)存下限,UNIT 物品單位,PLACE_CODE 庫(kù)位代號(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庫(kù)盤(pán)點(diǎn)作業(yè)管理SQL語(yǔ)句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 入庫(kù)物品編碼,STORE_PRO_NUM 庫(kù)存數(shù)量,STORE_UP_NUM 庫(kù)存上限,STORE_DOWN_NUM 庫(kù)存下限,UNIT 物品單位,PLACE_CODE 庫(kù)位代號(hào) from store_info入庫(kù)信息查詢create proc FindAllList_1_time @LIST_DATEED1 datetime,@LIST_DATEED2 datetimeasselect 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_infowhere list_code like 39。1%39。 and list_date between @list_dateed1 and @list_dateed2create proc FindAllList_1_Pro_code @PRO_CODEED varchar(5)asselect 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_infowhere list_code like 39。1%39。 and pro_code=@pro_codeedcreate proc FindAllList_1_Ope_id @OPERATOR_IDED VARCHAR(5)asselect 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_infowhere list_code like 39。1%39。 and operator_id=@operator_idedcreate proc FindList_1_ListCode @LIST_CODEED VARCHAR(5)asselect 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_infowhere list_code=@list_codeed出庫(kù)信息查詢create proc FindAllList_0_time @LIST_DATEED1 datetime,@LIST_DATEED2 datetimeasselect 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_infowhere list_code like 39。0%39。 and list_date between @list_dateed1 and @list_dateed2create proc FindAllList_0_Pro_code @PRO_CODEED varchar(5)asselect 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_infowhere list_code like 39。0%39。 and pro_code=@pro_codeedcreate proc FindAllList_0_Ope_id @OPERATOR_IDED VARCHAR(5)asselect 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_infowhere list_code like 39。0%39。 and operator_id=@operator_idedcreate proc FindList_0_ListCode @LIST_CODEED VARCHAR(5)asselect 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_infowhere list_code=@list_codeed用戶信息表管理SQL語(yǔ)句create proc InsertUser @DUSER_NAMEED VARCHAR(30),@USER_PWDED VARCHAR(30),@USER_LEVELED VARCHAR(10)asinsert 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)asupdate user_table set DUSER_NAME=@DUSER_NAMEED,USER_PWD=@USER_PWDED,USER_LEVEL=@USER_LEVELEDwhere DUSER_NAME=@DUSER_NAMEEDcreate proc DeleteUser @DUSER_NAMEED VARCHAR(30)asdelete from user_table where DUSER_NAME=@DUSER_NAMEEDcreate proc FindAllUserasselect DUSER_NAME 用戶名,USER_PWD 用戶密碼,USER_LEVEL 用戶級(jí)別from user_tablecreate proc UpdateUser_Psw @DUSER_NAMEED VARCHAR(30),@USER_PWDED VARCHAR(30)asupdate user_table set DUSER_NAME=@DUSER_NAMEED,USER_PWD=@USER_PWDEDwhere DUSER_NAME=@DUSER_NAMEED