public UCReportEmployeeClem(FRMMain mFRM) { InitializeComponent(); fRMMain = mFRM; conDB = new ConMySql(); convertDT = new ConvertDateTime(); }
public UCAddCompany(FRMMain mFRM) { InitializeComponent(); fRMMain = mFRM; conDB = new ConMySql(); convertDT = new ConvertDateTime(); }
public void CarregarGrid() { ConMySql conexao = new ConMySql(); conexao.ligar(); DataTable dtIncidente = new DataTable(); try { string comando = @"select * from incidente order by data_abertura"; MySqlDataAdapter Adapter = new MySqlDataAdapter(comando, conexao.con()); Adapter.Fill(dtIncidente); dgvIncidente.DataSource = dtIncidente; for (int count = 0; count < dtIncidente.Rows.Count; count++) { dgvIncidente.Rows[count].Cells[0].Value = dtIncidente.Rows[count]["titulo"]; dgvIncidente.Rows[count].Cells[1].Value = dtIncidente.Rows[count]["cliente"].ToString(); dgvIncidente.Rows[count].Cells[2].Value = dtIncidente.Rows[count]["Solicitante"].ToString(); dgvIncidente.Rows[count].Cells[3].Value = dtIncidente.Rows[count]["tipo"].ToString(); dgvIncidente.Rows[count].Cells[4].Value = dtIncidente.Rows[count]["usuario_atendente"].ToString(); } dgvIncidente.ClearSelection(); } catch (Exception EX) { MessageBox.Show("ERRO AO BUSCAR CLIENTES" + "\n" + EX.Message); } }
private void BtnPesquisar_Click(object sender, EventArgs e) { ConMySql conexao = new ConMySql(); conexao.ligar(); DataTable dtCliente = new DataTable(); try { string comando = $@"SELECT * FROM cliente where nome like '%{txtPesquisar.Text}%'"; //WHERE(SP.PES_NUMERO = {txtPesquisar.Text}) "; MySqlDataAdapter Adapter = new MySqlDataAdapter(comando, conexao.con()); Adapter.Fill(dtCliente); dgvCliente.DataSource = dtCliente; for (int count = 0; count < dtCliente.Rows.Count; count++) { dgvCliente.Rows[count].Cells[0].Value = dtCliente.Rows[count]["IMAGEM"]; dgvCliente.Rows[count].Cells[1].Value = dtCliente.Rows[count]["NOME"].ToString(); dgvCliente.Rows[count].Cells[2].Value = dtCliente.Rows[count]["TELEFONE"].ToString(); dgvCliente.Rows[count].Cells[3].Value = dtCliente.Rows[count]["ENDERECO"].ToString(); dgvCliente.Rows[count].Cells[4].Value = dtCliente.Rows[count]["EMAIL"].ToString(); } } catch (Exception EX) { MessageBox.Show("ERRO AO BUSCAR CLIENTES" + "\n" + EX.Message); } }
public UCAddProductType(FRMMain fRMMain) { InitializeComponent(); // TODO: Complete member initialization this.fRMMain = fRMMain; conDB = new ConMySql(); convertDT = new ConvertDateTime(); }
public UCAddCustomer(FRMMain fRMMain) { // TODO: Complete member initialization this.fRMMain = fRMMain; InitializeComponent(); conDB = new ConMySql(); convertDT = new ConvertDateTime(); }
public UCListCompany(FRMMain fRMMain) { // TODO: Complete member initialization this.fRMMain = fRMMain; InitializeComponent(); conDB = new ConMySql(); //listCompany = conDB.getCompany(); }
public FRMMain() { InitializeComponent(); strPathSkin = pathFolderSave + "\\" + skinFileName; loadSkin(); showWaitingForm("กำลังทำการเปิดโปรแกรม"); conDB = new ConMySql(); }
private void testConDB() { ConMySql conDB = new ConMySql(); bool resultCheckConnect = conDB.CheckConnect(); conDB.CloseConnection(); setStatusConnect(resultCheckConnect); }
public UCCustomerClem() { Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); InitializeComponent(); DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle(""); panelControl5.Appearance.BackColor = Color.Red; conDB = new ConMySql(); }
public UCAddEmployee(FRMMain fRMMain) { InitializeComponent(); // TODO: Complete member initialization this.fRMMain = fRMMain; conDB = new ConMySql(); convertDT = new ConvertDateTime(); dtStart.Properties.DisplayFormat.FormatString = fRMMain.formatDate; dtStart.Properties.Mask.EditMask = fRMMain.formatDate; }
public UCAddProduct(FRMMain fRMMain) { InitializeComponent(); // TODO: Complete member initialization this.fRMMain = fRMMain; conDB = new ConMySql(); convertDT = new ConvertDateTime(); price.Properties.Mask.MaskType = MaskType.Numeric; price.Properties.Mask.EditMask = "n"; }
public UCAddEmployeeClem(FRMMain fRMMain) { Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); InitializeComponent(); // TODO: Complete member initialization this.fRMMain = fRMMain; conDB = new ConMySql(); convertDT = new ConvertDateTime(); //set รูปแบบวันที่ dtProductEndDate.Properties.DisplayFormat.FormatString = fRMMain.formatDate; dtProductEndDate.Properties.Mask.EditMask = fRMMain.formatDate; }
public UCAddCustomerClem(FRMMain mFRM) { Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); InitializeComponent(); fRMMain = mFRM; conDB = new ConMySql(); convertDT = new ConvertDateTime(); //set รูปแบบวันที่ dtProductEndDate.Properties.DisplayFormat.FormatString = fRMMain.formatDate; dtProductEndDate.Properties.Mask.EditMask = fRMMain.formatDate; textEditChargebacks.Properties.Mask.MaskType = MaskType.Numeric; textEditChargebacks.Properties.Mask.EditMask = "n"; }
private DataTable ListarPessoa(string pessoa) { ConMySql conexao = new ConMySql(); conexao.ligar(); DataTable dtPessoa = new DataTable(); try { string comando = $"SELECT * FROM {pessoa} order by nome"; MySqlDataAdapter Adapter = new MySqlDataAdapter(comando, conexao.con()); Adapter.Fill(dtPessoa); } catch (Exception EX) { MessageBox.Show("ERRO:" + "\n" + EX.Message); } return(dtPessoa); }