private void b_regist_Click(object sender, EventArgs e) { //入力チェック chk.clear(); chk.addControl(d_Shooting_purpose); chk.addControl(d_facility); //chk.addControl(t_name); //chk.addControl(t_name_kana); //chk.addControl(d_sex2); //chk.addControl(d_height); //chk.addControl(d_foot); //chk.addControl(d_sleeve); if (chk.check("W00000", chk.checkControlImportant)) { return; } //桁数チェック //20 chk.clear(); chk.addControl(d_facility); chk.addControl(t_name); if (chk.check("W00001", chk.checkTextboxLength, 20)) { return; } //40 chk.clear(); chk.addControl(t_name_kana); if (chk.check("W00001", chk.checkTextboxLength, 40)) { return; } //4 chk.clear(); chk.addControl(d_height); chk.addControl(d_foot); chk.addControl(d_sleeve); if (chk.check("W00001", chk.checkTextboxLength, 4)) { return; } //フォーマットチェック chk.clear(); chk.addControl(d_height); chk.addControl(d_foot); chk.addControl(d_sleeve); if (chk.check("W00003", chk.checkTextboxFormat, @"\d{1,4}?\z", @"半角数字")) { return; } for (int i = 0; d_renral_result.Rows.Count > i; i++) { if (costumeReservationList[i].costume_reservation_code == "") { costumeReservationList[i].costume_reservation_code = DB.t_costume_reservation.getNewcostume_reservation_code(); } costumeReservationList[i].memo = d_renral_result.Rows[i].Cells[11].Value == null ? "" : d_renral_result.Rows[i].Cells[11].Value.ToString(); if (d_Cancellation_date.Checked) { costumeReservationList[i].cancellation_date = d_Cancellation_date.Value; } else { costumeReservationList[i].cancellation_date = null; } costumeReservationList[i].shooting_purpose = Enum.GetNames(typeof(Utile.Data.撮影目的)).ToList()[d_Shooting_purpose.SelectedIndex]; costumeReservationList[i].facility = d_facility.Text; costumeReservationList[i].name = t_name.Text; costumeReservationList[i].name_kana = t_name_kana.Text; if (d_sex2.SelectedIndex != -1) { costumeReservationList[i].sex = d_sex2.SelectedIndex.ToString(); } else { costumeReservationList[i].sex = null; } if (dt_birthday.Checked) { costumeReservationList[i].birthday = dt_birthday.Value; } else { costumeReservationList[i].birthday = null; } if (d_height.Text != "") { costumeReservationList[i].height = int.Parse(d_height.Text); } else { costumeReservationList[i].height = null; } if (d_foot.Text != "") { costumeReservationList[i].foot = int.Parse(d_foot.Text); } else { costumeReservationList[i].foot = null; } if (d_sleeve.Text != "") { costumeReservationList[i].sleeve = int.Parse(d_sleeve.Text); } else { costumeReservationList[i].sleeve = null; } costumeReservationList[i].Command(); var res = new DB.t_reservation(); res.costume_reservation_code = costumeReservationList[i].costume_reservation_code; res.reservation_code = MainForm.session_t_reception.reception_code; res.facility_reservation_code = " "; res.Command(); } pageParent.PageRefresh(); MainForm.backPage(this); }
private void b_regist_Click(object sender, EventArgs e) { if (d_check.Checked) { // 必須チェック chk.clear(); chk.addControl(d_start_time); chk.addControl(d_end_time); if (chk.check("W00000", chk.checkControlImportant)) { return; } chk.clear(); //フォーマットチェック chk.addControl(d_start_time); chk.addControl(d_end_time); if (chk.check("W00003", chk.checkTextboxFormat, @"^([0-9]|[0-1][0-9]|[2][0-3]):[0-5][0-9]$", "00:00")) { return; } chk.clear(); //桁数チェック chk.addControl(d_start_time); chk.addControl(d_end_time); if (chk.check("W00001", chk.checkTextboxLength, 5)) { return; } chk.clear(); chk.addControl(d_tekiyou); if (chk.check("W00001", chk.checkTextboxLength, 256)) { return; } chk.clear(); //施設予約登録処理(スケジュール) if (facility_reservation.facility_reservation_code == null) { facility_reservation.facility_reservation_code = DB.t_facility_reservation.getNewFacility_reservation_code(); } facility_reservation.start_date = d_start_date.Value; facility_reservation.start_time = TimeSpan.Parse(d_start_time.Text); facility_reservation.end_date = d_end_date.Value; facility_reservation.end_time = TimeSpan.Parse(d_end_time.Text); facility_reservation.reservator = null; facility_reservation.remarks = d_tekiyou.Text; facility_reservation.cancellation_date = null; facility_reservation.shooting_purpose = null; facility_reservation.photographer = null; facility_reservation.task_class = null; facility_reservation.selection_start_date = null; facility_reservation.selection_start_time = null; facility_reservation.selection_end_date = null; facility_reservation.selection_end_time = null; facility_reservation.selector = null; facility_reservation.store_code = DB.m_store.getSingleName(d_tenpomei.SelectedItem.ToString()).store_code; facility_reservation.facility_code = MainForm.Reservation_timetable.scheduleLabel; facility_reservation.order_code = null; //DOTO:特に入力するものが無いため取りあえずNULLを入れる //重複チェック using (var dbc = new DB.DBConnect()) { var frStart = new DateTime(facility_reservation.start_date.Year, facility_reservation.start_date.Month, facility_reservation.start_date.Day, facility_reservation.start_time.Hours, facility_reservation.start_time.Minutes, 0); var frEnd = new DateTime(facility_reservation.end_date.Year, facility_reservation.end_date.Month, facility_reservation.end_date.Day, facility_reservation.end_time.Hours, facility_reservation.end_time.Minutes, 0); var q = from t in dbc.t_facility_reservation select t; foreach (var data in q) { var dStart = new DateTime(data.start_date.Year, data.start_date.Month, data.start_date.Day, data.start_time.Hours, data.start_time.Minutes, 0); var dEnd = new DateTime(data.end_date.Year, data.end_date.Month, data.end_date.Day, data.end_time.Hours, data.end_time.Minutes, 0); if (data.facility_code == facility_reservation.facility_code && data.store_code == facility_reservation.store_code && !(dEnd <= frStart || dStart >= frEnd)) { Utile.Message.showMessageOK("I03009"); return; } } } facility_reservation.Command(); //リスト更新 if (MainForm.session_t_reception != null) { setYoyakuTabList(MainForm.session_t_reception.reception_code); } sescheduleTabList(facility_reservation.start_date, facility_reservation.store_code); Utile.Message.showMessageOK("I03003"); } else { // 必須チェック chk.clear(); chk.addControl(d_tenpomei); chk.addControl(d_shisetumei); chk.addControl(d_satueisya); chk.addControl(d_select_name); chk.addControl(d_tasukukubun); chk.addControl(d_satsueimokuteki); chk.addControl(d_start_time); chk.addControl(d_end_time); chk.addControl(d_yoyakusya); if (chk.check("W00000", chk.checkControlImportant)) { return; } chk.clear(); //フォーマットチェック chk.addControl(d_start_time); chk.addControl(d_end_time); if (d_select_start_time.Text != "") { chk.addControl(d_select_start_time); } if (d_select_end_time.Text != "") { chk.addControl(d_select_end_time); } if (chk.check("W00003", chk.checkTextboxFormat, @"^([0-9]|[0-1][0-9]|[2][0-3]):[0-5][0-9]$", "00:00")) { return; } chk.clear(); //桁数チェック chk.addControl(d_start_time); chk.addControl(d_end_time); if (d_select_start_time.Text != "") { chk.addControl(d_select_start_time); } if (d_select_end_time.Text != "") { chk.addControl(d_select_end_time); } if (chk.check("W00001", chk.checkTextboxLength, 5)) { return; } chk.clear(); chk.addControl(d_yoyakusya); if (chk.check("W00001", chk.checkTextboxLength, 20)) { return; } chk.clear(); chk.addControl(d_tekiyou); if (chk.check("W00001", chk.checkTextboxLength, 256)) { return; } chk.clear(); //施設予約登録処理 if (facility_reservation.facility_reservation_code == null) { facility_reservation.facility_reservation_code = DB.t_facility_reservation.getNewFacility_reservation_code(); } facility_reservation.start_date = d_start_date.Value; facility_reservation.start_time = TimeSpan.Parse(d_start_time.Text); facility_reservation.end_date = d_end_date.Value; facility_reservation.end_time = TimeSpan.Parse(d_end_time.Text); facility_reservation.reservator = d_yoyakusya.Text; facility_reservation.remarks = d_tekiyou.Text; if (d_tyushi.Checked) { facility_reservation.cancellation_date = d_tyushi.Value; } else { facility_reservation.cancellation_date = null; } facility_reservation.shooting_purpose = ((Utile.Data.撮影目的)(d_satsueimokuteki.SelectedIndex)).ToString(); facility_reservation.photographer = d_satueisya.Text; facility_reservation.task_class = DB.m_task.getSingleName(d_tasukukubun.SelectedItem.ToString()).task_class; if (d_select_start_time.Text == "") { facility_reservation.selection_start_date = null; facility_reservation.selection_start_time = null; } else { facility_reservation.selection_start_date = d_select_start_date.Value; facility_reservation.selection_start_time = TimeSpan.Parse(d_select_start_time.Text); } if (d_select_end_time.Text == "") { facility_reservation.selection_end_date = null; facility_reservation.selection_end_time = null; } else { facility_reservation.selection_end_date = d_select_end_date.Value; facility_reservation.selection_end_time = TimeSpan.Parse(d_select_end_time.Text); } facility_reservation.selector = d_select_name.SelectedItem.ToString(); facility_reservation.store_code = DB.m_store.getSingleName(d_tenpomei.SelectedItem.ToString()).store_code; facility_reservation.facility_code = DB.m_facility.getSingleName(facility_reservation.store_code, d_shisetumei.SelectedItem.ToString()).facility_code; facility_reservation.order_code = null; //DOTO:特に入力するものが無いため取りあえずNULLを入れる //重複チェック using (var dbc = new DB.DBConnect()) { var frStart = new DateTime(facility_reservation.start_date.Year, facility_reservation.start_date.Month, facility_reservation.start_date.Day, facility_reservation.start_time.Hours, facility_reservation.start_time.Minutes, 0); var frEnd = new DateTime(facility_reservation.end_date.Year, facility_reservation.end_date.Month, facility_reservation.end_date.Day, facility_reservation.end_time.Hours, facility_reservation.end_time.Minutes, 0); var q = from t in dbc.t_facility_reservation select t; foreach (var data in q) { var dStart = new DateTime(data.start_date.Year, data.start_date.Month, data.start_date.Day, data.start_time.Hours, data.start_time.Minutes, 0); var dEnd = new DateTime(data.end_date.Year, data.end_date.Month, data.end_date.Day, data.end_time.Hours, data.end_time.Minutes, 0); if (data.facility_code == facility_reservation.facility_code && data.store_code == facility_reservation.store_code && !(dEnd <= frStart || dStart >= frEnd)) { Utile.Message.showMessageOK("I03009"); return; } } } facility_reservation.Command(); //予約登録処理 DB.t_reservation reservation = new DB.t_reservation(); reservation.reservation_code = MainForm.session_t_reception.reception_code; reservation.facility_reservation_code = facility_reservation.facility_reservation_code; reservation.costume_reservation_code = " "; reservation.Command(); //撮影データ登録処理 DB.t_shooting_data shooting_data = DB.t_shooting_data.getSingle(MainForm.session_t_reception.customer_code, d_start_date.Value, MainForm.session_t_reception.reception_code); if (shooting_data == null) { shooting_data = new DB.t_shooting_data(); int index = 1; string folder = null; while (true) { folder = d_start_date.Value.ToString("yyyyMMdd") + "-" + index.ToString() + "-" + DB.m_customer.getSingle(MainForm.session_t_reception.customer_code).surname; if (DB.t_shooting_data.chkFolder(folder)) { break; } index++; } shooting_data.customer_code = MainForm.session_t_reception.customer_code; shooting_data.shooting_date = d_start_date.Value; shooting_data.folder = folder; shooting_data.select_class = "2"; shooting_data.images = 0; shooting_data.reception_code = MainForm.session_t_reception.reception_code; shooting_data.Command(); // フォルダ作成 var photo_root = System.Configuration.ConfigurationManager.AppSettings["photo_root"]; var Photographer_Select = System.Configuration.ConfigurationManager.AppSettings["Photographer_Select"]; var Photographer_Select_dir = System.IO.Path.Combine(photo_root, Photographer_Select); var folderPath = System.IO.Path.Combine(Photographer_Select_dir, folder); folderPath = System.IO.Path.GetFullPath(folderPath); if (System.IO.Directory.Exists(folderPath)) { Utile.Message.showMessageOK("I03008"); } else { System.IO.Directory.CreateDirectory(folderPath); } } //リスト更新 if (MainForm.session_t_reception != null) { setYoyakuTabList(MainForm.session_t_reception.reception_code); } sescheduleTabList(facility_reservation.start_date, facility_reservation.store_code); Utile.Message.showMessageOK("I03001"); } //更新チェックリセット mod.reset(); }