//---------------------------------------------------------------- // 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; }
//------------------------------ // 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; }
//------------------------------ // Get Comprobante(s) de venta //------------------------------- public DataTable Get_Comprobante_Venta_by_cPerJurCodigo_nCtaCteComCodigo_cCtaCteComNumero(string cPerJurCodigo, long nCtaCteComCodigo, string cCtaCteComNumero, DateTime dFecIni, DateTime dFecFin, string cFlag) { 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_Comprobante_Venta_by_cPerJurCodigo_nCtaCteComCodigo_cCtaCteComNumero(Request); }