//private string WR()
//{
// DateTime curr_data = DateTime.Now;
// string q = "";
// if (dateTimePicker2.Value.Date <= curr_data) { q = @"UPDATE orderr SET ready = '" + "Не выполнено" + @"' WHERE expiration_date<=CURDATE();"; }
// else q = @"UPDATE orderr SET readyy = '"+"Выполнено"+ @"' WHERE expiration_date>=CURDATE();";
// return q;
//}
private void button1_Click(object sender, EventArgs e)
{
double OC = 0;
string readyy = "Не выполнено";
ClassDataBase db = new ClassDataBase();
string qq = @"insert into clientt(s_cl, n_cl, p_cl) values ('" + clF.Text + @"','" + clN.Text + @"','" + clP.Text + @"')";
db.ExecuteNonQuery("ALD_V2.db", qq, 0);
string qq2 = @"select id_cl, s_cl, n_cl, p_cl from clientt order by id_cl desc limit 1;";
db.Execute <Client>("ALD_V2.db", qq2, ref listClient);
string qqq = @"insert into orderr(id_cl, footage, date_of_conclusion, expiration_date, order_cost, readyy) values (" + listClient[0].Id_cl + @"," + ordSq.Text + @",'" + dateTimePicker1.Text + @"','" + dateTimePicker2.Text + @"'," + OC + @",'" + readyy + @"');";
db.ExecuteNonQuery("ALD_V2.db", qqq, 0);
listOrder.Clear();
string qqq2 = @"select id_order, id_cl, footage, date_of_conclusion, expiration_date, order_cost, readyy from orderr order by id_cl desc limit 1;";
db.Execute <Order>("ALD_V2.db", qqq2, ref listOrder);
string qqq3 = @"insert into order_empl(id_order,id_empl) values ('" + listOrder[0].Id_order + @"','" + GetIDE(cbEmpl.Text.Trim()) + @"')";
db.ExecuteNonQuery("ALD_V2.db", qqq3, 0);
OrdersProjects newForm = new OrdersProjects();
newForm.Show();
}
private void button1_Click(object sender, EventArgs e)
{
ClassDataBase db = new ClassDataBase();
double TC = 0;
string ll = @"select id_order, id_cl, footage, date_of_conclusion, expiration_date, order_cost, readyy from orderr order by id_order desc limit 1;";
db.Execute <Order>("ALD_V2.db", ll, ref listOrder);
string ll2 = @"select id_proj, cat_proj, name_proj, cost_of_work, min_square, work_time from projects where cat_proj = '" + cbCatProj.Text + @"' and name_proj='" + cbNameProj.Text + @"'";
db.Execute <Projects>("ALD_V2.db", ll2, ref listProj);
//string lll = @"insert into order_proj(id_order, id_proj) values (" + listOrder[0].Id_order + @"," + listProj[0].Id_proj + @")";
string s = @"INSERT INTO order_proj (id_order, id_proj) VALUES (" + "(select id_order from orderr order by 1 desc limit 1)" + @"," + GetIDP(cbNameProj.Text) + @")";
//db.Execute<Order>("ALD_V2.db", s, ref listOrder);
db.ExecuteNonQuery("ALD_V2.db", s, 0);
string z = @"select o.id_order, c.s_cl , c.n_cl , c.p_cl , o.footage, o.date_of_conclusion, o.expiration_date, o.order_cost, p.id_proj, p.cat_proj, p.name_proj, p.cost_of_work, p.min_square, p.work_time, o.readyy from projects p natural join orderr o natural join clientt c;";
db.Execute <OrderProj>("ALD_V2.db", z, ref listOrderProj);
for (int i = 0; i < listProj.Count; i++)
{
if (listProj[i].Cat_proj == cbCatProj.Text && listProj[i].Name_proj == cbNameProj.Text)
{
TC = TC + listProj[i].Cost_of_work;
}
}
s = @"UPDATE orderr SET order_cost = order_cost +'" + TC + @"' WHERE id_order = '" + listOrder[0].Id_order + @"'";
db.ExecuteNonQuery("ALD_V2.db", s, 0);
s = @"UPDATE Materials SET order_cost = order_cost +'" + TC + @"' WHERE id_order = '" + listOrder[0].Id_order + @"'";
db.ExecuteNonQuery("ALD_V2.db", s, 0);
Close();
}
public void LoadData()
{
string q = @"select id_proj, cat_proj, name_proj, cost_of_work, min_square, work_time from projects";
db.Execute <Projects>("ALD_V2.db", q, ref listProj);
string qq = @"select id_proj, cat_proj, name_proj, cost_of_work, min_square, work_time from projects group by cat_proj";
db.Execute <Projects>("ALD_V2.db", qq, ref listProjCat);
for (int i = 0; i < listProjCat.Count; i++)
{
cbCatProj.Items.Add(listProj[i].Cat_proj);
}
}
public void LoadData()
{
string l = @"select id_m, name_m, category_m, unit_of_measurement_m, quatnity_m, cost_m from materials";
db1.Execute <Materials>("ALD_V2.db", l, ref listMat);
for (int i = 0; i < listMat.Count; i++)
{
cbNM.Items.Add(listMat[i].Name_m);
}
l = @"select id_proj, cat_proj, name_proj, cost_of_work, min_square, work_time from projects";
db1.Execute <Projects>("ALD_V2.db", l, ref listProj);
l = @"select m.id_mat_proj, p.name_proj, ma.name_m, m.quantity_m_min_square from m_projects m join materials ma on ma.id_m = m.id_m join projects p on p.id_proj = m.id_proj";
db1.Execute <MProjects>("ALD_V2.db", l, ref listMProj);
}
public void LoadData()
{
string q = @"select id_proj, cat_proj, name_proj, cost_of_work, min_square, work_time from projects";
db.Execute <Projects>("ALD_V2.db", q, ref listProjects);
for (int i = 0; i < listProjects.Count; i++)
{
dgvProj.Rows.Add(listProjects[i].Name_proj, listProjects[i].Cat_proj, listProjects[i].Cost_of_work, listProjects[i].Min_square, listProjects[i].Work_time);
}
}
public void LoadData()
{
string q = @"select id_m, name_m, category_m, unit_of_measurement_m, quatnity_m, cost_m from materials";
db.Execute <Materials>("ALD_V2.db", q, ref listMaterials);
string l = @"select id_proj, cat_proj, name_proj, cost_of_work, min_square, work_time from projects";
db.Execute <Projects>("ALD_V2.db", l, ref listProjects);
for (int i = 0; i < listProjects.Count; i++)
{
comboBox1.Items.Add(listProjects[i].Name_proj);
}
l = @"select m.id_mat_proj, p.name_proj, ma.name_m, m.quantity_m_min_square from m_projects m join materials ma on ma.id_m = m.id_m join projects p on p.id_proj = m.id_proj";
db.Execute <MProjects>("ALD_V2.db", l, ref listMProjects);
for (int i = 0; i < listMProjects.Count; i++)
{
dataGridView1.Rows.Add(listMProjects[i].Name_proj, listMProjects[i].Name_m, listMaterials[i].Unit_of_measurement_m, listMProjects[i].Quantity_m_min_square);
}
}
private void button1_Click(object sender, EventArgs e)
{
string s = @"select o.id_order, c.s_cl, c.n_cl, c.p_cl, o.footage, o.date_of_conclusion, o.expiration_date, o.order_cost, o.readyy, e.s_empl, e.n_empl, e.p_empl from employee e natural join order_empl natural join orderr o natural join clientt c where o.id_order = '" + comboBox1.Text + @"' group by id_order ;";
db.Execute("ALD_V2.db", s, ref listOrder2);
ClassSerialiaze.SerialiazeToXml <List <Order2> >(ref listOrder2, "data.xml");
FormReport frmReport = new FormReport();
frmReport.ShowDialog();
}
public void LoadData()
{
string q = @"select id_empl, n_empl, s_empl, p_empl, exper from employee;";
db.Execute <Employee>("ALD_V2.db", q, ref listEmployee);
string epl = "";
for (int i = 0; i < listEmployee.Count; i++)
{
epl = listEmployee[i].S_empl + " " + listEmployee[i].N_empl + " " + listEmployee[i].P_empl;
cbEmpl.Items.Add(epl);
}
}
public void Serch()
{
string[] val = comboBox2.Text.Split('|');
double profit = 0;
string q = @"select id_order, id_cl, footage, date_of_conclusion, expiration_date, order_cost, readyy from orderr where year(expiration_date) = '" + comboBox1.Text + @"'and month(expiration_date) = '" + val[1] + @"'; ";
db.Execute <Order>("ALD_V2.db", q, ref listOrder);
for (int i = 0; i < listOrder.Count; i++)
{
if (listOrder[i].Readyy == "Выполнено")
{
dataGridView1.Rows.Add(listOrder[i].Id_order, listOrder[i].Footage, listOrder[i].Date_of_conclusion, listOrder[i].Expiration_date, listOrder[i].Order_cost, listOrder[i].Readyy);
profit = profit + listOrder[i].Order_cost;
}
}
textBox1.Text = Convert.ToString(profit);
}
public void LoadData()
{
string a = @"select id_order, id_empl from order_empl; ";
db.Execute <Order_Empl>("ALD_V2.db", a, ref listOrderEmpl);
string z = @"select o.id_order, c.s_cl , c.n_cl , c.p_cl , o.footage, o.date_of_conclusion, o.expiration_date, o.order_cost, p.id_proj, p.cat_proj, p.name_proj, p.cost_of_work, p.min_square, p.work_time, o.readyy from projects p natural join orderr o natural join clientt c;";
db.Execute <OrderProj>("ALD_V2.db", z, ref listOrderProj);
string q = @"select o.id_order, o.id_cl, o.footage, o.date_of_conclusion, o.expiration_date, o.order_cost, o.readyy from orderr o;";
db.Execute <Order>("ALD_V2.db", q, ref listOrder);
string qq1 = @"select id_empl, s_empl, n_empl, p_empl, exper from employee;";
db.Execute <Employee>("ALD_V2.db", qq1, ref listEmployee);
string s = @"select o.id_order, c.s_cl, c.n_cl, c.p_cl, o.footage, o.date_of_conclusion, o.expiration_date, o.order_cost, o.readyy, e.s_empl, e.n_empl, e.p_empl from employee e natural join order_empl natural join orderr o natural join clientt c group by id_order;";
db.Execute("ALD_V2.db", s, ref listOrder2);
WR();
string qq = @"select id_cl, s_cl, n_cl, p_cl from clientt;";
db.Execute <Client>("ALD_V2.db", qq, ref listClient);
string client = "";
string empl = "";
double qwe = 0;
for (int i = 0; i < listOrder.Count; i++)
{
//qwe = TC(i+1);
client = listClient[i].S_cl + " " + listClient[i].N_cl + " " + listClient[i].P_cl;
dgvOR.Rows.Add(listOrder[i].Id_order, client, listOrder[i].Footage, listOrder[i].Date_of_conclusion, listOrder[i].Expiration_date, listOrder[i].Order_cost, listOrder[i].Readyy);
}
for (int i = 0; i < listClient.Count; i++)
{
comboBox1.Items.Add(client = listClient[i].S_cl + " " + listClient[i].N_cl + " " + listClient[i].P_cl);
}
for (int i = 0; i < listOrder.Count; i++)
{
comboBox2.Items.Add(listOrder[i].Date_of_conclusion);
}
for (int i = 0; i < listEmployee.Count; i++)
{
empl = listEmployee[i].S_empl + " " + listEmployee[i].N_empl + " " + listEmployee[i].P_empl;
comboBox3.Items.Add(empl);
}
comboBox4.Items.Add("Выполнено");
comboBox4.Items.Add("Не выполнено");
}