private void TimeSet_Load(object sender, EventArgs e)
{
this.Top = f1.Top + (f1.Height - this.Height) / 2;
this.Left = f1.Left + (f1.Width - this.Width) / 2;
//現在年の日本の祝日を取得する
NationalHoliday = GetHoliday.GetNationalHolidays(int.Parse(DateTime.Today.ToString("yyyy")), AccessKey, f1.LocalHoliday);
}
/// <summary>
/// データベースへ勤務情報を登録
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string memo_str = "NULL";
string tmpDate;
string tmpDay;
string tmpMonth;
bool flg = false;
DateTime cmpWorkStartTime;
DateTime cmpWorkEndTime;
DateTime cmpBreakStartTime;
DateTime cmpBreakEndTime;
DateTime dt1 = new DateTime(2014, 1, 1, 0, 0, 0); //初期化
if ((cmbWST_h.Text == "" || cmbWST_m.Text == "") ||
(cmbWET_h.Text == "" || cmbWET_m.Text == "") ||
(cmbBST_h.Text == "" || cmbBST_m.Text == "") ||
(cmbBET_h.Text == "" || cmbBET_m.Text == ""))
{
MessageBox.Show(this, "入力に誤りがあります", "エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
cmpWorkStartTime = DateTime.Parse(f1.lblYear.Text + "/" + f1.lblMonth.Text + "/" + f1.DaysArray[i].Text + " " + cmbWST_h.Text + ":" + cmbWST_m.Text + ":00");
cmpWorkEndTime = DateTime.Parse(f1.lblYear.Text + "/" + f1.lblMonth.Text + "/" + f1.DaysArray[i].Text + " " + cmbWET_h.Text + ":" + cmbWET_m.Text + ":00");
cmpBreakStartTime = DateTime.Parse(f1.lblYear.Text + "/" + f1.lblMonth.Text + "/" + f1.DaysArray[i].Text + " " + cmbBST_h.Text + ":" + cmbBST_m.Text + ":00");
cmpBreakEndTime = DateTime.Parse(f1.lblYear.Text + "/" + f1.lblMonth.Text + "/" + f1.DaysArray[i].Text + " " + cmbBET_h.Text + ":" + cmbBET_m.Text + ":00");
if ((cmpWorkStartTime.CompareTo(cmpWorkEndTime) == 1) ||
(cmpBreakStartTime.CompareTo(cmpBreakEndTime) == 1))
{
MessageBox.Show(this, "入力に誤りがあります", "エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
//指定年の日本の祝日を取得する
NationalHoliday = GetHoliday.GetNationalHolidays(int.Parse(f1.lblYear.Text), AccessKey, f1.LocalHoliday);
foreach (GetHoliday.NationalHoliday NationalHoliday2 in NationalHoliday)
{
if (f1.DaysArray[i].Text != "")
{
//2ケタ補正
if (f1.DaysArray[i].Text.Length != 2)
{
tmpDay = "0" + f1.DaysArray[i].Text;
}
else
{
tmpDay = f1.DaysArray[i].Text;
}
if (f1.lblMonth.Text.Length != 2)
{
tmpMonth = "0" + f1.lblMonth.Text;
}
else
{
tmpMonth = f1.lblMonth.Text;
}
tmpDate = f1.lblYear.Text + "/" + tmpMonth + "/" + tmpDay + " 0:00:00";
try
{
dt1 = DateTime.Parse(tmpDate);
if (string.Compare(tmpDate, NationalHoliday2.Date.ToString()) == 0)
{
flg = true; //祝日
}
}
catch (Exception) { }
}
}
//2ケタ補正
if (f1.DaysArray[i].Text.Length != 2)
{
tmpDay = "0" + f1.DaysArray[i].Text;
}
else
{
tmpDay = f1.DaysArray[i].Text;
}
if (f1.lblMonth.Text.Length != 2)
{
tmpMonth = "0" + f1.lblMonth.Text;
}
else
{
tmpMonth = f1.lblMonth.Text;
}
if (txtMemo.Text == "")
{
memo_str = "NULL";
}
else
{
memo_str = "\r\n" + txtMemo.Text;
}
if (flg == true)
{
sql = "insert into Manage (CDate, CYear, CMonth, CDay, HourlyWage, WorkStartTime, WorkEndTime, BreakStartTime, BreakEndTime, Memo) values ("
+ "'" + f1.lblYear.Text + "-" + tmpMonth + "-" + tmpDay + "', "
+ f1.lblYear.Text + ", "
+ f1.lblMonth.Text + ", "
+ f1.DaysArray[i].Text + ", "
+ f1.TimeMoneyK.Text + ", "
+ "'" + cmbWST_h.Text + ":" + cmbWST_m.Text + ":00', "
+ "'" + cmbWET_h.Text + ":" + cmbWET_m.Text + ":00', "
+ "'" + cmbBST_h.Text + ":" + cmbBST_m.Text + ":00', "
+ "'" + cmbBET_h.Text + ":" + cmbBET_m.Text + ":00', "
+ "'" + memo_str + "')";
}
else if (string.Compare(dt1.ToString("ddd"), "土") == 0) //土曜日
{
sql = "insert into Manage (CDate, CYear, CMonth, CDay, HourlyWage, WorkStartTime, WorkEndTime, BreakStartTime, BreakEndTime, Memo) values ("
+ "'" + f1.lblYear.Text + "-" + tmpMonth + "-" + tmpDay + "', "
+ f1.lblYear.Text + ", "
+ f1.lblMonth.Text + ", "
+ f1.DaysArray[i].Text + ", "
+ f1.TimeMoneyK.Text + ", "
+ "'" + cmbWST_h.Text + ":" + cmbWST_m.Text + ":00', "
+ "'" + cmbWET_h.Text + ":" + cmbWET_m.Text + ":00', "
+ "'" + cmbBST_h.Text + ":" + cmbBST_m.Text + ":00', "
+ "'" + cmbBET_h.Text + ":" + cmbBET_m.Text + ":00', "
+ "'" + memo_str + "')";
}
else if (string.Compare(dt1.ToString("ddd"), "日") == 0) //日曜日
{
sql = "insert into Manage (CDate, CYear, CMonth, CDay, HourlyWage, WorkStartTime, WorkEndTime, BreakStartTime, BreakEndTime, Memo) values ("
+ "'" + f1.lblYear.Text + "-" + tmpMonth + "-" + tmpDay + "', "
+ f1.lblYear.Text + ", "
+ f1.lblMonth.Text + ", "
+ f1.DaysArray[i].Text + ", "
+ f1.TimeMoneyK.Text + ", "
+ "'" + cmbWST_h.Text + ":" + cmbWST_m.Text + ":00', "
+ "'" + cmbWET_h.Text + ":" + cmbWET_m.Text + ":00', "
+ "'" + cmbBST_h.Text + ":" + cmbBST_m.Text + ":00', "
+ "'" + cmbBET_h.Text + ":" + cmbBET_m.Text + ":00', "
+ "'" + memo_str + "')";
}
else
{
sql = "insert into Manage (CDate, CYear, CMonth, CDay, HourlyWage, WorkStartTime, WorkEndTime, BreakStartTime, BreakEndTime, Memo) values ("
+ "'" + f1.lblYear.Text + "-" + tmpMonth + "-" + tmpDay + "', "
+ f1.lblYear.Text + ", "
+ f1.lblMonth.Text + ", "
+ f1.DaysArray[i].Text + ", "
+ f1.TimeMoneyH.Text + ", "
+ "'" + cmbWST_h.Text + ":" + cmbWST_m.Text + ":00', "
+ "'" + cmbWET_h.Text + ":" + cmbWET_m.Text + ":00', "
+ "'" + cmbBST_h.Text + ":" + cmbBST_m.Text + ":00', "
+ "'" + cmbBET_h.Text + ":" + cmbBET_m.Text + ":00', "
+ "'" + memo_str + "')";
}
f1.timer1.Enabled = false;
using (SQLiteConnection conn = new SQLiteConnection(gDataSource))
{
try
{
conn.Open();
command = new SQLiteCommand(sql, conn);
command.ExecuteNonQuery();
f1.ToolTip_Reload();
f1.timer1.Enabled = true;
Close();
}
catch (Exception ex)
{
MessageBox.Show(this, "Error : " + ex.Message, "エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conn.Close();
}
}
}
}
}
