銷售管理圖書銷售管理系統(tǒng)簡介

{銷售管理}圖書銷售管理項(xiàng)工作。在單機(jī)版的基礎(chǔ)上可以針對(duì)規(guī)模較大的圖書銷售商開發(fā)網(wǎng)模塊，而前臺(tái)則使用銷售管理模塊。容易被經(jīng)營者所接受。u根據(jù)顧客選取的書目完成收款業(yè)務(wù)。u提供上下班結(jié)款、提示上架、密碼修改等輔助功能。2.1.3查詢模塊◆書目查詢◆入庫查詢◆銷售記錄查詢◆庫存查詢例如：總經(jīng)理查詢子模塊可直接查詢各種業(yè)務(wù)數(shù)據(jù)，包括銷售情況、字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性書編號(hào),no,Char,13,,N作者,author,Char,100,,Y出版社名稱,publishing,Char,50,,Y價(jià)格,price,Decimal,9,2,N簡介,introduction,Varchar,1024,,Y書類型,type,int,4,,N打折起始期,discount_sdate,Char,10,,N打折終止期,Discount_edate,char,10,,N打折度,Discount_rate,Decima,9,2,N會(huì)員是否有效,Card_Discount,int,4,,N庫編號(hào),no,Char,4,,N庫地點(diǎn),addr,Char,100,,Y負(fù)責(zé)人,pri_name,Char,100,,Y電話,Tele_no,Char,100,,Y字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性廠商編號(hào),no,Char,13,,N地點(diǎn),addr,Char,100,,Y電話,telenum,Char,20,,Y負(fù)責(zé)人,pri_name,Char,50,,Y員工編號(hào),No,Char,4,,N性別,Sex,bit,1,,Y年齡,Age,int,4,,Y權(quán)限,privilege,int,4,,N卡編號(hào),no,Char,4,,N卡類型,type,Char,4,,Y卡積分,integral,int,4,,Y字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性編號(hào),no,Char,4,,N地點(diǎn),addr,Char,100,,Y性別,sex,bit,1,,Y年齡,age,int,4,,Y職業(yè),vocation,Char,5,,Y行為：書編號(hào),book_no,Char,13,,N上架書數(shù)量,bookshell_num,int,4,,Y書編號(hào),book_no,Char,13,,N進(jìn)貨日期,stock_date,char,10,,N員工編號(hào),worker_no,Char,4,,Y數(shù)量,stock_number,int,4,,N是否結(jié)款,Ifreckoning,bit,1,,Y廠商負(fù)責(zé)人,pri_name,Char,100,,Y備注,remark,Varchar,1024,,Y字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性銷售編號(hào),seq,Int(增量),4,,N書編號(hào),book_no,Char,13,,N卡類型,Card_style,Char,4,,Y數(shù)量,Sell_num,int,4,,N出售日期,Sell_date,char,10,,N字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性書編號(hào),Book_no,Char,13,,N退換日期,date,char,10,,N備注,remark,Varchar,1024,,Y書編號(hào),Book_no,Char,13,,N預(yù)定數(shù)量,number,int,4,,Y預(yù)定時(shí)間,date,Char,10,,Y預(yù)定人號(hào),credit_no,Char,8,,Y預(yù)定金,earnest,money,8,4,Y電話,tele_num,Char,100,,Y字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性書編號(hào),Book_no,Char,13,,N結(jié)款日期,date,char,10,,N數(shù)量,number,int,4,,N字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性書編號(hào),Book_no,Char,13,,N卡類型,Card_style,Char,4,,Y打折起始期,sdate,char,10,,N打折終止期,edate,char,10,,N書類型,type,in