倉庫管理手冊系統(tǒng)代碼_第1頁
倉庫管理手冊系統(tǒng)代碼_第2頁
倉庫管理手冊系統(tǒng)代碼_第3頁
倉庫管理手冊系統(tǒng)代碼_第4頁
倉庫管理手冊系統(tǒng)代碼_第5頁
已閱讀5頁,還剩35頁未讀, 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請進(jìn)行舉報或認(rèn)領(lǐ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

溫馨提示

  • 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論