//------------------------- //OBTIENE Año - Periodo //------------------------- public DataTable Get_Periodo_By_nPrdCodigo(BE_ReqPeriodo 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_Periodo_By_nPrdCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPrdCodigo", Request.nObjCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//--------------------------------- //Ins - Get (Periodo) //--------------------------------- public DataTable Ins_Get_Periodo(BE_ReqPeriodo Request) { //Recuperando registros DataTable dt = new DataTable(); DA_Sistema Obj = new DA_Sistema(); return(Obj.Ins_Get_Periodo(Request)); }
//--------------------------------- //Get Periodo Contable por default //--------------------------------- public DataTable Get_PeriodoContDefault(BE_ReqPeriodo Request) { //Recuperando registros DataTable dt = new DataTable(); DA_Sistema Obj = new DA_Sistema(); return(Obj.Get_PeriodoContDefault(Request)); }
public DataTable Get_Periodo_By_nPrdCodigo(BE_ReqPeriodo Request) { //Recuperando registros DataTable dt = new DataTable(); DA_Sistema Obj = new DA_Sistema(); return(Obj.Get_Periodo_By_nPrdCodigo(Request)); }