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