Разработка программных средств автоматизированной работы автозаправки

break;

case Supply:

SelectedRowTableTitles(dataTable.getSelectedRow());

break;

case Description:

SelectedRowTableDescription(dataTable.getSelectedRow());

break;

case Fuelling:

SelectedRowTableFuelling(dataTable.getSelectedRow());

break;

case Description_fuelling:

SelectedRowTableDescFuelling(dataTable.getSelectedRow());

break;

case Clients:

SelectedRowTableClients(dataTable.getSelectedRow());

break;

default:

break;

}

}}};

}

private void FalsePanel() {

SuppliersDataPanel.setVisible(false);

ProdDataPanel.setVisible(false);

SupplyDataPanel.setVisible(false);

DescriptionDataPanel.setVisible(false);

FuellingDataPanel.setVisible(false);

DescFuellingDataPanel.setVisible(false);

ClientsDataPanel.setVisible(false);

viewDataPanel.setVisible(false);

viewDataPanel1.setVisible(false);

viewDataPanel2.setVisible(false);

sendPanel.setVisible(false);

}

/**Menu */

private void Menu()

{

//Меню

menuB = new JMenuBar();

menuB.setBounds(0, 0, 902, 21);

contentPanel.add(menuB);

//Таблицы

mnTable = new JMenu("\u041F\u0440\u043E\u0441\u043C\u043E\u0442\u0440 \u0441\u043F\u0440\u0430\u0432\u043E\u0447\u043D\u043E\u0439 \u0438\u043D\u0444\u043E\u0440\u043C\u0430\u0446\u0438\u0438");

menuB.add(mnTable);

mntmProductions = new JMenuItem("Информация о продукции");

mnTable.add(mntmProductions);

mntmProductions.addActionListener(ActionProduction());

mntmSupply = new JMenuItem("Информация о поставках");

mnTable.add(mntmSupply);

mntmSupply.addActionListener(ActionSupply());

mntmSuppliers = new JMenuItem("Информация о поставщиках");

mnTable.add(mntmSuppliers);

mntmSuppliers.addActionListener(ActionSuppliers());

mntmDescription = new JMenuItem("Описание поставок");

mnTable.add(mntmDescription);

mntmDescription.addActionListener(ActionDescription());

mntmFuelling = new JMenuItem("Информация о заправках автомобилей");

mnTable.add(mntmFuelling);

mntmFuelling.addActionListener(ActionFuelling());

//Таблица описание заправки

mntmDescFuelling = new JMenuItem("Описание заправки автомобилей");

mnTable.add(mntmDescFuelling);

mntmDescFuelling.addActionListener(ActionDescription_fuelling()); //Таблица клиенты

mntmClients = new JMenuItem("Информация о клиентах");

mnTable.add(mntmClients);

mntmClients.addActionListener(ActionClients());

JButton btnClose = new JButton("Закрыть");

btnClose.setBounds(415, 279, 117, 38);

contentPanel.add(btnClose);

JButton btnADD = new JButton("Добавить");

btnADD.setBounds(10, 279, 131, 38);

contentPanel.add(btnADD);

JButton btnUPDATE = new JButton("Изменить");

btnUPDATE.setBounds(278, 279, 117, 38);

contentPanel.add(btnUPDATE);

JButton btnDELETE = new JButton("Удалить");

btnDELETE.setBounds(151, 279, 117, 38);

contentPanel.add(btnDELETE);

btnDELETE.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

jDBC=JDBC.Delete;

try {

QueryTable();

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

jDBC=JDBC.Null;

}

});

btnUPDATE.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

jDBC=JDBC.Update;

try {

QueryTable();

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

jDBC=JDBC.Null;

}

});

btnADD.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

jDBC=JDBC.Insert;

try {

QueryTable();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

jDBC=JDBC.Null;

}

});

btnClose.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

System.exit(0);

}

});

//Представления

JMenu mnView = new JMenu("\u0414\u043E\u043F\u043E\u043B\u043D\u0438\u0442\u0435\u043B\u044C\u043D\u044B\u0435 \u0441\u0432\u0435\u0434\u0435\u043D\u0438\u044F");

menuB.add(mnView);

JMenuItem mntmIOS = new JMenuItem("\u0421\u0432\u0435\u0434\u0435\u043D\u0438\u044F \u043E \u043F\u043E\u0441\u0442\u0430\u0432\u043A\u0430\u0445 \u043D\u0430 \u0410\u0417\u0421");

mnView.add(mntmIOS);

mntmIOS.addActionListener(ActionIAS());

JMenuItem mntmSP = new JMenuItem("\u0421\u0432\u0435\u0434\u0435\u043D\u0438\u044F \u043E \u0437\u0430\u043F\u0440\u0430\u0432\u043A\u0430\u0445 \u0430\u0432\u0442\u043E");

mnView.add(mntmSP);

mntmSP.addActionListener(ActionIAF());

}

/** МЕТОДЫ ДЛЯ ЗАПОЛНЕНИЯ ТАБЛИЦ ИЗ ЗАПРОСОВ*/

private ActionListener ActionIAF() {

// TODO Auto-generated method stub

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Inf_about_fuelling;

textFieldIP6.setEnabled(true);

textFieldIP5.setEnabled(true);

FalsePanel();

viewDataPanel2.setVisible(true);

try {

QueryTable();//заполнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}}};

}

private ActionListener ActionIAS() {

// TODO Auto-generated method stub

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Inf_about_supply;

textFieldIP3.setEnabled(true);

textFieldIP4.setEnabled(true);

FalsePanel();

viewDataPanel1.setVisible(true);

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

e1.printStackTrace();

}}}; }

private ActionListener ActionProduction() {

// TODO Auto-generated method stub

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Production;

FalsePanel();

ProdDataPanel.setVisible(true);

sendPanel.setVisible(true);

try {

QueryTable();//заполнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

} }};}

private ActionListener ActionSuppliers()

{

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Suppliers;

FalsePanel();

SuppliersDataPanel.setVisible(true);

sendPanel.setVisible(true);

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}}};}

private ActionListener ActionSupply()

{

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Supply;

FalsePanel();;

SupplyDataPanel.setVisible(true);

sendPanel.setVisible(true);

try {

QueryTable();//заполнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}};

}

private ActionListener ActionDescription()

{

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Description;

FalsePanel();;

DescriptionDataPanel.setVisible(true);

sendPanel.setVisible(true);

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}};

}

private ActionListener ActionFuelling()

{

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Fuelling;

FalsePanel();;

FuellingDataPanel.setVisible(true);

sendPanel.setVisible(true);

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}};

}

private ActionListener ActionDescription_fuelling()

{

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Description_fuelling;

FalsePanel();;

DescFuellingDataPanel.setVisible(true);

sendPanel.setVisible(true);

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}};

}

private ActionListener ActionClients()

{

return new ActionListener(){

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

SelectTable=NameTable.Clients;

FalsePanel();;

ClientsDataPanel.setVisible(true);

sendPanel.setVisible(true);

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}};

}

/**

* Connection Table.

*/

public void QueryTable() throws Exception{

mdbc=new MyDbConnection();

mdbc.init();

Connection conn=mdbc.getMyConnection();

stmt= conn.createStatement();

switch (jDBC) {

case Insert:

InsertTable();

break;

case Delete:

DeleteTable();

break;

case Update:

UpdateTable();

break;

default:

System.out.println(jDBC);

break;

}

ViewTable();

InitTable();

mdbc.close(stmt);

}

private void UpdateTable() {

// TODO Auto-generated method stub

try {

stmt.execute(UpdateString());

} catch (SQLException e) {

e.printStackTrace();

}

}

private String UpdateString()

{

// TODO Auto-generated method stub

String str="Update "+SelectTable+" Set ";

switch (SelectTable)

{

case Production:

str+="Type_of_production='"+textFieldTypeProd.getText()+"', Description='"+ textFieldDescProd.getText()+"', Quantity='"+ textFieldQuantityProd.getText()+"' ";

break;

case Suppliers:

str+="Name_of_the_organization='"+textFieldNameSupplier.getText()+"', Phone='"+textFieldPhoneSupplier.getText()+"', Director='"+textFieldDirector.getText()+"' ";

break;

case Supply:

str+="idsupplier='"+IdSupplier.getSelectedItemId()+"', Summ="+textFieldSummSupply.getText()+"',Date_of_the_plan_supply='"+ textFieldDoTPS.getText()+"',Date_of_the_fact_supply = '"+textFieldDoTFS.getText()+"' ";

break;

case Description:

str+="idsupply='"+IdSupply.getSelectedItemId()+"', idproduction='"+ IdProduct.getSelectedItemId()+"', Quantity='"+ textFieldSQuantity.getText()+"', Summ_desc='"+ textFieldSSumdesc.getText()+"' ";

break;

case Fuelling:

str+="idclient="+IdClient.getSelectedItemId()+", Date_fuelling='"+ textFieldDateFuelling.getText()+"', Summ_fuelling='"+ textFieldSummFueling.getText()+"' ";

break;

case Description_fuelling:

str+="idfuelling = "+IdFuelling.getSelectedItemId()+", idproduction="+IdProduct.getSelectedItemId()+" ";

break;

case Clients:

//System.out.println(java.sql.Date.valueOf(textFieldDateP.getText()));

str+="FIO ='"+textFieldFIOC.getText()+"',Phone ='"+textFieldPhoneClient.getText()+"', Number_of_the_card ='"+textFieldNCart.getText()+"' ";

break;

}

//return str;

return str+"WHERE id="+dataTable.getValueAt(dataTable.getSelectedRow(),0);

}

private String DeleteString() {

// TODO Auto-generated method stub

return "DELETE FROM "+SelectTable+" WHERE id="+dataTable.getValueAt(dataTable.getSelectedRow(),0)+";";

}

private void DeleteTable() {

// TODO Auto-generated method stub

try {

stmt.execute(DeleteString());

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

private void InsertTable() {

// TODO Auto-generated method stub

try {

stmt.execute(InsertString());

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

private String InsertString() {

// TODO Auto-generated method stub

String str="insert into "+SelectTable;

switch (SelectTable) {

case Production:

str+="(Type_of_production,Description,Quantity) values ('"+ textFieldTypeProd.getText()+"','"+ textFieldDescProd.getText()+"',"+ textFieldQuantityProd.getText()+");";

break;

case Suppliers:

str+="(Name_of_the_organization,Phone,Director) values ('"+ textFieldNameSupplier.getText()+"','"+textFieldPhoneSupplier.getText()+"','"+ textFieldDirector.getText()+"');";

break;

case Supply:

str+="(idsupplier,Summ,Date_of_the_plan_supply,Date_of_the_fact_supply) values ("+IdSupplier.getSelectedItemId()+","+textFieldSummSupply.getText()+",'"+ textFieldDoTPS.getText()+"','"+textFieldDoTFS.getText()+"');";

break;

case Description:

str+="(idsupply,idproduction,Quantity,Summ_desc) values ("+IdSupply.getSelectedItemId()+","+ IdProduct.getSelectedItemId()+","+ textFieldSQuantity.getText()+","+textFieldSSumdesc.getText()+");";

break;

case Fuelling:

str+=" (idclient,Date_fuelling,Summ_fuelling) values ("+IdClient.getSelectedItemId()+",'"+ textFieldDateFuelling.getText()+"',"+ textFieldSummFueling.getText()+");";

break;

case Description_fuelling:

str+="(idfuelling,idproduction) values ("+IdFuelling.getSelectedItemId()+","+IdProduct2.getSelectedItemId()+");";

break;

case Clients:

str+="(FIO,Phone,Number_of_the_card) values ('"+textFieldFIOC.getText()+"',"+textFieldPhoneClient.getText()+","+textFieldNCart.getText()+");";

break;

}

return str;

}

/**

* Заполнение таблицы

*/

private void InitTable() {

// TODO Auto-generated method stub

ResultSet rs=null;

switch(SelectTable)

{

case Inf_about_supply:

rs= getResultViewIOS();

dataTable.setModel(new DTableModel(rs));

break;

case Inf_about_fuelling:

rs= getResultViewIOF();

dataTable.setModel(new DTableModel(rs));

break;

default:

rs= getResultFrom();

dataTable.setModel(new DTableModel(rs));

//Заполняем ComboBox

ComboBoxSuppliers();

ComboBoxProduct();

ComboBoxSupply();

ComboBoxClients();

ComboBoxFuelling();

ComboBoxProduct2();

break;

}

}

/**

* Заполняем combobox

*/

private void ComboBoxFuelling() {

ResultSet rs=null;

IdFuelling.init();

try{

rs=stmt.executeQuery("Select * from Fuelling");

while(rs.next()){

IdFuelling.addElement(rs.getString(1),rs.getString(1));

}

}

catch(SQLException e){}

}

private void ComboBoxSuppliers() {

ResultSet rs=null;

IdSupplier.init();

try{

rs=stmt.executeQuery("Select * from Suppliers");

while(rs.next()){

IdSupplier.addElement(rs.getString(1),rs.getString(2));

}

}

catch(SQLException e){}

}

private void ComboBoxSupply() {

ResultSet rs=null;

IdSupply.init();

try{

rs=stmt.executeQuery("Select * from Supply");

while(rs.next()){

IdSupply.addElement(rs.getString(1),rs.getString(1));

}

}

catch(SQLException e){}

}

private void ComboBoxProduct() {

ResultSet rs=null;

IdProduct.init();

try{

rs=stmt.executeQuery("Select * from Production");

while(rs.next()){

IdProduct.addElement(rs.getString(1),rs.getString(2)+rs.getString(3));

}

}

catch(SQLException e){}

}

private void ComboBoxProduct2() {

ResultSet rs=null;

IdProduct2.init();

try{

rs=stmt.executeQuery("Select * from Production");

while(rs.next()){

IdProduct2.addElement(rs.getString(1),rs.getString(2)+rs.getString(3));

}

}

catch(SQLException e){}

}

private void ComboBoxClients() {

ResultSet rs=null;

IdClient.init();

try{

rs=stmt.executeQuery("Select * from Clients");

while(rs.next()){

IdClient.addElement(rs.getString(1),rs.getString(4));

}

}

catch(SQLException e){}

}

/*МЕТОДЫ ДЛЯ ЗАПРОСОВ!!!!!*/

private ResultSet getResultViewIOF() {

ResultSet rs=null;

try{

rs=stmt.executeQuery("Select * from "+SelectTable+" Where Date_fuelling='"+textFieldIP6.getText()+"' OR Type_of_production='"+textFieldIP5.getText()+"'");

}

catch(SQLException e){}

return rs;

}

private ResultSet getResultViewIOS() {

ResultSet rs=null;

try{

//rs=stmt.executeQuery("Select * from Inf_about_supply");

rs=stmt.executeQuery("Select * from "+SelectTable+" Where Type_of_production='"+textFieldIP3.getText()+"' OR Name_of_the_organization='"+textFieldIP4.getText()+"'");

}

catch(SQLException e){}

return rs;

}

/**

* Строка запроса.

*/

private ResultSet getResultFrom() {

ResultSet rs=null;

try{

rs=stmt.executeQuery("Select * from "+SelectTable);

}

catch(SQLException e){}

return rs;

}

/*ЗАПРОСЫ*/

private void RedactionViewPanel()

{

viewDataPanel = new JPanel();

viewDataPanel.setBounds(10, 22, 409, 180);

contentPanel.add(viewDataPanel);

viewDataPanel.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblIP = new JLabel("");

viewDataPanel.add(lblIP);

textFieldIP = new JTextField();

viewDataPanel.add(textFieldIP);

textFieldIP.setColumns(10);

textFieldIP.setText("");

JLabel lblIP1 = new JLabel("");

viewDataPanel.add(lblIP1);

textFieldIP1 = new JTextField();

viewDataPanel.add(textFieldIP1);

textFieldIP1.setColumns(10);

textFieldIP1.setText("");

JLabel lblIP2 = new JLabel("");

viewDataPanel.add(lblIP2);

textFieldIP2 = new JTextField();

viewDataPanel.add(textFieldIP2);

textFieldIP2.setColumns(10);

textFieldIP2.setText("");

JButton btnSend = new JButton("Send");

btnSend.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}

});

viewDataPanel.add(btnSend);

JButton btnClose = new JButton("Close");

btnClose.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

System.exit(0);

}

});

viewDataPanel.add(btnClose);

}

private void RedactionViewPanel1()

{

viewDataPanel1 = new JPanel();

viewDataPanel1.setBounds(10, 22, 522, 295);

contentPanel.add(viewDataPanel1);

viewDataPanel1.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblIP3 = new JLabel("Наименование продукта:");

viewDataPanel1.add(lblIP3);

textFieldIP3 = new JTextField();

textFieldIP3.setFont(new Font("Tahoma", Font.PLAIN, 20));

textFieldIP3.setBackground(SystemColor.menu);

viewDataPanel1.add(textFieldIP3);

textFieldIP3.setColumns(10);

textFieldIP3.setText("Бензин");

JLabel lblIP4 = new JLabel("Наименование организации поставщика:");

viewDataPanel1.add(lblIP4);

textFieldIP4 = new JTextField();

textFieldIP4.setFont(new Font("Tahoma", Font.PLAIN, 20));

textFieldIP4.setBackground(SystemColor.menu);

viewDataPanel1.add(textFieldIP4);

textFieldIP4.setColumns(10);

textFieldIP4.setText("ОАО Газпром");

JButton btnSend = new JButton("Поиск");

btnSend.setDefaultCapable(false);

btnSend.setFont(new Font("Tahoma", Font.PLAIN, 20));

btnSend.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}

});

viewDataPanel1.add(btnSend);

JButton btnClose = new JButton("Выход");

btnClose.setFont(new Font("Tahoma", Font.PLAIN, 20));

viewDataPanel1.add(btnClose);

btnClose.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

System.exit(0);

}

});

}

private void RedactionViewPanel2()

{

viewDataPanel2 = new JPanel();

viewDataPanel2.setBounds(10, 22, 522, 295);

contentPanel.add(viewDataPanel2);

viewDataPanel2.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblIP3 = new JLabel("Дата заправки авто:");

viewDataPanel2.add(lblIP3);

textFieldIP6 = new JTextField();

textFieldIP6.setFont(new Font("Tahoma", Font.PLAIN, 20));

viewDataPanel2.add(textFieldIP6);

textFieldIP6.setColumns(10);

textFieldIP6.setText("12.12.2012");

JLabel lblIP5 = new JLabel("Вид топлива:");

viewDataPanel2.add(lblIP5);

textFieldIP5 = new JTextField();

textFieldIP5.setFont(new Font("Tahoma", Font.PLAIN, 20));

viewDataPanel2.add(textFieldIP5);

textFieldIP5.setColumns(10);

textFieldIP5.setText("Бензин");

JButton btnSend = new JButton("Поиск");

btnSend.setLocation(new Point(20, 20));

btnSend.setAlignmentX(Component.RIGHT_ALIGNMENT);

btnSend.setBounds(new Rectangle(10, 0, 0, 0));

btnSend.setForeground(SystemColor.desktop);

btnSend.setFont(new Font("Tahoma", Font.PLAIN, 20));

btnSend.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

try {

QueryTable();//запролнение таблицы из бд

} catch (Exception e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}

});

viewDataPanel2.add(btnSend);

JButton btnClose = new JButton("Выход");

btnClose.setFont(new Font("Tahoma", Font.PLAIN, 20));

viewDataPanel2.add(btnClose);

btnClose.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

System.exit(0);

}

});

}

private void RedactionViewPanel3()

{

}

private void RedactionViewPanel4()

{

}

private void RedactionProdPanel()

{

ProdDataPanel = new JPanel();

ProdDataPanel.setToolTipText("\u0418\u043D\u0444\u043E\u0440\u043C\u0430\u0446\u0438\u044F \u043E \u043F\u0440\u043E\u0434\u0443\u043A\u0446\u0438\u0438");

ProdDataPanel.setBounds(10, 22, 409, 205);

contentPanel.add(ProdDataPanel);

ProdDataPanel.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblTypeProd = new JLabel("\u041D\u0430\u0438\u043C\u0435\u043D\u043E\u0432\u0430\u043D\u0438\u0435 \u043F\u0440\u043E\u0434\u0443\u043A\u0446\u0438\u0438:");

lblTypeProd.setFont(new Font("Tahoma", Font.PLAIN, 14));

ProdDataPanel.add(lblTypeProd);

textFieldTypeProd = new JTextField();

textFieldTypeProd.setBackground(SystemColor.menu);

textFieldTypeProd.setFont(new Font("Tahoma", Font.PLAIN, 14));

ProdDataPanel.add(textFieldTypeProd);

textFieldTypeProd.setColumns(15);

JLabel lblDescProd = new JLabel("\u041E\u043F\u0438\u0441\u0430\u043D\u0438\u0435 \u043F\u0440\u043E\u0434\u0443\u043A\u0446\u0438\u0438:");

lblDescProd.setFont(new Font("Tahoma", Font.PLAIN, 14));

ProdDataPanel.add(lblDescProd);

textFieldDescProd = new JTextField();

textFieldDescProd.setBackground(SystemColor.menu);

textFieldDescProd.setFont(new Font("Tahoma", Font.PLAIN, 14));

ProdDataPanel.add(textFieldDescProd);

textFieldDescProd.setColumns(10);

JLabel lblQuantityProd = new JLabel("\u041A\u043E\u043B\u0438\u0447\u0435\u0441\u0442\u0432\u043E \u0435\u0434\u0438\u043D\u0438\u0446 \u043F\u0440\u043E\u0434\u0443\u043A\u0446\u0438\u0438:");

lblQuantityProd.setFont(new Font("Tahoma", Font.PLAIN, 14));

ProdDataPanel.add(lblQuantityProd);

textFieldQuantityProd = new JTextField();

textFieldQuantityProd.setBackground(SystemColor.menu);

textFieldQuantityProd.setFont(new Font("Tahoma", Font.PLAIN, 14));

ProdDataPanel.add(textFieldQuantityProd);

textFieldQuantityProd.setColumns(10);

// ProdDataPanel.setFocusTraversalPolicy(new FocusTraversalOnArray(new Component[]{lblTypeProd, textFieldTypeProd, lblDescProd, textFieldDescProd, lblQuantityProd, textFieldQuantityProd}));

}

/**Элементы для редактирования панели POST*/

private void RedactionSuppliersPanel()

{

SuppliersDataPanel = new JPanel();

SuppliersDataPanel.setToolTipText("\u0421\u0432\u0435\u0434\u0435\u043D\u0438\u044F \u043E \u043F\u043E\u0441\u0442\u0430\u0432\u0449\u0438\u043A\u0430\u0445");

SuppliersDataPanel.setVisible(false);

SuppliersDataPanel.setBounds(10, 22, 385, 190);

contentPanel.add(SuppliersDataPanel);

SuppliersDataPanel.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblNotO = new JLabel("\u041D\u0430\u0438\u043C\u0435\u043D\u043E\u0432\u0430\u043D\u0438\u0435 \u043E\u0440\u0433\u0430\u043D\u0438\u0437\u0430\u0446\u0438\u0438:");

lblNotO.setFont(new Font("Tahoma", Font.PLAIN, 14));

SuppliersDataPanel.add(lblNotO);

textFieldNameSupplier = new JTextField();

textFieldNameSupplier.setBackground(SystemColor.menu);

textFieldNameSupplier.setFont(new Font("Tahoma", Font.PLAIN, 14));

SuppliersDataPanel.add(textFieldNameSupplier);

textFieldNameSupplier.setColumns(10);

JLabel lblPhoneOrg = new JLabel("\u0422\u0435\u043B\u0435\u0444\u043E\u043D:");

lblPhoneOrg.setFont(new Font("Tahoma", Font.PLAIN, 14));

SuppliersDataPanel.add(lblPhoneOrg);

textFieldPhoneSupplier = new JTextField();

textFieldPhoneSupplier.setBackground(SystemColor.menu);

textFieldPhoneSupplier.setFont(new Font("Tahoma", Font.PLAIN, 14));

SuppliersDataPanel.add(textFieldPhoneSupplier);

textFieldPhoneSupplier.setColumns(10);

JLabel lblDirector = new JLabel("\u0414\u0438\u0440\u0435\u043A\u0442\u043E\u0440:");

lblDirector.setFont(new Font("Tahoma", Font.PLAIN, 14));

SuppliersDataPanel.add(lblDirector);

textFieldDirector = new JTextField();

textFieldDirector.setFont(new Font("Tahoma", Font.PLAIN, 14));

textFieldDirector.setBackground(SystemColor.menu);

SuppliersDataPanel.add(textFieldDirector);

textFieldDirector.setColumns(10);

}

/**Элементы для редактирования панели TITLES*/

private void RedactionSupplyPanel()

{

SupplyDataPanel = new JPanel();

SupplyDataPanel.setToolTipText("\u0418\u043D\u0444\u043E\u0440\u043C\u0430\u0446\u0438\u044F \u043E \u043F\u043E\u0441\u0442\u0430\u0432\u043A\u0430\u0445");

SupplyDataPanel.setBounds(10, 22, 436, 230);

contentPanel.add(SupplyDataPanel);

SupplyDataPanel.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblSSupplier = new JLabel(" \u041D\u0430\u0438\u043C\u0435\u043D\u043E\u0432\u0430\u043D\u0438\u0435 \u043E\u0440\u0433\u0430\u043D\u0438\u0437\u0430\u0446\u0438\u0438");

lblSSupplier.setFont(new Font("Tahoma", Font.PLAIN, 14));

SupplyDataPanel.add(lblSSupplier);

IdSupplier=new JDataBaseComboBox();

IdSupplier.setBounds(47, 213, 28, 20);

SupplyDataPanel.add(IdSupplier);

JLabel lblSummSupply = new JLabel(" Сумма поставляемой продукции:");

lblSummSupply.setFont(new Font("Tahoma", Font.PLAIN, 13));

SupplyDataPanel.add(lblSummSupply);

textFieldSummSupply = new JTextField();

textFieldSummSupply.setBackground(SystemColor.menu);

textFieldSummSupply.setFont(new Font("Tahoma", Font.PLAIN, 14));

SupplyDataPanel.add(textFieldSummSupply);

textFieldSummSupply.setColumns(10);

JLabel lblDoTPS = new JLabel(" \u041F\u043B\u0430\u043D\u0438\u0440\u0443\u0435\u043C\u0430\u044F \u0434\u0430\u0442\u0430 \u043F\u043E\u0441\u0442\u0430\u0432\u043A\u0438");

lblDoTPS.setFont(new Font("Tahoma", Font.PLAIN, 14));

SupplyDataPanel.add(lblDoTPS);

textFieldDoTPS = new JTextField();

textFieldDoTPS.setFont(new Font("Tahoma", Font.PLAIN, 14));

textFieldDoTPS.setBackground(SystemColor.menu);

SupplyDataPanel.add(textFieldDoTPS);

textFieldDoTPS.setColumns(10);

JLabel lblDoTFS = new JLabel(" \u0424\u0430\u043A\u0442\u0438\u0447\u0435\u0441\u043A\u0430\u044F \u0434\u0430\u0442\u0430 \u043F\u043E\u0441\u0442\u0430\u0432\u043A\u0438:");

lblDoTFS.setFont(new Font("Tahoma", Font.PLAIN, 14));

SupplyDataPanel.add(lblDoTFS);

textFieldDoTFS = new JTextField();

textFieldDoTFS.setFont(new Font("Tahoma", Font.PLAIN, 14));

textFieldDoTFS.setBackground(SystemColor.menu);

SupplyDataPanel.add(textFieldDoTFS);

textFieldDoTFS.setColumns(10);

}

/**Элементы для редактирования панели CASUALTIES*/

private void RedactionDescriptionPanel()

{

DescriptionDataPanel = new JPanel();

DescriptionDataPanel.setToolTipText("\u041E\u043F\u0438\u0441\u0430\u043D\u0438\u0435 \u043F\u043E\u0441\u0442\u0430\u0432\u043E\u043A");

DescriptionDataPanel.setBounds(10, 22, 409, 180);

contentPanel.add(DescriptionDataPanel);

DescriptionDataPanel.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblSupDesc = new JLabel(" \u041D\u043E\u043C\u0435\u0440 \u043F\u043E\u0441\u0442\u0430\u0432\u043A\u0438:");

lblSupDesc.setFont(new Font("Tahoma", Font.PLAIN, 14));

DescriptionDataPanel.add(lblSupDesc);

IdSupply=new JDataBaseComboBox();

IdSupply.setBounds(47, 213, 28, 20);

DescriptionDataPanel.add(IdSupply);

JLabel lblNameProd = new JLabel(" \u041D\u0430\u0438\u043C\u0435\u043D\u043E\u0432\u0430\u043D\u0438\u0435 \u043F\u0440\u043E\u0434\u0443\u043A\u0446\u0438\u0438:");

lblNameProd.setFont(new Font("Tahoma", Font.PLAIN, 14));

DescriptionDataPanel.add(lblNameProd);

IdProduct=new JDataBaseComboBox();

IdProduct.setBounds(47, 213, 28, 20);

DescriptionDataPanel.add(IdProduct);

JLabel lblSQiantityProdS = new JLabel(" \u041A\u043E\u043B\u0438\u0447\u0435\u0441\u0442\u0432\u043E \u0442\u043E\u0432\u0430\u0440\u0430:");

lblSQiantityProdS.setFont(new Font("Tahoma", Font.PLAIN, 14));

DescriptionDataPanel.add(lblSQiantityProdS);

textFieldSQuantity = new JTextField();

textFieldSQuantity.setBackground(SystemColor.menu);

textFieldSQuantity.setFont(new Font("Tahoma", Font.PLAIN, 14));

DescriptionDataPanel.add(textFieldSQuantity);

textFieldSQuantity.setColumns(10);

JLabel lblSummDesc = new JLabel(" \u0421\u0442\u043E\u0438\u043C\u043E\u0441\u0442\u044C:");

lblSummDesc.setFont(new Font("Tahoma", Font.PLAIN, 14));

DescriptionDataPanel.add(lblSummDesc);

textFieldSSumdesc = new JTextField();

textFieldSSumdesc.setFont(new Font("Tahoma", Font.PLAIN, 14));

textFieldSSumdesc.setBackground(SystemColor.menu);

DescriptionDataPanel.add(textFieldSSumdesc);

textFieldSSumdesc.setColumns(10);

}

/**Элементы для редактирования панели Offenders*/

private void RedactionFuellingPanel()

{

FuellingDataPanel = new JPanel();

FuellingDataPanel.setToolTipText("\u0417\u0430\u043F\u0440\u0430\u0432\u043A\u0430 \u0430\u0432\u0442\u043E");

FuellingDataPanel.setBounds(10, 22, 409, 215);

contentPanel.add(FuellingDataPanel);

FuellingDataPanel.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblClientCard = new JLabel(" \u041D\u043E\u043C\u0435\u0440 \u043A\u0430\u0440\u0442\u044B \u043A\u043B\u0438\u0435\u043D\u0442\u0430 :");

lblClientCard.setFont(new Font("Tahoma", Font.PLAIN, 14));

FuellingDataPanel.add(lblClientCard);

IdClient=new JDataBaseComboBox();

IdClient.setBounds(47, 213, 28, 20);

FuellingDataPanel.add(IdClient);

JLabel lblSummFuel = new JLabel("\u0421\u0443\u043C\u043C\u0430 \u0437\u0430\u043F\u0440\u0430\u0432\u043A\u0438 :");

lblSummFuel.setFont(new Font("Tahoma", Font.PLAIN, 14));

FuellingDataPanel.add(lblSummFuel);

textFieldSummFueling = new JTextField();

textFieldSummFueling.setBackground(SystemColor.menu);

textFieldSummFueling.setFont(new Font("Tahoma", Font.PLAIN, 14));

FuellingDataPanel.add(textFieldSummFueling);

textFieldSummFueling.setColumns(10);

JLabel lblDateFuelling = new JLabel("\u0414\u0430\u0442\u0430 \u0437\u0430\u043F\u0440\u0430\u0432\u043A\u0438 \u0430\u0432\u0442\u043E :");

lblDateFuelling.setFont(new Font("Tahoma", Font.PLAIN, 14));

FuellingDataPanel.add(lblDateFuelling);

textFieldDateFuelling = new JTextField();

textFieldDateFuelling.setFont(new Font("Tahoma", Font.PLAIN, 14));

textFieldDateFuelling.setBackground(SystemColor.menu);

FuellingDataPanel.add(textFieldDateFuelling);

textFieldDateFuelling.setColumns(10);

}

private void RedactionDescFuellingPanel()

{

DescFuellingDataPanel = new JPanel();

DescFuellingDataPanel.setToolTipText("\u041E\u043F\u0438\u0441\u0430\u043D\u0438\u0435 \u0437\u0430\u043F\u0440\u0430\u0432\u043E\u043A \u0430\u0432\u0442\u043E");

DescFuellingDataPanel.setBounds(10, 22, 409, 230);

contentPanel.add(DescFuellingDataPanel);

DescFuellingDataPanel.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblIdFuelling = new JLabel("\u041D\u043E\u043C\u0435\u0440 \u0437\u0430\u043F\u0440\u0430\u0432\u043A\u0438 \u0430\u0432\u0442\u043E:");

lblIdFuelling.setFont(new Font("Tahoma", Font.PLAIN, 14));

DescFuellingDataPanel.add(lblIdFuelling);

IdFuelling=new JDataBaseComboBox();

lblIdFuelling.setBounds(47, 213, 28, 20);

DescFuellingDataPanel.add(IdFuelling);

JLabel lblIdProduct = new JLabel("\u041D\u0430\u0438\u043C\u0435\u043D\u043E\u0432\u0430\u043D\u0438\u0435 \u0442\u043E\u0432\u0430\u0440\u0430:");

lblIdProduct.setFont(new Font("Tahoma", Font.PLAIN, 14));

DescFuellingDataPanel.add(lblIdProduct);

IdProduct2=new JDataBaseComboBox();

IdProduct2.setBounds(47, 213, 28, 20);

DescFuellingDataPanel.add(IdProduct2);

}

private void RedactionClientsPanel()

{

ClientsDataPanel = new JPanel();

ClientsDataPanel.setToolTipText("\u0418\u043D\u0444\u043E\u0440\u043C\u0430\u0446\u0438\u044F \u043E \u043A\u043B\u0438\u0435\u043D\u0442\u0430\u0445");

ClientsDataPanel.setBounds(10, 22, 409, 230);

contentPanel.add(ClientsDataPanel);

ClientsDataPanel.setLayout(new GridLayout(0, 2, 4, 8));

JLabel lblFIOC = new JLabel("\u0424\u0418\u041E \u043A\u043B\u0438\u0435\u043D\u0442\u0430:");

lblFIOC.setFont(new Font("Tahoma", Font.PLAIN, 14));

lblFIOC.setBackground(SystemColor.menu);

ClientsDataPanel.add(lblFIOC);

textFieldFIOC = new JTextField();

textFieldFIOC.setBackground(SystemColor.menu);

textFieldFIOC.setFont(new Font("Tahoma", Font.PLAIN, 14));

ClientsDataPanel.add(textFieldFIOC);

textFieldFIOC.setColumns(10);

JLabel lblPhoneClient = new JLabel("\u0422\u0435\u043B\u0435\u0444\u043E\u043D \u043A\u043B\u0438\u0435\u043D\u0442\u0430:");

lblPhoneClient.setFont(new Font("Tahoma", Font.PLAIN, 14));

ClientsDataPanel.add(lblPhoneClient);

textFieldPhoneClient = new JTextField();

textFieldPhoneClient.setBackground(SystemColor.menu);

textFieldPhoneClient.setFont(new Font("Tahoma", Font.PLAIN, 14));

ClientsDataPanel.add(textFieldPhoneClient);

textFieldPhoneClient.setColumns(10);

JLabel lblNCart = new JLabel("\u041D\u043E\u043C\u0435\u0440 \u043A\u0430\u0440\u0442\u044B \u043A\u043B\u0438\u0435\u043D\u0442\u0430:");

lblNCart.setFont(new Font("Tahoma", Font.PLAIN, 14));

ClientsDataPanel.add(lblNCart);

textFieldNCart = new JTextField();

textFieldNCart.setBackground(SystemColor.menu);

textFieldNCart.setFont(new Font("Tahoma", Font.PLAIN, 14));

ClientsDataPanel.add(textFieldNCart);

textFieldNCart.setColumns(10);

}

private void SelectedRowTableProd(int i){

textFieldTypeProd.setText((String) dataTable.getValueAt(i,1));

textFieldDescProd.setText((String) dataTable.getValueAt(i,2));

textFieldQuantityProd.setText((String) dataTable.getValueAt(i,3));

}

private void SelectedRowTableSupplier(int i)

{

textFieldNameSupplier.setText((String) dataTable.getValueAt(i,1));

textFieldPhoneSupplier.setText((String) dataTable.getValueAt(i,2));

textFieldDirector.setText((String) dataTable.getValueAt(i,3));

}

private void SelectedRowTableDescription(int i)

{

textFieldSQuantity.setText((String) dataTable.getValueAt(i,3));

textFieldSSumdesc.setText((String) dataTable.getValueAt(i,4));

}

private void SelectedRowTableFuelling(int i) {

// TODO Auto-generated method stub

textFieldDateFuelling.setText((String) dataTable.getValueAt(i,3));

textFieldSummFueling.setText((String) dataTable.getValueAt(i,2));

}

private void SelectedRowTableTitles(int i){

textFieldDoTPS.setText((String) dataTable.getValueAt(i,3));

textFieldDoTFS.setText((String) dataTable.getValueAt(i,4));

textFieldSummSupply.setText((String) dataTable.getValueAt(i,2));

}

private void SelectedRowTableDescFuelling(int i){

}

private void SelectedRowTableClients(int i){

textFieldFIOC.setText((String) dataTable.getValueAt(i,1));

textFieldPhoneClient.setText((String) dataTable.getValueAt(i,2));

textFieldNCart.setText((String) dataTable.getValueAt(i,3));

}

}

Размещено на Allbest.ru