private void btnON_Click(object sender, EventArgs e)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
try
{
WebCommModel model = new WebCommModel();
if (ckbMend.Checked)
{
model.WBC_SERNO = My.GenSerNo();
DateTime d = DateTime.Parse(dateTimePicker1.Value.ToString());
model.WBC_DATE = d.ToString("yyyy-MM-dd");;
model.WBC_CLOCKIN = d.ToString("HH:mm");
WebCommDAL.Delete(connection, model.WBC_DATE);
if (WebCommDAL.Add(connection, model, PunchCard.ON) > 0)
{
MessageBox.Show(string.Format("補打卡上班 時間:{0} {1}", model.WBC_DATE, model.WBC_CLOCKIN));
}
else
{
MessageBox.Show("打卡發生異常!");
}
}
else
{
model.WBC_SERNO = My.GenSerNo();
model.WBC_DATE = DateTime.Now.ToString("yyyy-MM-dd");;
model.WBC_CLOCKIN = DateTime.Now.AddMinutes(-1).ToString("HH:mm");
if (WebCommDAL.GetSernoByDate(connection, DateTime.Now.ToString("yyyy-MM-dd")) != string.Empty)
{
MessageBox.Show("今日已打卡過!");
return;
}
if (WebCommDAL.Add(connection, model, PunchCard.ON) > 0)
{
MessageBox.Show(string.Format("打卡上班 時間:{0} {1}", model.WBC_DATE, model.WBC_CLOCKIN));
}
else
{
MessageBox.Show("打卡發生異常!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
