Пример #1
0
        private void edit_bt_Click(object sender, EventArgs e)
        {
            int obra_id = Int32.Parse(obras_dataGridView1.CurrentRow.Cells[0].Value.ToString());

            data.connectToDB();
            ObraModel tmp = new ObraModel();

            //String sql = String.Format("SELECT * FROM proj_obras WHERE obra_id = '" + obra_id + "'");
            SqlCommand com = new SqlCommand("getObrasById", data.connection());

            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.AddWithValue("@obra_id", obra_id);
            SqlDataReader reader;

            reader = com.ExecuteReader();
            while (reader.Read())
            {
                tmp.obra_id    = Int32.Parse(reader["obra_id"].ToString());
                tmp.data_ini   = DateTime.Parse(reader["data_ini"].ToString());
                tmp.data_fim   = DateTime.Parse(reader["data_fim"].ToString());
                tmp.orcamento  = Int32.Parse(reader["orcamento"].ToString());
                tmp.condominio = Decimal.Parse(reader["condominio"].ToString());
            }
            data.close();

            tmp.empresa = Decimal.Parse(obras_dataGridView1.CurrentRow.Cells[2].Value.ToString());

            AddObra o = new AddObra(tmp);

            o.ShowDialog(this);
        }
Пример #2
0
        private void add_bt_Click(object sender, EventArgs e)
        {
            AddObra obra = new AddObra();

            obra.ShowDialog(this);
        }