//---------------------------------
 //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);
 }
예제 #2
0
 //---------------------------------
 //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);
 }
예제 #3
0
        //-------------------------
        //CREA Y/O OBTIENE PERIODO
        //-------------------------
        public DataTable Ins_Get_Periodo(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_Ins_Get_Periodo]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("nAnno", Request.cAnno);
                        cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo);
                        cm.Parameters.AddWithValue("cflag", Request.cflag);
                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);

                    }
                }

            }
            catch (Exception)
            {
                throw;
            }
            return dt;
        }