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個文件信息