public DataTable Get_Constante(BE_ReqConstante Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_Constante]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("flag", Request.flag); cm.Parameters.AddWithValue("nConCodigo", Request.nConCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//----------- //Constante //----------- //para obterner Constante por nConCodigo public DataTable Get_Constante(string flag, long nConCodigo) { BE_ReqConstante Request = new BE_ReqConstante(); DA_Constante da = new DA_Constante(); Request.flag = flag; Request.nConCodigo = nConCodigo; return da.Get_Constante(Request); }