public List <CsTa> SELECT_CodeLibelle_By_NUM(int NUM) { CsTa _ta; List <CsTa> ListeTA = new List <CsTa>(); cn = new SqlConnection(ConnectionString); cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = EnumProcedureStockee.SelectTaCodeLibelleByNum; SqlParameter param = new SqlParameter("@NUM", SqlDbType.SmallInt); param.Direction = ParameterDirection.Input; param.Value = NUM; cmd.Parameters.Add(param); try { if (cn.State == ConnectionState.Closed) { cn.Open(); } SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); //throw new Exception("Aucune colonne trouvée pour cette table."); } while (reader.Read()) { _ta = new CsTa(); //_ta.CODE = reader.GetValue(0).ToString().Trim(); _ta.LIBELLE = reader.GetValue(1).ToString().Trim(); ListeTA.Add(_ta); } //Fermeture reader reader.Close(); return(ListeTA); } catch (Exception ex) { throw new Exception(EnumProcedureStockee.SelectTaCodeLibelleByNum + ":" + ex.Message); } finally { if (cn.State == ConnectionState.Open) { cn.Close(); // Fermeture de la connection } cmd.Dispose(); } }
public CsTa SELECT_Exploitation() { bool ErreurSql = false; CsTa _ta = new CsTa(); cn = new SqlConnection(ConnectionString); cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = EnumProcedureStockee.SelectTaExploitation; try { if (cn.State == ConnectionState.Closed) { cn.Open(); } SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { reader.Close(); //throw new Exception("Aucune colonne trouvée pour cette table."); } while (reader.Read()) { // _ta.CODE = reader.GetValue(0).ToString().Trim(); _ta.LIBELLE = reader.GetValue(1).ToString().Trim(); } //Fermeture reader reader.Close(); return(_ta); } catch (SqlException) { return(null); } catch (Exception ex) { throw new Exception(EnumProcedureStockee.SelectTaCodeLibelleByNum + ":" + ex.Message); } finally { if (cn.State == ConnectionState.Open) { cn.Close(); // Fermeture de la connection } cmd.Dispose(); } }
public CsTa SELECT_Exploitation(string Code) { CsTa _ta = null; cn = new SqlConnection(ConnectionString); SqlCommand command = new SqlCommand("SPX_TA_SELECT_VALEUR_58_By_CODE", cn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Clear(); command.Parameters.Add("@Code", SqlDbType.VarChar, 6).Value = Code; try { if (cn.State == ConnectionState.Closed) { cn.Open(); } SqlDataReader reader = command.ExecuteReader(); if (!reader.HasRows) { reader.Close(); //throw new Exception("Aucune colonne trouvée pour cette table."); } while (reader.Read()) { _ta = new CsTa(); //_ta.CODE = reader.GetValue(0).ToString().Trim(); _ta.LIBELLE = reader.GetValue(1).ToString().Trim(); } //Fermeture reader reader.Close(); return(_ta); } catch (SqlException) { return(null); } catch (Exception ex) { throw new Exception("SPX_TA_SELECT_VALEUR_58_By_CODE" + ":" + ex.Message); } finally { if (cn.State == ConnectionState.Open) { cn.Close(); // Fermeture de la connection } command.Dispose(); } }
private void cbo_evnt5_DropDownClosed(object sender, EventArgs e) { if (dgINIT.SelectedItem == null || cbo_evnt5.SelectedItem == null) { return; } CsTa index = new CsTa(); index = cbo_evnt5.SelectedItem as CsTa; CsTypeDemande casSelected = dgINIT.SelectedItem as CsTypeDemande; //casSelected.EVT5 = index.PK_CODE; AjouterListeMaj(casSelected); }