/// <summary>
/// 入力データをDBに登録
/// </summary>
private void SaveCountLimitDay()
{
DataTable dtCountLimitDay;
DataRow drCountLimitDay;
dtCountLimitDay = clsDataTableControl.GetTable_CountLimitDay();
drCountLimitDay = dtCountLimitDay.NewRow();
// 既存データの削除
clsDatabaseControl.DeleteCountLimitDay_Ward(pstrTargetWard);
// データを登録(看護師)
for (int iDayOfWeek = 1; iDayOfWeek <= 8; iDayOfWeek++)
{
drCountLimitDay["ward"] = pstrTargetWard;
drCountLimitDay["staff_kind"] = "01";
drCountLimitDay["day_of_week"] = String.Format("{0:D2}", iDayOfWeek);
switch (String.Format("{0:D2}", iDayOfWeek))
{
case "01":
drCountLimitDay["day_min"] = txtNurseMinDaySun.Text;
drCountLimitDay["night_max"] = txtNurseMaxNightSun.Text;
break;
case "02":
drCountLimitDay["day_min"] = txtNurseMinDayMon.Text;
drCountLimitDay["night_max"] = txtNurseMaxNightMon.Text;
break;
case "03":
drCountLimitDay["day_min"] = txtNurseMinDayTue.Text;
drCountLimitDay["night_max"] = txtNurseMaxNightTue.Text;
break;
case "04":
drCountLimitDay["day_min"] = txtNurseMinDayWed.Text;
drCountLimitDay["night_max"] = txtNurseMaxNightWed.Text;
break;
case "05":
drCountLimitDay["day_min"] = txtNurseMinDayThu.Text;
drCountLimitDay["night_max"] = txtNurseMaxNightThu.Text;
break;
case "06":
drCountLimitDay["day_min"] = txtNurseMinDayFri.Text;
drCountLimitDay["night_max"] = txtNurseMaxNightFri.Text;
break;
case "07":
drCountLimitDay["day_min"] = txtNurseMinDaySat.Text;
drCountLimitDay["night_max"] = txtNurseMaxNightSat.Text;
break;
case "08":
drCountLimitDay["day_min"] = txtNurseMinDayHol.Text;
drCountLimitDay["night_max"] = txtNurseMaxNightHol.Text;
break;
}
clsDatabaseControl.InsertCountLimitDay(drCountLimitDay);
}
// データを登録(ケア)
for (int iDayOfWeek = 1; iDayOfWeek <= 8; iDayOfWeek++)
{
drCountLimitDay["ward"] = pstrTargetWard;
drCountLimitDay["staff_kind"] = "02";
drCountLimitDay["day_of_week"] = String.Format("{0:D2}", iDayOfWeek);
switch (String.Format("{0:D2}", iDayOfWeek))
{
case "01":
drCountLimitDay["day_min"] = txtCareMinDaySun.Text;
drCountLimitDay["night_max"] = txtCareMaxNightSun.Text;
break;
case "02":
drCountLimitDay["day_min"] = txtCareMinDayMon.Text;
drCountLimitDay["night_max"] = txtCareMaxNightMon.Text;
break;
case "03":
drCountLimitDay["day_min"] = txtCareMinDayTue.Text;
drCountLimitDay["night_max"] = txtCareMaxNightTue.Text;
break;
case "04":
drCountLimitDay["day_min"] = txtCareMinDayWed.Text;
drCountLimitDay["night_max"] = txtCareMaxNightWed.Text;
break;
case "05":
drCountLimitDay["day_min"] = txtCareMinDayThu.Text;
drCountLimitDay["night_max"] = txtCareMaxNightThu.Text;
break;
case "06":
drCountLimitDay["day_min"] = txtCareMinDayFri.Text;
drCountLimitDay["night_max"] = txtCareMaxNightFri.Text;
break;
case "07":
drCountLimitDay["day_min"] = txtCareMinDaySat.Text;
drCountLimitDay["night_max"] = txtCareMaxNightSat.Text;
break;
case "08":
drCountLimitDay["day_min"] = txtCareMinDayHol.Text;
drCountLimitDay["night_max"] = txtCareMaxNightHol.Text;
break;
}
clsDatabaseControl.InsertCountLimitDay(drCountLimitDay);
}
}
