//------------------------------------- // Ingresos por Laboratorio y Convenios //------------------------------------- public DataTable Get_Ingresos_LabExt_Convenio_by_rango_fechas(ReqRptParametros 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_Ingresos_LabExt_Convenio_by_rango_fechas]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("dFecIni", Request.dFecIni); cm.Parameters.AddWithValue("dFecFin", Request.dFecFin); cm.Parameters.AddWithValue("nFlag", Request.nFlag); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//------------------------------------------------------------------- // Detalle de Ventas según Fecha de Atención agrupado por Tipo de Atención //------------------------------------------------------------------- public DataTable Get_Detalle_Venta_by_Tipo_FechaAtencion_Group_cPerJurCodigo(ReqRptParametros 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_Detalle_Venta_by_Tipo_FechaAtencion_Group_cPerJurCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo ", Request.cPerJuridica); cm.Parameters.AddWithValue("cFecIni", Request.cFecIni); cm.Parameters.AddWithValue("cFecFin", Request.cFecFin); cm.Parameters.AddWithValue("nflagFiltro", Request.nFlagFiltro); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//--------------------------------------------------------------------------------------- // Detalle Importe Derivacion Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin //--------------------------------------------------------------------------------------- public DataTable Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin(ReqRptParametros 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_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodMedico ", Request.cPerCodMedico); cm.Parameters.AddWithValue("dFecIni", Request.dFecIni); cm.Parameters.AddWithValue("dFecFin", Request.dFecFin); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//------------------------------------------------ // Ventas según Fecha de Atención por Turnos //------------------------------------------------ public DataTable Get_Ventas_Group_PerJur_Turno_TipoAtencion_by_Fechas(ReqRptParametros 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_RRHH_Get_Ventas_Group_PerJur_Turno_TipoAtencion_by_Fechas]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cFechaIni", Request.cFecIni); cm.Parameters.AddWithValue("cFechaFin", Request.cFecFin); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
public DataTable Get_Ranking_Grupo_Examenes(ReqRptParametros reqRptParametros) { 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_Ranking_Grupo_Examenes]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cCtaCteSerJerarquia", reqRptParametros.cIntJerarquia); cm.Parameters.AddWithValue("dFecIni", reqRptParametros.cFecIni); cm.Parameters.AddWithValue("dFecFin", reqRptParametros.cFecFin); cm.Parameters.AddWithValue("cFlag", reqRptParametros.cTipo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//---------------------------------------------------- //Reporte de Ventas según Fecha de Atención y Turnos //---------------------------------------------------- public DataTable Get_Ventas_Group_PerJur_Turno_TipoAtencion_by_Fechas(string cFecIni, string cFecFin) { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cFecIni = cFecIni; Request.cFecFin = cFecFin; return(Obj.Get_Ventas_Group_PerJur_Turno_TipoAtencion_by_Fechas(Request)); }
//------------------ 2017-03-03 ------------------------ // Ver Historial Medico Detalle for (App ANDROID) -EINCIO //------------------------------------------------------ public DataTable Android_Get_Medico_and_comision_Detalle(string cPerCodigo, string FecIni, string FecFin) { ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cPerCodigo = cPerCodigo; Request.cFecIni = FecIni; Request.cFecFin = FecFin; //Recuperando... return(Obj.Android_Get_Medico_and_comision_Detalle(Request)); }
//------------------ 2017-01-24 ------------------------ // Ver Comision Medico por Promotor for (App ANDROID) -EINCIO //------------------------------------------------------ public DataTable Android_Get_Medico_and_comision(string ApeDoctor, string FecIni, string FecFin) { ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cApeDoctor = ApeDoctor; Request.cFecIni = FecIni; Request.cFecFin = FecFin; //Recuperando... return(Obj.Android_Get_Medico_and_comision(Request)); }
//--------------------------------------------------------------------------------------- // Detalle Importe Derivacion Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin //--------------------------------------------------------------------------------------- public DataTable Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin(string cPerCodMedico, DateTime dFecIni, DateTime dFecFin) { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cPerCodMedico = cPerCodMedico; Request.dFecIni = dFecIni; Request.dFecFin = dFecFin; return(Obj.Get_Derivacion_Medico_by_cPerCodMedico_and_dFecIni_dFecFin(Request)); }
//------------------------------------- // Ingresos por Laboratorio y Convenios //------------------------------------- public DataTable Get_Ingresos_LabExt_Convenio_by_rango_fechas(DateTime dFecIni, DateTime dFecFin, string nFlag = "P") { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.dFecIni = dFecIni; Request.dFecFin = dFecFin; Request.nFlag = nFlag; return(Obj.Get_Ingresos_LabExt_Convenio_by_rango_fechas(Request)); }
//------------------------------------------------------------------- // Reporte por Sucursal y Rango de fechas //------------------------------------------------------------------- public DataTable Get_Venta_by_cPerJurCodigo_and_fecini_fecfin(string cPerJurCodigo, DateTime dFecIni, DateTime dFecFin) { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cPerJuridica = cPerJurCodigo; Request.dFecIni = dFecIni; Request.dFecFin = dFecFin; return(Obj.Get_Venta_by_cPerJurCodigo_and_fecini_fecfin(Request)); }
//------------------------------------------------------------------- // Reporte por Sucursal según Fecha de Atención //------------------------------------------------------------------- public DataTable Get_Venta_by_cPerJurCodigo_and_FechaAtencion(string cPerJurCodigo, string cFecIni, string cFecFin) { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cPerJuridica = cPerJurCodigo; Request.cFecIni = cFecIni; Request.cFecFin = cFecFin; return(Obj.Get_Venta_by_cPerJurCodigo_and_FechaAtencion(Request)); }
//------------------------------------------------------------------------------ // Reporte por Sucursal según Fecha de Atención y agrupado por Tipo de Atención //------------------------------------------------------------------------------ public DataTable Get_Detalle_Venta_by_Tipo_FechaAtencion_Group_cPerJurCodigo(string cPerJurCodigo, string cFecIni, string cFecFin, string cFlagFiltro) { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cPerJuridica = cPerJurCodigo; Request.cFecIni = cFecIni; Request.cFecFin = cFecFin; Request.nFlagFiltro = cFlagFiltro; return(Obj.Get_Detalle_Venta_by_Tipo_FechaAtencion_Group_cPerJurCodigo(Request)); }
//--------------------------------------------------------------------- // Reporte Ventas por Promotor en TEXTO (by App Android) VENTA SIN IGV //--------------------------------------------------------------------- public DataTable Get_Android_MetaPromotor_Avance_By_Promotor(string cFlag, string cFecIni, string cFecFin, string cPerPromCodigo) { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.nFlag = cFlag; Request.cFecIni = cFecIni; Request.cFecFin = cFecFin; Request.cPerCodPromotor = cPerPromCodigo; return(Obj.Get_Android_MetaPromotor_Avance_By_Promotor(Request)); }
//------------------------------------------------------------------------------------------ //Reporte Resumen y Detalle de Pruebas Pendientes de Facturación (Lab. Externo / Convenios) //------------------------------------------------------------------------------------------ public DataTable Get_LabConv_Pendientes_de_Facturacion_By_RangoFecha(string FecIni, string FecFin, string cPerCodigoTerceros = "") { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cPerCodigoTerceros = cPerCodigoTerceros; Request.cFecIni = FecIni; Request.cFecFin = FecFin; return(Obj.Get_LabConv_Pendientes_de_Facturacion_By_RangoFecha(Request)); }
//VENTAS DIARIAS SEGÚN REPORTE public DataTable Get_VentasDiarias_Segun_Reporte(string cPrdIni = "", string cPrdFin = "", string cFlagReporte = "", string cPerPromCodigo = "") { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); Request.nFlag = cFlagReporte; Request.cFecIni = cPrdIni; Request.cFecFin = cPrdFin; Request.cPerCodPromotor = cPerPromCodigo; DARptMaster Obj = new DARptMaster(); return(Obj.Get_VentasDiarias_Segun_Reporte(Request)); }
//------------------ 2016-06-09 ------------------------ // Ver Comision Medico por Promotor for (App ANDROID) -EINCIO //------------------------------------------------------ public DataTable Android_Comisiones_By_Promotor(string FecIni, string FecFin, string cPerUsuCodigo, int nFlagTodos = 0, string cTipo = "R", string cPerCodMedico = "", Int32 nFlagComision = 1) { ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cFecIni = FecIni; Request.cFecFin = FecFin; Request.cPerUsuCodigo = cPerUsuCodigo; Request.nFlagTodos = nFlagTodos; Request.cTipo = cTipo; Request.cPerCodMedico = cPerCodMedico; Request.nFlagComision = nFlagComision; //Recuperando... return(Obj.Android_Comisiones_By_Promotor(Request)); }
//--------------------------------------------------------------------------------- // Detalle de Saldos agrupado por Clientes y filtro por Rango de fechas for Android //--------------------------------------------------------------------------------- public DataTable Get_Android_Detalle_Saldo_Venta_by_fecini_fecfin_Group_cPerCodigo(string cPerJurCodigo, string cFecIni, string cFecFin, string nflagFiltro, string nflag) { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cPerJuridica = cPerJurCodigo; Request.cFecIni = cFecIni; Request.cFecFin = cFecFin; Request.nFlagFiltro = nflagFiltro; Request.nFlag = nflag; return(Obj.Get_Android_Detalle_Saldo_Venta_by_fecini_fecfin_Group_cPerCodigo(Request)); }
//------------------------------------------------------------------- // Comsión Doctores usp_Get_ComisionMedico_by_cPerJuridica_cPerMedico //------------------------------------------------------------------- public DataTable Get_ComisionMedico_by_cPerJuridica_cPerMedico(string cPerJuridica, string cPerCodMedico, DateTime dFecIni, DateTime dFecFin, string nFlag = "G", string cPerCodPromotor = "") { //Recuperando... ReqRptParametros Request = new ReqRptParametros(); DARptMaster Obj = new DARptMaster(); Request.cPerJuridica = cPerJuridica; Request.cPerCodMedico = cPerCodMedico; Request.dFecIni = dFecIni; Request.dFecFin = dFecFin; Request.nFlag = nFlag; Request.cPerCodPromotor = cPerCodPromotor; return(Obj.Get_ComisionMedico_by_cPerJuridica_cPerMedico(Request)); }
//------------------ 2016-06-09 ------------------------ // Ver Comision Medico por Promotor for (App ANDROID) -EINCIO //------------------------------------------------------ public DataTable Android_Comisiones_By_Promotor(ReqRptParametros Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); //string Cadena = Obj.GetConexionString("Naylamp"); string Cadena = "Server=10.0.0.10\\SRVDATOSMED; DataBase = BDDatos; Uid = android; Pwd =C2879442C28147B;Integrated Security=False; Pooling = False"; using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[Android].[usp_Android_Comisiones_By_Promotor]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cFecIni", Request.cFecIni); cm.Parameters.AddWithValue("cFecFin", Request.cFecFin); cm.Parameters.AddWithValue("cPerUsuCodigo", Request.cPerUsuCodigo); cm.Parameters.AddWithValue("nFlagTodos", Request.nFlagTodos); cm.Parameters.AddWithValue("cTipo", Request.cTipo); cm.Parameters.AddWithValue("cPerCodMedico", Request.cPerCodMedico); cm.Parameters.AddWithValue("nFlagComision", Request.nFlagComision); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//------------------------------------------------ // Ventas según Fecha de Atención por Turnos //------------------------------------------------ public DataTable Get_VentasDiarias_Segun_Reporte(ReqRptParametros 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_Admision_Get_Ventas_by_Fechas_Reporte]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cFechaIni", Request.cFecIni); cm.Parameters.AddWithValue("cFechaFin", Request.cFecFin); cm.Parameters.AddWithValue("cFlag", Request.nFlag); if (!Request.cPerCodPromotor.Equals("")) { cm.Parameters.AddWithValue("cPromCodigo", Request.cPerCodPromotor); } cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//------------------------------------------------ // Laboratorios con Pagos Pendientes de Facturar //------------------------------------------------ public DataTable Get_LabConv_Pendientes_de_Facturacion_By_RangoFecha(ReqRptParametros 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_Admision_Get_LabConv_Pendientes_de_Facturacion_By_RangoFecha]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cFecIni", Request.cFecIni); cm.Parameters.AddWithValue("cFecFin", Request.cFecFin); if (Request.cPerCodPromotor != "") { cm.Parameters.AddWithValue("cPerCodigoTerceros", Request.cPerCodigoTerceros); } cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//------------------------------------- // b).- Agrupado por Sucursal y Turno //------------------------------------- public DataTable Get_Ventas_Group_cPerJur_Turno_TipoAtencion_by_Fechas(ReqRptParametros Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); //string Cadena = Obj.GetConexionString("Naylamp"); string Cadena = "Server=10.0.0.10\\SRVDATOSMED; DataBase = BDDatos; Uid = android; Pwd =C2879442C28147B;Integrated Security=False; Pooling = False"; using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[Android].[usp_Get_Ventas_Group_cPerJur_Turno_TipoAtencion_by_Fechas]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJuridica ", Request.cPerJuridica); cm.Parameters.AddWithValue("cFechaIni", Request.cFecIni); cm.Parameters.AddWithValue("cFechaFin", Request.cFecFin); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
public DataTable Get_Ranking_Grupo_Examenes(ReqRptParametros reqRptParametros) { CtaCteListaServicioDAOSQLServer ctaCteListaServicioDAOSQLServer = new CtaCteListaServicioDAOSQLServer(); return(ctaCteListaServicioDAOSQLServer.Get_Ranking_Grupo_Examenes(reqRptParametros)); }
//------------------------------------------------------------------- // Detalle de Saldos agrupado por Clientes y filtro por Rango de fechas for Android //------------------------------------------------------------------- public DataTable Get_Android_Detalle_Saldo_Venta_by_fecini_fecfin_Group_cPerCodigo(ReqRptParametros Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); //string Cadena = Obj.GetConexionString("Naylamp"); string Cadena = "Server=10.0.0.10\\SRVDATOSMED; DataBase = BDDatos; Uid = android; Pwd =C2879442C28147B;Integrated Security=False; Pooling = False"; using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_Detalle_Saldo_Venta_by_fecini_fecfin_Group_cPerCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo ", Request.cPerJuridica); cm.Parameters.AddWithValue("fecini", Request.cFecIni); cm.Parameters.AddWithValue("fecfin", Request.cFecFin); cm.Parameters.AddWithValue("nflagFiltro", Request.nFlagFiltro); cm.Parameters.AddWithValue("nflag", Request.nFlag); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//-------------------------------------------------------------------------- // en SqlDataReader: Obtiene List Reporte Admision por Permisos PerUsuGruAcc //-------------------------------------------------------------------------- public List <BE_Res_Interface> Get_List_Report_by_cIntJerarquia_and_cPerCodigo(ReqRptParametros Request) { BE_Res_Interface Item = new BE_Res_Interface(); var lista = new List <BE_Res_Interface>(); 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_List_Report_by_cIntJerarquia_and_cPerCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nIntClase", Request.nIntClase); cm.Parameters.AddWithValue("cIntJerarquia", Request.cIntJerarquia); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { lista.Clear(); while (dr.Read()) { Item = new BE_Res_Interface(); //Item.nIntClase = dr.GetInt32(dr.GetOrdinal("nIntClase")); //Item.nIntCodigo = dr.GetInt32(dr.GetOrdinal("nIntCodigo")); Item.nIntTipo = dr.GetInt32(dr.GetOrdinal("nIntTipo")); Item.cIntDescripcion = dr.GetString(dr.GetOrdinal("cIntDescripcion")).Trim(); Item.cIntJerarquia = dr.GetString(dr.GetOrdinal("cIntJerarquia")).Trim(); Item.cIntNombre = dr.GetString(dr.GetOrdinal("cIntNombre")).Trim(); lista.Add(Item); } dr.Close(); } } } } catch (Exception) { throw; } return(lista); }
//-------------------------------------------------------------------------- // en SqlDataReader: Obtiene List Reporte Admision por Permisos PerUsuGruAcc //-------------------------------------------------------------------------- public List <BE_Res_Interface> Get_List_Report_by_cIntJerarquia_and_cPerCodigo(ReqRptParametros Request) { DARptMaster Obj = new DARptMaster(); return(Obj.Get_List_Report_by_cIntJerarquia_and_cPerCodigo(Request)); }