table1.Notes [i] .Records [1]);
}. Text= № raquo ;; label2.Text= Date raquo ;; label3.Text= Employee raquo ;; label4.Text= Sum raquo ;; label5.Text= Sort raquo ;; label6.Text= Currency raquo ;;; Personal_Data :. Height=220; .Location=new Point (112, 150) ;. Visible=true; textBox2.Visible=true; textBox3.Visible=true; textBox4.Visible=true; textBox5.Visible=true; .Text= №Contract raquo ;; label2.Text= №Passport raquo ;; label3.Text= F.I.O raquo ;; label4.Text= Birth_Date raquo ;; label5.Text= Contract_Date raquo ;; table7=new TableStruct ();=Logic.WorkWithDB.ReadRecords ( Personal_Data ) ;. Text=table7.Notes.Count.ToString () ;. ReadOnly=true ;; Empl_Data :. Height=220; .Location=new Point (112, 150) ;. Text= FIO raquo ;; label2.Text= Post raquo ;; label3.Text= Department raquo ;;. Visible=true; .Location=new Point (112, 15) ;. Location=new Point (112, 45) ;. Location=new Point (112, 75) ;. Visible= true; .Visible=true; table8=new TableStruct ();=Logic.WorkWithDB.ReadRecords ( Personal_Data ); (int i=1; i lt; table8.Notes.Count; i ++)
{. Items.Add (table8.Notes [i] .Records [2]);
}=Logic.WorkWithDB.ReadRecords ( Posts ); (int i=1; i lt; table8.Notes.Count; i ++)
{. Items.Add (table8.Notes [i] .Records [1]);
}=Logic.WorkWithDB.ReadRecords ( Departments ); (int i=1; i lt; table8.Notes.Count; i ++)
{. Items.Add (table8.Notes [i] .Records [1]);
}; Posts :. Height=220; .Location=new Point (112, 150) ;. Visible=true; textBox2.Visible=true; textBox3.Visible=true; .Text= № raquo ;; label2.Text= Name raquo ;; label3.Text= Salary raquo ;; label4.Text= Department raquo ;; table9=new TableStruct ();=Logic.WorkWithDB.ReadRecords ( Posts ) ;. Text=table9.Notes.Count.ToString () ;. ReadOnly=true; .Visible= true; .Location=new Point (112, 90);=Logic.WorkWithDB.ReadRecords ( Departments ); (int i=1; i lt; table9.Notes.Count; i ++)
{. Items.Add (table9.Notes [i] .Records [1]);
}; Departments :. Height=220; .Location=new Point (112, 150) ;. Visible=true; textBox2.Visible=true; .Text= № raquo ;; label2.Text= Name raquo ;; table10=new TableStruct ();=Logic.WorkWithDB.ReadRecords ( Departments ) ;. Text=table10.Notes.Count.ToString () ;. ReadOnly=true ;; Services :. Height=220; .Location=new Point (112, 150) ;. Visible=true; textBox2.Visible=true; textBox3.Visible=true; .Text= № raquo ;; label2.Text= Service_Sort raquo ;; label3.Text= Cost raquo ;; table11=new TableStruct ();=Logic.WorkWithDB.ReadRecords ( Services ) ;. Text=table11.Notes.Count.ToString () ; .ReadOnly=true ;; Services_Rendered :. Height=320; .Location=new Point (112, 250) ;. Visible=true; textBox3.Visible=true; textBox4.Visible=true; textBox5.Visible=true; textBox7.Visible=true; .Text= № raquo ;; label2.Text= Service_Sort raquo ;; label3.Text= Date raquo ;; label4.Text= Start_Time raquo ;; label5.Text= Finish_Time raquo ;; label6.Text= Employee raquo ;; label7.Text= Revenue raquo ;; label8.Text= Sort raquo ;; label9.Text= Currency raquo ;; table12=new TableStruct ();=Logic.WorkWithDB.ReadRecords ( Revenue ) ;. Text=table12.Notes [table12.Notes.Count - 1] .Records [0]. ToString () ;. Text=(Convert.ToInt32 (textBox1.Text) + 1) .ToString () ;. ReadOnly=true; .Visible=true; .Location=new Point (112, 40) ;. Visible=true;.Location=new Point (112, 140) ;. Visible=true; .Location=new Point (112, 192) ;. Visible=true; .Location=new Point (112, 220);=Logic.WorkWithDB.ReadRecords ( Services ); (int i=1; i lt; table12.Notes.Count; i ++)
{. Items.Add (table12.Notes [i] .Records [1]);
}=Logic.WorkWithDB.ReadRecords ( Personal_Data ); (int i=1; i lt; table12.Notes.Count; i ++)
{. Items.Add (table12.Notes [i] .Records [2]);
}=Logic.WorkWithDB.ReadRecords ( Sort_Rev_Exp ); (int i=1; i lt; table12.Notes.Count; i ++)
{. Items.Add (table12.Notes [i] .Records [1]);
}=Logic.WorkWithDB.ReadRecords ( Currency ); (int i=1; i lt; table12.Notes.Count; i ++)
{. Items.Add (table12.Notes [i] .Records [1]);
} ;: ;;
}
} void button1_Click (object sender, EventArgs e)
{(tablename1)
{ Clients raquo ;: Logic.WorkWithDB.Insert ( Insert into Clients ([№], [FIO], [Adress], [Tel], [E-mail]) Values (raquo;+textBox1.Text+laquo;,laquo;raquo;+textBox2.Text+laquo;raquo;,laquo;raquo;+textBox3.Text+laquo;raquo;,laquo;raquo;+textBox4.Text+laquo;raquo;,laquo;raquo;+textBox5.Text+laquo;raquo;)raquo;);;laquo;Suppliersraquo;: Logic.WorkWithDB.Insert ( Insert into Suppliers ([№], [FIO], [Adress], [Tel], [...