制造MES系统

制造MES系统，车间管理，制造MES系统，车间管理，制造MES系统，车间管理

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 < tb.Rows.Count; 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 < tb1.Rows.Count; 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个文件信息