




版權(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)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。
最新文檔
- 鐵路勞動安全培訓(xùn)
- 安全生產(chǎn)的核心要素
- 塑料廠消防應(yīng)急預(yù)案
- 企業(yè)提取安全生產(chǎn)費(fèi)用應(yīng)當(dāng)怎么核算
- 闖紅燈的交通事故
- 山東省沂源縣二中2025年高一物理第二學(xué)期期末統(tǒng)考試題含解析
- 2025年內(nèi)蒙古烏拉特前旗第一中學(xué)物理高一第二學(xué)期期末調(diào)研試題含解析
- 2025年重慶市南川三校聯(lián)盟物理高二第二學(xué)期期末學(xué)業(yè)水平測試試題含解析
- 吉林省長春市榆樹市2025年高二物理第二學(xué)期期末學(xué)業(yè)水平測試試題含解析
- 2025年新疆高一物理第二學(xué)期期末達(dá)標(biāo)檢測試題含解析
- 2025年中小學(xué)暑假安全教育主題家長會 課件
- 2025年佛山市南海區(qū)圖書館招聘題庫帶答案分析
- 醫(yī)院職業(yè)暴露醫(yī)務(wù)人員銳器傷登記表
- 學(xué)與教的心理學(xué)第6版(師范專業(yè)心理學(xué))PPT完整全套教學(xué)課件
- 甲狀腺相關(guān)性眼病的診治進(jìn)展課件
- 小升初易錯成語總結(jié)
- 郵輪基礎(chǔ)英語PPT全套教學(xué)課件
- 初一語文現(xiàn)代文閱讀題及答案
- GMP質(zhì)量管理體系文件 玻璃器皿檢定規(guī)程
- 三年級英語閱讀理解(打印)
- GB/T 4169.19-2006塑料注射模零件第19部分:澆口套
評論
0/150
提交評論