?? workmanege.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 workmanege : Form
{
data da = new data();
public workmanege()
{
InitializeComponent();
}
private void workmanege_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
sqlda.Fill(ds, "WorkerAttendance");
worklistview.DataSource = ds.Tables["WorkerAttendance"];
da.link().Close();
}
//本日情況
private void todaybtn_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
string aa = dt.ToString("yyyy-MM-dd 00:00:00");
string bb = dt.ToString("yyyy-MM-dd 23:00:00");
DataSet ds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView WHERE 日期 >= '" + aa + "' and 日期 <= '" + bb + "'", da.link());
sqlda.Fill(ds, "WorkerAttendance");
worklistview.DataSource = ds.Tables["WorkerAttendance"];
da.link().Close();
}
//歷史查詢
private void selecthistrybtn_Click(object sender, EventArgs e)
{
selectwork selwo = new selectwork();
selwo.ShowDialog();
DataSet ds = new DataSet();
string sql = "select * from WorkerAttendanceView WHERE 日期 >= '" + selectwork.aa + "' and 日期 <= '" + selectwork.bb + "'";
SqlDataAdapter sqlda = new SqlDataAdapter(sql, da.link());
sqlda.Fill(ds, "WorkerAttendance");
worklistview.DataSource = ds.Tables["WorkerAttendance"];
da.link().Close();
}
//確定
private void yesbtn_Click(object sender, EventArgs e)
{
this.Close();
}
//考勤設置
private void setbtn_Click(object sender, EventArgs e)
{
if (worklistview.DataSource != null && worklistview.CurrentCell != null)
{
DataSet ds = new DataSet();
SqlDataAdapter sqlda1 = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
sqlda1.Fill(ds);
SetAttendanceType sat = new SetAttendanceType();
sat.Tag = ds.Tables[0].Rows[worklistview.CurrentCell.RowIndex][0].ToString().Trim();
sat.ShowDialog();
da.link().Close();
SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
sqlda.Fill(ds, "WorkerAttendance");
worklistview.DataSource = ds.Tables["WorkerAttendance"];
}
else
MessageBox.Show("沒有指定的考勤信息");
//SetAttendanceType sat = new SetAttendanceType();
//sat.ShowDialog();
//DataSet ds = new DataSet();
//string sql = "select * from WorkerAttendance";
//SqlDataAdapter sqlda = new SqlDataAdapter(sql, da.link());
//sqlda.Fill(ds, "WorkerAttendance");
//worklistview.DataSource = ds.Tables["WorkerAttendance"];
//da.link().Close();
}
private void setinbtn_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter("select * from WorkerAttendanceView", da.link());
sqlda.Fill(ds, "WorkerAttendance");
worklistview.DataSource = ds.Tables["WorkerAttendance"];
da.link().Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -