using System; using System.Data; using System.Drawing; using System.Windows.Forms; using DevComponents.DotNetBar; namespace Cyberpipe { public partial class TaskInfo : Form { int taskid = 0; public TaskInfo(int taskid) { this.taskid = taskid; InitializeComponent(); } //OracleConnection conn = null; private DataGridView dataGridView1; private ButtonItem buttonItem1; private ComboBoxItem comboBoxItem1; private ButtonItem buttonItem2; private 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("没有相应详细任务信息!", "提示"); Close(); return; } 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() { dataGridView1 = new DataGridView(); buttonItem1 = new ButtonItem(); buttonItem1 = new ButtonItem(); comboBoxItem1 = new ComboBoxItem(); buttonItem2 = new ButtonItem(); buttonItem3 = new ButtonItem(); ((System.ComponentModel.ISupportInitialize)(dataGridView1)).BeginInit(); SuspendLayout(); // // dataGridView1 // dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; dataGridView1.Dock = DockStyle.Fill; dataGridView1.Location = new Point(0, 0); dataGridView1.Name = "dataGridView1"; dataGridView1.RowTemplate.Height = 23; dataGridView1.Size = new Size(705, 430); dataGridView1.TabIndex = 3; // // button_first // buttonItem1.Name = "button_first"; buttonItem1.Text = "|<首页"; // // buttonItem1 // buttonItem1.Name = "buttonItem1"; buttonItem1.Text = "buttonItem1"; // // comboBoxItem1 // comboBoxItem1.DropDownHeight = 106; comboBoxItem1.ItemHeight = 17; comboBoxItem1.Name = "comboBoxItem1"; // // buttonItem2 // buttonItem2.Name = "buttonItem2"; buttonItem2.Text = "buttonItem2"; // // buttonItem3 // buttonItem3.Name = "buttonItem3"; buttonItem3.Text = "buttonItem3"; // // TaskInfo // ClientSize = new Size(705, 430); Controls.Add(dataGridView1); Name = "TaskInfo"; StartPosition = FormStartPosition.CenterScreen; Text = "工单详细信息"; Load += new EventHandler(TaskInfo_Load); ((System.ComponentModel.ISupportInitialize)(dataGridView1)).EndInit(); ResumeLayout(false); } } }