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];
} }
}
}
}
