public Form_PricingStrategy() { InitializeComponent(); numericUpDown_bookingDateLimt.Value = Convert.ToByte(ConfigParameters.getValue("BOOKING_DATE_LIMIT")); for (int i = 0; i < checkedListBox_bookingTimeSetting.Items.Count; i++) { checkedListBox_bookingTimeSetting.SetItemChecked(i, "TRUE" == ConfigParameters.getValue(checkedListBox_bookingTimeSetting.Items[i].ToString().Remove(5, 1).Remove(2, 1))); } comboBox_action.Items.Clear(); string sql = "select DICT_NAME from CFG_DICT where DICT_TYPE=1037 order by VIEW_INDEX"; comboBox_action.Items.AddRange(mDBM.SelectArray(sql)); comboBox_schoolName.Items.Clear(); comboBox_schoolNameForTest.Items.Clear(); sql = "select NAME from BAS_DRIVING_SCHOOL"; comboBox_schoolName.Items.AddRange(mDBM.SelectArray(sql)); comboBox_schoolNameForTest.Items.AddRange(mDBM.SelectArray(sql)); comboBox_referenceMethod1.Items.Clear(); comboBox_referenceMethod2.Items.Clear(); sql = "select DICT_NAME from CFG_DICT where DICT_TYPE=1038 order by VIEW_INDEX"; comboBox_referenceMethod1.Items.AddRange(mDBM.SelectArray(sql)); comboBox_referenceMethod2.Items.AddRange(mDBM.SelectArray(sql)); dataGridView_pricingStrategy.DataSource = mDBM.Select(pricingStrategyView).Tables[0]; }
public Form_TrainBooking() { InitializeComponent(); comboBox_gender.Items.Clear(); string sql = "select DICT_NAME from CFG_DICT where DICT_TYPE=2001 order by VIEW_INDEX"; comboBox_gender.Items.AddRange(mDBM.SelectArray(sql)); comboBox_idType.Items.Clear(); sql = "select DICT_NAME from CFG_DICT where DICT_TYPE=2002 order by VIEW_INDEX"; comboBox_idType.Items.AddRange(mDBM.SelectArray(sql)); comboBox_driverLicenseType.Items.Clear(); sql = "select DICT_CODE from CFG_DICT where DICT_TYPE=2003 order by VIEW_INDEX"; comboBox_driverLicenseType.Items.AddRange(mDBM.SelectArray(sql)); comboBox_schoolName.Items.Clear(); //sql = "select NAME from BAS_DRIVING_SCHOOL"; sql = "select distinct school_name from bas_student"; comboBox_schoolName.Items.AddRange(mDBM.SelectArray(sql)); comboBox_subjectName.Items.Clear(); sql = "select DICT_NAME from CFG_DICT where DICT_TYPE=1006 order by VIEW_INDEX"; comboBox_subjectName.Items.AddRange(mDBM.SelectArray(sql)); comboBox_subjectName.SelectedIndex = 1; comboBox_paymentWay.Items.Clear(); sql = "select DICT_NAME from CFG_DICT where DICT_TYPE=1001 order by VIEW_INDEX"; comboBox_paymentWay.Items.AddRange(mDBM.SelectArray(sql)); comboBox_paymentWay.SelectedIndex = 0; dateTimePicker_bookingDate.MinDate = DateTime.Now.Date; byte bookingDateLimit = 1; try { bookingDateLimit = Convert.ToByte(ConfigParameters.getValue("BOOKING_DATE_LIMIT")); } catch (Exception) { } dateTimePicker_bookingDate.MaxDate = dateTimePicker_bookingDate.MinDate + TimeSpan.FromDays(bookingDateLimit) - TimeSpan.FromSeconds(1); dateTimePicker_bookingDate.Value = DateTime.Now.Date; comboBox_car.Items.Clear(); sql = "select LICENSE_PLATE from BAS_CAR"; comboBox_car.Items.AddRange(mDBM.SelectArray(sql)); }
public Form_BookingStatus() { InitializeComponent(); for (int i = 0; i < Convert.ToByte(ConfigParameters.getValue("BOOKING_DATE_LIMIT")); i++) { dataGridView_status.Columns.Add($"column{i}", (DateTime.Now + TimeSpan.FromDays(i)).ToString("yyyy-MM-dd")); dataGridView_status.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } #if simpleBookingTime string sql = "select distinct(case when substr(DISPLAY_NAME,1,2)<12 then '上午' else '下午' end) from CFG_PARAM where PARAM_NAME like '__0000' and PARAM_VALUE='TRUE'"; #else string sql = "select DISPLAY_NAME from CFG_PARAM where PARAM_NAME like '__0000' and PARAM_VALUE='TRUE'"; #endif string[] names = mDBM.SelectArray(sql); if (names.Length > 0) { dataGridView_status.Rows.Add(names.Length); for (int i = 0; i < names.Length; i++) { dataGridView_status.Rows[i].HeaderCell.Value = names[i]; } for (int i = 0; i < Convert.ToByte(ConfigParameters.getValue("BOOKING_DATE_LIMIT")); i++) { string dateString = (DateTime.Now + TimeSpan.FromDays(i)).ToString("yyyyMMdd"); #if simpleBookingTime sql = $"select sum(booking_times) from (select distinct(case when substr(DISPLAY_NAME,1,2)<12 then '上午' else '下午' end) bookingTimePiece from cfg_param where param_name like '__0000' and param_value='TRUE') a left join bas_booking on case when substr(bas_booking.booking_datetime,9,2)<12 then '上午' else '下午' end =a.bookingTimePiece and substr(bas_booking.booking_datetime,1,8)={dateString} group by a.bookingTimePiece order by a.bookingTimePiece"; #else sql = $"select sum(booking_times) from (select param_name from cfg_param where param_name like '__0000' and param_value='TRUE') a left join bas_booking on substr(bas_booking.booking_datetime,9,6)=a.param_name and substr(bas_booking.booking_datetime,1,8)={dateString} group by a.param_name order by a.param_name"; #endif string[] values = mDBM.SelectArray(sql); for (int j = 0; j < names.Length; j++) #if simpleBookingTime { if (i == 0 && ("上午" == dataGridView_status.Rows[j].HeaderCell.Value.ToString()) && (Convert.ToByte(DateTime.Now.ToString("hh")) >= 12)) #else if (i == 0 && Convert.ToDateTime(dataGridView_status.Rows[j].HeaderCell.Value) < DateTime.Now.ToLocalTime()) #endif { dataGridView_status.Rows[j].Cells[i].Style.BackColor = dataGridView_status.Rows[j].Cells[i].Style.SelectionBackColor = Color.LightGray; } else { dataGridView_status.Rows[j].Cells[i].Value = values[j]; } } } } }