Newer
Older
EMS_SZ / TaskInfo.cs
root on 21 Mar 2016 4 KB first
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.OracleClient;
using Cyberpipe;

namespace EMS
{
    public partial class TaskInfo : Form
    {
        int taskid = 0;
        public TaskInfo(int taskid)
        {
            this.taskid = taskid;
            InitializeComponent();
        }
        //OracleConnection conn = null;
        private DataGridView dataGridView1;
        private DevComponents.DotNetBar.ButtonItem buttonItem1;
        private DevComponents.DotNetBar.ComboBoxItem comboBoxItem1;
        private DevComponents.DotNetBar.ButtonItem buttonItem2;
        private DevComponents.DotNetBar.ButtonItem buttonItem3;
        //OracleDataAdapter sda = null;
        DataTable dt = new DataTable();

        private void TaskInfo_Load(object sender, EventArgs e)
        {
            try
            {
                string sql="select * from MARK_TASK where TASK_ID ='" + taskid + "' order by DBID";
                dt = OracleUtils.ExecuteDataset(OracleUtils.ConnectionString, CommandType.Text, sql).Tables[0];

                dataGridView1.DataSource = dt;
                if (dt.Rows.Count == 0)
                {
                    MessageBox.Show("没有相应详细任务信息!", "提示");
                    this.Close();
                    return;
                }
                else
                {
                    dataGridView1.Columns[0].ReadOnly = true;
                    dataGridView1.AllowUserToAddRows = false;
                    dataGridView1.Columns[0].DefaultCellStyle.BackColor = Color.LightGray;
                    dataGridView1.Columns[0].HeaderText = "定位点编号";
                    dataGridView1.Columns[1].HeaderText = "定位时间";
                    dataGridView1.Columns[2].HeaderText = "是否定位";
                    dataGridView1.Columns[3].HeaderText = "标识器编号";
                    dataGridView1.Columns[4].HeaderText = "任务编号";
                }
            }
            catch(Exception ex)
            {
                MessageBox.Show("任务信息加载失败:" + ex.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void InitializeComponent()
        {
            this.dataGridView1 = new System.Windows.Forms.DataGridView();
            this.buttonItem1 = new DevComponents.DotNetBar.ButtonItem();
            this.buttonItem1 = new DevComponents.DotNetBar.ButtonItem();
            this.comboBoxItem1 = new DevComponents.DotNetBar.ComboBoxItem();
            this.buttonItem2 = new DevComponents.DotNetBar.ButtonItem();
            this.buttonItem3 = new DevComponents.DotNetBar.ButtonItem();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
            this.SuspendLayout();
            // 
            // dataGridView1
            // 
            this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.dataGridView1.Location = new System.Drawing.Point(0, 0);
            this.dataGridView1.Name = "dataGridView1";
            this.dataGridView1.RowTemplate.Height = 23;
            this.dataGridView1.Size = new System.Drawing.Size(705, 430);
            this.dataGridView1.TabIndex = 3;
            // 
            // bar1
            // 




            // 
            // button_first
            // 
            this.buttonItem1.Name = "button_first";
            this.buttonItem1.Text = "|<首页";
            // 
            // buttonItem1
            // 
            this.buttonItem1.Name = "buttonItem1";
            this.buttonItem1.Text = "buttonItem1";
            // 
            // comboBoxItem1
            // 
            this.comboBoxItem1.DropDownHeight = 106;
            this.comboBoxItem1.ItemHeight = 17;
            this.comboBoxItem1.Name = "comboBoxItem1";
            // 
            // buttonItem2
            // 
            this.buttonItem2.Name = "buttonItem2";
            this.buttonItem2.Text = "buttonItem2";
            // 
            // buttonItem3
            // 
            this.buttonItem3.Name = "buttonItem3";
            this.buttonItem3.Text = "buttonItem3";
            // 
            // TaskInfo
            // 
            this.ClientSize = new System.Drawing.Size(705, 430);
            this.Controls.Add(this.dataGridView1);
            this.Name = "TaskInfo";
            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
            this.Text = "工单详细信息";
            this.Load += new System.EventHandler(this.TaskInfo_Load);
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
            this.ResumeLayout(false);

        }
         
    }
}