Salut a tous
j'ai besoin de votre aide au sujet d'une page en aspx cs cette page retourne un formulaire a remplir ou il ya quelques problemes il ya un inversement des champs fréquences sur un site 1 et fréquence sur un site 2 ces deux champs sont inversés et ça cause des problemes dans l'operateur telecom ou je travaille bon voila le code aidez moi en m'indiquant ou je dois faire des modifications pour annuler ces inversement et Merci:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.OleDb;
namespace transmission
{
/// <summary>
/// Description résumée de D7T_Form.
/// </summary>
public class D7T_Form : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label Label6;
protected System.Web.UI.WebControls.TextBox txt_site1;
protected System.Web.UI.WebControls.TextBox txt_site2;
protected System.Web.UI.WebControls.TextBox txt_Date;
protected System.Web.UI.WebControls.Label Label7;
protected System.Web.UI.WebControls.Label Label8;
protected System.Web.UI.WebControls.TextBox txt_frequence;
protected System.Web.UI.WebControls.Label Label9;
protected System.Web.UI.WebControls.TextBox txt_configuration;
protected System.Web.UI.WebControls.Label Label10;
protected System.Web.UI.WebControls.TextBox txt_capacite_equipement;
protected System.Web.UI.WebControls.Label Label11;
protected System.Web.UI.WebControls.TextBox txt_capacite_requise;
protected System.Web.UI.WebControls.Label Label12;
protected System.Web.UI.WebControls.TextBox txt_equipementier;
protected System.Web.UI.WebControls.Label Label13;
protected System.Web.UI.WebControls.TextBox txt_version;
protected System.Web.UI.WebControls.Label Label14;
protected System.Web.UI.WebControls.TextBox txt_modele_equipement;
protected System.Web.UI.WebControls.Label Label15;
protected System.Web.UI.WebControls.Label Label16;
protected System.Web.UI.WebControls.Label Label17;
protected System.Web.UI.WebControls.Label Label18;
protected System.Web.UI.WebControls.TextBox txt_polarisation;
protected System.Web.UI.WebControls.TextBox txt_canal;
protected System.Web.UI.WebControls.TextBox txt_puissance_emise_theorique;
protected System.Web.UI.WebControls.TextBox txt_puissance_recue_theorique;
protected System.Web.UI.WebControls.Label Label19;
protected System.Web.UI.WebControls.Label Label20;
protected System.Web.UI.WebControls.Label Label21;
protected System.Web.UI.WebControls.Label Label22;
protected System.Web.UI.WebControls.TextBox txt_freq_em1_site1;
protected System.Web.UI.WebControls.TextBox txt_freq_em2_site1;
protected System.Web.UI.WebControls.TextBox txt_puiss_em_site1;
protected System.Web.UI.WebControls.TextBox txt_puiss_rec_site1;
protected System.Web.UI.WebControls.TextBox txt_freq_em1_site2;
protected System.Web.UI.WebControls.TextBox txt_freq_em2_site2;
protected System.Web.UI.WebControls.TextBox txt_puiss_em_site2;
protected System.Web.UI.WebControls.TextBox txt_puiss_rec_site2;
protected System.Web.UI.WebControls.Label Label23;
protected System.Web.UI.WebControls.Label Label24;
protected System.Web.UI.WebControls.Label Label25;
protected System.Web.UI.WebControls.Label Label26;
protected System.Web.UI.WebControls.Label Label27;
protected System.Web.UI.WebControls.TextBox txt_numserie_antenne_extension_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_antenne_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_antenne_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_antenne_principal_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_tribint_extension_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_tribint_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_tribint_principal_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_controller_extension_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_controller_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_controller_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_controller_principal_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_rtm_extension_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_rtm_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_rtm_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_rtm_principal_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_odu_extension_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_odu_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_odu_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_odu_principal_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_idu_extension_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_idu_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_numserie_idu_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_tribint_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_numserie_idu_principal_site1;
protected System.Web.UI.WebControls.Label Label28;
protected System.Web.UI.WebControls.Label Label29;
protected System.Web.UI.WebControls.Label Label30;
protected System.Web.UI.WebControls.Label Label31;
protected System.Web.UI.WebControls.Label Label32;
protected System.Web.UI.WebControls.Label Label33;
protected System.Web.UI.WebControls.Label Label34;
protected System.Web.UI.WebControls.Label Label35;
protected System.Web.UI.WebControls.Label Label36;
protected System.Web.UI.WebControls.Label Label37;
protected System.Web.UI.WebControls.Label Label38;
protected System.Web.UI.WebControls.TextBox txt_taille_ant_principal_site1;
protected System.Web.UI.WebControls.TextBox txt_nbre_ant_principal_site1;
protected System.Web.UI.WebControls.TextBox txt_hauteur_ant_principal_site1;
protected System.Web.UI.WebControls.TextBox txt_taille_ant_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_nbre_ant_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_hauteur_ant_extension_site1;
protected System.Web.UI.WebControls.TextBox txt_taille_ant_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_taille_ant_extension_site2;
protected System.Web.UI.WebControls.TextBox txt_nbre_ant_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_nbre_ant_extension_site2;
protected System.Web.UI.WebControls.TextBox txt_hauteur_ant_principal_site2;
protected System.Web.UI.WebControls.TextBox txt_hauteur_ant_extension_site2;
protected System.Web.UI.WebControls.RadioButtonList brakon_site1;
protected System.Web.UI.WebControls.RadioButtonList brakon_site2;
protected System.Web.UI.WebControls.Label Label39;
protected System.Web.UI.WebControls.Label Label40;
protected System.Web.UI.WebControls.Label Label41;
protected System.Web.UI.WebControls.Label Label42;
protected System.Web.UI.WebControls.Label Label43;
protected System.Web.UI.WebControls.RadioButtonList mise_a_terre_rack_site1;
protected System.Web.UI.WebControls.RadioButtonList mise_a_terre_rack_site2;
protected System.Web.UI.WebControls.RadioButtonList mise_a_terre_idu_site1;
protected System.Web.UI.WebControls.RadioButtonList mise_a_terre_idu_site2;
protected System.Web.UI.WebControls.RadioButtonList mise_a_terre_odu_site1;
protected System.Web.UI.WebControls.RadioButtonList mise_a_terre_odu_site2;
protected System.Web.UI.WebControls.RadioButtonList mise_a_terre_cableIF_site1;
protected System.Web.UI.WebControls.RadioButtonList mise_a_terre_cableIF_site2;
protected System.Web.UI.WebControls.Label Label44;
protected System.Web.UI.WebControls.Label Label45;
protected System.Web.UI.WebControls.Label Label46;
protected System.Web.UI.WebControls.TextBox txt_energie_mesuree;
protected System.Web.UI.WebControls.Label Label47;
protected System.Web.UI.WebControls.RadioButtonList resultat_energie;
protected System.Web.UI.WebControls.Label Label48;
protected System.Web.UI.WebControls.Label Label49;
protected System.Web.UI.WebControls.Label Label50;
protected System.Web.UI.WebControls.Label Label51;
protected System.Web.UI.WebControls.RadioButtonList etancheite_odu_site1;
protected System.Web.UI.WebControls.RadioButtonList etancheite_odu_site2;
protected System.Web.UI.WebControls.RadioButtonList etancheite_tremie_site1;
protected System.Web.UI.WebControls.RadioButtonList etancheite_tremie_site2;
protected System.Web.UI.WebControls.RadioButtonList etancheite_proprete_site1;
protected System.Web.UI.WebControls.RadioButtonList etancheite_proprete_site2;
protected System.Web.UI.WebControls.Label Label52;
protected System.Web.UI.WebControls.RadioButtonList supervision;
protected System.Web.UI.WebControls.Label Label53;
protected System.Web.UI.WebControls.TextBox txt_ip_site1;
protected System.Web.UI.WebControls.TextBox txt_ip_site2;
protected System.Web.UI.WebControls.Label Label54;
protected System.Web.UI.WebControls.Label Label55;
protected System.Web.UI.WebControls.TextBox txt_zone_ospf_site1;
protected System.Web.UI.WebControls.TextBox txt_zone_ospf_site2;
protected System.Web.UI.WebControls.TextBox txt_mask_site1;
protected System.Web.UI.WebControls.TextBox txt_mask_site2;
protected System.Web.UI.WebControls.Label Label56;
protected System.Web.UI.WebControls.RadioButtonList cable_nms_vbus_site2;
protected System.Web.UI.WebControls.RadioButtonList cable_nms_vbus_site1;
protected System.Web.UI.WebControls.Label Label57;
protected System.Web.UI.WebControls.RadioButtonList label_nms_vbus_site1;
protected System.Web.UI.WebControls.RadioButtonList label_nms_vbus_site2;
protected System.Web.UI.WebControls.Label Label58;
protected System.Web.UI.WebControls.Label Label59;
protected System.Web.UI.WebControls.Label Label60;
protected System.Web.UI.WebControls.RadioButtonList deconnection_affluent_site1;
protected System.Web.UI.WebControls.RadioButtonList deconnection_affluent_site2;
protected System.Web.UI.WebControls.RadioButtonList deconnection_idu_odu_site1;
protected System.Web.UI.WebControls.RadioButtonList deconnection_idu_odu_site2;
protected System.Web.UI.WebControls.Label Label61;
protected System.Web.UI.WebControls.Label Label62;
protected System.Web.UI.WebControls.Label Label63;
protected System.Web.UI.WebControls.Label Label64;
protected System.Web.UI.WebControls.Label Label65;
protected System.Web.UI.WebControls.RadioButtonList agregat_idu_site1;
protected System.Web.UI.WebControls.RadioButtonList agregat_idu_site2;
protected System.Web.UI.WebControls.RadioButtonList agregat_odu_site1;
protected System.Web.UI.WebControls.RadioButtonList agregat_odu_site2;
protected System.Web.UI.WebControls.RadioButtonList rf_site1;
protected System.Web.UI.WebControls.RadioButtonList rf_site2;
protected System.Web.UI.WebControls.RadioButtonList affl_distant_site1;
protected System.Web.UI.WebControls.RadioButtonList affl_distant_site2;
protected System.Web.UI.WebControls.Label Label66;
protected System.Web.UI.WebControls.Label Label67;
protected System.Web.UI.WebControls.Label Label68;
protected System.Web.UI.WebControls.Label Label69;
protected System.Web.UI.WebControls.Label Label70;
protected System.Web.UI.WebControls.Label Label71;
protected System.Web.UI.WebControls.RadioButtonList comm_aut_tx1x_site1;
protected System.Web.UI.WebControls.RadioButtonList comm_aut_tx1x_site2;
protected System.Web.UI.WebControls.RadioButtonList comm_aut_txx1_site1;
protected System.Web.UI.WebControls.RadioButtonList comm_aut_txx1_site2;
protected System.Web.UI.WebControls.RadioButtonList comm_aut_rx1x_site1;
protected System.Web.UI.WebControls.RadioButtonList comm_aut_rx1x_site2;
protected System.Web.UI.WebControls.RadioButtonList comm_aut_rxx1_site1;
protected System.Web.UI.WebControls.RadioButtonList comm_aut_rxx1_site2;
protected System.Web.UI.WebControls.Label Label72;
protected System.Web.UI.WebControls.Label Label73;
protected System.Web.UI.WebControls.Label Label74;
protected System.Web.UI.WebControls.Label Label75;
protected System.Web.UI.WebControls.Label Label76;
protected System.Web.UI.WebControls.RadioButtonList comm_man_tx1x_site1;
protected System.Web.UI.WebControls.RadioButtonList comm_man_tx1x_site2;
protected System.Web.UI.WebControls.RadioButtonList comm_man_txx1_site1;
protected System.Web.UI.WebControls.RadioButtonList comm_man_txx1_site2;
protected System.Web.UI.WebControls.RadioButtonList comm_man_rx1x_site1;
protected System.Web.UI.WebControls.RadioButtonList comm_man_rx1x_site2;
protected System.Web.UI.WebControls.RadioButtonList comm_man_rxx1_site1;
protected System.Web.UI.WebControls.RadioButtonList comm_man_rxx1_site2;
protected System.Web.UI.WebControls.Label Label77;
protected System.Web.UI.WebControls.Label Label78;
protected System.Web.UI.WebControls.RadioButtonList coffret_indoor_idu_site1;
protected System.Web.UI.WebControls.RadioButtonList coffret_indoor_idu_site2;
protected System.Web.UI.WebControls.Label Label79;
protected System.Web.UI.WebControls.Label Label80;
protected System.Web.UI.WebControls.Label Label81;
protected System.Web.UI.WebControls.RadioButtonList cables_indoor_coax_site1;
protected System.Web.UI.WebControls.RadioButtonList cables_indoor_coax_site2;
protected System.Web.UI.WebControls.Label Label82;
protected System.Web.UI.WebControls.RadioButtonList cables_indoor_energie_site1;
protected System.Web.UI.WebControls.RadioButtonList cables_indoor_energie_site2;
protected System.Web.UI.WebControls.Label Label83;
protected System.Web.UI.WebControls.RadioButtonList cables_indoor_pcm_site1;
protected System.Web.UI.WebControls.RadioButtonList cables_indoor_pcm_site2;
protected System.Web.UI.WebControls.Label Label84;
protected System.Web.UI.WebControls.Label Label85;
protected System.Web.UI.WebControls.RadioButtonList bandeau_indoor_disjoncteur_site1;
protected System.Web.UI.WebControls.RadioButtonList bandeau_indoor_disjoncteur_site2;
protected System.Web.UI.WebControls.Label Label86;
protected System.Web.UI.WebControls.RadioButtonList bandeau_indoor_19_site1;
protected System.Web.UI.WebControls.RadioButtonList bandeau_indoor_19_site2;
protected System.Web.UI.WebControls.Label Label87;
protected System.Web.UI.WebControls.RadioButtonList bandeau_indoor_fermeDDF_site1;
protected System.Web.UI.WebControls.RadioButtonList bandeau_indoor_fermeDDF_site2;
protected System.Web.UI.WebControls.Label Label88;
protected System.Web.UI.WebControls.Label Label89;
protected System.Web.UI.WebControls.RadioButtonList coffret_outdoor_odu_site1;
protected System.Web.UI.WebControls.RadioButtonList coffret_outdoor_odu_site2;
protected System.Web.UI.WebControls.Label Label90;
protected System.Web.UI.WebControls.Label Label91;
protected System.Web.UI.WebControls.RadioButtonList cables_outdoor_coax_site1;
protected System.Web.UI.WebControls.RadioButtonList cables_outdoor_coax_site2;
protected System.Web.UI.WebControls.Label Label92;
protected System.Web.UI.WebControls.RadioButtonList test_qualite;
protected System.Web.UI.WebControls.Label Label93;
protected System.Web.UI.WebControls.TextBox txt_duree;
protected System.Web.UI.WebControls.Label Label94;
protected System.Web.UI.WebControls.Label Label95;
protected System.Web.UI.WebControls.RadioButtonList proprete_installation_site1;
protected System.Web.UI.WebControls.RadioButtonList proprete_installation_site2;
protected System.Web.UI.WebControls.Label Label96;
protected System.Web.UI.WebControls.Label Label97;
protected System.Web.UI.WebControls.CheckBox conforme;
protected System.Web.UI.WebControls.Label Label98;
protected System.Web.UI.WebControls.RadioButtonList reserves;
protected System.Web.UI.WebControls.Label Label99;
protected System.Web.UI.WebControls.Button btn_valider;
protected System.Web.UI.WebControls.TextBox txt_observations;
protected System.Web.UI.WebControls.Button btn_ok;
protected System.Web.UI.WebControls.TextBox txt_heure;
protected System.Web.UI.WebControls.Label Label100;
protected System.Web.UI.WebControls.RadioButtonList list_proprete_site2;
protected System.Web.UI.WebControls.RadioButtonList list_proprete_site1;
protected System.Web.UI.WebControls.Label Label101;
protected System.Web.UI.WebControls.TextBox txt_loss;
protected System.Web.UI.WebControls.DropDownList list1;
protected System.Web.UI.WebControls.ImageButton btn_search;
protected System.Web.UI.WebControls.Label lbl_erreur;
protected System.Web.UI.WebControls.Label Label102;
protected System.Web.UI.WebControls.Label Label103;
protected System.Web.UI.WebControls.Label Label104;
protected System.Web.UI.WebControls.Label Label105;
protected System.Web.UI.WebControls.Label Label106;
protected System.Web.UI.WebControls.Label Label107;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.TextBox txt_fournisseur;
protected System.Web.UI.WebControls.TextBox TextBox6;
protected System.Web.UI.WebControls.TextBox txt_NomDate_client;
protected System.Web.UI.WebControls.TextBox txt_NomDate_fournisseur;
protected System.Web.UI.WebControls.Label Label108;
protected System.Web.UI.WebControls.RadioButtonList atpc;
protected System.Web.UI.WebControls.Label Label109;
protected System.Web.UI.WebControls.RadioButtonList odu_conf_hd;
protected System.Web.UI.WebControls.RadioButtonList odu_conf_hp;
protected System.Web.UI.WebControls.Label Label110;
protected System.Web.UI.WebControls.Label Label111;
protected System.Web.UI.WebControls.Label Label112;
protected System.Web.UI.WebControls.Label Label113;
protected System.Web.UI.WebControls.RadioButtonList v11_card_site1;
protected System.Web.UI.WebControls.RadioButtonList v11_card_site2;
protected System.Web.UI.WebControls.Label Label114;
protected System.Web.UI.WebControls.TextBox txt_Date2;
protected System.Web.UI.WebControls.ImageButton Imagebutton2;
protected System.Web.UI.WebControls.Calendar Calendar2;
protected System.Web.UI.WebControls.Calendar Calendar3;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DropDownList list_model_equipment;
protected System.Web.UI.WebControls.RadioButtonList odu_conf_nd;
protected System.Web.UI.WebControls.Calendar Calendar1;
private void Page_Load(object sender, System.EventArgs e)
{
if (Session["fonction"].ToString() == "acceptance" || Session["fonction"].ToString() == "admin" || Session["fonction"].ToString() == "LL")
{
SqlConnection conn1 = new SqlConnection();
//conn1.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False; Trusted_Connection=Yes; Initial Catalog=base_trans;Data Source=INES;Packet Size=4096;Workstation ID=INES;";
conn1.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False; Trusted_Connection=Yes; Initial Catalog=base_trans;Data Source=dttpe005;Packet Size=4096;Workstation ID=dttpe005;";
conn1.Open();
SqlDataAdapter da1 = new SqlDataAdapter();
DataSet ds1 = new DataSet();
SqlCommand cmd1 = new SqlCommand("link_name_D7T");
cmd1.Connection = conn1;
cmd1.CommandType = CommandType.StoredProcedure;
da1.SelectCommand = cmd1;
da1.Fill(ds1);
DataTable t = new DataTable();
t = ds1.Tables[0];
int i = 0;
foreach (DataRow r1 in t.Rows)
{
list1.Items.Add(r1["link_name"].ToString());
i++;
}
conn1.Close();
}
else
Response.Redirect("access_denied.aspx");
}
#region Code généré par le Concepteur Web Form
override protected void OnInit(EventArgs e)
{
//
// CODEGEN : Cet appel est requis par le Concepteur Web Form ASP.NET.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Méthode requise pour la prise en charge du concepteur - ne modifiez pas
/// le contenu de cette méthode avec l'éditeur de code.
/// </summary>
private void InitializeComponent()
{
this.Calendar3.SelectionChanged += new System.EventHandler(this.Calendar3_SelectionChanged);
this.Imagebutton2.Click += new System.Web.UI.ImageClickEventHandler(this.Imagebutton2_Click);
this.txt_Date2.TextChanged += new System.EventHandler(this.txt_Date2_TextChanged);
this.btn_search.Click += new System.Web.UI.ImageClickEventHandler(this.btn_search_Click);
this.Calendar1.SelectionChanged += new System.EventHandler(this.Calendar1_SelectionChanged);
this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
this.txt_Date.TextChanged += new System.EventHandler(this.txt_Date_TextChanged);
this.btn_valider.Click += new System.EventHandler(this.btn_valider_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Calendar1.Visible = true;
}
private void Calendar1_SelectionChanged(object sender, System.EventArgs e)
{
System.DateTime dtime;
dtime = Calendar1.SelectedDate;
txt_Date.Text = dtime.ToShortDateString();
Calendar1.Visible = false;
}
private void txt_Date_TextChanged(object sender, System.EventArgs e)
{
Calendar1.Visible = false;
}
private void btn_valider_Click(object sender, System.EventArgs e)
{
test_qualite.BackColor = Color.Transparent;
resultat_energie.BackColor = Color.Transparent;
reserves.BackColor = Color.Transparent;
brakon_site1.BackColor = Color.Transparent;
brakon_site2.BackColor = Color.Transparent;
mise_a_terre_rack_site1.BackColor = Color.Transparent;
mise_a_terre_rack_site2.BackColor = Color.Transparent;
mise_a_terre_idu_site1.BackColor = Color.Transparent;
mise_a_terre_idu_site2.BackColor = Color.Transparent;
mise_a_terre_odu_site1.BackColor = Color.Transparent;
mise_a_terre_odu_site2.BackColor = Color.Transparent;
mise_a_terre_cableIF_site1.BackColor = Color.Transparent;
mise_a_terre_cableIF_site2.BackColor = Color.Transparent;
etancheite_odu_site1.BackColor = Color.Transparent;
etancheite_odu_site2.BackColor = Color.Transparent;
etancheite_tremie_site1.BackColor = Color.Transparent;
etancheite_tremie_site2.BackColor = Color.Transparent;
etancheite_proprete_site1.BackColor = Color.Transparent;
etancheite_proprete_site2.BackColor = Color.Transparent;
cable_nms_vbus_site1.BackColor = Color.Transparent;
cable_nms_vbus_site2.BackColor = Color.Transparent;
label_nms_vbus_site1.BackColor = Color.Transparent;
label_nms_vbus_site2.BackColor = Color.Transparent;
coffret_indoor_idu_site1.BackColor = Color.Transparent;
coffret_indoor_idu_site2.BackColor = Color.Transparent;
cables_indoor_coax_site1.BackColor = Color.Transparent;
cables_indoor_coax_site2.BackColor = Color.Transparent;
cables_indoor_energie_site1.BackColor = Color.Transparent;
cables_indoor_energie_site2.BackColor = Color.Transparent;
cables_indoor_pcm_site1.BackColor = Color.Transparent;
cables_indoor_pcm_site2.BackColor = Color.Transparent;
bandeau_indoor_disjoncteur_site1.BackColor = Color.Transparent;
bandeau_indoor_disjoncteur_site2.BackColor = Color.Transparent;
bandeau_indoor_19_site1.BackColor = Color.Transparent;
bandeau_indoor_19_site2.BackColor = Color.Transparent;
bandeau_indoor_fermeDDF_site1.BackColor = Color.Transparent;
bandeau_indoor_fermeDDF_site2.BackColor = Color.Transparent;
coffret_outdoor_odu_site1.BackColor = Color.Transparent;
coffret_outdoor_odu_site2.BackColor = Color.Transparent;
cables_outdoor_coax_site1.BackColor = Color.Transparent;
cables_outdoor_coax_site2.BackColor = Color.Transparent;
deconnection_affluent_site1.BackColor = Color.Transparent;
deconnection_affluent_site2.BackColor = Color.Transparent;
deconnection_idu_odu_site1.BackColor = Color.Transparent;
deconnection_idu_odu_site2.BackColor = Color.Transparent;
agregat_idu_site1.BackColor = Color.Transparent;
agregat_idu_site2.BackColor = Color.Transparent;
agregat_odu_site1.BackColor = Color.Transparent;
agregat_odu_site2.BackColor = Color.Transparent;
rf_site1.BackColor = Color.Transparent;
rf_site2.BackColor = Color.Transparent;
affl_distant_site1.BackColor = Color.Transparent;
affl_distant_site2.BackColor = Color.Transparent;
comm_aut_tx1x_site1.BackColor = Color.Transparent;
comm_aut_tx1x_site2.BackColor = Color.Transparent;
comm_aut_txx1_site1.BackColor = Color.Transparent;
comm_aut_txx1_site2.BackColor = Color.Transparent;
comm_aut_rx1x_site1.BackColor = Color.Transparent;
comm_aut_rx1x_site2.BackColor = Color.Transparent;
comm_aut_rxx1_site1.BackColor = Color.Transparent;
comm_aut_rxx1_site2.BackColor = Color.Transparent;
comm_man_tx1x_site1.BackColor = Color.Transparent;
comm_man_tx1x_site2.BackColor = Color.Transparent;
comm_man_txx1_site1.BackColor = Color.Transparent;
comm_man_txx1_site2.BackColor = Color.Transparent;
comm_man_rx1x_site1.BackColor = Color.Transparent;
comm_man_rx1x_site2.BackColor = Color.Transparent;
comm_man_rxx1_site1.BackColor = Color.Transparent;
comm_man_rxx1_site2.BackColor = Color.Transparent;
proprete_installation_site1.BackColor = Color.Transparent;
proprete_installation_site2.BackColor = Color.Transparent;
list_proprete_site1.BackColor = Color.Transparent;
list_proprete_site2.BackColor = Color.Transparent;
txt_NomDate_client.BackColor = Color.Transparent;
txt_NomDate_fournisseur.BackColor = Color.Transparent;
supervision.BackColor = Color.Transparent;
atpc.BackColor = Color.Transparent;
odu_conf_nd.BackColor = Color.Transparent;
odu_conf_hd.BackColor = Color.Transparent;
odu_conf_hp.BackColor = Color.Transparent;
v11_card_site1.BackColor = Color.Transparent;
v11_card_site2.BackColor = Color.Transparent;
txt_puiss_em_site1.BackColor = Color.Transparent;
txt_puiss_rec_site1.BackColor = Color.Transparent;
txt_puiss_em_site2.BackColor = Color.Transparent;
txt_puiss_rec_site2.BackColor = Color.Transparent;
txt_Date.BackColor = Color.Transparent;
txt_Date2.BackColor = Color.Transparent;
///// connexion à la base //////////////
SqlConnection connSQL = new SqlConnection();
//connSQL.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False; Trusted_Connection=Yes; Initial Catalog=base_trans;Data Source=INES;Packet Size=4096;Workstation ID=INES;";
connSQL.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False; Trusted_Connection=Yes; Initial Catalog=base_trans;Data Source=dttpe005;Packet Size=4096;Workstation ID=dttpe005;";
connSQL.Open();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("select_link");
SqlParameter ln = new SqlParameter("@link_name", SqlDbType.VarChar);
DataSet ds = new DataSet();
cmd.Connection = connSQL;
cmd.CommandType = CommandType.StoredProcedure;
ln.Value = list1.SelectedItem.Text;
cmd.Parameters.Add(ln);
da.SelectCommand = cmd;
da.Fill(ds);
SqlDataAdapter da0 = new SqlDataAdapter();
SqlCommand cmd0 = new SqlCommand("select_channel_id_1");
SqlParameter linkid0 = new SqlParameter("@mwlink_id", SqlDbType.VarChar);
DataSet ds0 = new DataSet();
cmd0.Connection = connSQL;
cmd0.CommandType = CommandType.StoredProcedure;
linkid0.Value = ds.Tables[0].Rows[0]["mwlink_id"].ToString();
cmd0.Parameters.Add(linkid0);
da0.SelectCommand = cmd0;
da0.Fill(ds0);
if (Convert.ToInt16(ds0.Tables[0].Rows[0]["T_Channel_ID"]) == 45)
{
int i1 = txt_freq_em1_site1.Text.IndexOf("Mhz");
int i2 = txt_freq_em1_site2.Text.IndexOf("Mhz");
float f1 = Convert.ToSingle(txt_freq_em1_site1.Text.Substring(0,i1).Trim());
float f2 = Convert.ToSingle(txt_freq_em1_site2.Text.Substring(0,i2).Trim());
SqlDataAdapter da5 = new SqlDataAdapter();
DataSet ds5 = new DataSet();
SqlCommand cmd5 = new SqlCommand("select_Channel_ID");
SqlParameter low_freq = new SqlParameter("@low_freq", SqlDbType.Float);
SqlParameter heigh_freq = new SqlParameter("@heigh_freq", SqlDbType.Float);
SqlParameter cn = new SqlParameter("@channel_number", SqlDbType.Int);
cmd5.Connection = connSQL;
cmd5.CommandType = CommandType.StoredProcedure;
int nbr;
nbr = txt_canal.Text.Length;
cn.Value = Convert.ToInt16(txt_canal.Text.Substring(0,nbr-1));
low_freq.Value = f1;
heigh_freq.Value = f2;
cmd5.Parameters.Add(low_freq);
cmd5.Parameters.Add(heigh_freq);
cmd5.Parameters.Add(cn);
da5.SelectCommand = cmd5;
da5.Fill(ds5);
int ch = Convert.ToInt16(ds5.Tables[0].Rows[0]["T_Channel_ID"]);
SqlDataAdapter da7 = new SqlDataAdapter();
DataSet ds7 = new DataSet();
SqlCommand cmd7 = new SqlCommand("select_link");
SqlParameter link_name7 = new SqlParameter("@link_name", SqlDbType.VarChar);
cmd7.Connection = connSQL;
cmd7.CommandType = CommandType.StoredProcedure;
link_name7.Value = list1.SelectedItem.Text;
cmd7.Parameters.Add(link_name7);
da7.SelectCommand = cmd7;
da7.Fill(ds7);
SqlCommand cmd4 = new SqlCommand("update_channel");
SqlParameter T_Channel_ID4 = new SqlParameter("@T_Channel_ID",SqlDbType.Int);
SqlParameter linkid4 = new SqlParameter("@mwlink_id",SqlDbType.VarChar);
cmd4.Connection = connSQL;
cmd4.CommandType = CommandType.StoredProcedure;
T_Channel_ID4.Value = ch;
linkid4.Value = ds7.Tables[0].Rows[0]["mwlink_id"];
cmd4.Parameters.Add(T_Channel_ID4);
cmd4.Parameters.Add(linkid4);
cmd4.ExecuteNonQuery();
}
SqlCommand cmd1 = new SqlCommand("insert_test_d7t");
SqlParameter test_qualite1 = new SqlParameter("@test_qualite",SqlDbType.VarChar);
SqlParameter duree1 = new SqlParameter("@duree",SqlDbType.VarChar);
SqlParameter energie_mesuree1 = new SqlParameter("@energie_mesuree",SqlDbType.Float);
SqlParameter test_energie1 = new SqlParameter("@test_energie",SqlDbType.Bit);
SqlParameter conforme1 = new SqlParameter("@conforme",SqlDbType.Bit);
SqlParameter reserves1 = new SqlParameter("@reserves",SqlDbType.VarChar);
SqlParameter observations1 = new SqlParameter("@observations",SqlDbType.VarChar);
SqlParameter date1 = new SqlParameter("@date",SqlDbType.DateTime);
SqlParameter mwlink_ID1 = new SqlParameter("@mwlink_ID",SqlDbType.VarChar);
SqlParameter matricule1 = new SqlParameter("@matricule",SqlDbType.VarChar);
SqlParameter nomDate_Client1 = new SqlParameter("@nomDate_Client",SqlDbType.VarChar);
SqlParameter nomDate_Fournisseur1 = new SqlParameter("@nomDate_Fournisseur",SqlDbType.VarChar);
cmd1.Connection = connSQL;
cmd1.CommandType = CommandType.StoredProcedure;
matricule1.Value = Session["matricule"].ToString();
cmd1.Parameters.Add(matricule1);
if (txt_NomDate_client.Text != "")
nomDate_Client1.Value = txt_NomDate_client.Text;
else goto sortie74;
cmd1.Parameters.Add(nomDate_Client1);
if (txt_NomDate_fournisseur.Text != "")
nomDate_Fournisseur1.Value = txt_NomDate_fournisseur.Text;
else goto sortie75;
cmd1.Parameters.Add(nomDate_Fournisseur1);
if (test_qualite.Items[0].Selected || test_qualite.Items[1].Selected || test_qualite.Items[2].Selected)
{
switch(test_qualite.SelectedItem.Text)
{
case "OK" :
test_qualite1.Value = "OK";
break;
case "NOK" :
test_qualite1.Value = "NOK";
break;
case "NA" :
test_qualite1.Value = "NA";
break;
}
}
else goto sortie1;
cmd1.Parameters.Add(test_qualite1);
duree1.Value = txt_duree.Text;
cmd1.Parameters.Add(duree1);
if (txt_energie_mesuree.Text != "")
{
try
{
energie_mesuree1.Value = Convert.ToSingle(txt_energie_mesuree.Text.Trim());
}
catch
{
lbl_erreur.Visible = true;
lbl_erreur.Text = "Vérifiez la valeur de l'énergie !";
connSQL.Close();
goto fin;
}
if (resultat_energie.Items[0].Selected || resultat_energie.Items[1].Selected)
{
switch(resultat_energie.SelectedItem.Text)
{
case "OK" :
test_energie1.Value = true;
break;
case "NOK" :
test_energie1.Value = false;
break;
}
}
else goto sortie2;
}
else
{
energie_mesuree1.Value = -48;
test_energie1.Value = true;
}
cmd1.Parameters.Add(energie_mesuree1);
cmd1.Parameters.Add(test_energie1);
if (conforme.Checked)
conforme1.Value = true;
else
conforme1.Value = false;
cmd1.Parameters.Add(conforme1);
if (reserves.Items[0].Selected || reserves.Items[1].Selected)
{
switch(reserves.SelectedItem.Text)
{
case "MINEURES" :
reserves1.Value = "MINEURES";
break;
case "MAJEURES" :
reserves1.Value = "MAJEURES";
break;
}
}
else reserves1.Value = "SANS RESERVES";
cmd1.Parameters.Add(reserves1);
if (txt_observations.Text != "")
observations1.Value = txt_observations.Text;
else
observations1.Value = "";
cmd1.Parameters.Add(observations1);
DateTime d1 = DateTime.Today;
string d2 = txt_Date.Text + " " + txt_heure.Text;
try
{
d1 = Convert.ToDateTime(d2);
}
catch
{
lbl_erreur.Visible = true;
txt_Date.BackColor = Color.Pink;
lbl_erreur.Text = "Vérifiez la date, l'heure doit être de la forme HH:MM:SS";
connSQL.Close();
goto fin;
}
date1.Value = d1;
cmd1.Parameters.Add(date1);
mwlink_ID1.Value = ds.Tables[0].Rows[0]["mwlink_ID"].ToString();
cmd1.Parameters.Add(mwlink_ID1);
SqlCommand cmd2 = new SqlCommand("insert_antenna_d7t");
SqlParameter num_serie_antenne_principal21 = new SqlParameter("@num_serie_antenne_principal1",SqlDbType.VarChar);
SqlParameter num_serie_antenne_principal22 = new SqlParameter("@num_serie_antenne_principal2",SqlDbType.VarChar);
SqlParameter num_serie_antenne_extension21 = new SqlParameter("@num_serie_antenne_extension1",SqlDbType.VarChar);
SqlParameter num_serie_antenne_extension22 = new SqlParameter("@num_serie_antenne_extension2",SqlDbType.VarChar);
SqlParameter nbre_antenne_principal21 = new SqlParameter("@nbre_antenne_principal1",SqlDbType.Int);
SqlParameter nbre_antenne_principal22 = new SqlParameter("@nbre_antenne_principal2",SqlDbType.Int);
SqlParameter nbre_antenne_extension21 = new SqlParameter("@nbre_antenne_extension1",SqlDbType.Int);
SqlParameter nbre_antenne_extension22 = new SqlParameter("@nbre_antenne_extension2",SqlDbType.Int);
SqlParameter hauteur_antenne_principal21 = new SqlParameter("@hauteur_antenne_principal1",SqlDbType.Float);
SqlParameter hauteur_antenne_principal22 = new SqlParameter("@hauteur_antenne_principal2",SqlDbType.Float);
SqlParameter hauteur_antenne_extension21 = new SqlParameter("@hauteur_antenne_extension1",SqlDbType.Float);
SqlParameter hauteur_antenne_extension22 = new SqlParameter("@hauteur_antenne_extension2",SqlDbType.Float);
SqlParameter brakon21 = new SqlParameter("@brakon1",SqlDbType.VarChar);
SqlParameter brakon22 = new SqlParameter("@brakon2",SqlDbType.VarChar);
SqlParameter site_id21 = new SqlParameter("@site_id1",SqlDbType.VarChar);
SqlParameter site_id22 = new SqlParameter("@site_id2",SqlDbType.VarChar);
SqlParameter mwlink_ID2 = new SqlParameter("@mwlink_ID", SqlDbType.VarChar);
cmd2.Connection = connSQL;
cmd2.CommandType = CommandType.StoredProcedure;
if (txt_numserie_antenne_principal_site1.Text != "")
num_serie_antenne_principal21.Value = txt_numserie_antenne_principal_site1.Text;
else
num_serie_antenne_principal21.Value = "";
cmd2.Parameters.Add(num_serie_antenne_principal21);
if (txt_numserie_antenne_principal_site2.Text != "")
num_serie_antenne_principal22.Value = txt_numserie_antenne_principal_site2.Text;
else
num_serie_antenne_principal22.Value = "";
cmd2.Parameters.Add(num_serie_antenne_principal22);
if (txt_numserie_antenne_extension_site1.Text != "")
num_serie_antenne_extension21.Value = txt_numserie_antenne_extension_site1.Text;
else
num_serie_antenne_extension21.Value = "";
cmd2.Parameters.Add(num_serie_antenne_extension21);
if (txt_numserie_antenne_extension_site2.Text != "")
num_serie_antenne_extension22.Value = txt_numserie_antenne_extension_site2.Text;
else
num_serie_antenne_extension22.Value = "";
cmd2.Parameters.Add(num_serie_antenne_extension22);
if (txt_nbre_ant_principal_site1.Text != "")
nbre_antenne_principal21.Value = Convert.ToInt16(txt_nbre_ant_principal_site1.Text);
else
nbre_antenne_principal21.Value = 0;
cmd2.Parameters.Add(nbre_antenne_principal21);
if (txt_nbre_ant_principal_site2.Text != "")
nbre_antenne_principal22.Value = Convert.ToInt16(txt_nbre_ant_principal_site2.Text);
else
nbre_antenne_principal22.Value = 0;
cmd2.Parameters.Add(nbre_antenne_principal22);
if (txt_nbre_ant_extension_site1.Text != "")
nbre_antenne_extension21.Value = Convert.ToInt16(txt_nbre_ant_extension_site1.Text);
else
nbre_antenne_extension21.Value = 0;
cmd2.Parameters.Add(nbre_antenne_extension21);
if (txt_nbre_ant_extension_site2.Text != "")
nbre_antenne_extension22.Value = Convert.ToInt16(txt_nbre_ant_extension_site2.Text);
else
nbre_antenne_extension22.Value = 0;
cmd2.Parameters.Add(nbre_antenne_extension22);
if (txt_hauteur_ant_principal_site1.Text != "")
hauteur_antenne_principal21.Value = Convert.ToSingle(txt_hauteur_ant_principal_site1.Text);
else
hauteur_antenne_principal21.Value = 0;
cmd2.Parameters.Add(hauteur_antenne_principal21);
if (txt_hauteur_ant_principal_site2.Text != "")
hauteur_antenne_principal22.Value = Convert.ToSingle(txt_hauteur_ant_principal_site2.Text);
else
hauteur_antenne_principal22.Value = 0;
cmd2.Parameters.Add(hauteur_antenne_principal22);
if (txt_hauteur_ant_extension_site1.Text != "")
hauteur_antenne_extension21.Value = Convert.ToSingle(txt_hauteur_ant_extension_site1.Text);
else
hauteur_antenne_extension21.Value = 0;
cmd2.Parameters.Add(hauteur_antenne_extension21);
if (txt_hauteur_ant_extension_site2.Text != "")
hauteur_antenne_extension22.Value = Convert.ToSingle(txt_hauteur_ant_extension_site2.Text);
else
hauteur_antenne_extension22.Value = 0;
cmd2.Parameters.Add(hauteur_antenne_extension22);
if (brakon_site1.Items[0].Selected || brakon_site1.Items[1].Selected || brakon_site1.Items[2].Selected)
{
switch(brakon_site1.SelectedItem.Text)
{
case "OK" :
brakon21.Value = "OK";
break;
case "NOK" :
brakon21.Value = "NOK";
break;
case "NA" :
brakon21.Value = "NA";
break;
}
}
else goto sortie4;
cmd2.Parameters.Add(brakon21);
if (brakon_site2.Items[0].Selected || brakon_site2.Items[1].Selected || brakon_site2.Items[2].Selected)
{
switch(brakon_site2.SelectedItem.Text)
{
case "OK" :
brakon22.Value = "OK";
break;
case "NOK" :
brakon22.Value = "NOK";
break;
case "NA" :
brakon22.Value = "NA";
break;
}
}
else goto sortie5;
cmd2.Parameters.Add(brakon22);
site_id21.Value = txt_site1.Text;
cmd2.Parameters.Add(site_id21);
site_id22.Value = txt_site2.Text;
cmd2.Parameters.Add(site_id22);
mwlink_ID2.Value = ds.Tables[0].Rows[0]["mwlink_ID"].ToString();
cmd2.Parameters.Add(mwlink_ID2);
SqlCommand cmd3 = new SqlCommand("insert_equipment_d7t");
SqlParameter model1 = new SqlParameter("@model",SqlDbType.VarChar);
SqlParameter puissance_emise_pratique1 = new SqlParameter("@puissance_emise_pratique1",SqlDbType.Float);
SqlParameter puissance_emise_pratique2 = new SqlParameter("@puissance_emise_pratique2",SqlDbType.Float);
SqlParameter puissance_reçue_pratique1 = new SqlParameter("@puissance_reçue_pratique1",SqlDbType.Float);
SqlParameter puissance_reçue_pratique2 = new SqlParameter("@puissance_reçue_pratique2",SqlDbType.Float);
SqlParameter num_serie_idu_principal1 = new SqlParameter("@num_serie_idu_principal1",SqlDbType.VarChar);
SqlParameter num_serie_idu_principal2 = new SqlParameter("@num_serie_idu_principal2",SqlDbType.VarChar);
SqlParameter num_serie_idu_extension1 = new SqlParameter("@num_serie_idu_extension1",SqlDbType.VarChar);
SqlParameter num_serie_idu_extension2 = new SqlParameter("@num_serie_idu_extension2",SqlDbType.VarChar);
SqlParameter num_serie_odu_principal1 = new SqlParameter("@num_serie_odu_principal1",SqlDbType.VarChar);
SqlParameter num_serie_odu_principal2 = new SqlParameter("@num_serie_odu_principal2",SqlDbType.VarChar);
SqlParameter num_serie_odu_extension1 = new SqlParameter("@num_serie_odu_extension1",SqlDbType.VarChar);
SqlParameter num_serie_odu_extension2 = new SqlParameter("@num_serie_odu_extension2",SqlDbType.VarChar);
SqlParameter num_serie_rtm_principal1 = new SqlParameter("@num_serie_rtm_principal1",SqlDbType.VarChar);
SqlParameter num_serie_rtm_principal2 = new SqlParameter("@num_serie_rtm_principal2",SqlDbType.VarChar);
SqlParameter num_serie_rtm_extension1 = new SqlParameter("@num_serie_rtm_extension1",SqlDbType.VarChar);
SqlParameter num_serie_rtm_extension2 = new SqlParameter("@num_serie_rtm_extension2",SqlDbType.VarChar);
SqlParameter num_serie_controller_principal1 = new SqlParameter("@num_serie_controller_principal1",SqlDbType.VarChar);
SqlParameter num_serie_controller_principal2 = new SqlParameter("@num_serie_controller_principal2",SqlDbType.VarChar);
SqlParameter num_serie_controller_extension1 = new SqlParameter("@num_serie_controller_extension1",SqlDbType.VarChar);
SqlParameter num_serie_controller_extension2 = new SqlParameter("@num_serie_controller_extension2",SqlDbType.VarChar);
SqlParameter num_serie_TRIBint_principal1 = new SqlParameter("@num_serie_TRIBint_principal1",SqlDbType.VarChar);
SqlParameter num_serie_TRIBint_principal2 = new SqlParameter("@num_serie_TRIBint_principal2",SqlDbType.VarChar);
SqlParameter num_serie_TRIBint_extension1 = new SqlParameter("@num_serie_TRIBint_extension1",SqlDbType.VarChar);
SqlParameter num_serie_TRIBint_extension2 = new SqlParameter("@num_serie_TRIBint_extension2",SqlDbType.VarChar);
SqlParameter mise_a_terre_rack1 = new SqlParameter("@mise_a_terre_rack1",SqlDbType.VarChar);
SqlParameter mise_a_terre_rack2 = new SqlParameter("@mise_a_terre_rack2",SqlDbType.VarChar);
SqlParameter mise_a_terre_idu1 = new SqlParameter("@mise_a_terre_idu1",SqlDbType.VarChar);
SqlParameter mise_a_terre_idu2 = new SqlParameter("@mise_a_terre_idu2",SqlDbType.VarChar);
SqlParameter mise_a_terre_odu1 = new SqlParameter("@mise_a_terre_odu1",SqlDbType.VarChar);
SqlParameter mise_a_terre_odu2 = new SqlParameter("@mise_a_terre_odu2",SqlDbType.VarChar);
SqlParameter mise_a_terre_cableIF1 = new SqlParameter("@mise_a_terre_cableIF1",SqlDbType.VarChar);
SqlParameter mise_a_terre_cableIF2 = new SqlParameter("@mise_a_terre_cableIF2",SqlDbType.VarChar);
SqlParameter etancheite_odu1 = new SqlParameter("@etancheite_odu1",SqlDbType.VarChar);
SqlParameter etancheite_odu2 = new SqlParameter("@etancheite_odu2",SqlDbType.VarChar);
SqlParameter etancheite_tremie1 = new SqlParameter("@etancheite_tremie1",SqlDbType.VarChar);
SqlParameter etancheite_tremie2 = new SqlParameter("@etancheite_tremie2",SqlDbType.VarChar);
SqlParameter etancheite_proprete1 = new SqlParameter("@etancheite_proprete1",SqlDbType.VarChar);
SqlParameter etancheite_proprete2 = new SqlParameter("@etancheite_proprete2",SqlDbType.VarChar);
SqlParameter cable_NMS_VBUS1 = new SqlParameter("@cable_NMS_VBUS1",SqlDbType.VarChar);
SqlParameter cable_NMS_VBUS2 = new SqlParameter("@cable_NMS_VBUS2",SqlDbType.VarChar);
SqlParameter label_NMS_VBUS1 = new SqlParameter("@label_NMS_VBUS1",SqlDbType.VarChar);
SqlParameter label_NMS_VBUS2 = new SqlParameter("@label_NMS_VBUS2",SqlDbType.VarChar);
SqlParameter coffret_indoor_idu1 = new SqlParameter("@coffret_indoor_idu1",SqlDbType.VarChar);
SqlParameter coffret_indoor_idu2 = new SqlParameter("@coffret_indoor_idu2",SqlDbType.VarChar);
SqlParameter cables_indoor_coax1 = new SqlParameter("@cables_indoor_coax1",SqlDbType.VarChar);
SqlParameter cables_indoor_coax2 = new SqlParameter("@cables_indoor_coax2",SqlDbType.VarChar);
SqlParameter cables_indoor_energie1 = new SqlParameter("@cables_indoor_energie1",SqlDbType.VarChar);
SqlParameter cables_indoor_energie2 = new SqlParameter("@cables_indoor_energie2",SqlDbType.VarChar);
SqlParameter cables_indoor_PCM1 = new SqlParameter("@cables_indoor_PCM1",SqlDbType.VarChar);
SqlParameter cables_indoor_PCM2 = new SqlParameter("@cables_indoor_PCM2",SqlDbType.VarChar);
SqlParameter bandeau_indoor_disjoncteur1 = new SqlParameter("@bandeau_indoor_disjoncteur1",SqlDbType.VarChar);
SqlParameter bandeau_indoor_disjoncteur2 = new SqlParameter("@bandeau_indoor_disjoncteur2",SqlDbType.VarChar);
SqlParameter bandeau_indoor_191 = new SqlParameter("@bandeau_indoor_191",SqlDbType.VarChar);
SqlParameter bandeau_indoor_192 = new SqlParameter("@bandeau_indoor_192",SqlDbType.VarChar);
SqlParameter bandeau_indoor_ferme_DDF1 = new SqlParameter("@bandeau_indoor_ferme_DDF1",SqlDbType.VarChar);
SqlParameter bandeau_indoor_ferme_DDF2 = new SqlParameter("@bandeau_indoor_ferme_DDF2",SqlDbType.VarChar);
SqlParameter coffret_outdoor_odu1 = new SqlParameter("@coffret_outdoor_odu1",SqlDbType.VarChar);
SqlParameter coffret_outdoor_odu2 = new SqlParameter("@coffret_outdoor_odu2",SqlDbType.VarChar);
SqlParameter cables_outdoor_coax1 = new SqlParameter("@cables_outdoor_coax1",SqlDbType.VarChar);
SqlParameter cables_outdoor_coax2 = new SqlParameter("@cables_outdoor_coax2",SqlDbType.VarChar);
SqlParameter deconnection_affluent1 = new SqlParameter("@deconnection_affluent1",SqlDbType.VarChar);
SqlParameter deconnection_affluent2 = new SqlParameter("@deconnection_affluent2",SqlDbType.VarChar);
SqlParameter deconnection_IDU_ODU1 = new SqlParameter("@deconnection_IDU_ODU1",SqlDbType.VarChar);
SqlParameter deconnection_IDU_ODU2 = new SqlParameter("@deconnection_IDU_ODU2",SqlDbType.VarChar);
SqlParameter agregat_IDU1 = new SqlParameter("@agregat_IDU1",SqlDbType.VarChar);
SqlParameter agregat_IDU2 = new SqlParameter("@agregat_IDU2",SqlDbType.VarChar);
SqlParameter agregat_ODU1 = new SqlParameter("@agregat_ODU1",SqlDbType.VarChar);
SqlParameter agregat_ODU2 = new SqlParameter("@agregat_ODU2",SqlDbType.VarChar);
SqlParameter rf1 = new SqlParameter("@rf1",SqlDbType.VarChar);
SqlParameter rf2 = new SqlParameter("@rf2",SqlDbType.VarChar);
SqlParameter affl_distant1 = new SqlParameter("@affl_distant1",SqlDbType.VarChar);
SqlParameter affl_distant2 = new SqlParameter("@affl_distant2",SqlDbType.VarChar);
SqlParameter comm_aut_TX1_X1 = new SqlParameter("@comm_aut_TX1_X1",SqlDbType.VarChar);
SqlParameter comm_aut_TX1_X2 = new SqlParameter("@comm_aut_TX1_X2",SqlDbType.VarChar);
SqlParameter comm_aut_TXX_11 = new SqlParameter("@comm_aut_TXX_11",SqlDbType.VarChar);
SqlParameter comm_aut_TXX_12 = new SqlParameter("@comm_aut_TXX_12",SqlDbType.VarChar);
SqlParameter comm_aut_RX1_X1 = new SqlParameter("@comm_aut_RX1_X1",SqlDbType.VarChar);
SqlParameter comm_aut_RX1_X2 = new SqlParameter("@comm_aut_RX1_X2",SqlDbType.VarChar);
SqlParameter comm_aut_RXX_11 = new SqlParameter("@comm_aut_RXX_11",SqlDbType.VarChar);
SqlParameter comm_aut_RXX_12 = new SqlParameter("@comm_aut_RXX_12",SqlDbType.VarChar);
SqlParameter comm_man_TX1_X1 = new SqlParameter("@comm_man_TX1_X1",SqlDbType.VarChar);
SqlParameter comm_man_TX1_X2 = new SqlParameter("@comm_man_TX1_X2",SqlDbType.VarChar);
SqlParameter comm_man_TXX_11 = new SqlParameter("@comm_man_TXX_11",SqlDbType.VarChar);
SqlParameter comm_man_TXX_12 = new SqlParameter("@comm_man_TXX_12",SqlDbType.VarChar);
SqlParameter comm_man_RX1_X1 = new SqlParameter("@comm_man_RX1_X1",SqlDbType.VarChar);
SqlParameter comm_man_RX1_X2 = new SqlParameter("@comm_man_RX1_X2",SqlDbType.VarChar);
SqlParameter comm_man_RXX_11 = new SqlParameter("@comm_man_RXX_11",SqlDbType.VarChar);
SqlParameter comm_man_RXX_12 = new SqlParameter("@comm_man_RXX_12",SqlDbType.VarChar);
SqlParameter proprete_installation1 = new SqlParameter("@proprete_installation1",SqlDbType.VarChar);
SqlParameter proprete_installation2 = new SqlParameter("@proprete_installation2",SqlDbType.VarChar);
SqlParameter proprete_site1 = new SqlParameter("@proprete_site1",SqlDbType.VarChar);
SqlParameter proprete_site2 = new SqlParameter("@proprete_site2",SqlDbType.VarChar);
SqlParameter site_id1 = new SqlParameter("@site_id1",SqlDbType.VarChar);
SqlParameter site_id2 = new SqlParameter("@site_id2",SqlDbType.VarChar);
SqlParameter mwlink_ID3 = new SqlParameter("@mwlink_ID",SqlDbType.VarChar);
SqlParameter atpc1 = new SqlParameter("@atpc", SqlDbType.VarChar);
SqlParameter odu_conf_nd1 = new SqlParameter("@odu_conf_nd", SqlDbType.VarChar);
SqlParameter odu_conf_hd1 = new SqlParameter("@odu_conf_hd", SqlDbType.VarChar);
SqlParameter odu_conf_hp1 = new SqlParameter("@odu_conf_hp", SqlDbType.VarChar);
SqlParameter v11_card1 = new SqlParameter("@v11_card_1", SqlDbType.VarChar);
SqlParameter v11_card2 = new SqlParameter("@v11_card_2", SqlDbType.VarChar);
cmd3.Connection = connSQL;
cmd3.CommandType = CommandType.StoredProcedure;
if (txt_modele_equipement.Text != "")
model1.Value = txt_modele_equipement.Text;
else
model1.Value = "";
cmd3.Parameters.Add(model1);
if (txt_puiss_em_site1.Text != "")
{
try
{
puissance_emise_pratique1.Value = Convert.ToSingle(txt_puiss_em_site1.Text.Trim());
}
catch
{
connSQL.Close();
txt_puiss_em_site1.BackColor = Color.Pink;
lbl_erreur.Visible = true;
lbl_erreur.Text = "Vérifiez la valeur du champ indiqué ci-dessous !";
goto fin;
}
}
else
puissance_emise_pratique1.Value = 0;
cmd3.Parameters.Add(puissance_emise_pratique1);
if (txt_puiss_em_site2.Text != "")
{
try
{
puissance_emise_pratique2.Value = Convert.ToSingle(txt_puiss_em_site2.Text.Trim());
}
catch
{
connSQL.Close();
txt_puiss_em_site2.BackColor = Color.Pink;
lbl_erreur.Visible = true;
lbl_erreur.Text = "Vérifiez la valeur du champ indiqué ci-dessous !";
goto fin;
}
}
else
puissance_emise_pratique2.Value = 0;
cmd3.Parameters.Add(puissance_emise_pratique2);
if (txt_puiss_rec_site1.Text != "")
{
try
{
puissance_reçue_pratique1.Value = Convert.ToSingle(txt_puiss_rec_site1.Text.Trim());
}
catch
{
connSQL.Close();
txt_puiss_rec_site1.BackColor = Color.Pink;
lbl_erreur.Visible = true;
lbl_erreur.Text = "Vérifiez la valeur du champ indiqué ci-dessous !";
goto fin;
}
}
else
puissance_reçue_pratique1.Value = 0;
cmd3.Parameters.Add(puissance_reçue_pratique1);
if (txt_puiss_rec_site2.Text != "")
{
try
{
puissance_reçue_pratique2.Value = Convert.ToSingle(txt_puiss_rec_site2.Text.Trim());
}
catch
{
connSQL.Close();
txt_puiss_rec_site2.BackColor = Color.Pink;
lbl_erreur.Visible = true;
lbl_erreur.Text = "Vérifiez la valeur du champ indiqué ci-dessous !";
goto fin;
}
}
else
puissance_reçue_pratique2.Value = 0;
cmd3.Parameters.Add(puissance_reçue_pratique2);
if (txt_numserie_idu_principal_site1.Text != "")
num_serie_idu_principal1.Value = txt_numserie_idu_principal_site1.Text;
else
num_serie_idu_principal1.Value = "";
cmd3.Parameters.Add(num_serie_idu_principal1);
if (txt_numserie_idu_principal_site2.Text != "")
num_serie_idu_principal2.Value = txt_numserie_idu_principal_site2.Text;
else
num_serie_idu_principal2.Value = "";
cmd3.Parameters.Add(num_serie_idu_principal2);
if (txt_numserie_idu_extension_site1.Text != "")
num_serie_idu_extension1.Value = txt_numserie_idu_extension_site1.Text;
else
num_serie_idu_extension1.Value = "";
cmd3.Parameters.Add(num_serie_idu_extension1);
if (txt_numserie_idu_extension_site2.Text != "")
num_serie_idu_extension2.Value = txt_numserie_idu_extension_site2.Text;
else
num_serie_idu_extension2.Value = "";
cmd3.Parameters.Add(num_serie_idu_extension2);
if (txt_numserie_odu_principal_site1.Text != "")
num_serie_odu_principal1.Value = txt_numserie_odu_principal_site1.Text;
else
num_serie_odu_principal1.Value = "";
cmd3.Parameters.Add(num_serie_odu_principal1);
if (txt_numserie_odu_principal_site2.Text != "")
num_serie_odu_principal2.Value = txt_numserie_odu_principal_site2.Text;
else
num_serie_odu_principal2.Value = "";
cmd3.Parameters.Add(num_serie_odu_principal2);
if (txt_numserie_odu_extension_site1.Text != "")
num_serie_odu_extension1.Value = txt_numserie_odu_extension_site1.Text;
else
num_serie_odu_extension1.Value = "";
cmd3.Parameters.Add(num_serie_odu_extension1);
if (txt_numserie_odu_extension_site2.Text != "")
num_serie_odu_extension2.Value = txt_numserie_odu_extension_site2.Text;
else
num_serie_odu_extension2.Value = "";
cmd3.Parameters.Add(num_serie_odu_extension2);
if (txt_numserie_rtm_principal_site1.Text != "")
num_serie_rtm_principal1.Value = txt_numserie_rtm_principal_site1.Text;
else
num_serie_rtm_principal1.Value = "";
cmd3.Parameters.Add(num_serie_rtm_principal1);
if (txt_numserie_rtm_principal_site2.Text != "")
num_serie_rtm_principal2.Value = txt_numserie_rtm_principal_site2.Text;
else
num_serie_rtm_principal2.Value = "";
cmd3.Parameters.Add(num_serie_rtm_principal2);
if (txt_numserie_rtm_extension_site1.Text != "")
num_serie_rtm_extension1.Value = txt_numserie_rtm_extension_site1.Text;
else
num_serie_rtm_extension1.Value = "";
cmd3.Parameters.Add(num_serie_rtm_extensio
Afficher la suite