public void LoadData()
{
ClassDataBase db = new ClassDataBase();
string a = "select id_r, t.name_t,(select t1.name_t from town t1,rout r1, price pr1 where r1.id_end=t1.id_t and pr1.ID_PR=r1.ID_PR and r1.ID_R=r.ID_R ) as end_r,";
string b = "r.DAY_R, strdate_r,enddate_r,DISTANCE_R*pr.PRICE, pr.Price, DISTANCE_R from rout r, town t, price pr where r.id_st = t.id_t and pr.ID_PR=r.ID_PR";
string d = a + b;
db.Execute <timetable>(ref sp, d, ref r.list1);
}
public void Search(string a, int forfunction)
{
string command = "select r2.id_r from rout r2, btown bt2, town t2 where (r2.ID_END=t2.ID_T or (bt2.ID_T=t2.ID_T and bt2.ID_R=r2.ID_R)) and t2.NAME_T like '" + a + "' group by r2.ID_R";
ClassDataBase db = new ClassDataBase();
db.Execute <Shearch>(ref sp, command, ref r.search1);
SortDataGrid();
r.Answear();
r.search1.Clear();
}
public void SearchFrom(string a, string data)
{
string command = "select r2.id_r from rout r2, btown bt2, town t2 where (r2.ID_ST=t2.ID_T or (bt2.ID_T=t2.ID_T and bt2.ID_R=r2.ID_R)) and t2.NAME_T like '" + a + "' and instr(r2.DAY_R,'" + r.dtpm.Value.ToString("ddd") + "')!=0 group by r2.ID_R";
ClassDataBase db = new ClassDataBase();
db.Execute <Shearch>(ref sp, command, ref r.search1);
SortDataGrid();
r.Answear();
r.search1.Clear();
}
//public void InfaTickat(int counter)
//{
// t.tbfrm.Text = r.list1[counter - 1].str_tw;
// t.tbto.Text = r.list1[counter - 1].end_tw;
// t.tbdtt.Text = r.list1[counter - 1].date_end;
// t.u = counter;
// t.id = r.list1[counter - 1].id.ToString();
// t.Show();
//}
#region
public void Search(string a, string b)
{
string command1 = "SELECT r.id_r from rout r,town t, btown bt where (r.ID_ST=t.ID_T or (bt.ID_T=t.ID_T and bt.ID_R=r.ID_R))and instr(r.DAY_R,'" + r.dtpm.Value.ToString("ddd") + "')!=0 and t.NAME_T like'" + a + "'and r.ID_R=(select r2.id_r from rout r2, btown bt2, town t2 where";
string command2 = "(r2.ID_END=t2.ID_T or (bt2.ID_T=t2.ID_T and bt2.ID_R=r2.ID_R and bt2.ID_BT>=bt.ID_BT)) and t2.NAME_T like '" + b + "' and r2.ID_R=r.ID_R group by r2.ID_R) group by r.ID_R";
string command = command1 + command2;
ClassDataBase db = new ClassDataBase();
db.Execute <Shearch>(ref sp, command, ref r.search1);
SortDataGrid();
r.Answear();
r.search1.Clear();
}
public void LoadDataCB()
{
ClassDataBase db = new ClassDataBase();
db.Execute <towns>(ref sp, "Select id_t,name_t from town", ref r.ttowns);
}