} //Empresa public DataTable Fornecedor(ModelFornecedor filtro) { string P0 = ""; string P1 = ""; string P2 = ""; string P3 = ""; string P4 = ""; string P5 = ""; if (filtro.CodForn > 0) { P0 = " AND codForn = " + filtro.CodForn; } if (filtro.CnpjForn != "" && filtro.CnpjForn != null) { P1 = " AND cnpjForn LIKE '" + filtro.CnpjForn + "%'"; } if (filtro.CpfForn != "" && filtro.CpfForn != null) { P2 = " AND cpfForn LIKE '" + filtro.CpfForn + "%'"; } if (filtro.DocForn != "" && filtro.DocForn != null) { P3 = " AND (cpfForn LIKE '" + filtro.DocForn + "%' OR cnpjForn LIKE '" + filtro.DocForn + "%')"; } if (filtro.NomeForn != "" && filtro.NomeForn != null) { P4 = " AND nomeForn LIKE '" + filtro.NomeForn + "%'"; } if (filtro.StatusFor != "" && filtro.StatusFor != null) { P5 = " AND statusForn = '" + filtro.StatusFor + "'"; } string sql = String.Format("SELECT * FROM FORNECEDORES WHERE codForn > 0 {0}{1}{2}{3}{4}{5}", P0, P1, P2, P3, P4, P5); try { conexao = new SqlCeConnection(Funcoes.Busca_Conexao()); cmd = new SqlCeCommand(sql, conexao); daDados = new SqlCeDataAdapter(cmd); dtDados = new DataTable(); daDados.Fill(dtDados); return(dtDados); } catch (Exception ex) { throw ex; } finally { conexao.Close(); } } //Fornercedor
public string CadFornecedor(ModelFornecedor dados, int mode) { SqlCeConnection conexao = new SqlCeConnection(); string consulta = ""; string result = ""; if (mode == 0) //INSERT { consulta = "INSERT INTO FORNECEDORES (nomeForn, statusForn, cpfForn, cnpjForn, contatoForn, tel1Forn, tel2Forn, emailForn) " + "VALUES (@nomeForn, @statusForn, @cpfForn, @cnpjForn, @contatoForn, @tel1Forn, @tel2Forn, @emailForn)"; } if (mode == 1) //UPDATE { consulta = "UPDATE FORNECEDORES SET nomeForn = @nomeForn, statusForn = @statusForn, cpfForn = @cpfForn, cnpjForn = @cnpjForn, " + "contatoForn = @contatoForn, tel1Forn = @tel1Forn, tel2Forn = @tel2Forn, emailForn = @emailForn\n " + "WHERE codForn = @codForn"; } try { conexao = Funcoes.CriaConexao(); SqlCeCommand cmd = new SqlCeCommand(consulta, conexao); //Parâmetros if (mode != 0) //UPDATE ou DELETE { cmd.Parameters.AddWithValue("@codForn", dados.CodForn); } cmd.Parameters.AddWithValue("@nomeForn", dados.NomeForn); cmd.Parameters.AddWithValue("@statusForn", dados.StatusFor); cmd.Parameters.AddWithValue("@cpfForn", dados.CpfForn); cmd.Parameters.AddWithValue("@cnpjForn", dados.CnpjForn); cmd.Parameters.AddWithValue("@contatoForn", dados.ContatoForn); cmd.Parameters.AddWithValue("@tel1Forn", dados.Tel1Forn); cmd.Parameters.AddWithValue("@tel2Forn", dados.Tel2Forn); cmd.Parameters.AddWithValue("@emailForn", dados.EmailForn); conexao.Open(); cmd.ExecuteNonQuery(); result = "OK"; return(result); } catch (Exception ex) { result = ex.Message; return(result); } finally { conexao.Close(); } }