private void for_paint(string qwery)
{
data_save = Properties.Settings.Default.pz_dt;
get_razmer();
for_base obj = new for_base(qwery, @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + Environment.CurrentDirectory.Replace(@"\bin\Debug", "")
+ "\\Database1.mdf;Integrated Security=True;");
obj.connection_open();
obj.proverka_znachenei_v_bd();
if (obj.reader.HasRows)
{
int vs = 0, cn = 0;
string name = "", kol = "0";
while (obj.reader.Read())
{
name = obj.reader.GetString(0);
vs = obj.reader.GetInt32(1);
cn = obj.reader.GetInt32(2);
if (!qwery.Contains("like"))
{
if (data_save.Contains(name))
{
kol = Regex.Match(data_save, name + @"={[0-9]*}").ToString().Replace(name + "={", "").Replace("}", "");
}
else
{
kol = "0";
}
mix.Add(new string[] { name, cn.ToString(), vs.ToString(), kol });
}
foreach (var item in mix)
{
if (item[0] == name)
{
kol = item[3];
}
}
paint_form(name, vs, cn, kol);
}
}
panel2.Visible = false;
obj.connection_close();
}
private void Form1_Load(object sender, EventArgs e)
{
for_base obj = new for_base("" +
"select Bludo.Id, Bludo.name, Bludo.opisanie, Bludo.img, ingridient.name/*, ingridient.ves, ingridient.cena*/, razmer.razmer, razmer.ves, razmer.cena " +
"from Bludo, bludo_ing, ingridient, razmer " +
"where Bludo.Id = razmer.bludo_Id and Bludo.Id = bludo_ing.bludo_Id and bludo_ing.ingrid_Id = ingridient.Id",
@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + Environment.CurrentDirectory.Replace(@"\bin\Debug", "") + "\\Database1.mdf;Integrated Security=True;");
obj.connection_open();
obj.proverka_znachenei_v_bd();
if (obj.reader.HasRows)
{
int id = 0, razmer1 = 0, razmer2 = 0, razmer3 = 0, vs = 0, vs2 = 0, vs3 = 0, cn = 0, cn2 = 0, cn3 = 0, time_per = 0, time_razm = 0, time_cn = 0, time_vs = 0;
string name = "", ops = "", img = "", ing = "", time_ingr = "";
while (obj.reader.Read())
{
if (obj.reader.GetInt32(0) != id)
{
if (time_per == 0)
{
id = obj.reader.GetInt32(0);
razmer1 = obj.reader.GetInt32(5);
time_razm = obj.reader.GetInt32(5);
vs = obj.reader.GetInt32(6);
cn = obj.reader.GetInt32(7);
name = obj.reader.GetString(1);
ops = obj.reader.GetString(2);
img = obj.reader.GetString(3);
ing = obj.reader.GetString(4);
time_ingr = obj.reader.GetString(4);
time_per += 1;
}
else
{
ing += ".";
ls.Add(new string[] { cn + "@" + vs, cn2 + "@" + vs2, cn3 + "@" + vs3 });
create_checklist(name, cn, vs, cn2, vs2, cn3, vs3, razmer1, razmer2, razmer3);
paint_form(name, ops, img, ing, razmer1, razmer2, razmer3, vs, cn);
razmer2 = 0; vs2 = 0; cn2 = 0;
id = obj.reader.GetInt32(0);
razmer1 = obj.reader.GetInt32(5);
vs = obj.reader.GetInt32(6);
cn = obj.reader.GetInt32(7);
name = obj.reader.GetString(1);
ops = obj.reader.GetString(2);
img = obj.reader.GetString(3);
ing = obj.reader.GetString(4);
time_ingr = obj.reader.GetString(4);
}
}
else
{
if (time_ingr != obj.reader.GetString(4))
{
ing += ", " + obj.reader.GetString(4);
time_ingr = obj.reader.GetString(4);
}
if (time_razm != obj.reader.GetInt32(5))
{
if (razmer2 == 0)
{
razmer2 = obj.reader.GetInt32(5);
}
else
{
razmer3 = obj.reader.GetInt32(5);
}
time_razm = obj.reader.GetInt32(5);
}
if (time_vs != obj.reader.GetInt32(6))
{
if (vs2 == 0)
{
vs2 = obj.reader.GetInt32(6);
}
else
{
vs3 = obj.reader.GetInt32(6);
}
time_vs = obj.reader.GetInt32(6);
}
if (time_cn != obj.reader.GetInt32(7))
{
if (cn2 == 0)
{
cn2 = obj.reader.GetInt32(7);
}
else
{
cn3 = obj.reader.GetInt32(7);
}
time_cn = obj.reader.GetInt32(7);
}
}
}
ls.Add(new string[] { cn + "@" + vs, cn2 + "@" + vs2, cn3 + "@" + vs3 });
create_checklist(name, cn, vs, cn2, vs2, cn3, vs3, razmer1, razmer2, razmer3);
paint_form(name, ops, img, ing, razmer1, razmer2, razmer3, vs, cn);
panel1.Visible = false;
}
obj.connection_close();
radio_btn();
btn_zakaz();
}