public FrmTimKiemKhachHang(string P_KEYSEARCH) { InitializeComponent(); dgvThongTinKhachHang.Columns["STT"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["STT"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["MAKHACHHANG"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["MAKHACHHANG"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["MATHE"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["MATHE"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["TENKHACHHANG"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["TENKHACHHANG"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["DIACHI"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["DIACHI"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["DIENTHOAI"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["DIENTHOAI"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["CANCUOC_CONGDAN"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["CANCUOC_CONGDAN"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["NGAYSINH"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["NGAYSINH"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["NGAYDACBIET"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["NGAYDACBIET"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["SODIEM"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["SODIEM"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["TONGTIEN"].HeaderCell.Style.Font = new Font("Arial", 15F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); dgvThongTinKhachHang.Columns["TONGTIEN"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvThongTinKhachHang.Columns["NGAYDACBIET"].Visible = false; dgvThongTinKhachHang.Columns["CANCUOC_CONGDAN"].Visible = false; dgvThongTinKhachHang.Columns["SODIEM"].Visible = false; dgvThongTinKhachHang.Columns["TONGTIEN"].Visible = false; BindingList <TIMKIEM_DTO> _comboItems = new BindingList <TIMKIEM_DTO>(); _comboItems.Add(new TIMKIEM_DTO { VALUE = 0, TEXT = "Mã thẻ" }); _comboItems.Add(new TIMKIEM_DTO { VALUE = 1, TEXT = "Mã khách hàng" }); _comboItems.Add(new TIMKIEM_DTO { VALUE = 2, TEXT = "Tên khách hàng" }); _comboItems.Add(new TIMKIEM_DTO { VALUE = 3, TEXT = "Số điện thoại" }); _comboItems.Add(new TIMKIEM_DTO { VALUE = 4, TEXT = "Số chứng minh thư" }); _comboItems.Add(new TIMKIEM_DTO { VALUE = 5, TEXT = "Số điểm" }); cboDieuKienTimKiem.DataSource = _comboItems; cboDieuKienTimKiem.DisplayMember = "TEXT"; cboDieuKienTimKiem.ValueMember = "VALUE"; cboDieuKienTimKiem.SelectedIndex = 0; txtDieuKienTimKiem.Text = P_KEYSEARCH; List <KHACHHANG_DTO> _LST_KHACHHANG_DTO = new List <KHACHHANG_DTO>(); _LST_KHACHHANG_DTO = FrmThanhToanService.TIMKIEM_KHACHHANG_FROM_ORACLE(P_KEYSEARCH, 1, cboDieuKienTimKiem.SelectedIndex, Session.Session.CurrentUnitCode); BINDING_DATA_KHACHHANG_TO_GRIDVIEW(_LST_KHACHHANG_DTO); }
private void THANHTOAN_HOADON_BANLE_TRALAI() { bool success = false; string TONGTIEN_BANGCHU = ConvertSoThanhChu.ChuyenDoiSoThanhChu(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.THANHTIEN); try { LUU_DULIEU(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL); } catch { MessageBox.Show("CẢNH BÁO ! XẢY RA LỖI KHI LƯU HÓA ĐƠN NÀY, HÃY LƯU LẠI HÓA ĐƠN ĐỂ KIỂM TRA ! XIN CẢM ƠN "); } try { string MA_TEN_KHACHHANG = ""; if (Config.CheckConnectToServer()) { MA_TEN_KHACHHANG = FrmThanhToanService.LAY_MA_TEN_KHACHHANG_FROM_ORACLE(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAKHACHHANG); } else { MA_TEN_KHACHHANG = FrmThanhToanService.LAY_MA_TEN_KHACHHANG_FROM_SQLSERVER(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAKHACHHANG); } using (frmPrintBill_TraLai frmBanTraLai = new frmPrintBill_TraLai()) { try { BILL_DTO infoBill = new BILL_DTO() { ADDRESS = Session.Session.CurrentAddress, CONLAI = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.TIEN_TRALAI_KHACH, PHONE = Session.Session.CurrentPhone, MAKH = MA_TEN_KHACHHANG, DIEM = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.SODIEM, INFOTHUNGAN = "THU NGÂN: " + Session.Session.CurrentTenNhanVien, MA_GIAODICH = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MA_GIAODICH, THANHTIENCHU = TONGTIEN_BANGCHU, TIENKHACHTRA = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.TIENKHACH_TRA, TENCUAHANG = Session.Session.CurrentNameStore }; frmBanTraLai.PrintInvoice_BanLeTraLai(infoBill, _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL); } catch { } finally { this.handler(true); this.Dispose(); frmBanTraLai.Dispose(); frmBanTraLai.Refresh(); } } } catch (Exception ex) { WriteLogs.LogError(ex); } }
private void btnTimKiemKhachHang_Click(object sender, System.EventArgs e) { string P_KEYSEARCH = txtDieuKienTimKiem.Text; int P_USE_TIMKIEM_ALL = 0; int P_DIEUKIEN_TIMKIEM = cboDieuKienTimKiem.SelectedIndex; List <KHACHHANG_DTO> _LST_KHACHHANG_DTO = new List <KHACHHANG_DTO>(); _LST_KHACHHANG_DTO = FrmThanhToanService.TIMKIEM_KHACHHANG_FROM_ORACLE(P_KEYSEARCH, P_USE_TIMKIEM_ALL, P_DIEUKIEN_TIMKIEM, Session.Session.CurrentUnitCode); BINDING_DATA_KHACHHANG_TO_GRIDVIEW(_LST_KHACHHANG_DTO); }
private void txtDieuKienTimKiem_TextChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtDieuKienTimKiem.Text)) { string P_KEYSEARCH = txtDieuKienTimKiem.Text; int P_USE_TIMKIEM_ALL = 1; int P_DIEUKIEN_TIMKIEM = cboDieuKienTimKiem.SelectedIndex; List <KHACHHANG_DTO> _LST_KHACHHANG_DTO = new List <KHACHHANG_DTO>(); _LST_KHACHHANG_DTO = FrmThanhToanService.TIMKIEM_KHACHHANG_FROM_ORACLE(P_KEYSEARCH, P_USE_TIMKIEM_ALL, P_DIEUKIEN_TIMKIEM, Session.Session.CurrentUnitCode); BINDING_DATA_KHACHHANG_TO_GRIDVIEW(_LST_KHACHHANG_DTO); } }