仓库管理系统代码

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;£¬Ç°Õ߸¸´°¿ÚÒ²¿É»ñµÃ½¹µã£¬ºóÕßÖ»ÓÐд´½¨µÄ´°Ìåprivate void btnOS_Cli

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

10、dsManage.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 void b

11、tnGI_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 btnSL_Cl

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

14、Sum.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();private

15、 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.frmEdit

16、Pwd 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 sender

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

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

19、ageBoxButtons.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();private void

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

21、con.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 ³ö¿â¹ÜÀíToo

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

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

24、ct 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)btnISL_

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

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

27、der, 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、16;ÓÚ±¾ÏµÍ³ToolStripMenuItem_Click(object sender, EventArgs e)btnAU_Click(sender, e);private void »õÎï¹ÜÀíToolStripMenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 0;private void »ù±&#

29、190;µµ°¸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(object send

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

32、.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.DataCon d

33、atacon = 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、191;ؼþÖÐÌí¼ÓÁËÒ»¸öˮƽ¹ö¶¯Ìõdoperate.cboxBind("select StoreName from tb_Storage", "tb_Storage", "StoreName", cboxSName);/²Ö¿â

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

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

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

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

39、les0;/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("»õÎïµ¥¼Û²»ÄÜΪ¿Õ£¡", "ÐÅÏ¢", MessageBoxBut

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

43、xt = "")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(), cboxSName.

45、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、0;­±»Õ¼Óã¡", "ÐÅÏ¢", MessageBoxButtons.OK, MessageBoxIcon.Information);else if (P_int_returnValue = 200)MessageBox.Show("ÕâÀà»õÎïÒѾ­´æÔ

47、18;Ωһ±àºÅ£¡", "ÐÅÏ¢", 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、214;¸Ê¾µÄÊý¾ÝÏîdatacon.getcom("delete from tb_InStore where ISID="+ Convert.ToString(dgvISManage0, dgvISManage.CurrentCell.RowIndex.Value).Trim() + "");/Convert.ToString(dataGridView11,dataGridView1.CurrentCell.RowIndex.Value

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

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

52、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();cboxSNa

55、me.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 = Conver

56、t.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.ToString(dg

57、vISManage9, 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(object sen

58、der, 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、84;æ", 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 = ""¡¡¡¡³ö¿â¹ÜÀí£¨fr

62、mOsManage.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.BaseClass.

63、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("select

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

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

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

67、;);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='&qu

68、ot;+ 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、5;»ÓÐ×ã¹»µÄ»õÎ", "Ìáʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);elsedatacon.getcom("insert into tb_OutStore(StoreName,GoodsName,GoodsSpec,GoodsUnit," + GoodsNum,Goods

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

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

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

73、geBoxButtons.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, Message

75、BoxIcon.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(dgvOSMana

76、ge2, 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, dgvOSManag

77、e.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.CurrentCell

78、.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.RowInd

79、ex.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 void cbo

80、xGName_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", "GoodsSpec"

81、;, 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_TextChanged(object sender, EventArgs e)trytxtGS