private void txtThanhToan_TienMat_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode != Keys.Enter)
{
if (!txtThanhToan_TienMat.Text.Equals(txtThanhToan_TienThanhToan.Text))
{
decimal THANHTOAN_TIENTHE = 0;
string THANHTOAN_TIENMAT_STRING = txtThanhToan_TienMat.Text;
int start = txtThanhToan_TienMat.Text.Length - txtThanhToan_TienMat.SelectionStart;
THANHTOAN_TIENMAT_STRING = THANHTOAN_TIENMAT_STRING.Replace(",", "");
decimal THANHTOAN_TIENMAT = 0;
decimal.TryParse(THANHTOAN_TIENMAT_STRING, out THANHTOAN_TIENMAT);
TONGTIEN_KHACHTRA = THANHTOAN_TIENMAT;
decimal THANHTOAN_TONGTIEN = 0;
decimal.TryParse(txtThanhToan_TienThanhToan.Text.Trim().Replace(",", ""), out THANHTOAN_TONGTIEN);
_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.THANHTIEN = THANHTOAN_TIENMAT;
_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.TIENKHACH_TRA = THANHTOAN_TIENMAT;
decimal THANHTOAN_TIENTRALAI = THANHTOAN_TIENTHE + THANHTOAN_TIENMAT - THANHTOAN_TONGTIEN;
txtThanhToan_TienMat.Text = FormatCurrency.FormatMoney(THANHTOAN_TIENMAT_STRING);
txtThanhToan_TienMat.SelectionStart = -start + txtThanhToan_TienMat.Text.Length;
if (THANHTOAN_TIENTRALAI > 0)
{
txtThanhToan_TienTraLai.Text = FormatCurrency.FormatMoney(THANHTOAN_TIENTRALAI);
txtThanhToan_TraLai_BangChu.Text = ConvertSoThanhChu.ChuyenDoiSoThanhChu(THANHTOAN_TIENTRALAI);
}
else
{
txtThanhToan_TienTraLai.Text = "-" + FormatCurrency.FormatMoney(THANHTOAN_TIENTRALAI);
}
_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.TIEN_TRALAI_KHACH = THANHTOAN_TIENTRALAI;
}
else
{
return;
}
}
else
{
decimal tienThanhToan = 0;
decimal.TryParse(txtThanhToan_TienTraLai.Text, out tienThanhToan);
if (tienThanhToan >= 0)
{
THANHTOAN_HOADON_BANLE_TRALAI();
}
else
{
NotificationLauncher.ShowNotificationError("THÔNG BÁO", "SỐ TIỀN SAI !", 1, "0x1", "0x8", "normal");
}
}
}
private void btnThanhToan_Save_Click(object sender, EventArgs e)
{
decimal tienThanhToan = 0;
decimal.TryParse(txtThanhToan_TienTraLai.Text.ToString(), out tienThanhToan);
if (tienThanhToan >= 0)
{
THANHTOAN_HOADON_BANLE_TRALAI();
}
else
{
NotificationLauncher.ShowNotificationError("Thông báo", "Sai tiền !", 1, "0x1", "0x8", "normal");
}
}
/// <summary>
/// fill data to bill
/// </summary>
/// <param name="objBillDto"></param>
/// <param name="data"></param>
/// GIAO DỊCH BÁN LẺ
public void PrintInvoice_BanLeInLai(BILL_DTO objBillDto, NVGDQUAY_ASYNCCLIENT_DTO _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL)
{
done = true;
try
{
ReportInLaiBill reportInLai = new ReportInLaiBill();
foreach (Parameter p in reportInLai.Parameters)
{
p.Visible = false;
}
reportInLai.InitDataInLaiBillBanLe(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL, objBillDto);
dcmvContent.DocumentSource = reportInLai;
reportInLai.CreateDocument();
reportInLai.Print();
}
catch
{
NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG TÌM THẤY MÁY IN", 1, "0x1", "0x8", "normal");
}
}
private void FrmThanhToan_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
this.Close();
_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL = new NVGDQUAY_ASYNCCLIENT_DTO();
_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL = new NVGDQUAY_ASYNCCLIENT_DTO();
}
if (e.KeyCode == Keys.Enter)
{
decimal tienThanhToan = 0;
decimal.TryParse(txtThanhToan_TienTraLai.Text, out tienThanhToan);
if (tienThanhToan >= 0)
{
THANHTOAN_HOADON_BANLE_TRALAI();
}
else
{
NotificationLauncher.ShowNotificationError("Thông báo", "Sai tiền !", 1, "0x1", "0x8", "normal");
}
}
}
public string SAVE_MAKHACHHANG_TO_ORACLE()
{
string RESULT = "";
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
int CURRENT = 0;
OracleCommand command = new OracleCommand();
command.Connection = connection;
string querySelectItem = "SELECT \"TYPE\",CODE,\"CURRENT\" FROM MD_ID_BUILDER WHERE CODE = 'KH'";
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.TYPE = "KH";
_MD_ID_BUILDER.CODE = "KH";
_MD_ID_BUILDER.CURRENT = "0000";
_MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode;
int CURRENT_NUMBER = 0;
int.TryParse(dataReaderBuildCode["CURRENT"].ToString(), out CURRENT_NUMBER);
string SO_MA = GENERATE_NUMBER(CURRENT_NUMBER.ToString());
_MD_ID_BUILDER.CURRENT = SO_MA;
OracleCommand commandUpdate = new OracleCommand();
commandUpdate.Connection = connection;
string queryUpdateItem = "UPDATE MD_ID_BUILDER SET \"CURRENT\" = '" + _MD_ID_BUILDER.CURRENT + "' WHERE \"TYPE\" = '" + _MD_ID_BUILDER.TYPE + "' AND \"CODE\" = '" + _MD_ID_BUILDER.CODE + "' ";
commandUpdate.CommandText = queryUpdateItem;
commandUpdate.CommandType = CommandType.Text;
commandUpdate.ExecuteNonQuery();
RESULT = string.Format("{0}{1}", _MD_ID_BUILDER.CODE, SO_MA);
}
}
else
{
MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER();
_MD_ID_BUILDER.ID = Guid.NewGuid().ToString();
_MD_ID_BUILDER.TYPE = "KH";
_MD_ID_BUILDER.CODE = "KH";
_MD_ID_BUILDER.CURRENT = "0000";
_MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode;
string SO_MA = GENERATE_NUMBER(_MD_ID_BUILDER.CURRENT);
_MD_ID_BUILDER.CURRENT = SO_MA;
OracleCommand commandInsert = new OracleCommand();
commandInsert.Connection = connection;
string queryInsertItem = "INSERT INTO MD_ID_BUILDER(ID,\"TYPE\",CODE,\"CURRENT\",\"UNITCODE\",NGAYTAO) VALUES ('" + _MD_ID_BUILDER.ID + "','" + _MD_ID_BUILDER.TYPE + "','" + _MD_ID_BUILDER.TYPE + "','" + _MD_ID_BUILDER.CURRENT + "','" + _MD_ID_BUILDER.UNITCODE + "','" + DateTime.Now + "')";
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);
}
private void btnCreateConnectSql_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtDatabaseNameSql.Text) || string.IsNullOrEmpty(txtPasswordSql.Text) ||
string.IsNullOrEmpty(txtUsernameSql.Text))
{
NotificationLauncher.ShowNotificationWarning("Lỗi nhập", "Yêu cầu nhập đầy đủ thông tin !", 1,
"0x1", "0x8", "normal");
}
else
{
//Constructing connection string from the inputs
StringBuilder connetStringSql = new StringBuilder("Data Source=");
connetStringSql.Append(txtHostnameSql.Text.Trim());
connetStringSql.Append(";Initial Catalog=");
connetStringSql.Append(txtDatabaseNameSql.Text.Trim());
connetStringSql.Append(";Integrated Security=True;User ID=");
connetStringSql.Append(txtUsernameSql.Text.Trim());
connetStringSql.Append(";Password="******";MultipleActiveResultSets=true");
string strCon = connetStringSql.ToString();
UpdateConfigFile_ERBusCashier(strCon);
SqlConnection connection = new SqlConnection();
try
{
//test connect
ConfigurationManager.RefreshSection("connectionStrings");
connection.ConnectionString = ConfigurationManager.ConnectionStrings["ERBusCashier"].ToString();
connection.Open();
if (connection.State == ConnectionState.Open)
{
//khởi tạo cấu trúc db
string SqlCreateDbQuery = string.Format("SELECT DATABASE_ID FROM SYS.DATABASES WHERE NAME = '{0}'", "ERBUS_CASHIER");;
using (SqlCommand sqlCmd = new SqlCommand(SqlCreateDbQuery, connection))
{
object resultObj = sqlCmd.ExecuteScalar();
if (resultObj == null)
{
//câu lệnh create DB
SqlCommand cmdCreateDb = new SqlCommand();
cmdCreateDb.Connection = connection;
cmdCreateDb.CommandText = string.Format(@"CREATE DATABASE ERBUS_CASHIER");
int i = cmdCreateDb.ExecuteNonQuery();
if (i > 0)
{
}
}
else
{
if (!ConnectDatabaseService.CheckTableExistInDatabase("AU_DONVI"))
{
}
}
}
NotificationLauncher.ShowNotification("Thông báo", "Kết nối thành công với cơ sở dữ liệu SQL", 1,
"0x1", "0x8", "normal");
this.Close();
this.Dispose();
}
else
{
NotificationLauncher.ShowNotificationError("Thông báo", "Lỗi không kết nối được với cơ sở dữ liệu SQL", 1,
"0x1", "0x8", "normal");
}
}
catch
{
NotificationLauncher.ShowNotificationError("Thông báo", "Không có khả năng kết nối tới HostName ! Kiểm tra thông tin kết nối", 1,
"0x1", "0x8", "normal");
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
private void INSERT_DATA_HANG_GIAODICHQUAY_SQL(NVGDQUAY_ASYNCCLIENT_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
{
foreach (NVHANGGDQUAY_ASYNCCLIENT ITEM in _NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS)
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
string queryInsertItem = string.Format(@"INSERT INTO [dbo].[NVHANGGDQUAY_ASYNCCLIENT]([ID],[MAGDQUAYPK],[MAKHOHANG],[MADONVI],[MAVATTU],[MANGUOITAO],[NGUOITAO],[MABOPK],[NGAYTAO],[NGAYPHATSINH],[SOLUONG],[TTIENCOVAT],[GIABANLECOVAT],[TYLECHIETKHAU],[TIENCHIETKHAU],[TYLEKHUYENMAI],[TIENKHUYENMAI],[TYLEVOUCHER],[TIENVOUCHER],[TYLELAILE],[GIAVON],[MAVAT],[VATBAN],[MACHUONGTRINHKM],[UNITCODE])
VALUES (@ID,@MAGDQUAYPK,@MAKHOHANG,@MADONVI,@MAVATTU,@MANGUOITAO,@NGUOITAO,@MABOPK,@NGAYTAO,@NGAYPHATSINH,@SOLUONG,@TTIENCOVAT,@GIABANLECOVAT,@TYLECHIETKHAU,@TIENCHIETKHAU,@TYLEKHUYENMAI,@TIENKHUYENMAI,@TYLEVOUCHER,@TIENVOUCHER,@TYLELAILE,@GIAVON,@MAVAT,@VATBAN,@MACHUONGTRINHKM,@UNITCODE)");
command.CommandText = queryInsertItem;
command.CommandType = CommandType.Text;
command.Parameters.Add("ID", SqlDbType.NVarChar, 50).Value = ITEM.ID;
command.Parameters.Add("MAGDQUAYPK", SqlDbType.NVarChar, 50).Value = ITEM.MAGDQUAYPK;
command.Parameters.Add("MAKHOHANG", SqlDbType.NVarChar, 50).Value = ITEM.MAKHOHANG;
command.Parameters.Add("MADONVI", SqlDbType.NVarChar, 50).Value = ITEM.MADONVI;
command.Parameters.Add("MAVATTU", SqlDbType.NVarChar, 50).Value = ITEM.MAVATTU;
command.Parameters.Add("MANGUOITAO", SqlDbType.NVarChar, 50).Value = Session.Session.CurrentMaNhanVien;
command.Parameters.Add("NGUOITAO", SqlDbType.NVarChar, 50).Value = ITEM.NGUOITAO;
command.Parameters.Add("MABOPK", SqlDbType.NVarChar, 50).Value = ITEM.MABOPK;
command.Parameters.Add("NGAYTAO", SqlDbType.Date).Value = ITEM.NGAYTAO;
command.Parameters.Add("NGAYPHATSINH", SqlDbType.Date).Value = ITEM.NGAYPHATSINH;
command.Parameters.Add("SOLUONG", SqlDbType.Decimal).Value = ITEM.SOLUONG;
command.Parameters.Add("TTIENCOVAT", SqlDbType.Decimal).Value = ITEM.TTIENCOVAT;
command.Parameters.Add("GIABANLECOVAT", SqlDbType.Decimal).Value = ITEM.GIABANLECOVAT;
command.Parameters.Add("TIENCHIETKHAU", SqlDbType.Decimal).Value = ITEM.TIENCHIETKHAU;
command.Parameters.Add("TYLECHIETKHAU", SqlDbType.Decimal).Value = ITEM.TYLECHIETKHAU;
command.Parameters.Add("TYLEKHUYENMAI", SqlDbType.Decimal).Value = ITEM.TYLEKHUYENMAI;
command.Parameters.Add("TIENKHUYENMAI", SqlDbType.Decimal).Value = ITEM.TIENKHUYENMAI;
command.Parameters.Add("TYLEVOUCHER", SqlDbType.Decimal).Value = ITEM.TYLEVOUCHER;
command.Parameters.Add("TIENVOUCHER", SqlDbType.Decimal).Value = ITEM.TIENVOUCHER;
command.Parameters.Add("TYLELAILE", SqlDbType.Decimal).Value = ITEM.TYLELAILE;
command.Parameters.Add("GIAVON", SqlDbType.Decimal).Value = ITEM.GIAVON;
command.Parameters.Add("MAVAT", SqlDbType.NVarChar, 50).Value = ITEM.MAVAT;
command.Parameters.Add("VATBAN", SqlDbType.Decimal).Value = ITEM.VATBAN;
command.Parameters.Add("MACHUONGTRINHKM", SqlDbType.NVarChar, 50).Value = ITEM.MACHUONGTRINHKM;
command.Parameters.Add("UNITCODE", SqlDbType.NVarChar, 50).Value = ITEM.UNITCODE != null ? ITEM.UNITCODE : Session.Session.CurrentUnitCode;
try
{
if (command.ExecuteNonQuery() > 0)
{
countCheckInsertSuccess++;
}
}
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ế nối với cơ sở dữ liệu", 1, "0x1", "0x8", "normal");
}
}
}
}
private void INSERT_DATA_HANG_GIAODICHQUAY(NVGDQUAY_ASYNCCLIENT_DTO _NVGDQUAY_ASYNCCLIENT_DTO, ref int countCheckInsertSuccess)
{
if (_NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS.Count > 0)
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
foreach (NVHANGGDQUAY_ASYNCCLIENT ITEM in _NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
string queryInsertItem = string.Format(@"INSERT INTO NVHANGGDQUAY_ASYNCCLIENT (ID,MAGDQUAYPK,MAKHOHANG,MADONVI,MAVATTU,BARCODE,TENDAYDU,NGUOITAO,MABOPK,NGAYTAO,NGAYPHATSINH,
SOLUONG,TTIENCOVAT,VATBAN,GIABANLECOVAT,MAKHACHHANG,MAKEHANG,MACHUONGTRINHKM,LOAIKHUYENMAI,TIENCHIETKHAU,TYLECHIETKHAU,TYLEKHUYENMAI,TIENKHUYENMAI,TYLEVOUCHER,
TIENVOUCHER,TYLELAILE,GIAVON,ISBANAM,MAVAT) VALUES (:ID,:MAGDQUAYPK,:MAKHOHANG,:MADONVI,:MAVATTU,:BARCODE,:TENDAYDU,:NGUOITAO,:MABOPK,:NGAYTAO,:NGAYPHATSINH,
:SOLUONG,:TTIENCOVAT,:VATBAN,:GIABANLECOVAT,:MAKHACHHANG,:MAKEHANG,:MACHUONGTRINHKM,:LOAIKHUYENMAI,:TIENCHIETKHAU,:TYLECHIETKHAU,:TYLEKHUYENMAI,:TIENKHUYENMAI,:TYLEVOUCHER,
:TIENVOUCHER,:TYLELAILE,:GIAVON,:ISBANAM,:MAVAT)");
command.CommandText = queryInsertItem;
command.CommandType = CommandType.Text;
command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = ITEM.ID;
command.Parameters.Add("MAGDQUAYPK", OracleDbType.NVarchar2, 50).Value = ITEM.MAGDQUAYPK;
command.Parameters.Add("MAKHOHANG", OracleDbType.NVarchar2, 50).Value = ITEM.MAKHOHANG;
command.Parameters.Add("MADONVI", OracleDbType.NVarchar2, 50).Value = ITEM.MADONVI;
command.Parameters.Add("MAVATTU", OracleDbType.NVarchar2, 50).Value = ITEM.MAVATTU;
command.Parameters.Add("BARCODE", OracleDbType.NVarchar2, 2000).Value = ITEM.BARCODE;
command.Parameters.Add("TENDAYDU", OracleDbType.NVarchar2, 300).Value = ITEM.TENDAYDU;
command.Parameters.Add("NGUOITAO", OracleDbType.NVarchar2, 300).Value = ITEM.NGUOITAO;
command.Parameters.Add("MABOPK", OracleDbType.NVarchar2, 50).Value = ITEM.MABOPK;
command.Parameters.Add("NGAYTAO", OracleDbType.Date).Value = ITEM.NGAYTAO;
command.Parameters.Add("NGAYPHATSINH", OracleDbType.Date).Value = ITEM.NGAYPHATSINH;
command.Parameters.Add("SOLUONG", OracleDbType.Int32).Value = ITEM.SOLUONG;
command.Parameters.Add("TTIENCOVAT", OracleDbType.Decimal).Value = ITEM.TTIENCOVAT;
command.Parameters.Add("VATBAN", OracleDbType.Decimal).Value = ITEM.VATBAN;
command.Parameters.Add("GIABANLECOVAT", OracleDbType.Decimal).Value = ITEM.GIABANLECOVAT;
command.Parameters.Add("MAKHACHHANG", OracleDbType.NVarchar2, 50).Value = ITEM.MAKHACHHANG;
command.Parameters.Add("MAKEHANG", OracleDbType.NVarchar2, 50).Value = ITEM.MAKEHANG;
command.Parameters.Add("MACHUONGTRINHKM", OracleDbType.NVarchar2, 50).Value = ITEM.MACHUONGTRINHKM;
command.Parameters.Add("LOAIKHUYENMAI", OracleDbType.NVarchar2, 50).Value = ITEM.LOAIKHUYENMAI;
command.Parameters.Add("TIENCHIETKHAU", OracleDbType.Decimal).Value = ITEM.TIENCHIETKHAU;
command.Parameters.Add("TYLECHIETKHAU", OracleDbType.Decimal).Value = ITEM.TYLECHIETKHAU;
command.Parameters.Add("TYLEKHUYENMAI", OracleDbType.Decimal).Value = ITEM.TYLEKHUYENMAI;
command.Parameters.Add("TIENKHUYENMAI", OracleDbType.Decimal).Value = ITEM.TIENKHUYENMAI;
command.Parameters.Add("TYLEVOUCHER", OracleDbType.Decimal).Value = ITEM.TYLEVOUCHER;
command.Parameters.Add("TIENVOUCHER", OracleDbType.Decimal).Value = ITEM.TIENVOUCHER;
command.Parameters.Add("TYLELAILE", OracleDbType.Decimal).Value = ITEM.TYLELAILE;
command.Parameters.Add("GIAVON", OracleDbType.Decimal).Value = ITEM.GIAVON;
command.Parameters.Add("ISBANAM", OracleDbType.Decimal).Value = ITEM.ISBANAM;
command.Parameters.Add("MAVAT", OracleDbType.NVarchar2, 50).Value = ITEM.MAVAT;
try
{
if (command.ExecuteNonQuery() > 0)
{
countCheckInsertSuccess++;
}
}
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 int SAVE_DATA_KHACHHANG_TO_ORACLE()
{
int RESULT = 0;
//SAVE ORACLE
string MAKHACHHANG = SAVE_MAKHACHHANG_TO_ORACLE();
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO();
_KHACHHANG_DTO.MAKHACHHANG = txtMaKhachHang.Text;
_KHACHHANG_DTO.TENKHACHHANG = txtTenKhachHang.Text;
_KHACHHANG_DTO.DIACHI = txtDiaChi.Text;
_KHACHHANG_DTO.DIENTHOAI = txtDienThoai.Text;
_KHACHHANG_DTO.CANCUOC_CONGDAN = txtChungMinhThu.Text;
_KHACHHANG_DTO.NGAYSINH = dateNgaySinh.Value;
_KHACHHANG_DTO.NGAYDACBIET = dateNgayDacBiet.Value;
_KHACHHANG_DTO.MATHE = txtMaThe.Text;
_KHACHHANG_DTO.SODIEM = 0;
_KHACHHANG_DTO.TONGTIEN = 0;
_KHACHHANG_DTO.DIENGIAI = txtDienGiai.Text;
_KHACHHANG_DTO.TRANGTHAI = 10;
_KHACHHANG_DTO.I_CREATE_DATE = DateTime.Now;
_KHACHHANG_DTO.I_CREATE_BY = Session.Session.CurrentMaNhanVien;
_KHACHHANG_DTO.I_STATE = "X";
_KHACHHANG_DTO.UNITCODE = Session.Session.CurrentUnitCode;;
OracleCommand command = new OracleCommand();
command.Connection = connection;
string queryInsertItem = string.Format(@"INSERT INTO KHACHHANG (ID,MAKHACHHANG,TENKHACHHANG,DIACHI,DIENTHOAI,CANCUOC_CONGDAN,NGAYSINH,NGAYDACBIET,MATHE,SODIEM,TONGTIEN,DIENGIAI,TRANGTHAI,I_CREATE_DATE,I_CREATE_BY,I_STATE,UNITCODE) VALUES (:ID,:MAKHACHHANG,:TENKHACHHANG,:DIACHI,:DIENTHOAI,:CANCUOC_CONGDAN,:NGAYSINH,:NGAYDACBIET,:MATHE,:SODIEM,:TONGTIEN,:DIENGIAI,:TRANGTHAI,:I_CREATE_DATE,:I_CREATE_BY,:I_STATE,:UNITCODE)");
command.CommandText = queryInsertItem;
command.CommandType = CommandType.Text;
command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = Guid.NewGuid();
command.Parameters.Add("MAKHACHHANG", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.MAKHACHHANG;
command.Parameters.Add("TENKHACHHANG", OracleDbType.NVarchar2, 300).Value = _KHACHHANG_DTO.TENKHACHHANG;
command.Parameters.Add("DIACHI", OracleDbType.NVarchar2, 300).Value = _KHACHHANG_DTO.DIACHI;
command.Parameters.Add("DIENTHOAI", OracleDbType.NVarchar2, 20).Value = _KHACHHANG_DTO.DIENTHOAI;
command.Parameters.Add("CANCUOC_CONGDAN", OracleDbType.NVarchar2, 20).Value = _KHACHHANG_DTO.CANCUOC_CONGDAN;
command.Parameters.Add("NGAYSINH", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYSINH;
command.Parameters.Add("NGAYDACBIET", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYDACBIET;
command.Parameters.Add("MATHE", OracleDbType.NVarchar2, 20).Value = _KHACHHANG_DTO.MATHE;
command.Parameters.Add("SODIEM", OracleDbType.Decimal).Value = _KHACHHANG_DTO.SODIEM;
command.Parameters.Add("TONGTIEN", OracleDbType.Decimal).Value = _KHACHHANG_DTO.TONGTIEN;
command.Parameters.Add("DIENGIAI", OracleDbType.NVarchar2, 300).Value = _KHACHHANG_DTO.DIENGIAI;
command.Parameters.Add("TRANGTHAI", OracleDbType.Int32).Value = _KHACHHANG_DTO.TRANGTHAI;
command.Parameters.Add("I_CREATE_DATE", OracleDbType.Date).Value = _KHACHHANG_DTO.I_CREATE_DATE;
command.Parameters.Add("I_CREATE_BY", OracleDbType.Varchar2, 50).Value = _KHACHHANG_DTO.I_CREATE_BY;
command.Parameters.Add("I_STATE", OracleDbType.Varchar2, 1).Value = _KHACHHANG_DTO.I_STATE;
command.Parameters.Add("UNITCODE", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.UNITCODE;
try
{
if (command.ExecuteNonQuery() > 0)
{
RESULT++;
}
_STATUS_THEMMOI_KHACHHANG(_KHACHHANG_DTO);
}
catch (Exception e)
{
WriteLogs.LogError(e);
NotificationLauncher.ShowNotificationError("THÔNG BÁO", "XẢY RA LỖI KHI LƯU THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
}
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 TỚI ORACLE", 1, "0x1", "0x8", "normal");
}
}
return(RESULT);
}
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);
}
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 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 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);
}
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 int SAVE_DATA_KHACHHANG_TO_ORACLE()
{
int RESULT = 0;
//SAVE ORACLE
string MAKHACHHANG = SAVE_MAKHACHHANG_TO_ORACLE();
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO();
_KHACHHANG_DTO.MAKH = MAKHACHHANG;
_KHACHHANG_DTO.TENKH = txtTenKhachHang.Text;
_KHACHHANG_DTO.DIACHI = txtDiaChi.Text;
_KHACHHANG_DTO.DIENTHOAI = txtDienThoai.Text;
_KHACHHANG_DTO.CMTND = txtChungMinhThu.Text;
_KHACHHANG_DTO.EMAIL = "";
_KHACHHANG_DTO.SODIEM = 0;
_KHACHHANG_DTO.TONGTIEN = 0;
_KHACHHANG_DTO.NGAYCAPTHE = DateTime.Now;
_KHACHHANG_DTO.NGAYHETHAN = DateTime.Now.AddYears(1);
_KHACHHANG_DTO.NGAYSINH = dateNgaySinh.Value;
_KHACHHANG_DTO.UNITCODE = Session.Session.CurrentUnitCode;
_KHACHHANG_DTO.MATHE = txtMaThe.Text;
OracleCommand command = new OracleCommand();
command.Connection = connection;
string queryInsertItem = string.Format(@"INSERT INTO DM_KHACHHANG (ID,MAKH,TENKH,DIACHI,DIENTHOAI,CMTND,SODIEM,TONGTIEN,NGAYCAPTHE,NGAYHETHAN,NGAYSINH,UNITCODE,TRANGTHAI,MATHE) VALUES (:ID,:MAKH,:TENKH,:DIACHI,:DIENTHOAI,:CMTND,:SODIEM,:TONGTIEN,:NGAYCAPTHE,:NGAYHETHAN,:NGAYSINH,:UNITCODE,:TRANGTHAI,:MATHE)");
command.CommandText = queryInsertItem;
command.CommandType = CommandType.Text;
command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = Guid.NewGuid();
command.Parameters.Add("MAKH", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.MAKH;
command.Parameters.Add("TENKH", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.TENKH;
command.Parameters.Add("DIACHI", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.DIACHI;
command.Parameters.Add("DIENTHOAI", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.DIENTHOAI;
command.Parameters.Add("CMTND", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.CMTND;
command.Parameters.Add("SODIEM", OracleDbType.Decimal).Value = _KHACHHANG_DTO.SODIEM;
command.Parameters.Add("TONGTIEN", OracleDbType.Decimal).Value = _KHACHHANG_DTO.TONGTIEN;
command.Parameters.Add("NGAYCAPTHE", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYCAPTHE;
command.Parameters.Add("NGAYHETHAN", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYHETHAN;
command.Parameters.Add("NGAYSINH", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYSINH;
command.Parameters.Add("UNITCODE", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.UNITCODE;
command.Parameters.Add("TRANGTHAI", OracleDbType.Int32).Value = 10;
command.Parameters.Add("MATHE", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.MATHE;
try
{
if (command.ExecuteNonQuery() > 0)
{
RESULT++;
}
_STATUS_THEMMOI_KHACHHANG(_KHACHHANG_DTO);
}
catch (Exception e)
{
WriteLogs.LogError(e);
NotificationLauncher.ShowNotificationError("THÔNG BÁO", "XẢY RA LỖI KHI LƯU THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
}
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 TỚI ORACLE", 1, "0x1", "0x8", "normal");
}
}
return(RESULT);
}
private void LOGIN()
{
string Username = txtUserName.Text.Trim();
string passWord = txtPassWord.Text.Trim();
string passMd5 = MD5Encrypt.MD5Hash(passWord).Trim();
//check true false login
try
{
string msg = Config.CheckConnectToServer(out bool result);
if (msg.Length > 0)
{
MessageBox.Show(msg); return;
}
//BEGIN LOGIN
if (result) // nếu có mạng lan
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format(@"SELECT * FROM AU_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();
if (!string.IsNullOrEmpty(Session.Session.CurrentUnitCode))
{
Session.Session.CurrentCodeStore = Session.Session.CurrentUnitCode.Split('-')[1];
}
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandText = string.Format(@"SELECT * FROM AU_DONVI WHERE MADONVI = '" + Session.Session.CurrentUnitCode + "'");
OracleDataReader dataReaderDonVi = null;
dataReaderDonVi = command.ExecuteReader();
if (dataReaderDonVi.HasRows)
{
while (dataReaderDonVi.Read())
{
Session.Session.CurrentPhone = dataReaderDonVi["SODIENTHOAI"].ToString();
Session.Session.CurrentAddress = dataReaderDonVi["DIACHI"].ToString();
Session.Session.CurrentNameStore = dataReaderDonVi["TENCUAHANG"].ToString();
}
}
Session.Session.CurrentUserName = dataReader["USERNAME"].ToString();
Session.Session.CurrentNgayPhatSinh = FrmXuatBanLeService.GET_NGAYHACHTOAN_CSDL_ORACLE();
Session.Session.CurrentTableNamePeriod = FrmXuatBanLeService.GET_TABLE_NAME_NGAYHACHTOAN_CSDL_ORACLE();
Session.Session.CurrentWareHouse = (Session.Session.CurrentUnitCode + "-K2").ToUpper().Trim();
SplashScreenManager.ShowForm(typeof(WaitForm1));
SYNCHRONIZE_DATA.SYNCHRONIZE_AU_NGUOIDUNG();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_BOHANG();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_BOHANGCHITIET();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_KHACHHANG();
SYNCHRONIZE_DATA.SYNCHRONIZE_KHUYENMAI();
SYNCHRONIZE_DATA.SYNCHRONIZE_AU_THAMSOHETHONG();
SYNCHRONIZE_DATA.SYNCHRONIZE_AU_DONVI();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_VATTU();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_HANGKHACHHANG();
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ế 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["TBNETERP_CLIENT"].ConnectionString))
{
connectionSa.Open();
if (connectionSa.State == ConnectionState.Open)
{
try
{
SqlCommand cmdSelectSa = new SqlCommand();
cmdSelectSa.Connection = connectionSa;
cmdSelectSa.CommandText = string.Format(@"SELECT [ID],[USERNAME],[PASSWORD],[MANHANVIEN],[TENNHANVIEN],[SODIENTHOAI],[SOCHUNGMINHTHU],[GIOITINH],[TRANGTHAI],[LEVEL],[UNITCODE],[PARENT_UNITCODE] FROM [dbo].[AU_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();
if (!string.IsNullOrEmpty(Session.Session.CurrentUnitCode))
{
Session.Session.CurrentCodeStore = Session.Session.CurrentUnitCode.Split('-')[1];
}
SqlCommand commandDonVi = new SqlCommand();
commandDonVi.Connection = connectionSa;
commandDonVi.CommandText = string.Format(@"SELECT [ID],[MADONVI],[MADONVICHA],[TENDONVI],[SODIENTHOAI],[DIACHI],[TRANGTHAI],[MACUAHANG],[TENCUAHANG],[UNITCODE] FROM [dbo].[AU_DONVI] WHERE MADONVI = '" + Session.Session.CurrentUnitCode + "'");
SqlDataReader dataReaderDonVi = null;
dataReaderDonVi = commandDonVi.ExecuteReader();
if (dataReaderDonVi.HasRows)
{
while (dataReaderDonVi.Read())
{
Session.Session.CurrentPhone = dataReaderDonVi["SODIENTHOAI"].ToString();
Session.Session.CurrentAddress = dataReaderDonVi["DIACHI"].ToString();
Session.Session.CurrentNameStore = dataReaderDonVi["TENCUAHANG"].ToString();
}
}
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 = DateTime.Now;
Session.Session.CurrentWareHouse = (Session.Session.CurrentUnitCode + "-K2").ToUpper().Trim();
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ế 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ế 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ế nối với cơ sở dữ liệu máy bán", 1, "0x1", "0x8", "normal");
WriteLogs.LogError(ex);
}
}
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);
}
