//Get_CtasCtes_Get_LibroVentas_Electronico public DataTable Get_CtasCtes_Get_LibroVentas_Electronico(BE_ReqBookElectronicoVta 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_CtasCtes_Get_LibroVentas_Electronico]"; //cm.CommandTimeout = 0; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPrdCodigo", Request.nPrdCodigo); cm.Parameters.AddWithValue("cFlag", Request.cFlag); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//Get_CtaCteNumeracion public DataTable Get_CtasCtes_Get_LibroVentas_Electronico(Int32 nPrdCodigo, string cFlag = "D") { //Recuperando registros BE_ReqBookElectronicoVta Request = new BE_ReqBookElectronicoVta(); Request.nPrdCodigo = nPrdCodigo; Request.cFlag = cFlag; DA_BookElectronicoVta Obj = new DA_BookElectronicoVta(); return(Obj.Get_CtasCtes_Get_LibroVentas_Electronico(Request)); }
//Get_CtaCteNumeracion public DataTable Get_CtasCtes_Get_LibroVentas_Electronico(long Year, long Month, string Empresa) { //Recuperando registros BE_ReqBookElectronicoVta Request = new BE_ReqBookElectronicoVta(); Request.Year = Year; Request.Month = Month; Request.Empresa = Empresa; DA_BookElectronicoVta Obj = new DA_BookElectronicoVta(); return(Obj.Get_CtasCtes_Get_LibroVentas_Electronico(Request)); }