using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.SqlClient;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Configuration;
using?DevExpress.XtraBars;
using?DevExpress.XtraEditors.Repository;
using?Microsoft.Office.Core;

namespace?edames
{
????public?partial?class?cailiao_out?:?Form
????{
????????public?cailiao_out（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?comboBox1_DropDown（object?sender?EventArgs?e）
????????{
????????????comboBox1.Items.Clear（）;
????????????string?connstr1;
????????????connstr1?=?System.Configuration.ConfigurationManager.AppSettings[“connstr“];
????????????SqlConnection?con?=?new?SqlConnection（connstr1）;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（“select?distinct?prd_orderno?from?prdorderno?“?con）;
????????????DataTable?tb?=?new?DataTable（）;
????????????try
????????????{
????????????????if?（con.State?==?ConnectionState.Closed）
????????????????{
????????????????????con.Open（）;
????????????????}
????????????????da.Fill（tb）;
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????comboBox1.Items.Add（tb.Rows[i][0].ToString（））;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????}
????????????finally
????????????{
????????????????if?（con.State?==?ConnectionState.Open）
????????????????{
????????????????????con.Close（）;
????????????????}
????????????}



????????}

????????private?void?comboBox2_DropDown（object?sender?EventArgs?e）
????????{


????????????comboBox2.Items.Clear（）;
????????????string?connstr1;
????????????connstr1?=?System.Configuration.ConfigurationManager.AppSettings[“connstr“];
????????????SqlConnection?con?=?new?SqlConnection（connstr1）;
????????????if?（this.comboBox1.Text?==?““）
????????????{
????????????????MessageBox.Show（“請先選擇生產訂單號“）;
????????????}
????????????else
????????????{
????????????????SqlDataAdapter?da1?=?new?SqlDataAdapter（“select?cinvcode?from?prdorderno?where?prd_orderno=‘“?+?this.comboBox1.Text.Trim（）?+?“‘?order?by?cinvcode“?con）;
????????????????DataTable?tb1?=?new?DataTable（）;
????????????????try
????????????????{
????????????????????if?（con.State?==?ConnectionState.Closed）
????????????????????{
????????????????????????con.Open（）;
????????????????????}
????????????????????da1.Fill（tb1）;
????????????????????for?（int?i?=?0;?i?????????????????????{
????????????????????????comboBox2.Items.Add（tb1.Rows[i][0].ToString（））;
????????????????????????//this.textBox2.Text=tb1.Rows[0
????????????????????}
????????????????}
????????????????catch?（Exception?ex）
????????????????{
????????????????????MessageBox.Show（ex.Message?“提示“?MessageBoxButtons.OK?MessageBox

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????908??2016-05-16?08:37??mes\edames\edames.sln

????..A..H.?????61440??2016-05-27?09:50??mes\edames\edames.suo

?????文件???????1489??2016-05-17?10:32??mes\edames\edames\app.config

?????文件???????9951??2016-05-25?11:14??mes\edames\edames\edames.csproj

?????文件????????452??2016-05-16?08:37??mes\edames\edames\edames.csproj.user

?????文件???????1160??2016-05-19?14:11??mes\edames\edames\Form1.cs

?????文件??????38895??2016-05-19?14:11??mes\edames\edames\Form1.Designer.cs

?????文件??????75951??2016-05-19?14:11??mes\edames\edames\Form1.resx

?????文件??????17052??2016-05-27?09:45??mes\edames\edames\Frm_import.cs

?????文件???????8478??2016-05-27?09:42??mes\edames\edames\Frm_import.Designer.cs

?????文件???????6224??2016-05-27?09:42??mes\edames\edames\Frm_import.resx

?????文件????????891??2016-05-16?08:37??mes\edames\edames\Person.cs

?????文件????????703??2016-05-24?10:16??mes\edames\edames\Program.cs

?????文件???????1270??2016-05-16?08:37??mes\edames\edames\Properties\AssemblyInfo.cs

?????文件????????799??2016-05-16?08:37??mes\edames\edames\Properties\licenses.licx

?????文件???????2836??2016-05-16?16:00??mes\edames\edames\Properties\Resources.Designer.cs

?????文件???????5612??2016-05-16?08:37??mes\edames\edames\Properties\Resources.resx

?????文件???????1085??2016-05-16?16:00??mes\edames\edames\Properties\Settings.Designer.cs

?????文件????????249??2016-05-16?08:37??mes\edames\edames\Properties\Settings.settings

?????文件???????7214??2016-05-27?09:43??mes\edames\edames\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????4608??2016-05-16?17:29??mes\edames\edames\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll

?????文件?????104244??2016-05-20?08:45??mes\edames\edames\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件??????68634??2016-05-27?08:59??mes\edames\edames\obj\Debug\ResolveAssemblyReference.cache

?????文件???????4608??2016-05-27?08:59??mes\edames\edames\obj\Debug\Interop.LCC11.dll

?????文件????????810??2016-05-27?08:59??mes\edames\edames\obj\Debug\edames.csproj.ResolveComReference.cache

?????文件????????180??2016-05-27?08:59??mes\edames\edames\obj\Debug\edames.cailiao_out.resources

?????文件????????180??2016-05-27?08:59??mes\edames\edames\obj\Debug\edames.cuke_total.resources

?????文件????????180??2016-05-27?08:59??mes\edames\edames\obj\Debug\edames.cuku_see.resources

?????文件??????46220??2016-05-27?08:59??mes\edames\edames\obj\Debug\edames.Form1.resources

?????文件????????180??2016-05-27?09:43??mes\edames\edames\obj\Debug\edames.Frm_import.resources

............此處省略84個文件信息