?? system.cs
字號:
?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 人事管理
{
public partial class system : Form
{
data da = new data();
public system()
{
InitializeComponent();
}
private void system_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter("select * from SystemEventView", da.link());
sqlda.Fill(ds, "SystemEvent");
systemview.DataSource = ds.Tables["SystemEvent"];
da.link().Close();
}
//查詢
private void selectbtn_Click(object sender, EventArgs e)
{
selectsystem selesy = new selectsystem();
selesy.ShowDialog();
DataSet ds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter("select * from SystemEventView WHERE 事件發生時間 >= '" + selectsystem.aa + "' and 事件發生時間 <= '" + selectsystem.bb + "'", da.link());
sqlda.Fill(ds, "SystemEvent");
systemview.DataSource = ds.Tables["SystemEvent"];
da.link().Close();
}
//確定
private void yesbtn_Click(object sender, EventArgs e)
{
DialogResult sss = MessageBox.Show("請確認要退出!", "請確認要退出!", MessageBoxButtons.YesNo);
if (sss == DialogResult.Yes)
{
this.Close();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -