【正文】 庫(kù)存信息 insert into store_info(PRO_CODE,STORE_PRO_NUM,STORE_UP_NUM,STORE_DOWN_NUM,UNIT,PLACE_CODE) values(39。,39。,39。) insert into user_table(DUSER_NAME,USER_PWD,USER_LEVEL) values(39。,39。,39。) insert into user_table(DUSER_NAME,USER_PWD,USER_LEVEL) values(39。,39。,39。) insert into user_table(DUSER_NAME,USER_PWD,USER_LEVEL) values(39。,39。,39。) 用戶信息 insert into user_table(DUSER_NAME,USER_PWD,USER_LEVEL) values(39。,39。,39。,39。,5,39。,39。) insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,4,39。,39。) insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,3,39。,39。) insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,2,39。,39。) insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,1,39。,39。) 出庫(kù)單信息 insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,10,39。,39。) insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,10,39。,39。) insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,10,39。,39。) insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,10,39。,39。) insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,10,39。,39。) 數(shù)據(jù)單信息 入庫(kù)單信息 insert into list_info(LIST_CODE,LIST_DATE,PRO_NUM,UNIT,PRO_CODE,PLACE_CODE,OPERATOR_ID) values(39。,39。,39。,39。,39。,39。) insert into operator_info(OPERATOR_ID,DNAME,SEX,LEVEL1,PHONE,ADDRESS) values(39。,39。,39。,39。,39。,39。) insert into operator_info(OPERATOR_ID,DNAME,SEX,LEVEL1,PHONE,ADDRESS) values(39。,39。,39。,39。,39。,39。) insert into operator_info(OPERATOR_ID,DNAME,SEX,LEVEL1,PHONE,ADDRESS) values(39。,39。,39。,39。,39。,39。) insert into operator_info(OPERATOR_ID,DNAME,SEX,LEVEL1,PHONE,ADDRESS) values(39。,39。,39。,39。,39。,39。) insert into operator_info(OPERATOR_ID,DNAME,SEX,LEVEL1,PHONE,ADDRESS) values(39。,39。,39。,39。,39。,39。) 輸入員工信息 insert into operator_info(OPERATOR_ID,DNAME,SEX,LEVEL1,PHONE,ADDRESS) values(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。,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。,39。,39。) 輸入庫(kù)位信息 insert into place_info(place_code,area_name,pro_code) values(39。,39。,39。,39。) insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。,39。,39。,39。) insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。,39。,39。,39。) insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。,39。,39。,39。) insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。,39。,39。,39。) 輸入物品信息 insert into pro_info(pro_code,pro_name,supplier_code,unit) values(39。,39。,39。,39。,39。,39。) insert into supplier_info(supplier_code,supplier_name,link_man,link_phone,supplier_address,remark) values(39。,39。,39。,39。,39。,39。) insert into supplier_info(supplier_code,supplier_name,link_man,link_phone,supplier_address,remark) values(39。,39。,39。,39。,39。,39。) insert into supplier_info(supplier_code,supplier_name,link_man,link_phone,supplier_address,remark) values(39。,39。,39。,39。,39。,39。) insert into supplier_info(supplier_code,supplier_name,link_man,link_phone,supplier_address,remark) values(39。,39。,39。,39。,39。,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 用戶信息表管理 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 用戶名 ,USER_PWD 用戶密碼 ,USER_LEVEL 用戶級(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=DUSER_NAMEED 輸 入 各 表 數(shù) 據(jù) 輸入供應(yīng)商信息 insert into supplier_info(supplier_code,supplier_name,link_man,link_phone,supplier_address,remark) values(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。 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 wher