//----------------------------
        // SELECT Get_ReportCuadraCaja
        //----------------------------
        public DataTable Get_ReportCuadraCaja(BE_ReqRptCuadreCaja 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_ReportCuadreCaja]";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cFlag", Request.cFlag);
                        cm.Parameters.AddWithValue("dCtaCteComFecIni", Request.dCtaCteComFecIni);
                        cm.Parameters.AddWithValue("dCtaCteComFecFin", Request.dCtaCteComFecFin);
                        cm.Connection = cn;

                        using (SqlDataReader dr = cm.ExecuteReader())
                            dt.Load(dr);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return dt;
        }
        //------------------------
        //select CtaCteComprobante
        //------------------------
        public DataTable Get_ReportCuadraCaja(string cFlag, DateTime dCtaCteComFecIni, DateTime dCtaCteComFecFin)
        {
            //Recuperando...
            BE_ReqRptCuadreCaja Request = new BE_ReqRptCuadreCaja();
            DA_RptCuadreCaja Obj = new DA_RptCuadreCaja();

            Request.cFlag = cFlag;
            Request.dCtaCteComFecIni = dCtaCteComFecIni;
            Request.dCtaCteComFecFin = dCtaCteComFecFin;

            return Obj.Get_ReportCuadraCaja(Request);
        }
Exemplo n.º 3
0
        //------------------------
        //select CtaCteComprobante
        //------------------------
        public DataTable Get_ReportCuadraCaja(string cPerJurCodigo, int nTurno, DateTime dCtaCteComFecIni, DateTime dCtaCteComFecFin)
        {
            //Recuperando...
            BE_ReqRptCuadreCaja Request = new BE_ReqRptCuadreCaja();
            DA_RptCuadreCaja Obj = new DA_RptCuadreCaja();

            Request.cPerJurCodigo = cPerJurCodigo;
            Request.nTurno = nTurno;
            Request.dCtaCteComFecIni = dCtaCteComFecIni;
            Request.dCtaCteComFecFin = dCtaCteComFecFin;

            return Obj.Get_ReportCuadraCaja(Request);
        }