private void napDanhSachTenTiemVaDiaChi() { if (File.Exists(duongDanFileExcel)) { clsXuLyDuLieu _xuLy = new clsXuLyDuLieu(); //bbiChonFileDuLieu.EditValue = duongDanFileExcelMacDinh; DataTable dtDanhSachNhaCungCap = new DataTable(); dtDanhSachNhaCungCap = _xuLy.docDanhSachNhaCungCapFileExcel(duongDanFileExcel, Path.GetExtension(duongDanFileExcel), "Yes"); //MessageBox.Show(dtMaVachExcel.Rows.Count.ToString()); //napDuLieuVaoLuoiTuFileExcel(dtMaVachExcel); //var adapterDiaChi = new DANH_SACH_DIA_CHITableAdapter(); //adapterDiaChi.Connection.ConnectionString = SqlHelper.ConnectionString; //adapterDiaChi.ClearBeforeFill = true; //adapterDiaChi.Fill(dtDanhSachDiaChi); AutoCompleteStringCollection mangDanhSachNhaCungCap = new AutoCompleteStringCollection(); AutoCompleteStringCollection mangDanhSachDiaChi = new AutoCompleteStringCollection(); AutoCompleteStringCollection mangDanhSachTenTiem = new AutoCompleteStringCollection(); foreach (DataRow dr in dtDanhSachNhaCungCap.Rows) { mangDanhSachNhaCungCap.Add(dr["Nhà Cung Cấp"].ToString()); mangDanhSachDiaChi.Add(dr["Địa Chỉ"].ToString()); mangDanhSachTenTiem.Add(dr["Tên Tiệm"].ToString()); } var txtNhaCungCap_AutoComplete = txtNhaCungCap.MaskBox; txtNhaCungCap_AutoComplete.AutoCompleteSource = AutoCompleteSource.CustomSource; txtNhaCungCap_AutoComplete.AutoCompleteMode = AutoCompleteMode.Suggest; txtNhaCungCap_AutoComplete.AutoCompleteCustomSource = mangDanhSachNhaCungCap; var txtDiaChi_AutoComplete = txtDiaChi.MaskBox; txtDiaChi_AutoComplete.AutoCompleteSource = AutoCompleteSource.CustomSource; txtDiaChi_AutoComplete.AutoCompleteMode = AutoCompleteMode.Suggest; txtDiaChi_AutoComplete.AutoCompleteCustomSource = mangDanhSachDiaChi; var txtTenTiem_AutoComplete = txtTenTiem.MaskBox; txtTenTiem_AutoComplete.AutoCompleteSource = AutoCompleteSource.CustomSource; txtTenTiem_AutoComplete.AutoCompleteMode = AutoCompleteMode.Suggest; txtTenTiem_AutoComplete.AutoCompleteCustomSource = mangDanhSachTenTiem; } }
private void btnLuu_Click(object sender, EventArgs e) { //try //{ // var ds = new DataSet(); // var dt = new DataTable("ThongTinTiem"); // dt.Columns.Add("TenTiem"); // dt.Columns.Add("DiaChi"); // dt.Columns.Add("CongCOM"); // dt.Columns.Add("FileExcel"); // dt.Rows.Clear(); // dt.Rows.Add( // new object[] // { // txtTenTiem.Text, // txtDiaChi.Text, // txtCongCOM.Text, // txtDuongDanDuLieu.Text // } // ); // ds.Tables.Add(dt); // ds.WriteXml("ThongTinTiem.xml"); // RaiseNapLaiEventHander(); // this.Close(); //} //catch (Exception ex) //{ // XtraMessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); //} clsXuLyDuLieu _clsXuLyDuLieu = new clsXuLyDuLieu(); if(_clsXuLyDuLieu.luuThongTin(txtTenTiem.Text, txtDiaChi.Text, txtCongCOM.Text, txtDuongDanDuLieu.Text, txtTenMayIn.Text)) { RaiseNapLaiEventHander(); this.Close(); } }
private void rptChonFile_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { if(e.Button.Tag.ToString() == "Chon") { OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.Filter = "(*.xls, *.xlsx)|*.xls;*.xlsx|All files (*.*)|*.*"; openFileDialog1.FilterIndex = 1; openFileDialog1.Multiselect = false; // Call the ShowDialog method to show the dialog box. if (openFileDialog1.ShowDialog() != System.Windows.Forms.DialogResult.OK) return; string path = openFileDialog1.FileName; bbiChonFileDuLieu.EditValue = path; if (!string.IsNullOrEmpty(path) && File.Exists(path)) { var _xuLy = new clsXuLyDuLieu(); DataTable dtMaVachExcel = new DataTable(); dtMaVachExcel = _xuLy.docFileExcel(path, Path.GetExtension(path), "Yes"); napDuLieuVaoLuoiTuFileExcel(dtMaVachExcel); } } }
private void bbiXem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { string duongDanFileExcel = bbiChonFileDuLieu.EditValue.ToString(); if (!string.IsNullOrEmpty(duongDanFileExcel)) { bbiChonFileDuLieu.EditValue = duongDanFileExcel; if (File.Exists(duongDanFileExcel)) { var _xuLy = new clsXuLyDuLieu(); DataTable dtMaVachExcel = new DataTable(); dtMaVachExcel = _xuLy.docFileExcel(duongDanFileExcel, Path.GetExtension(duongDanFileExcel), "Yes"); napDuLieuVaoLuoiTuFileExcel(dtMaVachExcel); } } } catch(Exception ex) { MessageBox.Show(ex.Message); } }
private void frmQuanLyInTem_FormClosing(object sender, FormClosingEventArgs e) { string tenTiem = bbiTenTiem.EditValue == null ? "" : bbiTenTiem.EditValue.ToString(); string diaChi = bbiDiaChi.EditValue == null ? "" : bbiDiaChi.EditValue.ToString(); string congCOM = bbiCongCOM.EditValue == null ? "" : bbiCongCOM.EditValue.ToString(); string duongDanFileExcel = bbiChonFileDuLieu.EditValue == null ? "" : bbiChonFileDuLieu.EditValue.ToString(); string mayIn = bbiMayIn.EditValue == null ? "" : bbiMayIn.EditValue.ToString(); clsXuLyDuLieu _clsXuLyDuLieu = new clsXuLyDuLieu(); _clsXuLyDuLieu.luuThongTin(tenTiem, diaChi, congCOM, duongDanFileExcel, mayIn); }