倉庫管理手冊系統(tǒng)代碼

1、系統(tǒng)主函數(shù)（）using System;using warehouse static class Program Main1.0.0assembly: AssemblyFileVersion()數(shù)據(jù)庫連接類（）:using System;using ;using ;using class DataCon #region 建立數(shù)據(jù)庫連接 using ;using ;using ;using 為源自 Bitmap 和 Metafile 的類提供功能的抽象基類。using 命名空間包含一些類，這些類提供對.NET Framework 正則表達(dá)式引擎的訪問。該命名空間提供正則表達(dá)式功能n

2、amespace class DataOperate DataCon datacon = new DataCon();alue = P_str_UserName; UserPwd, , 20).Value = P_str_UserPwd; SqlParameter returnValue = returnValue, , 4); = ;alue = P_int_GoodsID; GoodsName, , 50).Value = P_str_GoodsName; PrName, , 100).Value = P_str_PrName; StoreName, , 100).Value = P_st

3、r_StoreName; GoodsSpec, , 50).Value = P_str_GoodsSpec; GoodsUnit, , 8).Value = P_str_GoodsUnit; GoodsNum, .Value = P_int_GoodsNum; GoodsPrice, .Value = P_dml_GoodsPrice; HandlePeople, , 20).Value = P_str_HPeople; ISRemark, , 1000).Value = P_str_Remark; SqlParameter returnValue = returnValue, , 4); =

4、 ; (); try (); catch (Exception ex) ; finally (); (); (); int P_int_returnValue = (int); return P_int_returnValue; #endregion #region 添加供應(yīng)商信息 alue = P_str_PrName; PrPeople, , 20).Value = P_str_PrPeople; PrPhone, , 20).Value = P_str_PrPhone; PrFax, , 20).Value = P_str_PrFax; PrRemark, , 1000).Value =

5、 P_int_PrRemark; SqlParameter returnValue = returnValue, , 4); = ; (); try (); catch (Exception ex) ; finally (); (); (); int P_int_returnValue = (int); return P_int_returnValue; #endregion #region 添加倉庫信息 alue = P_str_StoreName; StorePeople, , 20).Value = P_str_StorePeople; StorePhone, , 20).Value =

6、 P_str_StorePhone; StoreUnit, , 100).Value = P_str_StoreUnit; StoreRemark, , 1000).Value = P_int_StoreRemark; SqlParameter returnValue = returnValue, , 4); = ; (); try (); catch (Exception ex) ; finally (); (); (); int P_int_returnValue = (int); return P_int_returnValue; #endregion #region 添加新用戶 alu

7、e = P_str_UserName; UserPwd, , 20).Value = P_str_UserPwd; UserRight, , 10).Value = P_str_UserRight; SqlParameter returnValue = returnValue, , 4); = ; (); try (); catch (Exception ex) ; finally (); (); (); int P_int_returnValue = (int); return P_int_returnValue; #endregion #region 修改用戶信息 alue = P_int

8、_UID; UserPwd, , 20).Value = P_str_UserPwd; UserRight, , 10).Value = P_str_UserRight; (); try (); catch (Exception ex) ; finally (); (); (); #endregion 登陸界面（）using System;using ;using ;using ;using ;using warehouse public partial class frmLogin : Form public static string M_str_name;oString(); M_str

9、_right = ; (select UserPwd from tb_User where UserName= + + , txtPwd); (); private void frmLogin_FormClosing(object sender, FormClosingEventArgs e) (); 系統(tǒng)主界面（）using System;using ;using ;using ;using ;using ;namespace warehouse public partial class frmMain : Form public frmMain() InitializeComponent(

10、); private void frmMain_Load(object sender, EventArgs e) = 操作用戶權(quán)限： + = = 登錄系統(tǒng)時間： + if = 普通用戶) 入庫管理 = false; 出庫管理 = false; 借貨還貨 = false; 供貨商設(shè)置 = false; 貨物檔案設(shè)置 = false; 倉庫設(shè)置 = false; 權(quán)限設(shè)置 = false; 用戶管理 = false; = false; = false; = false; = false; = false; = false; = false; = false; private void btnIS_

11、Click(object sender, EventArgs e). (貨物刪除成功！, 信息, , ; frmISManage_Load(sender, e); 后再用 (dataGridView11, 來取得所選中的那行數(shù)據(jù)某列的值*/ = (dgvISManage1, = (dgvISManage2, = (dgvISManage4, = (dgvISManage3, = (dgvISManage5, = (dgvISManage6, = (dgvISManage7, = (dgvISManage8, = (dgvISManage9, = (dgvISManage11, = (dgvIS

12、Manage12, private void txtGIPrice_TextChanged(object sender, EventArgs e) try = * oString().Trim() (倉庫中沒有足夠的貨物！, 提示, , ; else (insert into tb_OutStore(StoreName,GoodsName,GoodsSpec,GoodsUnit, + GoodsNum,GoodsPrice,PGProvider,PGPeople,HandlePeople,OSRemark)+ values( + + , + + , + + , + + ,+ + , + + ,

13、 + + , + + , + + , + + ); (貨物出庫成功！, 信息, , ; frmOSManage_Load(sender, e); (); catch (Exception ex) , 警告, , ; private void btnDel_Click(object sender, EventArgs e) try (delete from tb_OutStore where OSID= + (dgvOSManage0, + ); (貨物刪除成功！, 信息, , ; frmOSManage_Load(sender, e); catch (Exception ex) , 警告, ,

14、 ; private void btnExit_Click(object sender, EventArgs e) (); private void dgvOSManage_CellClick(object sender, DataGridViewCellEventArgs e) = (dgvOSManage1, = (dgvOSManage2, = (dgvOSManage3, = (dgvOSManage4, = (dgvOSManage5, = (dgvOSManage6, = (dgvOSManage7, = (dgvOSManage9, = (dgvOSManage10, = (dg

15、vOSManage11, = (dgvOSManage12, private void cboxSName_SelectedIndexChanged(object sender, EventArgs e) (select distinct GoodsName from tb_InStore where StoreName= + + , tb_InStore, GoodsName, cboxGName); private void cboxGName_SelectedIndexChanged(object sender, EventArgs e) (select distinct GoodsSp

16、ec from tb_InStore where StoreName= + + and GoodsName= + + , tb_InStore, GoodsSpec, cboxGSpec); SqlDataReader sqlread = (select GoodsUnit,GoodsOutPrice,GoodsNum from tb_GoodsInfo + where StoreName= + + and GoodsName= + + ); if () = sqlreadGoodsUnit.ToString().Trim(); = qlreadGoodsOutPrice.ToString()

17、.Trim(); = sqlreadGoodsNum.ToString().Trim(); (); private void txtOSGNum_TextChanged(object sender, EventArgs e) try = catch (Exception ex) , 警告, , ; private void frmOSManage_FormClosed(object sender, FormClosedEventArgs e) (); 借貨管理using System;using ;using ;using ;using ;using public partial class

18、frmBGManage : Form datacon = new doperate = new public frmBGManage() InitializeComponent(); private void frmBGManage_Load(object sender, EventArgs e) (select StoreName from tb_Storage, tb_Storage, StoreName, cboxSName); DataSet myds = (select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱, + Goods

19、Spec as 貨物規(guī)格,GoodsNum as 借出數(shù)量,BGDate as 借貨日期,HandlePeople as 經(jīng)手, + BGPeople as 借貨,BGUnit as 借貨單位,BGRemark as 備注from tb_BorrowGoods, tb_BorrowGoods); = 0; private void btnAdd_Click(object sender, EventArgs e) try if (! (txtBGNum, 輸入必須為數(shù)字！); else (); SqlDataReader sqlread = (select GoodsName StoreName

20、,GoodsNum from tb_GoodsInfo + where StoreName= + + and GoodsName= + + and GoodsSpec= + + ); if () if (sqlreadGoodsNum.ToString().Trim() = (沒有足夠的貨物供您借?。? 警告, , ; = ; (); else (insert into tb_BorrowGoods(StoreName,GoodsName,GoodsSpec, + GoodsNum,HandlePeople,BGPeople,BGUnit,BGRemark) + values( + + , +

21、 + , + + , + + , + + , + + , + + , + + ); (借貨成功！, 信息, , ; frmBGManage_Load(sender, e); (); catch (Exception ex) , 警告, , ; private void btnDel_Click(object sender, EventArgs e) try (delete from tb_BorrowGoods where BGID= + (dgvBGManage0, + ); (借貨資料刪除成功！, 信息, , ; frmBGManage_Load(sender, e); catch (Ex

22、ception ex) , 警告, , ; private void btnRGManage_Click(object sender, EventArgs e) GMfrgm = new frmRGManage(); (); (); private void btnExit_Click(object sender, EventArgs e) (); private void cboxSName_SelectedIndexChanged(object sender, EventArgs e) (select distinct GoodsName from tb_GoodsInfo where S

23、toreName= + + , tb_GoodsInfo, GoodsName, cboxGName); private void cboxGName_SelectedIndexChanged(object sender, EventArgs e) (select distinct GoodsSpec from tb_GoodsInfo where StoreName= + and GoodsName= + + , tb_GoodsInfo, GoodsSpec, cboxGSpec); SqlDataReader sqlreader = (select GoodsName,StoreName

24、,GoodsNum from tb_GoodsInfo where StoreName= + + and GoodsName= + + ); if () = sqlreaderGoodsNum.ToString().Trim(); (); private void dgvBGManage_CellClick(object sender, ataGridViewCellEventArgs e) = (dgvBGManage2, = (dgvBGManage1, = (dgvBGManage3, = (dgvBGManage4, = (dgvBGManage6, = (dgvBGManage7,

25、= (dgvBGManage8, = (dgvBGManage9, private void frmBGManage_FormClosed(object sender, FormClosedEventArgs e) (); 貨物歸還using System;using ;using ;using ;using ;using public partial class frmRGManage : Form datacon = new doperate = new public frmRGManage() InitializeComponent(); private void frmRGManage

26、_Load(object sender, EventArgs e) (select BGID from tb_BorrowGoods, tb_BorrowGoods, BGID, cboxBGID); DataSet myds = (select RGID as 還貨編號,BGID as 借貨編號,StoreName as 倉庫名稱,GoodsName as 貨物名稱, + GoodsSpec as 貨物規(guī)格, RGNum as 歸還數(shù)量,NRGNum as 未歸還數(shù)量,RGDate as 還貨日期,HandlePeople as 經(jīng)手, + RGPeople as 還貨,RGRemark a

27、s 備注,Editer as 修改,EditDate as 修改日期from tb_ReturnGoods, tb_ReturnGoods); = tb_ReturnGoods; private void btnAdd_Click(object sender, EventArgs e) try SqlDataReader sqlread = (select GoodsNum from tb_BorrowGoods + where BGID= + + ); if () if (sqlreadGoodsNum.ToString().Trim() (您借的貨物數(shù)目為 + (sqlreadGoodsN

28、um.ToString().Trim() + ，請重新填寫還貨的數(shù)量！, 提示, , ; = ; (); else (insert into tb_ReturnGoods(BGID,StoreName,GoodsName,GoodsSpec,RGNum, + NRGNum,HandlePeople,RGPeople,RGRemark) values( + + , + + , + + , + + , + + , + + , + + , + + , + + ); (還貨成功！, 提示, , ; frmRGManage_Load(sender, e); (); catch (Exception ex

29、) , 警告, , ; private void btnEdit_Click(object sender, EventArgs e) try (update tb_ReturnGoods set HandlePeople= + + ,RGPeople= + + ,RGRemark= + + ,Editer= + + ,EditDate= + + where RGID=+ (dgvRGManage0, + ); (還貨檔案資料修改成功！, 信息, , ; frmRGManage_Load(sender, e); catch (Exception ex) , 警告, , ; private voi

30、d btnDel_Click(object sender, EventArgs e) try (delete from tb_ReturnGoods where RGID= + (dgvRGManage0, + ); (還貨檔案資料刪除成功！, 信息, , ; frmRGManage_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnExit_Click(object sender, EventArgs e) (); private void cboxBGID_SelectedIndexChanged(object

31、sender, EventArgs e) if = ) else SqlDataReader sqlreada = (select GoodsNum from tb_BorrowGoods + where BGID= + + ); if () = sqlreadaGoodsNum.ToString().Trim(); SqlDataReader sqlreadNum = (select sum(RGNum) as Num from tb_ReturnGoods + where BGID= + + ); if () if (sqlreadNumNum.ToString().Trim() = )

32、(您沒有還過該貨物。); else (已歸還數(shù)量為 + sqlreadNumNum.ToString().Trim() + 。); (); SqlDataReader sqlread = (select StoreName,GoodsName,GoodsSpec from tb_BorrowGoods+ where BGID= + + ); if () = sqlreadStoreName.ToString().Trim(); = sqlreadGoodsName.ToString().Trim(); = sqlreadGoodsSpec.ToString().Trim(); (); priv

33、ate void dgvRGManage_CellClick(object sender, DataGridViewCellEventArgs e) = (dgvRGManage1, = (dgvRGManage2, = (dgvRGManage3, = (dgvRGManage5, = (dgvRGManage6, = (dgvRGManage9, = (dgvRGManage8, = (dgvRGManage10, private void txtRGNum_TextChanged(object sender, EventArgs e) try SqlDataReader sqlread

34、= (select GoodsNum from tb_BorrowGoods + where BGID= + + ); if () = (sqlreadGoodsNum.ToString().Trim() - (); catch (Exception ex) , 警告, , ; private void frmRGManage_FormClosed(object sender, FormClosedEventArgs e) (); 檔案設(shè)置管理（倉庫設(shè)置）using System;using ;using ;using ;using ;using public partial class fr

35、mStoreInfo : Form datacon = new doperate = new public frmStoreInfo() InitializeComponent(); private void frmStoreInfo_Load(object sender, EventArgs e) DataSet myds = (select StoreID as 倉庫編號,StoreName as 倉庫名稱,StorePeople as 負(fù)責(zé), + StorePhone as 電話,StoreUnit as 所屬單位,StoreDate as 建庫日期,StoreRemark as 備注,

36、 + Editer as 修改,EditDate as 修改日期from tb_Storage, tb_Storage); =tb_Storage; private void btnAdd_Click(object sender, EventArgs e) try if (! (txtSPhone, 電話格式不對); else (); if = ) (倉庫名稱不能為空！, 信息, , ; else int P_int_returnValue = if (P_int_returnValue = 100) (該倉庫已經(jīng)存在！, 信息, , ; else (倉庫信息添加成功！, 信息, , ; fr

37、mStoreInfo_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnEdit_Click(object sender, EventArgs e) try if (! (txtSPhone, 電話號碼輸入格式不正確); else (); (update tb_Storage set StoreName= +, StorePeople= + + ,StorePhone=+ + ,StoreUnit= + ,StoreRemark= + + ,Editer= + + ,EditDate= + + where Store

38、ID= + (dgvSInfo0, + ); (倉庫檔案修改成功！, 信息, , ; frmStoreInfo_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnDel_Click(object sender, EventArgs e) try (delete from tb_Storage where StoreID= + (dgvSInfo0, + ); (成功刪除倉庫！, 信息, , ; frmStoreInfo_Load(sender, e); catch (Exception ex) , 警告, , ; p

39、rivate void btnExit_Click(object sender, EventArgs e) (); private void dgvSInfo_CellClick(object sender, DataGridViewCellEventArgs e) = (dgvSInfo1, = (dgvSInfo2, = (dgvSInfo3, = (dgvSInfo4, = (dgvSInfo6, private void frmStoreInfo_FormClosed(object sender, FormClosedEventArgs e) (); 供應(yīng)商設(shè)置using System

40、;using ;using ;using ;using ;using public partial class frmPrInfo : Form datacon = new doperate = new public frmPrInfo() InitializeComponent(); private void frmPrInfo_Load(object sender, EventArgs e) DataSet myds = (select PrID as 供應(yīng)商編號,PrName as 供應(yīng)商名稱,PrPeople as 負(fù)責(zé), + PrPhone as 電話,PrFax as 傳真,PrR

41、emark as 備注,Editer as 修改,EditDate as 修改日期from tb_Provider, tb_Provider); =tb_Provider; private void btnAdd_Click(object sender, EventArgs e) try if (! (txtPPhone, 電話號碼格式不正確); else if (! (txtPFax, 傳真號碼輸入格式不正確); else (); (); if = ) (供應(yīng)商名稱不能為空！, 信息, , ; else int P_int_returnValue = if (P_int_returnValu

42、e = 100) (該供應(yīng)商已經(jīng)存在！, 信息, , ; else (供應(yīng)商信息添加成功！, 信息, , ; frmPrInfo_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnEdit_Click(object sender, EventArgs e) try if (! (txtPPhone, 電話號碼格式不正確); else if (! (txtPFax, 傳真號碼輸入格式不正確); else (); (); (update tb_Provider set PrPeople= + + ,PrPhone= +

43、+ ,PrFax= + + ,PrRemark= + + ,Editer= + + ,EditDate= + + where PrID= + (dgvPInfo0, + ); (供應(yīng)商檔案修改成功！, 信息, , ; frmPrInfo_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnDel_Click(object sender, EventArgs e) try (delete from tb_Provider where PrID=+ (dgvPInfo0, + );(成功刪除供應(yīng)商！, 信息, , ; fr

44、mPrInfo_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnExit_Click(object sender, EventArgs e) (); private void dgvPInfo_CellClick(object sender, DataGridViewCellEventArgs e) = (dgvPInfo1, = (dgvPInfo2, = (dgvPInfo3, = (dgvPInfo4, = (dgvPInfo5, private void frmPrInfo_FormClosed(objec

45、t sender, FormClosedEventArgs e) (); 庫存貨物管理（）using System;using ;using ;using ;using ;using public partial class frmGoodsInfo : Form datacon = new doperate = new public frmGoodsInfo() InitializeComponent(); private void frmGoodsInfo_Load(object sender, EventArgs e) DataSet myds = (select GoodsID as

46、貨物編號,GoodsName as 貨物名稱, + StoreName as 倉庫名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as 計量單位, + GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價格,GoodsOutPrice as 出貨價格, + Editer as 修改,EditDate as 修改日期from tb_GoodsInfo, tb_GoodsInfo); = tb_GoodsInfo; private void btnEdit_Click(object sender, EventArgs e) try if (! (txtGOPric

47、e, 輸入必須為數(shù)字); else (); (update tb_GoodsInfo set GoodsOutPrice= + + ,Editer= + + ,EditDate= + + where GoodsID= + (dgvGInfo0, + ); (貨物檔案修改成功！, 信息, , ; frmGoodsInfo_Load(sender, e); catch(Exception ex) , 警告, , ; private void btnDel_Click(object sender, EventArgs e) try (delete from tb_GoodsInfo where Go

48、odsID= + (dgvGInfo0, + and StoreName= + (dgvGInfo2, + ); (貨物刪除成功！, 信息, , ; frmGoodsInfo_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnExit_Click(object sender, EventArgs e) (); private void dgvGInfo_CellClick(object sender, DataGridViewCellEventArgs e) = (dgvGInfo1, = (dgvGInfo3, =

49、 (dgvGInfo4, = (dgvGInfo5, = (dgvGInfo6, = (dgvGInfo7, private void frmGoodsInfo_FormClosed(object sender, FormClosedEventArgs e) (); 查詢管理（借出貨物）using System;using ;using ;using ;using ;using public partial class frmBGLook : Form public frmBGLook() InitializeComponent(); datacon = new private void fr

50、mBGLook_Load(object sender, EventArgs e) DataSet myds = (select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱, + GoodsSpec as 貨物規(guī)格,GoodsNum as 借出數(shù)量,BGDate as 借貨日期,HandlePeople as 經(jīng)手, + BGPeople as 借貨,BGUnit as 借貨單位,BGRemark as 備注from tb_BorrowGoods, tb_BorrowGoods); = 0; private void btnLook_Clic

51、k(object sender, EventArgs e) try if = ) frmBGLook_Load(sender, e); else if = 借貨編號) DataSet myds = (select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱, + GoodsSpec as 貨物規(guī)格,GoodsNum as 借出數(shù)量,BGDate as 借貨日期,HandlePeople as 經(jīng)手, + BGPeople as 借貨,BGUnit as 借貨單位,BGRemark as 備注from tb_BorrowGoods where

52、 BGID = + + , tb_BorrowGoods); = 0; if = 借貨日期) string P_str_dtime = DataSet myds = (select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱, + GoodsSpec as 貨物規(guī)格,GoodsNum as 借出數(shù)量,BGDate as 借貨日期,HandlePeople as 經(jīng)手, + BGPeople as 借貨,BGUnit as 借貨單位,BGRemark as 備注from tb_BorrowGoods + where year(BGDate)=

53、 + (0, 4) + and month(BGDate)= + (5, - 6) + , tb_BorrowGoods); = 0; if = 倉庫名稱) DataSet myds = (select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱, + GoodsSpec as 貨物規(guī)格,GoodsNum as 借出數(shù)量,BGDate as 借貨日期,HandlePeople as 經(jīng)手, + BGPeople as 借貨,BGUnit as 借貨單位,BGRemark as 備注from tb_BorrowGoods where Stor

54、eName like % + + %, tb_BorrowGoods); = 0; if = 貨物名稱) DataSet myds = (select BGID as 借貨編號,GoodsName as 貨物名稱,StoreName as 倉庫名稱,+ GoodsSpec as 貨物規(guī)格,GoodsNum as 借出數(shù)量,BGDate as 借貨日期,HandlePeople as 經(jīng)手, + BGPeople as 借貨,BGUnit as 借貨單位,BGRemark as 備注from tb_BorrowGoods where GoodsName like % + + %, tb_Borr

55、owGoods); = 0; catch (Exception ex) ,提示,; private void btnExit_Click(object sender, EventArgs e) (); private void cboxLCondition_SelectedIndexChanged(object sender, EventArgs e) if = 借貨日期) = 查詢年月份; else = 查詢關(guān)鍵字; private void frmBGLook_FormClosed(object sender, FormClosedEventArgs e) (); 庫存查詢（）using

56、System;using ;using ;using ;using ;using public partial class frmGILook : Form datacon = new public frmGILook() InitializeComponent(); private void frmGILook_Load(object sender, EventArgs e) DataSet myds = (select GoodsID as 貨物編號,GoodsName as 貨物名稱, + StoreName as 倉庫名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as

57、計量單位,+ GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價格,GoodsOutPrice as 出貨價格, + Editer as 修改,EditDate as 修改日期from tb_GoodsInfo, tb_GoodsInfo); = 0; private void btnLook_Click(object sender, EventArgs e) try if = ) frmGILook_Load(sender, e); else if = 貨物編號) DataSet myds = (select GoodsID as 貨物編號,GoodsName as 貨

58、物名稱, + StoreName as 倉庫名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as 計量單位, + GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價格,GoodsOutPrice as 出貨價格, + GoodsLeast as 最低存儲,GoodsMost as 最高存儲,Editer as 修改,EditDate as 修改日期 + from tb_GoodsInfo where GoodsID = + + , tb_GoodsInfo); = 0; if = 貨物名稱) DataSet myds = (select GoodsID as

59、 貨物編號,GoodsName as 貨物名稱, + StoreName as 倉庫名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as 計量單位, +GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價格,GoodsOutPrice as 出貨價格, + GoodsLeast as 最低存儲,GoodsMost as 最高存儲,Editer as 修改,EditDate as 修改日期 + from tb_GoodsInfo where GoodsName like % + + %, tb_GoodsInfo); = 0; if = 倉庫名稱) DataSe

60、t myds = (select GoodsID as 貨物編號,GoodsName as 貨物名稱, + StoreName as 倉庫名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as 計量單位, + GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價格,GoodsOutPrice as 出貨價格, + GoodsLeast as 最低存儲,GoodsMost as 最高存儲,Editer as 修改,EditDate as 修改日期 + from tb_GoodsInfo where StoreName like % + + %, tb_GoodsI