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

下載本文檔

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

文檔簡介

1、ϵͳÖ÷½çÃæ£¨frmMain.cs£©using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Diagnostics;namespace warehousepubl

2、ic partial class frmMain : Formpublic frmMain()InitializeComponent();private void frmMain_Load(object sender, EventArgs e)tsslUser.Text = "²Ù×÷Óû§È¨ÏÞ£º" + frmLogin.M_str_right.ToString().Trim();tsslDate.Text = DateTime

3、.Today.ToLongDateString();tsslTime.Text = "µÇ¼ϵͳʱ¼ä£º" + DateTime.Now.ToShortTimeString();if (frmLogin.M_str_right.ToString().Trim() = "ÆÕͨÓû§")Èë¿&#

4、226;¹ÜÀíToolStripMenuItem.Enabled = false;³ö¿â¹ÜÀíToolStripMenuItem.Enabled = false;½è»õ»¹»õToolStripMenuItem.Enabled = false;¹©»õÉÌÉèÖÃToolStripMenuI

5、tem.Enabled = false;»õÎïµµ°¸ÉèÖÃToolStripMenuItem.Enabled = false;²Ö¿âÉèÖÃToolStripMenuItem.Enabled = false;ȨÏÞÉèÖÃToolStripMenuItem.Enabled = false;Ó

6、5;»§¹ÜÀíToolStripMenuItem.Enabled = false;btnIS.Enabled = false;btnOS.Enabled = false;btnBR.Enabled = false;btnPI.Enabled = false;btnGI.Enabled = false;btnSI.Enabled = false;btnRI.Enabled = false;btnUM.Enabled = false;private void btnIS_Click(object sender, EventArgs e)

7、/Èë¿â¹ÜÀíGoodsManage.frmISManage GMfism = new warehouse.GoodsManage.frmISManage();/GMfism.Show();GMfism.ShowDialog();/ÕâÁ½¸öº¯Êý¾Í¿´Ë­»ñµÃ½¹µ

8、7;£¬Ç°Õ߸¸´°¿ÚÒ²¿É»ñµÃ½¹µã£¬ºóÕßÖ»ÓÐд´½¨µÄ´°Ìå1 / 29private void btn

9、OS_Click(object sender, EventArgs e)/³ö¿â¹ÜÀíGoodsManage.frmOSManage GMfosm = new warehouse.GoodsManage.frmOSManage();GMfosm.ShowDialog();private void btnBR_Click(object sender, EventArgs e)/½è»õ»¹»õ¹ÜÀ

10、37;GoodsManage.frmBGManage GMfbgm = new warehouse.GoodsManage.frmBGManage();GMfbgm.ShowDialog();private void btnPI_Click(object sender, EventArgs e)/¹©Ó¦ÉÌÉèÖÃBasicInfo.frmPrInfo BIfpi = new warehouse.BasicInfo.frmPrInfo();BIfpi.ShowDialog();private

11、void btnGI_Click(object sender, EventArgs e)/»õÎïµµ°¸ÉèÖÃBasicInfo.frmGoodsInfo BIfgi = new warehouse.BasicInfo.frmGoodsInfo();BIfgi.ShowDialog();private void btnSI_Click(object sender, EventArgs e)/²Ö¿âÉèÖ

12、;ÃBasicInfo.frmStoreInfo BIfsi = new warehouse.BasicInfo.frmStoreInfo();BIfsi.ShowDialog();private void btnISL_Click(object sender, EventArgs e)/Èë¿â²éѯLookandSum.frmISLook LSfisl = new warehouse.LookandSum.frmISLook();LSfisl.ShowDialog();private void bt

13、nSL_Click(object sender, EventArgs e)/¿â´æ²éѯLookandSum.frmGILook LSfgil = new warehouse.LookandSum.frmGILook();LSfgil.ShowDialog();private void btnGOL_Click(object sender, EventArgs e)/»õÎï½è³ö²éѯL

14、ookandSum.frmBGLook LSfbgl = new warehouse.LookandSum.frmBGLook();LSfbgl.ShowDialog();private void btnGIL_Click(object sender, EventArgs e)/»õÎï¹é»¹²éѯLookandSum.frmRGLook LSfrgl = new warehouse.LookandSum.frmRGLook();LSfrgl.ShowDialog();p

15、rivate void btnOSL_Click(object sender, EventArgs e)/³ö¿â²éѯLookandSum.frmOSLook LSfosl = new warehouse.LookandSum.frmOSLook();LSfosl.ShowDialog();private void btnEP_Click(object sender, EventArgs e)/¸ü¸ÄÃÜÂëSystemSet.f

16、rmEditPwd HPfep = new warehouse.SystemSet.frmEditPwd();HPfep.ShowDialog();private void btnRI_Click(object sender, EventArgs e)/ȨÏÞ¹ÜÀíSystemSet.frmRightManage HPfrm = new warehouse.SystemSet.frmRightManage();HPfrm.ShowDialog();private void btnUM_Click(object

17、sender, EventArgs e)/Óû§¹ÜÀíSystemSet.frmUserManage HPfum = new warehouse.SystemSet.frmUserManage();HPfum.ShowDialog();private void btnAU_Click(object sender, EventArgs e)/¹ØÓÚ±¾ÏµÍ³SystemSet.frmAboutUs HPfau

18、= new warehouse.SystemSet.frmAboutUs();HPfau.ShowDialog();private void btnCH_Click(object sender, EventArgs e)if (MessageBox.Show("ÄãÕæµÄҪעÏúµ±Ç°Óû§", "Ìáʾ"

19、, MessageBoxButtons.OKCancel, MessageBoxIcon.Information) = DialogResult.OK)warehouse.frmLogin frmlogin = new frmLogin();this.Hide();frmlogin.Show();private void btnExit_Click(object sender, EventArgs e)/Í˳öϵͳthis.Close();/<=>Application.Exit();privat

20、e void frmMain_FormClosed(object sender, FormClosedEventArgs e)if (MessageBox.Show("ÄúÕæµÄÒªÍ˳ö±¾ÏµÍ³Âð£¿", "Ìáʾ", MessageBoxButtons.OKCancel, Messa

21、geBoxIcon.Information) = DialogResult.OK)Application.Exit();elsefrmMain fmain = new frmMain();fmain.Show();private void Èë¿â¹ÜÀíToolStripMenuItem_Click(object sender, EventArgs e)btnIS_Click(sender, e);private void ³ö¿â¹ÜÀ

22、37;ToolStripMenuItem_Click(object sender, EventArgs e)btnOS_Click(sender,e);private void ½è»õ»¹»õToolStripMenuItem_Click(object sender, EventArgs e)btnBR_Click(sender, e);private void ¹©»õÉÌÉèÖÃToolStripMenuIte

23、m_Click(object sender, EventArgs e)btnPI_Click(sender, e);private void »õÎïµµ°¸ÉèÖÃToolStripMenuItem_Click(object sender, EventArgs e)btnGI_Click(sender, e);private void ²Ö¿âÉèÖÃToolStripMenuItem_Clic

24、k(object sender, EventArgs e)btnSI_Click(sender, e);private void ¿â´æ²éѯToolStripMenuItem_Click(object sender, EventArgs e)btnSL_Click(sender, e);private void Èë¿â²éѯToolStripMenuItem_Click(object sender, EventArgs e)b

25、tnISL_Click(sender, e);private void ³ö¿â²éѯToolStripMenuItem_Click(object sender, EventArgs e)btnOSL_Click(sender, e);private void »õÎï½è³ö²éѯToolStripMenuItem_Click(object sender, EventArgs e)btnGO

26、L_Click(sender, e);private void »õÎï¹é»¹²éѯToolStripMenuItem_Click(object sender, EventArgs e)btnGIL_Click(sender, e);private void ¸ü¸ÄÃÜÂëToolStripMenuItem_Click(object sender, EventArgs e)btnEP_Cli

27、ck(sender, e);private void ȨÏÞÉèÖÃToolStripMenuItem_Click(object sender, EventArgs e)btnRI_Click(sender, e);private void Óû§¹ÜÀíToolStripMenuItem_Click(object sender, EventArgs e)btnUM_Click(sender, e);private void 

28、85;ØÓÚ±¾ÏµÍ³ToolStripMenuItem_Click(object sender, EventArgs e)btnAU_Click(sender, e);private void »õÎï¹ÜÀíToolStripMenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 0;private void »ù&#

29、177;¾µµ°¸ToolStripMenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 1;private void ²éѯͳ¼ÆToolStripMenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 2;private void ϵͳÉ

30、èÖÃToolStripMenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 3;private void ×¢ÏúToolStripMenuItem_Click(object sender, EventArgs e)btnCH_Click(sender, e);private void Í˳öϵͳToolStripMenuItem_Click(objec

31、t sender, EventArgs e)btnExit_Click(sender, e);private void toolStripStatusLabel6_Click(object sender, EventArgs e)System.Diagnostics.Process.Start("");¡¡¡¡»õÎïµµ°¸¹ÜÀí£¨Èë¿â frmIn

32、Manage.cs£©using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace warehouse.GoodsManagepublic partial class frmISManage : Formwarehouse.BaseClass.Dat

33、aCon datacon = new warehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate();public frmISManage()InitializeComponent();private void frmISManage_Load(object sender, EventArgs e)dgvISManage.Controls.Add(hScrollBar1);/Êý¾ÝÔ&#

34、180;¿Ø¼þÖÐÌí¼ÓÁËÒ»¸öˮƽ¹ö¶¯Ìõdoperate.cboxBind("select StoreName from tb_Storage", "tb_Storage", "StoreName", cboxSName);/²Ö¿

35、;âÃû×ÖÏÔʾ³öÀ´doperate.cboxBind("select PrName from tb_Provider", "tb_Provider", "PrName", cboxPName);/¼ÆÁ¿µ¥Î»ÏÔʾ³öÀ´DataSe

36、t myds = datacon.getds("select ISID as Èë¿â±àºÅ,GoodsID as »õÎï±àºÅ,GoodsName as »õÎïÃû³Æ,PrName as ¹©Ó¦ÉÌÃû³Æ,"+ "

37、StoreName as ²Ö¿âÃû³Æ,GoodsSpec as »õÎï¹æ¸ñ,GoodsUnit as ¼ÆÁ¿µ¥Î»,GoodsNum as Èë¿âÊýÁ¿,"+ "GoodsPrice as »õÎï&

38、#181;¥¼Û,GoodsAPrice as ×ܽð¶î,ISDate as Èë¿âÈÕÆÚ,HandlePeople as ¾­ÊÖ,"+ "ISRemark as ±¸×¢from tb_InStore", "tb_InStore");dgvISManage.DataSource = my

39、ds.Tables0;/datasetÖеĵÚÒ»¸ödatatable 0<=>"tb_InStore"private void btnAdd_Click(object sender, EventArgs e)if (txtISGID.Text = "")MessageBox.Show("»õÎï±àºÅ²»ÄÜ

40、;Ϊ¿Õ£¡", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtISGName.Text = "")MessageBox.Show("»õÎïÃû³Æ²»ÄÜΪ¿Õ", "

41、ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtGIPrice.Text = "")MessageBox.Show("»õÎïµ¥¼Û²»ÄÜΪ¿Õ£¡", "ÐÅÏ¢", Message

42、BoxButtons.OK, MessageBoxIcon.Information);if (txtISGNum.Text = "")MessageBox.Show("Èë¿âÊýÁ¿²»ÄÜΪ¿Õ", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtGS

43、pec.Text = "")MessageBox.Show("»õÎï¹æ¸ñ²»ÄÜΪ¿Õ", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtHPeople.Text = "")MessageBox.Show("¾

44、;­ÊÖ²»ÄÜΪ¿Õ", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);elseint P_int_returnValue = doperate.InsertGoods(Convert.ToInt32(txtISGID.Text.Trim(), txtISGName.Text.Trim(),cboxPName.Text.Trim(), cbox

45、SName.Text.Trim(), txtGSpec.Text.Trim(), cboxGUnit.Text.Trim(),Convert.ToInt32(txtISGNum.Text.Trim(), Convert.ToDecimal(txtGIPrice.Text.Trim(), txtHPeople.Text.Trim(), txtISRemark.Text.Trim();if (P_int_returnValue = 100)MessageBox.Show("¸Ã»õÎïºÅÒ

46、9;¾­±»Õ¼Óã¡", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);else if (P_int_returnValue = 200)MessageBox.Show("ÕâÀà»õÎïÒѾ­´æ

47、12;ÚΩһ±àºÅ£¡", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);elseMessageBox.Show("»õÎïÈë¿â³É¹¦£¡", "ÐÅ

48、;Ï¢", MessageBoxButtons.OK, MessageBoxIcon.Information);frmISManage_Load(sender, e);private void btnDel_Click(object sender, EventArgs e)/ try/ /ɾ³ýÏÂÃæÊý¾ÝÔ´¿Ø¼þÖеģ&#

49、172;ָʾµÄÊý¾ÝÏîdatacon.getcom("delete from tb_InStore where ISID="+ Convert.ToString(dgvISManage0, dgvISManage.CurrentCell.RowIndex.Value).Trim() + "");/Convert.ToString(dataGridView11,dataGridView1.CurrentCell.RowIndex

50、.Value).Trim();/ À´È¡µÃËùÑ¡ÖеÄÄÇÐÐÊý¾ÝijÁеÄÖµ.MessageBox.Show("»õÎïɾ³ý³É¹¦£&#

51、161;", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);frmISManage_Load(sender, e);/catch (Exception ex)/ MessageBox.Show(ex.Message, "¾¯¸æ", MessageBoxButtons.OK, MessageBoxIcon.Warning);/private void btnExit_Click(object se

52、nder, EventArgs e)this.Close();private void dgvISManage_CellClick(object sender, DataGridViewCellEventArgs e)/*datagridview¿Ø¼þÓÐÒ»¸öCellClickʼþÊǵ±µ¥»÷datagridview¿Ø¼þ

53、µÄÈÎÒⲿ·ÖÊÇ·¢Éú.È»ºóÔÙÓà Convert.ToString(dataGridView11,dataGridView1.CurrentCell.RowIndex.Value).Trim(); À´È¡µÃËùÑ¡ÖÐ

54、µÄÄÇÐÐÊý¾ÝijÁеÄÖµ*/txtISGID.Text = Convert.ToString(dgvISManage1,dgvISManage.CurrentCell.RowIndex.Value).Trim();txtISGName.Text = Convert.ToString(dgvISManage2, dgvISManage.CurrentCell.RowIndex.Value).Trim();c

55、boxSName.Text = Convert.ToString(dgvISManage4, dgvISManage.CurrentCell.RowIndex.Value).Trim();cboxPName.Text = Convert.ToString(dgvISManage3, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtGSpec.Text = Convert.ToString(dgvISManage5, dgvISManage.CurrentCell.RowIndex.Value).Trim();cboxGUnit.Text =

56、Convert.ToString(dgvISManage6, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtISGNum.Text = Convert.ToString(dgvISManage7, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtGIPrice.Text = Convert.ToString(dgvISManage8, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtGSPrice.Text = Convert.ToStr

57、ing(dgvISManage9, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtHPeople.Text = Convert.ToString(dgvISManage11, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtISRemark.Text = Convert.ToString(dgvISManage12, dgvISManage.CurrentCell.RowIndex.Value).Trim();private void txtGIPrice_TextChanged(obje

58、ct sender, EventArgs e)trytxtGSPrice.Text = Convert.ToString(Convert.ToDecimal(txtGIPrice.Text.Trim() * Convert.ToInt32(txtISGNum.Text.Trim().Trim();/Convert.ToDecimal(txtGIPrice.Text.Trim()½«Îı¾Öµ×ªÎªDecimalÊýÖµ/½

59、«Êý×ÖµÄÖ¸¶¨String ±íʾÐÎʽת»»ÎªµÈЧµÄDecimal Êý×Ö¡£catch (Exception ex)MessageBox.Show(ex.Message, "¾

60、75;¸æ", MessageBoxButtons.OK, MessageBoxIcon.Warning);private void frmISManage_FormClosed(object sender, FormClosedEventArgs e)this.Close();private void button1_Click(object sender, EventArgs e)this.txtGIPrice.Text = ""this.txtGSpec.Text = ""this.txtHPeople.Text =

61、""this.txtISGID.Text = ""this.txtISGName.Text = ""this.txtISGNum.Text = ""this.txtISRemark.Text = ""this.txtGIPrice.Text = ""this.txtGSPrice.Text = ""¡¡¡¡³ö¿â¹ÜÀí£&#

62、168;frmOsManage.cs£©using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace warehouse.GoodsManagepublic partial class frmOSManage : Formwarehouse.Base

63、Class.DataCon datacon = new warehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate();public frmOSManage()InitializeComponent();private void frmOSManage_Load(object sender, EventArgs e)dgvOSManage.Controls.Add(hScrollBar1);doperate.cboxBind("

64、select distinct StoreName from tb_InStore", "tb_InStore", "StoreName", cboxSName);DataSet myds = datacon.getds("select OSID as ³ö¿â±àºÅ,StoreName as ²Ö¿âÃû³Æ,GoodsName as »õÎ&

65、#239;Ãû³Æ,"+ "GoodsSpec as ¹æ¸ñ,GoodsUnit as ¼ÆÁ¿µ¥Î»,GoodsNum as ³ö¿âÊýÁ¿,GoodsPrice as ¼Û¸ñ,GoodsAPrice as ×ܽð¶î,&quo

66、t;+ "OSDate as ³ö¿âÈÕÆÚ,PGProvider as Ìá»õµ¥Î»,PGPeople as Ìá»õ,"+ "HandlePeople as ¾­ÊÖ,OSRemark as ±¸×¢from tb_OutStore", "tb_OutStor

67、e");dgvOSManage.DataSource = myds.Tables"tb_OutStore"private void btnAdd_Click(object sender, EventArgs e)trySqlDataReader sqlread = datacon.getread("select GoodsNum from tb_GoodsInfo"+ " where StoreName='" + cboxSName.Text.Trim() + "' and GoodsName=&#

68、39;"+ cboxGName.Text.Trim() + "' and GoodsSpec='" + cboxGSpec.Text.Trim() + "'");if (sqlread.Read()if (Convert.ToInt32(txtOSGNum.Text.Trim() > Convert.ToInt32(sqlread"GoodsNum".ToString().Trim()MessageBox.Show("²Ö¿âÖ

69、8;ûÓÐ×ã¹»µÄ»õÎ", "Ìáʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);elsedatacon.getcom("insert into tb_OutStore(StoreName,GoodsName,GoodsSpec,GoodsUnit," + GoodsNum

70、,GoodsPrice,PGProvider,PGPeople,HandlePeople,OSRemark)"+ " values('" + cboxSName.Text.Trim() + "','" + cboxGName.Text.Trim() + "','" + cboxGSpec.Text.Trim() + "','" + cboxGUnit.Text.Trim() + "',"+ txtOSGNum.Text.T

71、rim() + "," + txtGOPrice.Text.Trim() + ",'" + txtOSUnit.Text.Trim() + "','" +txtOSPeople.Text.Trim() + "','" + txtHPeople.Text.Trim() + "','" + txtOSRemark.Text.Trim() + "')"); MessageBox.Show("»

72、45;Îï³ö¿â³É¹¦£¡", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);frmOSManage_Load(sender, e);sqlread.Close();catch (Exception ex)MessageBox.Show(ex.Message, "¾¯¸æ",

73、 MessageBoxButtons.OK, MessageBoxIcon.Warning);private void btnDel_Click(object sender, EventArgs e)trydatacon.getcom("delete from tb_OutStore where OSID="+ Convert.ToString(dgvOSManage0, dgvOSManage.CurrentCell.RowIndex.Value).Trim() + "");MessageBox.Show("»õÎ

74、;ïɾ³ý³É¹¦£¡", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);frmOSManage_Load(sender, e);catch (Exception ex)MessageBox.Show(ex.Message, "¾¯¸æ", MessageBoxButtons.OK, M

75、essageBoxIcon.Warning);private void btnExit_Click(object sender, EventArgs e)this.Close();private void dgvOSManage_CellClick(object sender, DataGridViewCellEventArgs e)cboxSName.Text = Convert.ToString(dgvOSManage1, dgvOSManage.CurrentCell.RowIndex.Value).Trim();cboxGName.Text = Convert.ToString(dgv

76、OSManage2, dgvOSManage.CurrentCell.RowIndex.Value).Trim();cboxGSpec.Text = Convert.ToString(dgvOSManage3, dgvOSManage.CurrentCell.RowIndex.Value).Trim();cboxGUnit.Text = Convert.ToString(dgvOSManage4, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSGNum.Text = Convert.ToString(dgvOSManage5, dgvO

77、SManage.CurrentCell.RowIndex.Value).Trim();txtGOPrice.Text = Convert.ToString(dgvOSManage6, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtGSPrice.Text = Convert.ToString(dgvOSManage7, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSUnit.Text = Convert.ToString(dgvOSManage9, dgvOSManage.Curre

78、ntCell.RowIndex.Value).Trim();txtOSPeople.Text = Convert.ToString(dgvOSManage10, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtHPeople.Text = Convert.ToString(dgvOSManage11, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSRemark.Text = Convert.ToString(dgvOSManage12, dgvOSManage.CurrentCell.

79、RowIndex.Value).Trim();private void cboxSName_SelectedIndexChanged(object sender, EventArgs e)doperate.cboxBind("select distinct GoodsName from tb_InStore where StoreName='"+ cboxSName.Text.Trim() + "'", "tb_InStore", "GoodsName", cboxGName);private vo

80、id cboxGName_SelectedIndexChanged(object sender, EventArgs e)doperate.cboxBind("select distinct GoodsSpec from tb_InStore where StoreName='"+ cboxSName.Text.Trim() + "' and GoodsName='" + cboxGName.Text.Trim()+ "'", "tb_InStore", "GoodsSpe

81、c", cboxGSpec);SqlDataReader sqlread = datacon.getread("select GoodsUnit,GoodsOutPrice,GoodsNum from tb_GoodsInfo"+ " where StoreName='" + cboxSName.Text.Trim()+ "' and GoodsName='" + cboxGName.Text.Trim() + "'");if (sqlread.Read()this.cboxGUnit.Text = sqlread"GoodsUnit".ToString().Trim();this.txtGOPrice.Text = qlread"GoodsOutPrice".ToString().Trim();this.tbxshenxia.Text = sqlread"GoodsNum".ToString().Trim();sqlread.Close();private void txtOSGNum_T

溫馨提示

  • 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

提交評論