private void btn_gotoWork_Click(object sender, EventArgs e)
{
GotoWork dlgGotoWork = new GotoWork(this);
dlgGotoWork.ShowDialog();
if (dlgGotoWork.DialogResult == DialogResult.OK)
{
conn = new MySqlConnection(strConn);
conn.Open();
cmd = new MySqlCommand("", conn);
string sql = "SELECT 출근시간 FROM commuting_time WHERE 아이디='" + LoginForm.uid + "'";
cmd.CommandText = sql;
reader = cmd.ExecuteReader();
string[] attendTime = { };
while (reader.Read())
{
attendTime = reader["출근시간"].ToString().Split(' ');
}
reader.Close();
// 출근 체크한 날짜가 DB에 있는 출근 날짜와 같지 않을 때 실행
if (attendTime[0].ToString() != DateTime.Now.ToString("yyyy-MM-dd"))
{
string dateTime = DateTime.Now.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss");
sql = "UPDATE commuting_time SET ";
sql += " 출근시간='" + dateTime + "', " + "퇴근시간=NULL, ";
sql += "작업라인='" + GotoWork.strWorkLine + "', 책임유무='" + GotoWork.strYesNo + "' ";
sql += " WHERE 아이디='" + LoginForm.uid + "'";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
else
{
MessageBox.Show("출근 처리가 이미 되었습니다.");
}
}
}
public CheckForm(GotoWork form)
{
InitializeComponent();
this.gotoWorkForm = form;
}
