} //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();
}
}