//---------------------------------------------------------- //Obtengo Estructura "Cabecera" para el comprobante de venta //---------------------------------------------------------- public DataTable Get_Fiscal_Header(BE_ReqCtaCteImprimirDocuVta 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_Fiscal_Header]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nCtaCteComCodigo", Request.nCtaCteComCodigo); cm.Parameters.AddWithValue("cCtaCteComNumero", Request.cCtaCteComNumero); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//---------------------------------------------------------- //Obtengo Estructura "Cabecera" para el comprobante de venta //---------------------------------------------------------- public DataTable Get_Fiscal_Header(string cPerJurCodigo, int nCtaCteComCodigo, string cCtaCteComNumero) { BE_ReqCtaCteImprimirDocuVta ReqParam = new BE_ReqCtaCteImprimirDocuVta(); Da_CtaCteComprobante Obj = new Da_CtaCteComprobante(); ReqParam.cPerJurCodigo = cPerJurCodigo; ReqParam.nCtaCteComCodigo = nCtaCteComCodigo; ReqParam.cCtaCteComNumero = cCtaCteComNumero; return(Obj.Get_Fiscal_Header(ReqParam)); }