//[usp_Get_Doc_Afiliacion_for_cDocCodigo] public DataTable Get_Doc_Afiliacion_for_cDocCodigo(BE_Get_Doc_Afiliacion_for_cDocCodigo 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_Doc_Afiliacion_for_cDocCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//[usp_Get_Doc_Afiliacion_for_cDocCodigo] public DataTable Get_Doc_Afiliacion_for_cDocCodigo(string cDocCodigo) { BE_Get_Doc_Afiliacion_for_cDocCodigo Request = new BE_Get_Doc_Afiliacion_for_cDocCodigo(); Request.cDocCodigo = cDocCodigo; DA_FondoMortorio DA = new DA_FondoMortorio(); return(DA.Get_Doc_Afiliacion_for_cDocCodigo(Request)); }