//---------------------------- // 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_CuadreCaja_by_cPerJurCodigo_nTurno_fecini_fecfin]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nTurno", Request.nTurno); cm.Parameters.AddWithValue("fecini", Request.dCtaCteComFecIni); cm.Parameters.AddWithValue("fecfin", 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)); }
//------------------------ //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)); }