/// <summary>
/// 勤務希望シフト登録
/// </summary>
public void SaveRequestData()
{
DataTable dtRequestShift;
DataRow drRequestShift;
string strTargetMonthForHeader = frmMainSchedule.lblTargetMonth.Text.Substring(0, 4) + frmMainSchedule.lblTargetMonth.Text.Substring(5, 2);
string strSQL = "";
int piRequestStaffCount = frmMainSchedule.grdMain.Rows.Count;
int piDayCount = frmMainSchedule.grdMain.ColumnCount - 1;
// 希望シフトの作成
strSQL = clsDatabaseControl.GetInsertRequestShift_Insert();
for (int iRequestStaff = 0; iRequestStaff < piRequestStaffCount; iRequestStaff++)
{
for (int iDay = 1; iDay <= piDayCount; iDay++)
{
if (frmMainSchedule.grdMain[iDay, iRequestStaff].Value.ToString() != "")
{
dtRequestShift = clsDataTableControl.GetTable_RequestShift();
drRequestShift = dtRequestShift.NewRow();
drRequestShift["staff"] = frmMainSchedule.astrScheduleStaff[iRequestStaff, 0];
drRequestShift["ward"] = frmMainSchedule.cmbWard.SelectedValue.ToString();
drRequestShift["staff_kind"] = frmMainSchedule.pstrStaffKind;
drRequestShift["target_date"] = clsCommonControl.GetTargetDateChangeFormat(strTargetMonthForHeader + String.Format("{0:D2}", iDay));
drRequestShift["work_kind"] = clsCommonControl.GetWorkKindID(frmMainSchedule.grdMain[iDay, iRequestStaff].Value.ToString(), frmMainSchedule.astrWorkKind);
strSQL += clsDatabaseControl.GetInsertRequestShift_Values(drRequestShift);
}
}
}
if (clsDatabaseControl.ExecuteBulkInsertSQL(strSQL) == false)
{
MessageBox.Show("勤務希望シフトの登録に失敗しました。");
}
}