on. Error);
}
}
}
System; System. Collections. Generic; System. ComponentModel; System. Data; System. Drawing; System. Linq; System. Text; System. Windows. Forms; System. Data. SqlClient; System.IO; System. Threading;
WindowsFormsApplication4
{partial class Form3: Form
{Form3 ()
{();
}
void Form3_Load (object sender, EventArgs e)
{connectionstring=server.name; String sqlll=«SELECT * FROM dbo.sotr»; SqlConnection connn=new SqlConnection (connectionstring); SqlDataAdapter dataaa=new SqlDataAdapter (sqlll, connn); DataSet dss=new DataSet (); connn. Open (); dataaa. Fill (dss, «oborud») ;. Close (); dataGridView8. DataSource=dss; dataGridView8. DataMember=«oborud»; (admin.adm == 1)
{. Visible=true ;. Visible=true ;. Visible=true;
}
{. Visible=false ;. Visible=false ;. Visible=false;
}. Items. Add («У роботі»); comboBox5. Items. Add («Списаний»);
comboBox5. Items. Add («ВБН»); if (Data.tumbler == 15 || Data.tumbler == 200)
{. active=13; (Data.tumbler == 15)
{. Text=«Змінити»;}
{. Text=«Зберегти»;} [] t=new string [3]; string tt; String sql=«SELECT inv_nom, zav_nom, naim_oborud, marka, model, data_post, Опис, Списання, Цех, мовляв, Списав, Гарантія, докосн, номзаклнепр, номактоспіс, Датаспіс, нахожд FROM dbo.oborud WHERE (inv_nom=N » + Data. Value + «)»; sqll=«SELECT naim_oborud FROM dbo.naim_oborud»; inv=«SELECT inv_nom FROM dbo.oborud»; con=new SqlConnection (connectionstring); data=new SqlDataAdapter (sql, con); adapter=new SqlDataAdapter (sqll, con); SqlDataAdapter dataadapter=new SqlDataAdapter (inv, con); DataSet ds=new DataSet (); DataSet ds1=new DataSet (); DataSet ds2=new DataSet (); con. Open (); data. Fill (ds, «oborud»); ataadapter. Fill (ds2, «oborud»); adapter. Fill (ds1, «naim_oborud»); con. Close (); dataGridView2. DataSource=ds; dataGridView2. DataMember=«oborud»; textBox1. Text=Convert. ToString (dataGridView2 [0, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [1, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [2, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [3, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [4, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [6, 0] .Value); textBox6. Text=Convert. ToString (dataGridView2 [9, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [7, 0] .Value); comboBox5. SelectedItem=textBox7. Text; textBox7. Text=Convert. ToString (dataGridView2 [7, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [12, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [13, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [14, 0] .Value) ;. Text=Convert. ToString (dataGridView2 [16, 0] .Value);
{numericUpDown1. Value=Convert. ToInt32 (dataGridView2 [11, 0] .Value);
}
{. Value=0;
}=Convert. ToString (dataGridView2 [5, 0] .Value); [0]=Convert. ToString (tt [0]); [0] +=Convert. ToString (tt [1]); [0] +=Convert. ToString (tt [2]); [1]=Convert. ToString (tt [3]); [1] +=Convert. ToString (tt [4]); [1] +=Convert. ToString (tt [5]); [2]=Convert. ToString (tt [6]); [2] +=Convert. ToString (tt [7]); [2] +=Convert. ToString (tt [8]); [2] +=Convert. ToString (tt [9]); tt=t [0]; + ??= t [1]; +=t [2]; +=«00:00:00»; dateTimePicker1. Value=Convert. ToDateTime (tt); (comboBox5. Text == «Списаний»)
{
{= Convert. ToString (dataGridView2 [15, 0] .Value); [0]=Convert. ToString (tt [0]); t [0] +=Convert. ToString (tt [1]); t [0] +=Convert. ToString (tt [2]); t [1]=Convert. ToString (tt [3]); t [1] +=Convert. ToString (tt [4]); t [1] +=Convert. ToString (tt [5]); t [2]=Convert. ToString (tt [6]); t [2] +=Convert. ToString (tt [7]); t [2] +=Convert. ToString (tt [8]); t [2] +=Convert. ToString (tt [9]); tt=t [0]; + ??= t [1]; +=t [2]; +=«00:00:00»; dateTimePicker2. Value=Convert. ToDateTime (tt);} {}
}. DataSource=ds1; dataGridView1. DataMember=«naim_oborud»; for (int i=0; i lt; dataGridView1. RowCount - 1; i ++)
{string s;=Convert. ToString (dataGridView1 [0, i] .Value); comboBox1. Items. Add (s);
}. DataSource=ds2; dataGridView3. DataMember=«oborud»; Data.inventar=new string [dataGridView3. RowCount]; for (int i=0; i lt; dataGridView3. RowCount - 1; i ++)
{. inventar [i]=Convert. ToString (dataGridView3 [0, i] .Value);} sqlmarka=«SELECT marka FROM dbo.marka WHERE naim_oborud=N » + Convert. ToString (dataGridView2 [2, 0] .Value) + «»; sqlmodel=«SELECT model FROM dbo.model WHERE marka=N » + Convert. ToString (dataGridView2 [3, 0] .Value) + «»; String sqlceh=«SELECT * FROM dbo.ceh»; SqlDataAdapter datamarka=new SqlDataAdapter (sqlmarka, con); SqlDataAdapter datamodel=new SqlDataAdapter (sqlmodel, con); SqlDataAdapter dataceh=new Sql...
