DBStore.rar

基于C#的仓库管理系统，这个系统使用Winform进行开发的，全部都是窗体，注意，不是网站，是窗体，本次开发的过程中使用了很多的技术，都是一些基本的项目要求，需要用的小伙伴可以，进行下载练习来学习一下，点击我的博客里面有很多的项目可以学习使用

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WFAStoreInfo
{
    public partial class AddInputInfoForm : Form
    {
        private SqlConnection sqlconn = null;
        private SqlCommand sqlcmd = null;
        public AddInputInfoForm（）
        {
            InitializeComponent（）;
            this.sqlconn = new SqlConnection（DB.DBConnStr.ConnStr）;
            this.sqlcmd = new SqlCommand（）;
            this.sqlcmd.Connection = this.sqlconn;
        }

        private void Cancel_button_Click（object sender EventArgs e）
        {
            this.Close（）;
        }

        private void Clear_button_Click（object sender EventArgs e）
        {
           this.WZBH_comboB.Text=““;
           this.WZMC_textB.Text=““;
           this.WZXH_textB.Text = ““;
           this.LB_textB.Text = ““;
           this.DW_textB.Text = ““;
           this.SL_textB.Text = ““;
           this.DJ_textB.Text = ““;
           this.JE_textB.Text = ““;
           this.RKSJ_dateTimeP.Text =DateTime.Now.ToLongDateString（）;
           this.JBR_textB.Text = ““;
           this.BGR_textB.Text = ““;
           this.CK_textB.Text = ““;
        }

        private void AddInputInfoForm_Load（object sender EventArgs e）
        {
            DataSet ds = new DataSet（）;
            SqlDataAdapter sadp = new SqlDataAdapter（““ sqlconn）;
            sadp.SelectCommand.CommandText = “select MID from materialinfo“;
            sadp.Fill（ds）;
           this.WZBH_comboB.DataSource = ds.Tables[0].DefaultView;
           this.WZBH_comboB.DisplayMember = “MID“;
            this.WZBH_comboB.ValueMember = “MID“;
        }

       

        private void WZBH_comboB_SelectedIndexChanged（object sender EventArgs e）
        {
            DataSet ds = new DataSet（）;
           SqlDataAdapter sadp = new SqlDataAdapter（““sqlconn）;
           string sql = “select MID MName MModel MType MUnit from materialinfo where MID=‘“ + WZBH_comboB.Text.Trim（） + “‘“;
            sadp.SelectCommand.CommandText = sql;
            sadp.Fill（ds）;
            if （ds.Tables[0].Rows.Count>0）
            {
              this.WZMC_textB.Text = ds.Tables[0].Rows[0][1].ToString（）.Trim（）;
            this.WZXH_textB.Text = ds.Tables[0].Rows[0][2].ToString（）.Trim（）;
            this.LB_textB.Text = ds.Tables[0].Rows[0][3].ToString（）.Trim（）;
            this.DW_textB.Text = ds.Tables[0].Rows[0][4].ToString（）.Trim（）;  
            }
            
        }

        private void Save_button_Click（object sender EventArgs e）
        {
            if （WZBH_comboB.Text.Trim（）==““）
            {
                MessageBox.Show（“请填写物资编号！““提示“）;
                return;
            }
            try
            {
                if （sqlconn.State != ConnectionState.Open）
 

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件    6291456  2019-03-31 09:23  DBStore\StoreDB.mdf

     文件    3211264  2019-03-31 09:23  DBStore\StoreDB_log.ldf

     文件       4525  2016-12-19 19:56  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddInputInfoForm.cs

     文件      20139  2016-12-19 19:26  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddInputInfoForm.Designer.cs

     文件       5817  2016-12-19 19:26  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddInputInfoForm.resx

     文件       2484  2016-12-19 10:48  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddMaterialForm.cs

     文件      10499  2016-12-19 10:46  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddMaterialForm.Designer.cs

     文件       5817  2016-12-19 10:46  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddMaterialForm.resx

     文件       5282  2016-12-25 14:11  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddOutputForm.cs

     文件      19084  2016-12-25 14:02  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddOutputForm.Designer.cs

     文件       5817  2016-12-25 14:02  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddOutputForm.resx

     文件       2496  2016-12-18 21:31  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddRoleForm.cs

     文件       9218  2016-12-18 21:03  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddRoleForm.Designer.cs

     文件       5817  2016-12-18 21:03  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AddRoleForm.resx

     文件       3118  2016-12-18 18:28  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AdduserForm.cs

     文件       8358  2016-12-18 18:26  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AdduserForm.Designer.cs

     文件       5817  2016-12-18 18:26  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\AdduserForm.resx

     文件        240  2016-12-17 17:07  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\App.config

     文件        240  2016-12-17 17:07  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\app.publish\Application Files\WFAStoreInfo_1_0_0_0\WFAStoreInfo.exe.config.deploy

     文件      99840  2017-05-24 08:13  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\app.publish\Application Files\WFAStoreInfo_1_0_0_0\WFAStoreInfo.exe.deploy

     文件       7125  2017-05-24 08:13  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\app.publish\Application Files\WFAStoreInfo_1_0_0_0\WFAStoreInfo.exe.manifest

     文件     431592  2017-05-24 08:13  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\app.publish\setup.exe

     文件       5701  2017-05-24 08:13  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\app.publish\WFAStoreInfo.application

     文件       1909  2017-05-24 08:15  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\WFAStoreInfo.application

     文件      99840  2017-05-24 08:15  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\WFAStoreInfo.exe

     文件        240  2016-12-17 17:07  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\WFAStoreInfo.exe.config

     文件       3408  2017-05-24 08:15  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\WFAStoreInfo.exe.manifest

     文件     179712  2017-05-24 08:15  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\WFAStoreInfo.pdb

     文件       1909  2017-05-24 08:15  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\WFAStoreInfo.vshost.application

     文件      11600  2017-05-24 08:15  DBStore\WFA-StoreInfo\WFAStoreInfo\WFAStoreInfo\bin\Debug\WFAStoreInfo.vshost.exe

............此处省略98个文件信息