public DataTable Get_Diagnostico_CIE10(BE_ReqCIE 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_Diagnostico_CIE10]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("nFlag", Request.nFlag);
cm.Parameters.AddWithValue("cDiagCodigo", Request.cDiagCodigo);
cm.Parameters.AddWithValue("cDiagGrupo", Request.cDiagGrupo);
cm.Parameters.AddWithValue("cDiagDescripcion", Request.cDiagDescripcion);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return(dt);
}
//------------------------
//select DIAGNOSTICO_CIE10
//------------------------
public DataTable Get_Diagnostico_CIE10(int nFlag, string cDiagCodigo="", string cDiagGrupo="", string cDiagDescripcion = "")
{
BE_ReqCIE Request = new BE_ReqCIE();
DA_CIE Obj = new DA_CIE();
Request.nFlag = nFlag;
Request.cDiagCodigo = cDiagCodigo;
Request.cDiagGrupo = cDiagGrupo;
Request.cDiagDescripcion = cDiagDescripcion;
return Obj.Get_Diagnostico_CIE10(Request);
}
//------------------------
//select DIAGNOSTICO_CIE10
//------------------------
public DataTable Get_Diagnostico_CIE10(int nFlag, string cDiagCodigo = "", string cDiagGrupo = "", string cDiagDescripcion = "")
{
BE_ReqCIE Request = new BE_ReqCIE();
DA_CIE Obj = new DA_CIE();
Request.nFlag = nFlag;
Request.cDiagCodigo = cDiagCodigo;
Request.cDiagGrupo = cDiagGrupo;
Request.cDiagDescripcion = cDiagDescripcion;
return(Obj.Get_Diagnostico_CIE10(Request));
}
public DataTable Get_Diagnostico_CIE10(BE_ReqCIE 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_Diagnostico_CIE10]";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("nFlag", Request.nFlag);
cm.Parameters.AddWithValue("cDiagCodigo", Request.cDiagCodigo);
cm.Parameters.AddWithValue("cDiagGrupo", Request.cDiagGrupo);
cm.Parameters.AddWithValue("cDiagDescripcion", Request.cDiagDescripcion);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return dt;
}