/// <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("勤務希望シフトの登録に失敗しました。"); } }