📄 frmbao.cs
字号:
this.textBox2.Location = new System.Drawing.Point(512, 204);
this.textBox2.Name = "textBox2";
this.textBox2.TabIndex = 9;
this.textBox2.Text = "";
//
// textBox3
//
this.textBox3.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.textBox3.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.textBox3.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.textBox3.Location = new System.Drawing.Point(512, 240);
this.textBox3.Name = "textBox3";
this.textBox3.TabIndex = 10;
this.textBox3.Text = "";
//
// textBox4
//
this.textBox4.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.textBox4.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.textBox4.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.textBox4.Location = new System.Drawing.Point(272, 204);
this.textBox4.Name = "textBox4";
this.textBox4.TabIndex = 11;
this.textBox4.Text = "";
//
// textBox5
//
this.textBox5.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.textBox5.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.textBox5.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.textBox5.Location = new System.Drawing.Point(272, 240);
this.textBox5.Name = "textBox5";
this.textBox5.TabIndex = 12;
this.textBox5.Text = "";
//
// textBox6
//
this.textBox6.BackColor = System.Drawing.SystemColors.ActiveCaptionText;
this.textBox6.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.textBox6.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.textBox6.Location = new System.Drawing.Point(512, 168);
this.textBox6.Name = "textBox6";
this.textBox6.TabIndex = 13;
this.textBox6.Text = "";
//
// label2
//
this.label2.BackColor = System.Drawing.SystemColors.Control;
this.label2.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label2.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.label2.Location = new System.Drawing.Point(168, 168);
this.label2.Name = "label2";
this.label2.TabIndex = 14;
this.label2.Text = "项目名称:";
//
// label3
//
this.label3.BackColor = System.Drawing.SystemColors.Control;
this.label3.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label3.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.label3.Location = new System.Drawing.Point(168, 204);
this.label3.Name = "label3";
this.label3.TabIndex = 15;
this.label3.Text = "级别:";
//
// label4
//
this.label4.BackColor = System.Drawing.SystemColors.Control;
this.label4.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label4.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.label4.Location = new System.Drawing.Point(168, 240);
this.label4.Name = "label4";
this.label4.TabIndex = 16;
this.label4.Text = "发生日期:";
//
// label5
//
this.label5.BackColor = System.Drawing.SystemColors.Control;
this.label5.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label5.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.label5.Location = new System.Drawing.Point(392, 240);
this.label5.Name = "label5";
this.label5.TabIndex = 19;
this.label5.Text = "处理员:";
//
// label6
//
this.label6.BackColor = System.Drawing.SystemColors.Control;
this.label6.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label6.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.label6.Location = new System.Drawing.Point(392, 204);
this.label6.Name = "label6";
this.label6.TabIndex = 18;
this.label6.Text = "录入员:";
//
// label7
//
this.label7.BackColor = System.Drawing.SystemColors.Control;
this.label7.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label7.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.label7.Location = new System.Drawing.Point(392, 168);
this.label7.Name = "label7";
this.label7.TabIndex = 17;
this.label7.Text = "当事人:";
//
// frmbao
//
this.AutoScaleBaseSize = new System.Drawing.Size(7, 14);
this.BackColor = System.Drawing.SystemColors.Control;
this.ClientSize = new System.Drawing.Size(648, 342);
this.Controls.Add(this.label5);
this.Controls.Add(this.label6);
this.Controls.Add(this.label7);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.textBox6);
this.Controls.Add(this.textBox5);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.label1);
this.Controls.Add(this.listView1);
this.Controls.Add(this.treeView1);
this.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.Name = "frmbao";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "保安巡查";
this.Load += new System.EventHandler(this.frmbao_Load);
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 应用程序的主入口点。
/// </summary>
private void frmbao_Load(object sender, System.EventArgs e)
{
try
{
objDataSet2=new DataSet();
objDataSet3=new DataSet();
objDataSet=new DataSet();
objSqlConn=new SqlConnection("database=atorregulate;uid=sa;password=;SERVER=(local)");
objSqlConn.Open();
abc();
objSqlDataAdapter=new SqlDataAdapter("select *from TABLE2",objSqlConn);
objSqlDataAdapter.Fill(objDataSet2,"TABLE2");
objSqlDataAdapter=new SqlDataAdapter("select *from TABLE3",objSqlConn);
objSqlDataAdapter.Fill(objDataSet3,"TABLE3");
objSqlDataAdapter=new SqlDataAdapter("select *from TABLE1",objSqlConn);
objSqlDataAdapter.Fill(objDataSet,"TABLE1");
}
catch(SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
////////////////////////////////////////9999999999999999999999
this.treeView1.Nodes.Clear();
TreeNode objNodeParent;
TreeNode objdsa;
for (int b=0;b<objDataSet2.Tables[0].Rows.Count;b++)
{
objNodeParent=treeView1.Nodes.Add(objDataSet2.Tables[0].Rows[b]["aaaaaa"].ToString());
for (int c=0;c<objDataSet3.Tables[0].Rows.Count;c++)
{
if(objDataSet2.Tables[0].Rows[b]["aaaaaa"].ToString()==objDataSet3.Tables[0].Rows[c]["qqqqqq"].ToString())
{
objdsa=objNodeParent.Nodes.Add(objDataSet3.Tables[0].Rows[c]["rrrrrr"].ToString());
}
}
}
}
private void treeView1_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
{
ewqdsa=e.Node.Text;
sad();
}
private void button1_Click(object sender, System.EventArgs e)
{
string insCmd="insert into TABLE1 values('"+this.textBox1.Text+"','"+ewq+"','"+this.textBox2.Text+"','"+this.textBox3.Text+"','"+this.textBox4.Text+"','"+this.textBox5.Text+"','"+this.textBox6.Text+"')";
this.objSqlCmd=new SqlCommand(insCmd,this.objSqlConn);
try
{
this.objSqlCmd.ExecuteNonQuery();
MessageBox.Show("成功插入事件");
abc();
sad();
button2.Enabled=false;
}
catch(SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, System.EventArgs e)
{
string str="delete TABLE1 where kkkkkk like '"+this.cxz+"'";
this.objSqlCmd=new SqlCommand(str,this.objSqlConn);
try
{
this.objSqlCmd.ExecuteNonQuery();
MessageBox.Show("成功删除事件");
abc();
sad();
}
catch(SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void listView1_Click(object sender, System.EventArgs e)
{
cxz =this.listView1.SelectedItems[0].Text;
button2.Enabled=true;
}
private void button3_Click(object sender, System.EventArgs e)
{
this.Close();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -