




版權(quán)說(shuō)明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)
文檔簡(jiǎn)介
1、系統(tǒng)主函數(shù)()using System;using warehouse static class Program Main1.0.0assembly: AssemblyFileVersion()數(shù)據(jù)庫(kù)連接類():using System;using ;using ;using class DataCon #region 建立數(shù)據(jù)庫(kù)連接 using ;using ;using ;using 為源自 Bitmap 和 Metafile 的類提供功能的抽象基類。using 命名空間包含一些類,這些類提供對(duì).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 添加倉(cāng)庫(kù)信息 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)時(shí)間: + if = 普通用戶) 入庫(kù)管理 = false; 出庫(kù)管理 = false; 借貨還貨 = false; 供貨商設(shè)置 = false; 貨物檔案設(shè)置 = false; 倉(cāng)庫(kù)設(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, 來(lái)取得所選中的那行數(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() (倉(cāng)庫(kù)中沒有足夠的貨物!, 提示, , ; else (insert into tb_OutStore(StoreName,GoodsName,GoodsSpec,GoodsUnit, + GoodsNum,GoodsPrice,PGProvider,PGPeople,HandlePeople,OSRemark)+ values( + + , + + , + + , + + ,+ + , + + ,
13、 + + , + + , + + , + + ); (貨物出庫(kù)成功!, 信息, , ; 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 借貨編號(hào),GoodsName as 貨物名稱,StoreName as 倉(cāng)庫(kù)名稱, + 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 還貨編號(hào),BGID as 借貨編號(hào),StoreName as 倉(cāng)庫(kù)名稱,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() + ,請(qǐng)重新填寫還貨的數(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、(您沒有還過(guò)該貨物。); 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è)置管理(倉(cāng)庫(kù)設(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 倉(cāng)庫(kù)編號(hào),StoreName as 倉(cāng)庫(kù)名稱,StorePeople as 負(fù)責(zé), + StorePhone as 電話,StoreUnit as 所屬單位,StoreDate as 建庫(kù)日期,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, 電話格式不對(duì)); else (); if = ) (倉(cāng)庫(kù)名稱不能為空!, 信息, , ; else int P_int_returnValue = if (P_int_returnValue = 100) (該倉(cāng)庫(kù)已經(jīng)存在!, 信息, , ; else (倉(cāng)庫(kù)信息添加成功!, 信息, , ; fr
37、mStoreInfo_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnEdit_Click(object sender, EventArgs e) try if (! (txtSPhone, 電話號(hào)碼輸入格式不正確); else (); (update tb_Storage set StoreName= +, StorePeople= + + ,StorePhone=+ + ,StoreUnit= + ,StoreRemark= + + ,Editer= + + ,EditDate= + + where Store
38、ID= + (dgvSInfo0, + ); (倉(cāng)庫(kù)檔案修改成功!, 信息, , ; frmStoreInfo_Load(sender, e); catch (Exception ex) , 警告, , ; private void btnDel_Click(object sender, EventArgs e) try (delete from tb_Storage where StoreID= + (dgvSInfo0, + ); (成功刪除倉(cāng)庫(kù)!, 信息, , ; 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)商編號(hào),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, 電話號(hào)碼格式不正確); else if (! (txtPFax, 傳真號(hào)碼輸入格式不正確); 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, 電話號(hào)碼格式不正確); else if (! (txtPFax, 傳真號(hào)碼輸入格式不正確); 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) (); 庫(kù)存貨物管理()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、貨物編號(hào),GoodsName as 貨物名稱, + StoreName as 倉(cāng)庫(kù)名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as 計(jì)量單位, + GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價(jià)格,GoodsOutPrice as 出貨價(jià)格, + 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 借貨編號(hào),GoodsName as 貨物名稱,StoreName as 倉(cāng)庫(kù)名稱, + 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 = 借貨編號(hào)) DataSet myds = (select BGID as 借貨編號(hào),GoodsName as 貨物名稱,StoreName as 倉(cāng)庫(kù)名稱, + 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 借貨編號(hào),GoodsName as 貨物名稱,StoreName as 倉(cāng)庫(kù)名稱, + 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 = 倉(cāng)庫(kù)名稱) DataSet myds = (select BGID as 借貨編號(hào),GoodsName as 貨物名稱,StoreName as 倉(cāng)庫(kù)名稱, + 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 借貨編號(hào),GoodsName as 貨物名稱,StoreName as 倉(cāng)庫(kù)名稱,+ 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) (); 庫(kù)存查詢()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 貨物編號(hào),GoodsName as 貨物名稱, + StoreName as 倉(cāng)庫(kù)名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as
57、計(jì)量單位,+ GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價(jià)格,GoodsOutPrice as 出貨價(jià)格, + 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 = 貨物編號(hào)) DataSet myds = (select GoodsID as 貨物編號(hào),GoodsName as 貨
58、物名稱, + StoreName as 倉(cāng)庫(kù)名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as 計(jì)量單位, + GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價(jià)格,GoodsOutPrice as 出貨價(jià)格, + GoodsLeast as 最低存儲(chǔ),GoodsMost as 最高存儲(chǔ),Editer as 修改,EditDate as 修改日期 + from tb_GoodsInfo where GoodsID = + + , tb_GoodsInfo); = 0; if = 貨物名稱) DataSet myds = (select GoodsID as
59、 貨物編號(hào),GoodsName as 貨物名稱, + StoreName as 倉(cāng)庫(kù)名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as 計(jì)量單位, +GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價(jià)格,GoodsOutPrice as 出貨價(jià)格, + GoodsLeast as 最低存儲(chǔ),GoodsMost as 最高存儲(chǔ),Editer as 修改,EditDate as 修改日期 + from tb_GoodsInfo where GoodsName like % + + %, tb_GoodsInfo); = 0; if = 倉(cāng)庫(kù)名稱) DataSe
60、t myds = (select GoodsID as 貨物編號(hào),GoodsName as 貨物名稱, + StoreName as 倉(cāng)庫(kù)名稱,GoodsSpec as 貨物規(guī)格,GoodsUnit as 計(jì)量單位, + GoodsNum as 貨物數(shù)量,GoodsInPrice as 進(jìn)貨價(jià)格,GoodsOutPrice as 出貨價(jià)格, + GoodsLeast as 最低存儲(chǔ),GoodsMost as 最高存儲(chǔ),Editer as 修改,EditDate as 修改日期 + from tb_GoodsInfo where StoreName like % + + %, tb_GoodsI
溫馨提示
- 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
- 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 統(tǒng)編高中語(yǔ)文教材性別平等研究-以選文性別形象為例
- 深度教學(xué)理念視域下高中古代論說(shuō)文閱讀教學(xué)研究
- 含酰亞胺環(huán)鄰苯二甲腈樹脂的合成及膠粘劑的研究
- 醫(yī)務(wù)管理培訓(xùn)課件
- 幼兒園健康安全小知識(shí)
- 刀刺傷護(hù)理措施及診斷
- 外傷處理健康教育
- 頸椎X線攝影技術(shù)課件
- 領(lǐng)域政策解讀課件
- 《社會(huì)財(cái)務(wù)共享服務(wù)實(shí)務(wù)》課件-財(cái)務(wù)共享服務(wù)產(chǎn)生與發(fā)展
- DGJ08-81-2015 現(xiàn)有建筑抗震鑒定與加固規(guī)程
- 房屋租賃合同范本15篇
- 2025至2030年中國(guó)飛行控制器行業(yè)市場(chǎng)供需態(tài)勢(shì)及未來(lái)趨勢(shì)研判報(bào)告
- 2025年汽車維修工職業(yè)資格考試試卷及答案
- 安全B證題庫(kù)-安全生產(chǎn)知識(shí)考試用書
- 2025至2030年中國(guó)錦氨綸汗布市場(chǎng)分析及競(jìng)爭(zhēng)策略研究報(bào)告
- 2024年江蘇地質(zhì)局所屬事業(yè)單位招聘考試真題
- 2025年湖北省中考物理試題(含答案及解析)
- 幾何畫板 培訓(xùn)課件
- 2025年中小學(xué)暑假安全教育主題家長(zhǎng)會(huì) 課件
- 經(jīng)皮肺動(dòng)脈瓣置換術(shù)(TPVRPPVI)
評(píng)論
0/150
提交評(píng)論