private void button9_Click(object sender, EventArgs e)
{
DataAccessLayerManager dao = DataAccessLayerManager.getInstance();
dao.ConnectionString = "server=mysql06-farm56.kinghost.net;port=3306;database=sotisolutions01;uid=sotisolutions01;pwd=sotisolutions01";
dao.ConnectionProvider = DataAccessLayerManager.ConnectionProviders.MYSQL;
dao.ConnectionOutput = Application.StartupPath + "\\sql.log";
ParceiroBO parceiroBO = dao.Find <ParceiroBO>(new Object[] { 14, 1 });
MessageBox.Show(String.Format("Nome={0}\nCNPJ\\CPF={1}", parceiroBO.BAAJ_NOME_FANT, parceiroBO.BAAJ_CNPJ_CPF_ID));
}
private void button8_Click(object sender, EventArgs e)
{
DataAccessLayerManager dao = DataAccessLayerManager.getInstance();
dao.ConnectionString = "server=mysql06-farm56.kinghost.net;port=3306;database=sotisolutions01;uid=sotisolutions01;pwd=fev030277";
dao.ConnectionProvider = DataAccessLayerManager.ConnectionProviders.MYSQL;
dao.ConnectionOutput = Application.StartupPath + "\\sql.log";
DataTable dataTable = dao.GetListBySelect("SELECT * FROM baaj");
dataGridView1.DataSource = dataTable;
}
private void button10_Click(object sender, EventArgs e)
{
DataAccessLayerManager dao = DataAccessLayerManager.getInstance();
dao.ConnectionString = "server=mysql06-farm56.kinghost.net;port=3306;database=sotisolutions01;uid=sotisolutions01;pwd=sotisolutions01";
dao.ConnectionProvider = DataAccessLayerManager.ConnectionProviders.MYSQL;
dao.ConnectionOutput = Application.StartupPath + "\\sql.log";
//ParceiroBO parceiroBO = dao.find<ParceiroBO>(new Object[,] {
// {"BAAJ_COD_FILIAL", 14 }, {"BAAJ_PADRAO", true}
//});
ParceiroBO parceiroBO = dao.Find <ParceiroBO>(new Object[, ] {
{ "BAAJ_EMAIL", "*****@*****.**" }
});
MessageBox.Show(String.Format("Nome={0}\nCNPJ\\CPF={1}", parceiroBO.BAAJ_NOME_FANT, parceiroBO.BAAJ_CNPJ_CPF_ID));
}
