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; }