//----------------------------------------------------------------
// SELECT usp_Get_CtaCteItem_for_cCtaCteRecibo_by_range_fechas
//----------------------------------------------------------------
public DataTable Get_CtaCteItem_for_cCtaCteRecibo_by_range_fechas(BE_ReqBuscaComprobante 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_CtaCteItem_for_cCtaCteRecibo_by_range_fechas]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cFlag", Request.cFlag);
cm.Parameters.AddWithValue("dFecIni", Request.dFecIni);
cm.Parameters.AddWithValue("dFecFin", Request.dFecFin);
cm.Parameters.AddWithValue("cCtaCteRecibo", Request.cCtaCteRecibo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return(dt);
}
//------------------------------------------------------'
//select Get_CtaCteItem_for_cCtaCteRecibo_by_range_fechas
//------------------------------------------------------'
public DataTable Get_CtaCteItem_for_cCtaCteRecibo_by_range_fechas(string cFlag, DateTime dFecIni, DateTime dFecFin, string cCtaCteRecibo)
{
BE_ReqBuscaComprobante Request = new BE_ReqBuscaComprobante();
DA_AnularComprobante da = new DA_AnularComprobante();
Request.cFlag = cFlag;
Request.dFecIni = dFecIni;
Request.dFecFin = dFecFin;
Request.cCtaCteRecibo = cCtaCteRecibo;
return(da.Get_CtaCteItem_for_cCtaCteRecibo_by_range_fechas(Request));
}
//------------------------------
// Get usp_Get_CtaCteComprobante(s) de venta
//-------------------------------
public DataTable Get_CtaCteComprobante(string cPerJurCodigo, long nCtaCteComCodigo, string cCtaCteComNumero, DateTime dFecIni, DateTime dFecFin, string cFlag = "C")
{
BE_ReqBuscaComprobante Request = new BE_ReqBuscaComprobante();
DA_AnularComprobante da = new DA_AnularComprobante();
Request.cPerJurCodigo = cPerJurCodigo;
Request.nCtaCteComCodigo = nCtaCteComCodigo;
Request.cCtaCteComNumero = cCtaCteComNumero;
Request.dFecIni = dFecIni;
Request.dFecFin = dFecFin;
Request.cFlag = cFlag;
return(da.Get_CtaCteComprobante(Request));
}
//------------------------------
// Get Comprobante(s) de venta
//-------------------------------
public DataTable Get_Comprobante_Venta_by_cPerJurCodigo_nCtaCteComCodigo_cCtaCteComNumero(BE_ReqBuscaComprobante 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_Comprobante_Venta]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo);
cm.Parameters.AddWithValue("nCtaCteComCodigo", Request.nCtaCteComCodigo);
cm.Parameters.AddWithValue("cCtaCteComNumero", Request.cCtaCteComNumero);
cm.Parameters.AddWithValue("fecini", Request.dFecIni);
cm.Parameters.AddWithValue("fecfin", Request.dFecFin);
cm.Parameters.AddWithValue("Flag", Request.cFlag);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return(dt);
}
