public List <MvcApplication8.Models.Institucion> autocomElm(string pRFC, string cct_intELIM) { List <MvcApplication8.Models.Institucion> lis = new List <MvcApplication8.Models.Institucion>(); using (SqlConnection cone = Conexion.conexion()) { SqlCommand comando = new SqlCommand(string.Format( //"IF(SELECT distinct ESTATUS FROM tablet WHERE medioprovedor = '" + pRFC + "' AND ESTATUS = 'M') ='M' " + //"SELECT distinct cct,nombre FROM tablet t, institucion i WHERE t.ESTATUS ='M' and i.CCT = t.intitucion and cct like '{0}%'" + //"ELSE IF (SELECT distinct ESTATUS FROM tablet WHERE proveedor = '" + pRFC + "' AND ESTATUS = 'P')='P' " + //"SELECT distinct cct,nombre FROM tablet t, institucion i WHERE t.ESTATUS ='P' and (i.CCT = t.medioprovedor or CCT =t.intitucion) and cct like '{0}%'" "IF(SELECT distinct ESTATUS FROM tablet WHERE medioprovedor = '" + pRFC + "' AND ESTATUS = 'M') ='M' " + "SELECT distinct cct, nombre FROM tablet t, institucion i WHERE t.ESTATUS = 'M' and i.CCT = t.medioprovedor and cct like 'T%' " + "ELSE IF(SELECT distinct ESTATUS FROM tablet WHERE proveedor = '" + pRFC + "' AND ESTATUS = 'P') = 'P' " + "SELECT distinct cct, nombre FROM tablet t, institucion i WHERE t.ESTATUS = 'P' and(i.CCT = t.medioprovedor or i.CCT = t.intitucion) and cct like '{0}%'", cct_intELIM), cone); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { MvcApplication8.Models.Institucion mde = new MvcApplication8.Models.Institucion(); mde.nombre = reader.GetString(0); mde.CCT = reader.GetString(1); mde.direccion = reader.GetString(0); lis.Add(mde); } cone.Close(); } return(lis); }
public List <MvcApplication8.Models.Institucion> autocomentrmp(string cct_int1, string pRFC) { List <MvcApplication8.Models.Institucion> lis = new List <MvcApplication8.Models.Institucion>(); using (SqlConnection cone = Conexion.conexion()) { SqlCommand comando = new SqlCommand(string.Format( "select CCT,nombre from institucion where dependencia ='{0}' and CCT like '{1}%'", pRFC, cct_int1), cone); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { MvcApplication8.Models.Institucion mde = new MvcApplication8.Models.Institucion(); mde.nombre = reader.GetString(1); mde.CCT = reader.GetString(0); lis.Add(mde); } cone.Close(); } return(lis); }
public List <MvcApplication8.Models.Institucion> autocomentrega(string cct_int) { List <MvcApplication8.Models.Institucion> lis = new List <MvcApplication8.Models.Institucion>(); using (SqlConnection cone = Conexion.conexion()) { SqlCommand comando = new SqlCommand(string.Format( "select i.nombre,p.cct_int from Proveedor_Institucion p, institucion i where cct_int like '{0}%' and cct_int = CCT", cct_int), cone); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { MvcApplication8.Models.Institucion mde = new MvcApplication8.Models.Institucion(); mde.nombre = reader.GetString(0); mde.CCT = reader.GetString(1); mde.direccion = reader.GetString(0); lis.Add(mde); } cone.Close(); } return(lis); }
public List <MvcApplication8.Models.Institucion> lista(string pRFC, string pRFC2) { List <MvcApplication8.Models.Institucion> lis = new List <MvcApplication8.Models.Institucion>(); bool media = false; string dependecia = ""; string cct = ""; using (SqlConnection cone = Conexion.conexion()) { SqlCommand comando = new SqlCommand(string.Format( "select cct,[medioprovedor],[dependencia] from institucion where CCT = '{0}'", pRFC2), cone); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { cct = reader.GetString(0); media = reader.GetBoolean(1); if (reader.GetValue(2) != null) { dependecia = reader.GetValue(2).ToString(); } } cone.Close(); } if (media == true) { if (!dependecia.Equals("")) { using (SqlConnection cone = Conexion.conexion()) { SqlCommand comando = new SqlCommand(string.Format( "select CCT, nombre from institucion where dependencia like '{0}%' and cct='{2}'", pRFC, cct, dependecia), cone); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { MvcApplication8.Models.Institucion mde1 = new MvcApplication8.Models.Institucion(); mde1.nombre = reader.GetString(1); mde1.CCT = reader.GetString(0); lis.Add(mde1); } cone.Close(); } } } else { if (!dependecia.Equals("")) { using (SqlConnection cone = Conexion.conexion()) { SqlCommand comando = new SqlCommand(string.Format( "select CCT, nombre from institucion where dependencia like '{0}%' and cct='{2}'", pRFC, cct, dependecia), cone); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { MvcApplication8.Models.Institucion mde1 = new MvcApplication8.Models.Institucion(); mde1.nombre = reader.GetString(1); mde1.CCT = reader.GetString(0); lis.Add(mde1); } cone.Close(); } } } using (SqlConnection cone = Conexion.conexion()) { SqlCommand comando = new SqlCommand(string.Format( "select distinct i.nombre,p.rfc_prov from Proveedor_Institucion p, proveedor i where rfc_prov like '{0}%' and rfc_prov = RFC ", pRFC), cone); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { MvcApplication8.Models.Institucion mde = new MvcApplication8.Models.Institucion(); mde.nombre = reader.GetString(0); mde.CCT = reader.GetString(1); lis.Add(mde); } cone.Close(); } return(lis); }