📄 frmbao.cs
字号:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace WindowsApplication1
{
/// <summary>
/// frmbao 的摘要说明。
/// </summary>
public class frmbao : System.Windows.Forms.Form
{
private System.Windows.Forms.TreeView treeView1;
private System.Windows.Forms.ListView listView1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.ColumnHeader columnHeader1;
private System.Windows.Forms.ColumnHeader columnHeader2;
private System.Windows.Forms.ColumnHeader columnHeader3;
private System.Windows.Forms.ColumnHeader columnHeader4;
private System.Windows.Forms.ColumnHeader columnHeader5;
private System.Windows.Forms.ColumnHeader columnHeader6;
private System.Windows.Forms.ColumnHeader columnHeader7;
private SqlConnection objSqlConn;
private DataSet objDataSet1;
private DataSet objDataSet2;
private DataSet objDataSet3;
private DataSet objDataSet;
private SqlCommand objSqlCmd;
private SqlParameter objSqlParam;
private string ewqdsa;
private string ewq="";
private string cxz;
private SqlDataAdapter objSqlDataAdapter;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.TextBox textBox6;
private void abc()
{
objDataSet1=new DataSet();
objSqlDataAdapter=new SqlDataAdapter("select *from TABLE1",objSqlConn);
objSqlDataAdapter.Fill(objDataSet1,"TABLE1");
}
private void sad()
{
this.listView1.Items.Clear();
button1.Enabled=false;
for (int c=0;c<objDataSet3.Tables[0].Rows.Count;c++)
{
if(ewqdsa==objDataSet3.Tables[0].Rows[c]["rrrrrr"].ToString())
{
button1.Enabled=true;
ewq=objDataSet3.Tables[0].Rows[c]["wwwwww"].ToString();
for (int a=0;a<objDataSet1.Tables[0].Rows.Count;a++)
{
if(objDataSet1.Tables[0].Rows[a]["wwwwww"].ToString()==objDataSet3.Tables[0].Rows[c]["wwwwww"].ToString())
{
ListViewItem IstItem=new ListViewItem();
IstItem.SubItems.Clear();
IstItem.SubItems[0].Text=objDataSet1.Tables[0].Rows[a]["kkkkkk"].ToString();
IstItem.SubItems.Add(objDataSet1.Tables[0].Rows[a]["ssssss"].ToString());
IstItem.SubItems.Add(objDataSet1.Tables[0].Rows[a]["dddddd"].ToString());
IstItem.SubItems.Add(objDataSet1.Tables[0].Rows[a]["aaaaaa"].ToString());
IstItem.SubItems.Add(objDataSet1.Tables[0].Rows[a]["q1"].ToString());
IstItem.SubItems.Add(objDataSet1.Tables[0].Rows[a]["q2"].ToString());
listView1.Items.Add(IstItem);
}
}
}
}
}
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;
public frmbao()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.treeView1 = new System.Windows.Forms.TreeView();
this.listView1 = new System.Windows.Forms.ListView();
this.columnHeader1 = new System.Windows.Forms.ColumnHeader();
this.columnHeader2 = new System.Windows.Forms.ColumnHeader();
this.columnHeader3 = new System.Windows.Forms.ColumnHeader();
this.columnHeader4 = new System.Windows.Forms.ColumnHeader();
this.columnHeader5 = new System.Windows.Forms.ColumnHeader();
this.columnHeader6 = new System.Windows.Forms.ColumnHeader();
this.columnHeader7 = new System.Windows.Forms.ColumnHeader();
this.label1 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.textBox6 = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.SuspendLayout();
//
// treeView1
//
this.treeView1.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.treeView1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.treeView1.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.treeView1.ImageIndex = -1;
this.treeView1.Location = new System.Drawing.Point(16, 40);
this.treeView1.Name = "treeView1";
this.treeView1.SelectedImageIndex = -1;
this.treeView1.Size = new System.Drawing.Size(144, 272);
this.treeView1.TabIndex = 1;
this.treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView1_AfterSelect);
//
// listView1
//
this.listView1.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.listView1.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
this.columnHeader1,
this.columnHeader2,
this.columnHeader3,
this.columnHeader4,
this.columnHeader5,
this.columnHeader6,
this.columnHeader7});
this.listView1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.listView1.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.listView1.Location = new System.Drawing.Point(176, 16);
this.listView1.Name = "listView1";
this.listView1.Size = new System.Drawing.Size(464, 136);
this.listView1.TabIndex = 3;
this.listView1.View = System.Windows.Forms.View.Details;
this.listView1.Click += new System.EventHandler(this.listView1_Click);
//
// columnHeader1
//
this.columnHeader1.Text = "序号";
this.columnHeader1.Width = 40;
//
// columnHeader2
//
this.columnHeader2.Text = "项目名称";
this.columnHeader2.Width = 70;
//
// columnHeader3
//
this.columnHeader3.Text = "级别";
this.columnHeader3.Width = 76;
//
// columnHeader4
//
this.columnHeader4.Text = "发生日期";
this.columnHeader4.Width = 102;
//
// columnHeader5
//
this.columnHeader5.Text = "当事人";
//
// columnHeader6
//
this.columnHeader6.Text = "录入员";
//
// columnHeader7
//
this.columnHeader7.Text = "处理员";
//
// label1
//
this.label1.BackColor = System.Drawing.SystemColors.Control;
this.label1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label1.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.label1.Location = new System.Drawing.Point(16, 16);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(96, 16);
this.label1.TabIndex = 4;
this.label1.Text = "类别/项目";
//
// button1
//
this.button1.BackColor = System.Drawing.SystemColors.Control;
this.button1.Enabled = false;
this.button1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.button1.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.button1.Location = new System.Drawing.Point(288, 288);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(104, 24);
this.button1.TabIndex = 5;
this.button1.Text = "插入";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.BackColor = System.Drawing.SystemColors.Control;
this.button2.Enabled = false;
this.button2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.button2.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.button2.Location = new System.Drawing.Point(408, 288);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(96, 24);
this.button2.TabIndex = 6;
this.button2.Text = "册除";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.BackColor = System.Drawing.SystemColors.Control;
this.button3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.button3.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.button3.Location = new System.Drawing.Point(520, 288);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(96, 24);
this.button3.TabIndex = 7;
this.button3.Text = "退出";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// textBox1
//
this.textBox1.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.textBox1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.textBox1.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.textBox1.Location = new System.Drawing.Point(272, 168);
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 8;
this.textBox1.Text = "";
//
// textBox2
//
this.textBox2.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.textBox2.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.textBox2.ForeColor = System.Drawing.SystemColors.ActiveCaption;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -