public void SearchCustomer(BunifuCustomDataGrid dataGrid, string name) { if (name.Length > 0) { //if (name == "w" || name == "W") //{ // MessageBox.Show("No Record Found For this Name", "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); //} //else //{ if (Checking(dataGrid, name)) { } else { if (!isError) { MessageBox.Show("No Record Found For this Name", "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); isError = true; } } //} } else if (name.Length == 0) { GetData(dataGrid, "select * from Customer order by Name"); } }
public void afficher_agent(BunifuCustomDataGrid dtg) { var cnx = new SqlConnection("Data Source=DESKTOP-PO0I2OH;Initial Catalog=db_medical_store;User ID=Lens;[email protected]?"); try { SqlHelper helper = new SqlHelper(prms.ToString()); if (helper.estConnecte) { cnx.Open(); var cmd = new SqlCommand("afficher_agent", cnx) { CommandType = CommandType.StoredProcedure }; cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); var dt = new DataTable(); da.Fill(dt); dtg.DataSource = dt; } } catch (Exception e) { MessageBox.Show("Erreur de connexion: " + e.Message); } finally { cnx.Close(); cnx.Dispose(); } }
public void GetData(BunifuCustomDataGrid dataGrid, string query) { try { using (SQLiteConnection sql = new SQLiteConnection(con)) { sql.Open(); SQLiteCommand cmd = new SQLiteCommand(query, sql); cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SQLiteDataAdapter da = new SQLiteDataAdapter(cmd); da.Fill(dt); if (dt.Rows.Count > 0) { string searchExpression = "Id = 1"; DataRow[] foundRows = dt.Select(searchExpression); foreach (DataRow dr in foundRows) { dt.Rows.Remove(dr); } //dt.Rows[0].Delete(); //dt.AcceptChanges(); } dataGrid.DataSource = dt; sql.Close(); dataGrid.Columns["Id"].Visible = false; dataGrid.Columns["Date"].Visible = false; } } catch (Exception ex) { MessageBox.Show("Exception Occurs in datagridView Code.........." + ex.Message); } }
private void dt_Listar_DoubleClick(object sender, EventArgs e) { BunifuCustomDataGrid btn = sender as BunifuCustomDataGrid; switch (this.numero) { case 1: if (btn.SelectedRows.Count.Equals(1)) { idPer = int.Parse(btn.CurrentRow.Cells[0].Value.ToString()); IniciarSubFormulario(); } else { SystemSounds.Hand.Play(); } break; case 2: if (btn.SelectedRows.Count.Equals(1)) { idEva = int.Parse(btn.CurrentRow.Cells[0].Value.ToString()); IniciarSubFormulario(); } else { SystemSounds.Hand.Play(); } break; } }
public void rechercher_agent_par_matricule(string matricule_agent, BunifuCustomDataGrid dtg) { SqlConnection cnx = new SqlConnection(prms.ToString()); try { if (cnx.State == ConnectionState.Closed) { cnx.Open(); } string requete = "recherche_agent_par_matricule"; SqlCommand cmd = new SqlCommand(requete, cnx); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("matricule_agent", SqlDbType.NVarChar)).Value = matricule_agent; cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); dtg.DataSource = dt; } catch (Exception e) { MessageBox.Show("Erreur de connexion: " + e.Message); } finally { cnx.Close(); cnx.Dispose(); } }
private bool Checking(BunifuCustomDataGrid dataGrid, string name) { using (SQLiteConnection sql = new SQLiteConnection(con)) { sql.Open(); SQLiteDataAdapter da = new SQLiteDataAdapter("select * from Expenses where Name like '" + name + "%'", sql); DataTable dt = new DataTable(); if (da != null) { da.Fill(dt); } if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { double sdate = Convert.ToDouble(row["Datetime"]); var sfinal = DateTime.FromOADate(sdate); row["Datetime"] = sfinal.ToString("dd-MM-yyyy"); } dataGrid.DataSource = dt; sql.Close(); return(true); } else { sql.Close(); return(false); } } }
private bool Checking(BunifuCustomDataGrid dataGrid, string name) { using (SQLiteConnection sql = new SQLiteConnection(con)) { sql.Open(); SQLiteDataAdapter da = new SQLiteDataAdapter("select * from Units where Name like '" + name + "%'", sql); //da.SelectCommand.Parameters.AddWithValue("@Name", txt_search.Text); DataTable dt = new DataTable(); if (da != null) { da.Fill(dt); } if (dt.Rows.Count > 0) { dataGrid.DataSource = dt; sql.Close(); return(true); } else { sql.Close(); return(false); } } }
private bool Checking(BunifuCustomDataGrid dataGrid, string name) { using (SQLiteConnection sql = new SQLiteConnection(con)) { sql.Open(); SQLiteDataAdapter da = new SQLiteDataAdapter("select Products.Id,Products.Name,Products.Price,Products.ImageUrl,Categories.Id as CategoryID,Products.UnitID,Products.ShortCode,Categories.Name as Category from Products inner join Categories on Products.CategoryID = Categories.Id where Name like '" + name + "%'", sql); //da.SelectCommand.Parameters.AddWithValue("@Name", txt_search.Text); DataTable dt = new DataTable(); if (da != null) { da.Fill(dt); } if (dt.Rows.Count > 0) { dataGrid.DataSource = dt; sql.Close(); return(true); } else { sql.Close(); return(false); } } }
private bool Checking(BunifuCustomDataGrid dataGrid, string name) { using (SQLiteConnection sql = new SQLiteConnection(con)) { sql.Open(); SQLiteDataAdapter da = new SQLiteDataAdapter("select Stock_Update.Id,Stock.Product_Id as Name,Stock_Update.Quantity,Stock_Update.Price,Stock_Update.Datetime,Stock_Update.Last_Available,Stock.Quantity as StockQuantity,Stock.Product_Id as ProductID from Stock inner join Stock_Update on Stock_Update.ProductID = Stock.Product_Id where Stock_Update.Datetime = @Datetime and Stock.Product_Id like '" + name + "%'", sql); da.SelectCommand.Parameters.AddWithValue("@Datetime", "" + Convert.ToInt32(DateTime.Now.Date.ToOADate())); DataTable dt = new DataTable(); if (da != null) { da.Fill(dt); } if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { double sdate = Convert.ToDouble(row["Datetime"]); var sfinal = DateTime.FromOADate(sdate); row["Datetime"] = sfinal.ToString("dd-MM-yyyy"); } dataGrid.DataSource = dt; sql.Close(); return(true); } else { sql.Close(); return(false); } } }
public bool DateWiseExpenses(BunifuCustomDataGrid dataGrid, int date) { using (SQLiteConnection sql = new SQLiteConnection(con)) { sql.Open(); SQLiteDataAdapter da = new SQLiteDataAdapter("select * from Expenses where Datetime=@Datetime", sql); da.SelectCommand.Parameters.AddWithValue("@Datetime", date); DataTable dt = new DataTable(); if (da != null) { da.Fill(dt); } if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { double sdate = Convert.ToDouble(row["Datetime"]); var sfinal = DateTime.FromOADate(sdate); row["Datetime"] = sfinal.ToString("dd-MM-yyyy"); } dataGrid.DataSource = dt; sql.Close(); return(true); } else { sql.Close(); return(false); } } }
public void Preencher(BunifuCustomDataGrid tableOrcamento, string _marca, Label _lblSemDados) { try { DataTable dataTable = new DataTable(); using (SqlConnection conexao = OpenConnection()) { string query = "select * from tb_orcamento where orc_aparelho = @marca"; SqlCommand cmd = new SqlCommand(query, conexao); cmd.Parameters.AddWithValue("@marca", _marca); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dataTable); if (dataTable.Rows.Count <= 0) { _lblSemDados.Visible = true; } else { _lblSemDados.Visible = false; } tableOrcamento.DataSource = dataTable; tableOrcamento.Sort(tableOrcamento.Columns["orc_id"], ListSortDirection.Descending); } } catch (Exception ex) { MessageBox.Show("Erro ao preencher a tabela.\n\n\nErro: " + ex, "ERRO", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void GetData(BunifuCustomDataGrid dataGrid, string query) { try { using (SQLiteConnection sql = new SQLiteConnection(con)) { sql.Open(); SQLiteCommand cmd = new SQLiteCommand(query, sql); cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SQLiteDataAdapter da = new SQLiteDataAdapter(cmd); da.Fill(dt); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { double sdate = Convert.ToDouble(row["Datetime"]); var sfinal = DateTime.FromOADate(sdate); //row["Datetime"] = sfinal.ToString("dd-MM-yyyy"); row["Datetime"] = sfinal.ToString("dd-MM-yyyy"); } } dataGrid.DataSource = dt; sql.Close(); dataGrid.Columns["Id"].Visible = false; } } catch (Exception ex) { MessageBox.Show("Exception Occurs in datagridView Code.........." + ex.Message); } }
public bool AllStock(BunifuCustomDataGrid dataGrid) { using (SQLiteConnection sql = new SQLiteConnection(con)) { sql.Open(); SQLiteDataAdapter da = new SQLiteDataAdapter("select Stock_Update.Id, Stock.Product_Id as Name, Stock_Update.Quantity, Stock_Update.Price, Stock_Update.Datetime, Stock_Update.Last_Available, Stock.Quantity as StockQuantity, Stock.Product_Id as ProductID from Stock inner join Stock_Update on Stock_Update.ProductID = Stock.Product_Id order by Stock_Update.Datetime", sql); DataTable dt = new DataTable(); if (da != null) { da.Fill(dt); } if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { double sdate = Convert.ToDouble(row["Datetime"]); var sfinal = DateTime.FromOADate(sdate); row["Datetime"] = sfinal.ToString("dd-MM-yyyy"); } dataGrid.DataSource = dt; sql.Close(); dataGrid.Columns["StockQuantity"].Visible = false; dataGrid.Columns["ProductID"].Visible = false; dataGrid.Columns["Id"].Visible = false; return(true); } else { sql.Close(); return(false); } } }
private void getValuesTable(BunifuCustomDataGrid table, int value) { id = int.Parse(table.CurrentRow.Cells[0].Value.ToString()); if (table.CurrentRow != null) { int until = table.Rows.Count; if (value == 1) { for (int y = 0; y < until; y++) { kirim_grid.CurrentRow.Cells[y].Selected = true; chiqim_grid.CurrentRow.Cells[y].Selected = false; } } else { for (int y = 0; y < 4; y++) { chiqim_grid.CurrentRow.Cells[y].Selected = true; kirim_grid.CurrentRow.Cells[y].Selected = false; } } } TableId = value; coming_amount.Text = table.CurrentRow.Cells[2].Value.ToString(); приход_date.Value = DateTime.Parse(table.CurrentRow.Cells[3].Value.ToString()); }
private void searchTable(BunifuCustomDataGrid table) { BindingSource bs = new BindingSource(); bs.DataSource = table.DataSource; //bs.Filter = "sana like '%" + tv_search.Text + "%'"; table.DataSource = bs; }
private float[] RecuperarTamaño(BunifuCustomDataGrid dt) { float[] tamaño = new float[dt.ColumnCount]; for (int i = 0; i < dt.ColumnCount; i++) { tamaño[i] = (float)dt.Columns[i].Width; } return(tamaño); }
public void View(BunifuCustomDataGrid dataGid) { using (QLNTEntities1 db = new QLNTEntities1()) { var result = from c in db.NhaCungCap select new { TenNCC = c.TenNCC, SoDienThoai = c.SoDienThoai, DiaChi = c.DiaChi, MaNCC = c.MaNCC }; dataGid.DataSource = result.ToList(); } }
public void Search(BunifuCustomDataGrid dataGrid, string s) { using (QLNTEntities1 db = new QLNTEntities1()) { var result = from c in db.PhanBons where c.TenPB.Contains(s) select new { TenPB = c.TenPB, Loai = c.Loai, KhoiLuong = c.KhoiLuong.ToString(), SoLuong = c.SoLuong, DonGia = c.DonGia, NgaySX = c.NgaySX.Day + "/" + c.NgaySX.Month + "/" + c.NgaySX.Year, HanSD = c.HanSD.Day + "/" + c.HanSD.Month + "/" + c.HanSD.Year, MaPB = c.MaPB }; dataGrid.DataSource = result.ToList(); } }
public void Search(BunifuCustomDataGrid dataGrid, string s) { using (QLNTEntities1 db = new QLNTEntities1()) { var result = from c in db.ThuocBaoVeTV where c.TenThuoc.Contains(s) select new { TenThuoc = c.TenThuoc, ThoiGianCachLy = c.ThoiGianCachLy, NoiSX = c.NoiSX, Dang = c.Dang, SoLuong = c.SoLuong, CongDung = c.CongDung, NgaySX = c.NgaySX, HanSD = c.HanSD, MaThuoc = c.MaThuoc, MaDoc = c.MaDoc }; dataGrid.DataSource = result.ToList(); } }
public void View(BunifuCustomDataGrid dataGrid) { using (QLNTEntities1 db = new QLNTEntities1()) { //var result = from c in db.PhanBons select new { TenPB=c.TenPB, Loai=c} ; var result = from c in db.Cay select new { TenCay = c.TenCay, SoLuong = c.SoLuong, MuaThuHoach = c.MuaThuHoach, NamTrongCay = c.NamTrongCay, MaLoaiCay = c.MaLoaiCay }; dataGrid.DataSource = result.ToList(); } }
public void View(BunifuCustomDataGrid dataGid) { using (QLNTEntities1 db = new QLNTEntities1()) { //var result = from c in db.PhanBons select new { TenPB=c.TenPB, Loai=c} ; var result = from c in db.KhachHang select new { TenKH = c.TenKH, DienThoai = c.DienThoai, DiaChi = c.DiaChi, MaKH = c.MaKH }; dataGid.DataSource = result.ToList(); } }
public void View(BunifuCustomDataGrid dataGrid) { using (QLNTEntities1 db = new QLNTEntities1()) { //var result = from c in db.NongSans select new { TenPB=c.TenPB, Loai=c} ; var result = from c in db.NongSans select new { ThoiGianBaoQuan = c.ThoiGianBaoQuan, SanLuongTonKho = c.SanLuongTonKho, DonGia = c.DonGia, BaoQuan = c.BaoQuan }; dataGrid.DataSource = result.ToList(); } }
public void Search(BunifuCustomDataGrid dataGrid, string s) { using (QLNTEntities1 db = new QLNTEntities1()) { var result = from c in db.Cay where c.TenCay.Contains(s) select new { TenCay = c.TenCay, SoLuong = c.SoLuong, MuaThuHoach = c.MuaThuHoach, NamTrongCay = c.NamTrongCay, MaLoaiCay = c.MaLoaiCay }; dataGrid.DataSource = result.ToList(); } }
public void getCTKeHoach(string id, BunifuCustomDataGrid dataGrid) { QLNTEntities1 db = new QLNTEntities1(); int ma = Convert.ToInt32(id); var result = from c in db.ChiTietKH join d in db.LoaiKH on c.MaLoai equals d.MaLoai where c.MaKH == ma select new { CongViec = d.TenLoai, HoanThanh = c.HoanThanh, MaLoai = c.MaLoai }; dataGrid.DataSource = result.ToList(); }
public void View(BunifuCustomDataGrid dataGid) { using (QLNTEntities1 db = new QLNTEntities1()) { var result = from c in db.NhanVien join q in db.Quyen on c.MaQuyen equals q.MaQuyen where q.MaQuyen != 1 select new { TenNV = c.TenNV, SoDienThoai = c.SoDienThoai, DiaChi = c.DiaChi, MatKhau = c.MatKhau, MaNV = c.MaNV, TenChucVu = q.TenChucVu, MaQuyen = q.MaQuyen }; dataGid.DataSource = result.ToList(); } }
public void View(BunifuCustomDataGrid dataGrid) { using (QLNTEntities1 db = new QLNTEntities1()) { //var result = from c in db.PhanBons select new { TenPB=c.TenPB, Loai=c} ; var result = from c in db.ThuocBaoVeTV select new { TenThuoc = c.TenThuoc, ThoiGianCachLy = c.ThoiGianCachLy, NoiSX = c.NoiSX, Dang = c.Dang, SoLuong = c.SoLuong, CongDung = c.CongDung, NgaySX = c.NgaySX, HanSD = c.HanSD, MaThuoc = c.MaThuoc, MaDoc = c.MaDoc }; dataGrid.DataSource = result.ToList(); } }
// thêm chi tiết kế hoạch chưa có public void ShowAddCtKH(int id, BunifuCustomDataGrid dataGrid) { using (QLNTEntities1 db = new QLNTEntities1()) { var result = from l in db.LoaiKH where !(from c in db.ChiTietKH where c.MaKH == id select c.MaLoai ).Contains(l.MaLoai) select new { MaLoai = l.MaLoai, CongViec = l.TenLoai }; dataGrid.DataSource = result.ToList(); } }
private void AddButton(BunifuCustomDataGrid dataGrid, string text) { _col = new DataGridViewButtonColumn { HeaderText = "", Text = text, UseColumnTextForButtonValue = true, Width = 90, DefaultCellStyle = { ForeColor = Color.DarkCyan, BackColor = Color.White }, FlatStyle = FlatStyle.Flat, DisplayIndex = dataGrid.Columns.Count + 1 }; dataGrid.Columns.Add(_col); }
public void PesquisarClienteNome(string _nomeCliente, BunifuCustomDataGrid tabelaClientes) { using (SqlConnection con = OpenConnection()) { DataTable datatable = new DataTable(); string query = "select cl_id, cl_nome, cl_cpf, cl_telefone from tb_clientes where cl_nome like @nomeCliente"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@nomeCliente", String.Format("%{0}%", _nomeCliente)); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.SelectCommand.ExecuteNonQuery(); adapter.Fill(datatable); tabelaClientes.DataSource = datatable; } }
public void Search(BunifuCustomDataGrid dataGid, string s) { using (QLNTEntities1 db = new QLNTEntities1()) { var result = from c in db.KhachHang where c.TenKH.Contains(s) select new { MaKH = c.MaKH, TenKH = c.TenKH, DienThoai = c.DienThoai, DiaChi = c.DiaChi }; dataGid.DataSource = result.ToList(); } }