private void LOGIN() { string Username = txtUserName.Text.Trim(); string passWord = txtPassWord.Text.Trim(); string passMd5 = MD5Encrypt.MD5Hash(passWord).Trim(); //check true false login try { //BEGIN LOGIN if (Config.CheckConnectToServer()) // nếu có mạng lan { using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; cmd.CommandText = string.Format(@"SELECT USERNAME,MANHANVIEN,TENNHANVIEN,UNITCODE FROM NGUOIDUNG WHERE USERNAME = '******' AND PASSWORD = '******'"); OracleDataReader dataReader = null; dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { Session.Session.CurrentMaNhanVien = dataReader["MANHANVIEN"].ToString(); Session.Session.CurrentTenNhanVien = dataReader["TENNHANVIEN"].ToString(); Session.Session.CurrentUnitCode = dataReader["UNITCODE"].ToString(); Session.Session.CurrentCodeStore = Session.Session.CurrentUnitCode; SYNCHRONIZE_DATA.SYNCHRONIZE_KYKETOAN(); SYNCHRONIZE_DATA.KHOASODULIEU(); SYNCHRONIZE_DATA.SYNCHRONIZE_KHOASO(); cmd.Parameters.Clear(); cmd.CommandText = string.Format(@"SELECT TEN_CUAHANG,DIACHI,SODIENTHOAI FROM CUAHANG WHERE MA_CUAHANG = '" + Session.Session.CurrentUnitCode + "'"); OracleDataReader dataReaderDonVi = null; dataReaderDonVi = cmd.ExecuteReader(); if (dataReaderDonVi.HasRows) { while (dataReaderDonVi.Read()) { Session.Session.CurrentPhone = dataReaderDonVi["SODIENTHOAI"].ToString(); Session.Session.CurrentAddress = dataReaderDonVi["DIACHI"].ToString(); Session.Session.CurrentNameStore = dataReaderDonVi["TEN_CUAHANG"].ToString(); } } dataReaderDonVi.Close(); Session.Session.CurrentUserName = dataReader["USERNAME"].ToString(); Session.Session.CurrentNgayPhatSinh = FrmXuatBanLeService.GET_NGAYHACHTOAN_CSDL_ORACLE(); Session.Session.CurrentTableNamePeriod = FrmXuatBanLeService.GET_TABLE_NAME_NGAYHACHTOAN_CSDL_ORACLE(); cmd.Parameters.Clear(); cmd.CommandText = string.Format(@"SELECT GIATRI_CHU FROM THAMSOHETHONG WHERE MA_THAMSO = 'DEFAULT_KHOBANLE' AND UNITCODE = '" + Session.Session.CurrentUnitCode + "'"); OracleDataReader dataReaderThamSo = null; dataReaderThamSo = cmd.ExecuteReader(); if (dataReaderThamSo.HasRows) { while (dataReaderThamSo.Read()) { Session.Session.CurrentWareHouse = dataReaderThamSo["GIATRI_CHU"].ToString(); } } else { Session.Session.CurrentWareHouse = "KH2"; } SplashScreenManager.ShowForm(typeof(WaitForm1)); SYNCHRONIZE_DATA.SYNCHRONIZE_NGUOIDUNG(); SYNCHRONIZE_DATA.SYNCHRONIZE_KHACHHANG(); SYNCHRONIZE_DATA.SYNCHRONIZE_KHUYENMAI(); SYNCHRONIZE_DATA.SYNCHRONIZE_KHUYENMAI_CHITIET(); SYNCHRONIZE_DATA.SYNCHRONIZE_THAMSOHETHONG(); SYNCHRONIZE_DATA.SYNCHRONIZE_LOAIHANG(); SYNCHRONIZE_DATA.SYNCHRONIZE_NHOMHANG(); SYNCHRONIZE_DATA.SYNCHRONIZE_MATHANG(); SYNCHRONIZE_DATA.SYNCHRONIZE_MATHANG_GIA(); SYNCHRONIZE_DATA.SYNCHRONIZE_CUAHANG(); SYNCHRONIZE_DATA.SYNCHRONIZE_DONVITINH(); SYNCHRONIZE_DATA.SYNCHRONIZE_THUE(); SYNCHRONIZE_DATA.SYNCHRONIZE_HANGKHACHHANG(); SYNCHRONIZE_DATA.SYNCHRONIZE_NHACUNGCAP(); SplashScreenManager.CloseForm(); FrmMain frmMain = new FrmMain(); frmMain.ShowDialog(); break; } } else { NotificationLauncher.ShowNotificationWarning("Thông báo", "Thông tin đăng nhập không đúng", 1, "0x1", "0x8", "normal"); txtPassWord.Text = ""; txtPassWord.Focus(); } } catch (Exception ex) { NotificationLauncher.ShowNotificationError("Thông báo", "Không có kết nối với cơ sở dữ liệu máy chủ", 1, "0x1", "0x8", "normal"); WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("Thông báo", "Không có kết nối với cơ sở dữ liệu", 1, "0x1", "0x8", "normal"); } } } else { //Kết nối với SQL using (SqlConnection connectionSa = new SqlConnection(ConfigurationManager.ConnectionStrings["ERBusCashier"].ConnectionString)) { connectionSa.Open(); if (connectionSa.State == ConnectionState.Open) { try { SqlCommand cmdSelectSa = new SqlCommand(); cmdSelectSa.Connection = connectionSa; cmdSelectSa.CommandText = string.Format(@"SELECT USERNAME,MANHANVIEN,TENNHANVIEN,UNITCODE FROM [dbo].[NGUOIDUNG] WHERE USERNAME = '******' AND PASSWORD = '******'"); SqlDataReader dataReader = null; dataReader = cmdSelectSa.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { Session.Session.CurrentMaNhanVien = dataReader["MANHANVIEN"].ToString(); Session.Session.CurrentTenNhanVien = dataReader["TENNHANVIEN"].ToString(); Session.Session.CurrentUnitCode = dataReader["UNITCODE"].ToString(); Session.Session.CurrentCodeStore = Session.Session.CurrentUnitCode; SqlCommand cmdSelectCuaHang = new SqlCommand(); cmdSelectCuaHang.Parameters.Clear(); cmdSelectCuaHang.Connection = connectionSa; cmdSelectCuaHang.CommandText = string.Format(@"SELECT TEN_CUAHANG,DIACHI,SODIENTHOAI FROM [dbo].[CUAHANG] WHERE MA_CUAHANG = '" + Session.Session.CurrentUnitCode + "'"); SqlDataReader dataReaderDonVi = null; dataReaderDonVi = cmdSelectCuaHang.ExecuteReader(); if (dataReaderDonVi.HasRows) { while (dataReaderDonVi.Read()) { Session.Session.CurrentPhone = dataReaderDonVi["SODIENTHOAI"].ToString(); Session.Session.CurrentAddress = dataReaderDonVi["DIACHI"].ToString(); Session.Session.CurrentNameStore = dataReaderDonVi["TEN_CUAHANG"].ToString(); } } dataReaderDonVi.Close(); Session.Session.CurrentUserName = dataReader["USERNAME"].ToString(); //nếu mất mạng thì ngày phát sinh là ngày hiện tại Session.Session.CurrentNgayPhatSinh = FrmXuatBanLeService.GET_NGAYHACHTOAN_CSDL_SQLSERVER(); SqlCommand cmdSelectThamSo = new SqlCommand(); cmdSelectThamSo.Connection = connectionSa; cmdSelectThamSo.Parameters.Clear(); cmdSelectThamSo.CommandText = string.Format(@"SELECT GIATRI_CHU FROM dbo.THAMSOHETHONG WHERE MA_THAMSO = 'DEFAULT_KHOBANLE'"); SqlDataReader dataReaderThamSo = null; dataReaderThamSo = cmdSelectThamSo.ExecuteReader(); if (dataReaderThamSo.HasRows) { while (dataReaderThamSo.Read()) { Session.Session.CurrentWareHouse = dataReaderThamSo["GIATRI_CHU"].ToString(); } dataReaderThamSo.Close(); } else { Session.Session.CurrentWareHouse = "KH2"; } FrmMain frmMain = new FrmMain(); frmMain.ShowDialog(); break; } dataReader.Close(); } else { NotificationLauncher.ShowNotificationWarning("Thông báo", "Thông tin đăng nhập không đúng", 1, "0x1", "0x8", "normal"); txtPassWord.Text = ""; txtPassWord.Focus(); } } catch (Exception ex) { NotificationLauncher.ShowNotificationError("Thông báo", "Không có kết nối với cơ sở dữ liệu máy bán", 1, "0x1", "0x8", "normal"); WriteLogs.LogError(ex); } finally { connectionSa.Close(); connectionSa.Dispose(); } } else { NotificationLauncher.ShowNotificationError("Thông báo", "Không có kết nối với cơ sở dữ liệu", 1, "0x1", "0x8", "normal"); } } } //END LOGIN } catch (Exception ex) { NotificationLauncher.ShowNotificationError("Thông báo", "Không có kết nối với cơ sở dữ liệu máy bán", 1, "0x1", "0x8", "normal"); WriteLogs.LogError(ex); } }
public string SAVE_MAKHACHHANG_TO_ORACLE() { string RESULT = ""; using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { OracleCommand command = new OracleCommand(); command.Connection = connection; string querySelectItem = "SELECT LOAIMA,NHOMMA,GIATRI,UNITCODE FROM CAPMA WHERE LOAIMA='VIP' AND NHOMMA = 'KHACHHANG'"; command.CommandText = querySelectItem; command.CommandType = CommandType.Text; OracleDataReader dataReaderBuildCode = command.ExecuteReader(); if (dataReaderBuildCode.HasRows) { while (dataReaderBuildCode.Read()) { MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER(); _MD_ID_BUILDER.ID = Guid.NewGuid().ToString(); _MD_ID_BUILDER.LOAIMA = "VIP"; _MD_ID_BUILDER.NHOMMA = "KHACHHANG"; _MD_ID_BUILDER.GIATRI = "0"; _MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode; int CURRENT_NUMBER = 0; int.TryParse(dataReaderBuildCode["GIATRI"].ToString(), out CURRENT_NUMBER); string SO_MA = GENERATE_NUMBER(CURRENT_NUMBER.ToString()); _MD_ID_BUILDER.GIATRI = SO_MA; OracleCommand commandUpdate = new OracleCommand(); commandUpdate.Connection = connection; string queryUpdateItem = "UPDATE CAPMA SET GIATRI = '" + _MD_ID_BUILDER.GIATRI + "' WHERE LOAIMA = '" + _MD_ID_BUILDER.LOAIMA + "' AND NHOMMA = '" + _MD_ID_BUILDER.NHOMMA + "' "; commandUpdate.CommandText = queryUpdateItem; commandUpdate.CommandType = CommandType.Text; commandUpdate.ExecuteNonQuery(); RESULT = string.Format("{0}{1}", _MD_ID_BUILDER.LOAIMA, SO_MA); } } else { MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER(); _MD_ID_BUILDER.ID = Guid.NewGuid().ToString(); _MD_ID_BUILDER.LOAIMA = "VIP"; _MD_ID_BUILDER.NHOMMA = "KHACHHANG"; _MD_ID_BUILDER.GIATRI = "0"; _MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode; string SO_MA = GENERATE_NUMBER(_MD_ID_BUILDER.GIATRI); _MD_ID_BUILDER.GIATRI = SO_MA; OracleCommand commandInsert = new OracleCommand(); commandInsert.Connection = connection; string queryInsertItem = "INSERT INTO CAPMA(ID,LOAIMA,NHOMMA,GIATRI,\"UNITCODE\") VALUES ('" + _MD_ID_BUILDER.ID + "','" + _MD_ID_BUILDER.LOAIMA + "','" + _MD_ID_BUILDER.NHOMMA + "','" + _MD_ID_BUILDER.GIATRI + "','" + _MD_ID_BUILDER.UNITCODE + "')"; commandInsert.CommandText = queryInsertItem; commandInsert.CommandType = CommandType.Text; commandInsert.ExecuteNonQuery(); } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU ORACLE", 1, "0x1", "0x8", "normal"); } } return(RESULT); }
public static List <KHACHHANG_DTO> TIMKIEM_KHACHHANG_FROM_ORACLE(string P_KEYSEARCH, int P_USE_TIMKIEM_ALL, int P_DIEUKIEN_TIMKIEM, string UNITCODE) { List <KHACHHANG_DTO> _LST_KHACHHANG_DTO = new List <KHACHHANG_DTO>(); try { using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString)) { try { connection.Open(); if (connection.State == ConnectionState.Open) { OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; cmd.InitialLONGFetchSize = 1000; cmd.CommandText = "TIMKIEM_KHACHHANG"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("P_KEYSEARCH", OracleDbType.Varchar2).Value = P_KEYSEARCH; cmd.Parameters.Add("P_UNITCODE", OracleDbType.Varchar2).Value = UNITCODE; cmd.Parameters.Add("P_USE_TIMKIEM_ALL", OracleDbType.Int32).Value = P_USE_TIMKIEM_ALL; cmd.Parameters.Add("P_DIEUKIEN_TIMKIEM", OracleDbType.Int32).Value = P_DIEUKIEN_TIMKIEM; cmd.Parameters.Add("CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO(); _KHACHHANG_DTO.MAKH = dataReader["MAKH"] != null ? dataReader["MAKH"].ToString().Trim() : ""; _KHACHHANG_DTO.TENKH = dataReader["TENKH"] != null ? dataReader["TENKH"].ToString().Trim() : ""; _KHACHHANG_DTO.DIACHI = dataReader["DIACHI"] != null ? dataReader["DIACHI"].ToString().Trim() : ""; _KHACHHANG_DTO.DIENTHOAI = dataReader["DIENTHOAI"] != null ? dataReader["DIENTHOAI"].ToString().Trim() : ""; _KHACHHANG_DTO.CMTND = dataReader["CMTND"] != null ? dataReader["CMTND"].ToString().Trim() : ""; _KHACHHANG_DTO.EMAIL = dataReader["EMAIL"] != null ? dataReader["EMAIL"].ToString().Trim() : ""; _KHACHHANG_DTO.HANGKHACHHANG = dataReader["HANGKHACHHANG"] != null ? dataReader["HANGKHACHHANG"].ToString().Trim() : ""; _KHACHHANG_DTO.HANGKHACHHANGCU = dataReader["HANGKHACHHANGCU"] != null ? dataReader["HANGKHACHHANGCU"].ToString().Trim() : ""; decimal SODIEM = 0; if (dataReader["SODIEM"] != null) { decimal.TryParse(dataReader["SODIEM"].ToString(), out SODIEM); } decimal TONGTIEN = 0; if (dataReader["TONGTIEN"] != null) { decimal.TryParse(dataReader["TONGTIEN"].ToString(), out TONGTIEN); } _KHACHHANG_DTO.SODIEM = SODIEM; _KHACHHANG_DTO.TONGTIEN = TONGTIEN; if (dataReader["NGAYCAPTHE"] != null) { DateTime?NGAYCAPTHE = string.IsNullOrEmpty(dataReader["NGAYCAPTHE"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["NGAYCAPTHE"].ToString()); _KHACHHANG_DTO.NGAYCAPTHE = NGAYCAPTHE; } if (dataReader["NGAYHETHAN"] != null) { DateTime?NGAYHETHAN = string.IsNullOrEmpty(dataReader["NGAYHETHAN"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["NGAYHETHAN"].ToString()); _KHACHHANG_DTO.NGAYHETHAN = NGAYHETHAN; } if (dataReader["NGAYSINH"] != null) { DateTime?NGAYSINH = string.IsNullOrEmpty(dataReader["NGAYSINH"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["NGAYSINH"].ToString()); _KHACHHANG_DTO.NGAYSINH = NGAYSINH; } _KHACHHANG_DTO.UNITCODE = dataReader["UNITCODE"] != null ? dataReader["UNITCODE"].ToString().Trim() : ""; _LST_KHACHHANG_DTO.Add(_KHACHHANG_DTO); } } } } catch { NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal"); } finally { connection.Close(); connection.Dispose(); } } } catch (Exception ex) { WriteLogs.LogError(ex); NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal"); } return(_LST_KHACHHANG_DTO); }
public static HANGKHACHHANG_DTO LAY_QUYDOI_THEOHANGKH_FROM_SQLSERVER(string MAHANGKHACHHANG) { HANGKHACHHANG_DTO RESULT = new HANGKHACHHANG_DTO(); try { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString)) { try { connection.Open(); if (connection.State == ConnectionState.Open) { SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = "SELECT MAHANGKH,TENHANGKH,SOTIEN,TYLEGIAMGIASN,TYLEGIAMGIA,QUYDOITIEN_THANH_DIEM,QUYDOIDIEM_THANH_TIEN FROM dbo.DM_HANGKHACHHANG WHERE TRANGTHAI = 10 AND MAHANGKH = '" + MAHANGKHACHHANG + "' AND UNITCODE = '" + Session.Session.CurrentUnitCode + "'"; cmd.CommandType = CommandType.Text; SqlDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { decimal SOTIEN = 0; decimal TYLEGIAMGIASN = 0; decimal TYLEGIAMGIA = 0; decimal QUYDOITIEN_THANH_DIEM = 0; decimal QUYDOIDIEM_THANH_TIEN = 0; RESULT.MAHANGKH = dataReader["MAHANGKH"] != null ? dataReader["MAHANGKH"].ToString() : ""; RESULT.TENHANGKH = dataReader["TENHANGKH"] != null ? dataReader["TENHANGKH"].ToString() : ""; decimal.TryParse(dataReader["SOTIEN"] != null ? dataReader["SOTIEN"].ToString() : "", out SOTIEN); decimal.TryParse(dataReader["TYLEGIAMGIASN"] != null ? dataReader["TYLEGIAMGIASN"].ToString() : "", out TYLEGIAMGIASN); decimal.TryParse(dataReader["TYLEGIAMGIA"] != null ? dataReader["TYLEGIAMGIA"].ToString() : "", out TYLEGIAMGIA); decimal.TryParse(dataReader["QUYDOITIEN_THANH_DIEM"] != null ? dataReader["QUYDOITIEN_THANH_DIEM"].ToString() : "", out QUYDOITIEN_THANH_DIEM); decimal.TryParse(dataReader["QUYDOIDIEM_THANH_TIEN"] != null ? dataReader["QUYDOIDIEM_THANH_TIEN"].ToString() : "", out QUYDOIDIEM_THANH_TIEN); RESULT.SOTIEN = SOTIEN; RESULT.TYLEGIAMGIASN = TYLEGIAMGIASN; RESULT.TYLEGIAMGIA = TYLEGIAMGIA; RESULT.QUYDOITIEN_THANH_DIEM = QUYDOITIEN_THANH_DIEM; RESULT.QUYDOIDIEM_THANH_TIEN = QUYDOIDIEM_THANH_TIEN; } } } } catch { NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN HẠNG KHÁCH HÀNG", 1, "0x1", "0x8", "normal"); } finally { connection.Close(); connection.Dispose(); } } } catch (Exception ex) { WriteLogs.LogError(ex); NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal"); } return(RESULT); }
public FrmTimKiemGiaoDich(string KeySearch, DateTime TuNgay, DateTime DenNgay, int DieuKienLoc) { InitializeComponent(); //khởi tạo giá trị chọn lựa điều kiện tìm kiếm BindingList <TIMKIEM_DTO> _comboItems = new BindingList <TIMKIEM_DTO>(); _comboItems.Add(new TIMKIEM_DTO { VALUE = 0, TEXT = "Mã giao dịch" }); _comboItems.Add(new TIMKIEM_DTO { VALUE = 1, TEXT = "Số tiền" }); _comboItems.Add(new TIMKIEM_DTO { VALUE = 2, TEXT = "Thu ngân tạo" }); cboDieuKienTimKiem.DataSource = _comboItems; cboDieuKienTimKiem.DisplayMember = "TEXT"; cboDieuKienTimKiem.ValueMember = "VALUE"; //default combobox cboDieuKienTimKiem.SelectedIndex = DieuKienLoc; dateTimeDenNgay.Format = DateTimePickerFormat.Custom; dateTimeDenNgay.CustomFormat = "dd/MM/yyyy"; this.dateTimeDenNgay.Value = DenNgay; dateTimeTuNgay.Format = DateTimePickerFormat.Custom; dateTimeTuNgay.CustomFormat = "dd/MM/yyyy"; this.dateTimeTuNgay.Value = TuNgay; txtDieuKienTimKiem.Text = KeySearch.Trim(); try { using ( var connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString)) { connection.OpenAsync(); OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; cmd.InitialLONGFetchSize = 1000; cmd.CommandText = "TIMKIEM_GIAODICHQUAY"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("P_KEYSEARCH", OracleDbType.Varchar2).Value = KeySearch; cmd.Parameters.Add("P_TUNGAY", OracleDbType.Date).Value = TuNgay; cmd.Parameters.Add("P_DENNGAY", OracleDbType.Date).Value = DenNgay; cmd.Parameters.Add("P_DIEUKIENLOC", OracleDbType.Int32).Value = DieuKienLoc; cmd.Parameters.Add("P_UNITCODE", OracleDbType.Varchar2).Value = Session.Session.CurrentUnitCode; cmd.Parameters.Add("CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader dataReader = null; dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { dgvDanhSachGiaoDichChiTiet.Rows.Clear(); dgvDanhSachGiaoDichChiTiet.DataSource = null; dgvDanhSachGiaoDichChiTiet.Refresh(); while (dataReader.Read()) { int LOAIGIAODICH = 0; int idx = dgvDanhSachGiaoDichChiTiet.Rows.Add(); DataGridViewRow rowData = dgvDanhSachGiaoDichChiTiet.Rows[idx]; rowData.Cells["MAGIAODICH"].Value = dataReader["MAGIAODICH"]; int.TryParse(dataReader["LOAIGIAODICH"].ToString(), out LOAIGIAODICH); rowData.Cells["LOAIGIAODICH"].Value = LOAIGIAODICH == 1 ? "XBLE" : "TRL"; rowData.Cells["NGAYPHATSINH"].Value = dataReader["NGAYPHATSINH"]; rowData.Cells["MANGUOITAO"].Value = dataReader["MANGUOITAO"]; rowData.Cells["NGUOITAO"].Value = dataReader["NGUOITAO"]; rowData.Cells["MAQUAYBAN"].Value = dataReader["MAQUAYBAN"]; rowData.Cells["HINHTHUCTHANHTOAN"].Value = dataReader["HINHTHUCTHANHTOAN"]; rowData.Cells["TIENKHACHDUA"].Value = FormatCurrency.FormatMoney(dataReader["TIENKHACHDUA"]); rowData.Cells["TIENTRALAI"].Value = FormatCurrency.FormatMoney(dataReader["TIENTRALAI"]); rowData.Cells["TTIENCOVAT"].Value = FormatCurrency.FormatMoney(dataReader["TTIENCOVAT"]); rowData.Cells["THOIGIAN"].Value = FormatCurrency.FormatMoney(dataReader["THOIGIAN"]); } } } } catch (Exception ex) { WriteLogs.LogError(ex); NotificationLauncher.ShowNotification("Thông báo", "Không tìm thấy", 1, "0x1", "0x8", "normal"); } }
public static List <NVGDQUAY_ASYNCCLIENT_DTO> TIMKIEM_GIAODICHQUAY(string KeySearch, DateTime TuNgay, DateTime DenNgay, int DieuKienLoc) { List <NVGDQUAY_ASYNCCLIENT_DTO> listReturn = new List <NVGDQUAY_ASYNCCLIENT_DTO>(); try { using (var connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString)) { connection.OpenAsync(); OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; cmd.InitialLONGFetchSize = 1000; cmd.CommandText = "TIMKIEM_GIAODICHQUAY"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("P_KEYSEARCH", OracleDbType.Varchar2).Value = KeySearch; cmd.Parameters.Add("P_TUNGAY", OracleDbType.Date).Value = TuNgay; cmd.Parameters.Add("P_DENNGAY", OracleDbType.Date).Value = DenNgay; cmd.Parameters.Add("P_DIEUKIENLOC", OracleDbType.Int32).Value = DieuKienLoc; cmd.Parameters.Add("P_UNITCODE", OracleDbType.Varchar2).Value = Session.Session.CurrentUnitCode; cmd.Parameters.Add("CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader dataReader = null; dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { NVGDQUAY_ASYNCCLIENT_DTO GDQUAY_DTO = new NVGDQUAY_ASYNCCLIENT_DTO(); int LoaiGD = 0; decimal TIENKHACHDUA, TIENVOUCHER, TIENTHEVIP, TIENTRALAI, TIENTHE, TIENCOD, TIENMAT, TTIENCOVAT = 0; int.TryParse(dataReader["LOAIGIAODICH"].ToString(), out LoaiGD); GDQUAY_DTO.MAGIAODICH = dataReader["MAGIAODICH"].ToString(); GDQUAY_DTO.MAGIAODICHQUAYPK = dataReader["MAGIAODICHQUAYPK"].ToString(); GDQUAY_DTO.LOAIGIAODICH = LoaiGD; GDQUAY_DTO.NGAYTAO = DateTime.Parse(dataReader["NGAYTAO"].ToString()); GDQUAY_DTO.MANGUOITAO = dataReader["MANGUOITAO"].ToString(); GDQUAY_DTO.NGUOITAO = dataReader["NGUOITAO"].ToString(); GDQUAY_DTO.MAQUAYBAN = dataReader["MAQUAYBAN"].ToString(); GDQUAY_DTO.NGAYPHATSINH = DateTime.Parse(dataReader["NGAYPHATSINH"].ToString()); GDQUAY_DTO.HINHTHUCTHANHTOAN = dataReader["HINHTHUCTHANHTOAN"].ToString(); GDQUAY_DTO.MAVOUCHER = dataReader["MAVOUCHER"].ToString(); decimal.TryParse(dataReader["TIENKHACHDUA"].ToString(), out TIENKHACHDUA); GDQUAY_DTO.TIENKHACHDUA = TIENKHACHDUA; decimal.TryParse(dataReader["TIENVOUCHER"].ToString(), out TIENVOUCHER); GDQUAY_DTO.TIENVOUCHER = TIENVOUCHER; decimal.TryParse(dataReader["TIENTHEVIP"].ToString(), out TIENTHEVIP); GDQUAY_DTO.TIENTHEVIP = TIENTHEVIP; decimal.TryParse(dataReader["TIENTRALAI"].ToString(), out TIENTRALAI); GDQUAY_DTO.TIENTRALAI = TIENTRALAI; decimal.TryParse(dataReader["TIENTHE"].ToString(), out TIENTHE); GDQUAY_DTO.TIENTHE = TIENTHE; decimal.TryParse(dataReader["TIENCOD"].ToString(), out TIENCOD); GDQUAY_DTO.TIENCOD = TIENCOD; decimal.TryParse(dataReader["TIENMAT"].ToString(), out TIENMAT); GDQUAY_DTO.TIENMAT = TIENMAT; decimal.TryParse(dataReader["TTIENCOVAT"].ToString(), out TTIENCOVAT); GDQUAY_DTO.TTIENCOVAT = TTIENCOVAT; GDQUAY_DTO.THOIGIAN = dataReader["THOIGIAN"].ToString(); GDQUAY_DTO.MAKHACHHANG = dataReader["MAKHACHHANG"].ToString(); GDQUAY_DTO.UNITCODE = dataReader["UNITCODE"].ToString(); listReturn.Add(GDQUAY_DTO); } } } } catch (Exception ex) { WriteLogs.LogError(ex); NotificationLauncher.ShowNotification("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal"); } return(listReturn); }
private void INSERT_DATA_HANG_GIAODICHQUAY_SQL(GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_DTO, ref int countCheckInsertSuccess) { if (_NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS.Count > 0) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { int i = 1; foreach (GIAODICH_CHITIET ITEM in _NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS) { SqlCommand command = new SqlCommand(); command.Connection = connection; string queryInsertItem = string.Format(@"INSERT INTO GIAODICH_CHITIET (ID,MA_GIAODICH,MAHANG,MATHUE_RA,SOLUONG,GIABANLE_VAT,MA_KHUYENMAI,TYLE_KHUYENMAI, TIEN_KHUYENMAI,TYLE_CHIETKHAU,TIEN_CHIETKHAU,TIENTHE_VIP,TIEN_VOUCHER,THANHTIEN,SAPXEP) VALUES (@ID,@MA_GIAODICH,@MAHANG,@MATHUE_RA,@SOLUONG,@GIABANLE_VAT, @MA_KHUYENMAI,@TYLE_KHUYENMAI,@TIEN_KHUYENMAI,@TYLE_CHIETKHAU,@TIEN_CHIETKHAU,@TIENTHE_VIP,@TIEN_VOUCHER,@THANHTIEN,@SAPXEP)"); command.CommandText = queryInsertItem; command.CommandType = CommandType.Text; command.Parameters.Add("ID", SqlDbType.NVarChar, 50).Value = ITEM.ID; command.Parameters.Add("MA_GIAODICH", SqlDbType.VarChar, 70).Value = ITEM.MA_GIAODICH; command.Parameters.Add("MAHANG", SqlDbType.VarChar, 50).Value = ITEM.MAHANG; command.Parameters.Add("MATHUE_RA", SqlDbType.VarChar, 50).Value = ITEM.MATHUE_RA; command.Parameters.Add("SOLUONG", SqlDbType.Decimal).Value = ITEM.SOLUONG; command.Parameters.Add("GIABANLE_VAT", SqlDbType.Decimal).Value = ITEM.GIABANLE_VAT; command.Parameters.Add("MA_KHUYENMAI", SqlDbType.NVarChar, 50).Value = ITEM.MA_KHUYENMAI; command.Parameters.Add("TYLE_KHUYENMAI", SqlDbType.Decimal).Value = ITEM.TYLE_KHUYENMAI; command.Parameters.Add("TIEN_KHUYENMAI", SqlDbType.Decimal).Value = ITEM.TIEN_KHUYENMAI; command.Parameters.Add("TYLE_CHIETKHAU", SqlDbType.Decimal).Value = ITEM.TYLE_CHIETKHAU; command.Parameters.Add("TIEN_CHIETKHAU", SqlDbType.Decimal).Value = ITEM.TIEN_CHIETKHAU; command.Parameters.Add("TIENTHE_VIP", SqlDbType.Decimal).Value = ITEM.TIENTHE_VIP; command.Parameters.Add("TIEN_VOUCHER", SqlDbType.Decimal).Value = ITEM.TIEN_VOUCHER; command.Parameters.Add("THANHTIEN", SqlDbType.Decimal).Value = ITEM.THANHTIEN; command.Parameters.Add("SAPXEP", SqlDbType.Int).Value = i; try { if (command.ExecuteNonQuery() > 0) { countCheckInsertSuccess++; i++; } } catch (Exception e) { WriteLogs.LogError(e); } } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("Thông báo", "Không có kết nối với cơ sở dữ liệu", 1, "0x1", "0x8", "normal"); } } } }
private void INSERT_DATA_HANG_GIAODICHQUAY(GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_DTO, ref int countCheckInsertSuccess) { if (_NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS.Count > 0) { using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { int i = 1; foreach (GIAODICH_CHITIET ITEM in _NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS) { OracleCommand command = new OracleCommand(); command.Connection = connection; string queryInsertItem = string.Format(@"INSERT INTO GIAODICH_CHITIET (ID,MA_GIAODICH,MAHANG,MATHUE_RA,SOLUONG,GIABANLE_VAT,MA_KHUYENMAI,TYLE_KHUYENMAI, TIEN_KHUYENMAI,TYLE_CHIETKHAU,TIEN_CHIETKHAU,TIENTHE_VIP,TIEN_VOUCHER,THANHTIEN,SAPXEP) VALUES (:ID,:MA_GIAODICH,:MAHANG,:MATHUE_RA,:SOLUONG,:GIABANLE_VAT, :MA_KHUYENMAI,:TYLE_KHUYENMAI,:TIEN_KHUYENMAI,:TYLE_CHIETKHAU,:TIEN_CHIETKHAU,:TIENTHE_VIP,:TIEN_VOUCHER,:THANHTIEN,:SAPXEP)"); command.CommandText = queryInsertItem; command.CommandType = CommandType.Text; command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = ITEM.ID; command.Parameters.Add("MA_GIAODICH", OracleDbType.NVarchar2, 70).Value = ITEM.MA_GIAODICH; command.Parameters.Add("MAHANG", OracleDbType.NVarchar2, 50).Value = ITEM.MAHANG; command.Parameters.Add("MATHUE_RA", OracleDbType.NVarchar2, 50).Value = ITEM.MATHUE_RA; command.Parameters.Add("SOLUONG", OracleDbType.Decimal).Value = ITEM.SOLUONG; command.Parameters.Add("GIABANLE_VAT", OracleDbType.Decimal).Value = ITEM.GIABANLE_VAT; command.Parameters.Add("MA_KHUYENMAI", OracleDbType.NVarchar2, 50).Value = ITEM.MA_KHUYENMAI; command.Parameters.Add("TYLE_KHUYENMAI", OracleDbType.Decimal).Value = ITEM.TYLE_KHUYENMAI; command.Parameters.Add("TIEN_KHUYENMAI", OracleDbType.Decimal).Value = ITEM.TIEN_KHUYENMAI; command.Parameters.Add("TYLE_CHIETKHAU", OracleDbType.Decimal).Value = ITEM.TYLE_CHIETKHAU; command.Parameters.Add("TIEN_CHIETKHAU", OracleDbType.Decimal).Value = ITEM.TIEN_CHIETKHAU; command.Parameters.Add("TIENTHE_VIP", OracleDbType.Decimal).Value = ITEM.TIENTHE_VIP; command.Parameters.Add("TIEN_VOUCHER", OracleDbType.Decimal).Value = ITEM.TIEN_VOUCHER; command.Parameters.Add("THANHTIEN", OracleDbType.Decimal).Value = ITEM.THANHTIEN; command.Parameters.Add("SAPXEP", OracleDbType.Int32).Value = i; try { if (command.ExecuteNonQuery() > 0) { countCheckInsertSuccess++; i++; } } catch (Exception e) { WriteLogs.LogError(e); } } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU ORACLE", 1, "0x1", "0x8", "normal"); } } } }
public static HANGKHACHHANG_DTO LAY_QUYDOI_THEOHANGKH_FROM_ORACLE(string MAHANGKHACHHANG) { HANGKHACHHANG_DTO RESULT = new HANGKHACHHANG_DTO(); try { using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { try { connection.Open(); if (connection.State == ConnectionState.Open) { OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; cmd.CommandText = string.Format(@"SELECT MAHANG, TENHANG, SOTIEN_LENHANG, TYLE_SINHNHAT, TYLE_DACBIET, QUYDOITIEN_THANH_DIEM, QUYDOIDIEM_THANH_TIEN FROM HANGKHACHHANG WHERE TRANGTHAI = 10 AND MAHANG = '" + MAHANGKHACHHANG + "' AND UNITCODE = '" + Session.Session.CurrentUnitCode + "'"); cmd.CommandType = CommandType.Text; OracleDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { decimal SOTIEN_LENHANG = 0; decimal TYLE_SINHNHAT = 0; decimal TYLE_DACBIET = 0; decimal QUYDOITIEN_THANH_DIEM = 0; decimal QUYDOIDIEM_THANH_TIEN = 0; RESULT.MAHANG = dataReader["MAHANG"] != null ? dataReader["MAHANG"].ToString() : ""; RESULT.TENHANG = dataReader["TENHANG"] != null ? dataReader["TENHANG"].ToString() : ""; decimal.TryParse(dataReader["SOTIEN_LENHANG"] != null ? dataReader["SOTIEN_LENHANG"].ToString() : "", out SOTIEN_LENHANG); decimal.TryParse(dataReader["TYLE_SINHNHAT"] != null ? dataReader["TYLE_SINHNHAT"].ToString() : "", out TYLE_SINHNHAT); decimal.TryParse(dataReader["TYLE_DACBIET"] != null ? dataReader["TYLE_DACBIET"].ToString() : "", out TYLE_DACBIET); decimal.TryParse(dataReader["QUYDOITIEN_THANH_DIEM"] != null ? dataReader["QUYDOITIEN_THANH_DIEM"].ToString() : "", out QUYDOITIEN_THANH_DIEM); decimal.TryParse(dataReader["QUYDOIDIEM_THANH_TIEN"] != null ? dataReader["QUYDOIDIEM_THANH_TIEN"].ToString() : "", out QUYDOIDIEM_THANH_TIEN); RESULT.SOTIEN_LENHANG = SOTIEN_LENHANG; RESULT.TYLE_SINHNHAT = TYLE_SINHNHAT; RESULT.TYLE_DACBIET = TYLE_DACBIET; RESULT.QUYDOITIEN_THANH_DIEM = QUYDOITIEN_THANH_DIEM; RESULT.QUYDOIDIEM_THANH_TIEN = QUYDOIDIEM_THANH_TIEN; } } } } catch { NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN HẠNG KHÁCH HÀNG", 1, "0x1", "0x8", "normal"); } finally { connection.Close(); connection.Dispose(); } } } catch (Exception ex) { WriteLogs.LogError(ex); NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal"); } return(RESULT); }