} //consulta Código de Barras
public DataTable TabPreco(ModelTabPreco filtro)
{
string P0 = "";
if (filtro.Seqtabpre > 0)
{
P0 = " AND seqtabpre = " + filtro.Seqtabpre;
}
string sql = String.Format("SELECT * FROM TABPRECO WHERE seqtabpre > 0 {0}", P0);
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();
}
}
public string CadTabPreco(ModelTabPreco tab, int mode)
{
SqlCeConnection conexao = new SqlCeConnection();
string consulta = "";
string result = "";
if (mode == 0) //INSERT
{
consulta = "INSERT INTO TABPRECO (desctabpre, perclucro, calcprecmp) VALUES (@desctabpre, @perclucro, @calcprecmp)";
}
if (mode == 1) //UPDATE
{
consulta = "UPDATE TABPRECO SET desctabpre = @desctabpre, perclucro = @perclucro, " +
"calcprecmp = @calcprecmp WHERE seqtabpre = @seqtabpre";
}
if (mode == 2) //DELETE
{
consulta = "DELETE FROM TABPRECO WHERE seqtabpre = @seqtabpre";
}
try
{
conexao = Funcoes.CriaConexao();
SqlCeCommand cmd = new SqlCeCommand(consulta, conexao);
//Parâmetros
if (mode > 0) //DELETE UPDATE
{
cmd.Parameters.AddWithValue("@seqtabpre", tab.Seqtabpre);
}
cmd.Parameters.AddWithValue("@desctabpre", tab.Desctabpre);
cmd.Parameters.AddWithValue("@perclucro", tab.Perclucro);
cmd.Parameters.AddWithValue("@calcprecmp", tab.Calcprecmp);
conexao.Open();
cmd.ExecuteNonQuery();
result = "OK";
return(result);
}
catch (Exception ex)
{
result = ex.Message;
return(result);
}
finally
{
conexao.Close();
}
}
