C#条码仓库管理系统的设计与开发—统计、报表模块(14)
时间:2016-12-12 22:53 来源:毕业论文 作者:毕业论文 点击:次
MessageBox.Show(ex.Message); } finally { } } 4.2.8 货物库存模块 本系统的货物库存量查询界面入图4.19所示： 图4.19 货物库存量查询界面设计图 private void SelDriveInfo_Load(object sender, System.EventArgs e) { try { this.sqlConnection1.ConnectionString= "server=.;Trusted_Connection=yes;user=sa;pwd=1;database=storage";//建立连接 this.sqlConnection1.Open(); DataSet driveSet=new DataSet(); driveAdapter.SelectCommand.CommandText="SELECT * FROM drivestorage"; driveAdapter.SelectCommand.Connection=sqlConnection1; driveAdapter.Fill(driveInfo); DataGridTableStyle dr = new DataGridTableStyle(); dr.AlternatingBackColor = Color.Blue;//颜色设置 dr.MappingName = driveInfo.TableName; } catch(Exception ex) { MessageBox.Show(ex.Message); } finally { } } 4.2.9 货物需求模块 本系统的货物需求模块分为采购计划界面和采购计划查询界面，分别如图4.20和图4.21所示 图4.20 新增货物采购计划界面设计图 private void buyFrm_Load(object sender, System.EventArgs e) { this.textNum.Focus(); this.textDate.Text = DateTime.Now.ToString(); } 图4.21 采购计划查询界面设计图 private void SelBuy_Load(object sender, System.EventArgs e) { try { this.sqlConnection1.ConnectionString= "server=.;Trusted_Connection=yes;user=sa;pwd=1;database=storage";//建立连接 this.sqlConnection1.Open(); DataSet buySet=new DataSet(); (责任编辑：qin) |