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);
}
