// Конструктор, вызываемый при нажатии "Добавить"
public add_menu(db_connect data_module)
{
InitializeComponent();
class_queue[] queue = new class_queue[512];
queue = Program.add_read_module.get_numb_queue();
if (queue != null)
{
this.cb_numb_queue.Items.Clear();
for (int i = 1; i < queue.Count(); i++)
{
if (queue[i] != null)
{
this.cb_numb_queue.Items.Add(queue[i].numb_queue);
}
else
{
break;
}
}
}
this._data_module = data_module;
this.set_state("NEW");
}
/// <summary>
/// Возвращает общее число порций (рассчитанное на определенное количество человек)
/// </summary>
public class_queue get_count_serv(int id_queue)
{
class_queue queue = new class_queue();
string query = "select Number_of_mens from Queue where ID_queue='" + id_queue + "'";
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query;
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
queue = new class_queue();
queue.result = "OK";
queue.numb_men = rd.GetInt32(0).ToString();
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.Data);
return null;
}
return queue;
}
/// <summary>
/// Событие возникающие при загрузке формы
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Menu_layout_Load(object sender, EventArgs e)
{
_food = get_food_breakfast(AddDayID);
dinner_food=get_food_dinner(AddDayID);
supper_food = get_food_supper(AddDayID);
_ingr_list_breakfast = get_ingr_list(AddDayID);
_ingr_list_dinner = get_ingr_list_dinner(AddDayID);
_ingr_list_supper = get_ingr_list_supper(AddDayID);
_ingr_list_all_day = get_ingr_all_day(AddDayID);
_ves_breakfast = get_ves_breakfast();
_ves2_breakfast = get_ves_breakfast2();
_ves3_breakfast = get_ves_breakfast3();
_ves4_breakfast = get_ves_breakfast4();
_ves5_breakfast = get_ves_breakfast5();
_ves6_breakfast = get_ves_breakfast6();
_ves7_breakfast = get_ves_breakfast7();
_ves8_breakfast = get_ves_breakfast8();
_ves_dinner = get_ves_dinner();
_ves_dinner2 = get_ves_dinner2();
_ves_dinner3 = get_ves_dinner3();
_ves_dinner4 = get_ves_dinner4();
_ves_dinner5 = get_ves_dinner5();
_ves_dinner6 = get_ves_dinner6();
_ves_dinner7 = get_ves_dinner7();
_ves_dinner8 = get_ves_dinner8();
_ves_supper = get_ves_supper();
_ves_supper2 = get_ves_supper2();
_ves_supper3 = get_ves_supper3();
_ves_supper4 = get_ves_supper4();
_ves_supper5 = get_ves_supper5();
_ves_supper6 = get_ves_supper6();
_ves_supper7 = get_ves_supper7();
_ves_supper8 = get_ves_supper8();
_obshcal=get_cal_breakfast(AddDayID);
_obshcal_dinner = get_cal_dinner(AddDayID);
_obshcal_supper = get_cal_supper(AddDayID);
_obshves_breakfast = get_sum_breakfast(AddDayID);
_obshves_dinner = get_sum_dinner(AddDayID);
_obshves_supper = get_sum_supper(AddDayID);
_obshves_all_day = get_sum_all_day(AddDayID);
_menu_in_day = this.menu_in_day();
_count_serv = this.get_count_serv(queue_id);
this._person = this.get_person_list();
fill_person_list();
}
/// <summary>
/// возвращает очередь по указанному в параметрах идентификатору (коду)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public class_queue get_queue(int id)
{
class_queue queue = new class_queue();
string query = "select * from Queue where ID_queue=";
query += id.ToString();
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query;
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
queue.result = "OK";
queue.queue_id = id.ToString();
if (rd.IsDBNull(1))
{
queue.numb_men = "";
}
else
{
queue.numb_men = rd.GetInt32(1).ToString();
}
if (rd.IsDBNull(2))
{
queue.start = "";
}
else
{
queue.start = rd.GetDateTime(2).ToString("dd.MM.yyyy");
}
if (rd.IsDBNull(3))
{
queue.end = "";
}
else
{
queue.end = rd.GetDateTime(3).ToString("dd.MM.yyyy");
}
if (rd.IsDBNull(4))
{
queue.length = "";
}
else
{
queue.length = rd.GetInt32(4).ToString();
}
if (rd.IsDBNull(5))
{
queue.numb_queue = "";
}
else
{
queue.numb_queue = rd.GetString(5);
}
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
queue.result = "ERROR_" + ex.Data + " " + ex.Message;
}
return queue;
}
/// <summary>
/// возвращает список очередей
/// </summary>
/// <returns></returns>
public class_queue[] get_numb_queue()
{
class_queue[] menu = new class_queue[512];
string query = "select ID_queue, Number_queue from Queue "
+ "where ID_queue not in "
+ "(select ID_queue from Menu)";
try
{
SqlCommand com = Program.data_module._conn.CreateCommand();
com.CommandText = query;
SqlDataReader rd = com.ExecuteReader();
int i = 0;
while (rd.Read())
{
i++;
menu[i] = new class_queue();
menu[i].result = "OK";
menu[i].queue_id = rd.GetInt32(0).ToString();
menu[i].numb_queue = rd.GetString(1);
}
rd.Close();
rd.Dispose();
com.Dispose();
}
catch (Exception ex)
{
menu[0].result = "ERROR_" + ex.Data + " " + ex.Message;
}
return menu;
}
