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); } } }