private void cmbMaCK_SelectedIndexChanged(object sender, EventArgs e)
{
QLiSucMuaDTO qLiSucMuaDTO = (QLiSucMuaDTO)cmbMaCK.SelectedItem;
if (qLiSucMuaDTO != null)
{
txtGiaTran.Text = qLiSucMuaDTO.GiaTran.ToString();
txtGiaSan.Text = qLiSucMuaDTO.GiaSan.ToString();
txtGiaVay.Text = qLiSucMuaDTO.GiaVay.ToString();
txtTiLeVay.Text = qLiSucMuaDTO.TiLeVay.ToString();
txtSL.Text = qLiSucMuaDTO.SoLuong.ToString();
txtGiaMua.Text = txtGiaSan.Text;
if (txtGiaVay.Text == "0" && txtTiLeVay.Text == "0")
{
txtSMCB.Text = txtTSDB.Text;
txtSMTD.Text = txtSMCB.Text;
}
else
{
if (txtTSDB.Text != "")
{
long SucMuaCB = long.Parse(txtTienMat.Text) + Math.Min(long.Parse(txtTSDB.Text), long.Parse(txtHanMucVay.Text)) - long.Parse(txtSoDuNo.Text);
txtSMCB.Text = SucMuaCB.ToString();
double temp;
temp = (double.Parse(txtGiaVay.Text) * double.Parse(txtTiLeVay.Text) / 100) / double.Parse(txtGiaMua.Text);
double SMTD = SucMuaCB / (1 - temp);
long result = (long)Math.Round(SMTD);
txtSMTD.Text = result.ToString();
}
}
}
}
// Hiển thị thông tin mã chứng khoán
private void groupBoxTTMaCK_Enter(object sender, EventArgs e)
{
lblError.ForeColor = Color.Red;
// Lấy ds mã CK có trong rổ
QLiSucMuaBUS qLiSucMua = new QLiSucMuaBUS();
string jsonData = qLiSucMua.layThongtinCK(txtSoTKLK.Text);
List <QLiSucMuaDTO> list = JsonConvert.DeserializeObject <List <QLiSucMuaDTO> >(jsonData);
List <string> listMaCK = new List <string>();
qLiSucMuaDTOs = list;
foreach (QLiSucMuaDTO temp in list)
{
listMaCK.Add(temp.MaCK);
}
// Lấy danh sách các mã CK
QLCKBUS qLCKBUS = new QLCKBUS();
List <QLCKDTO> qLCKDTOs = JsonConvert.DeserializeObject <List <QLCKDTO> >(qLCKBUS.layDSCK());
foreach (QLCKDTO temp in qLCKDTOs)
{
if (!listMaCK.Contains(temp.MaCK))
{
QLiSucMuaDTO qLiSucMuaDTO = new QLiSucMuaDTO();
qLiSucMuaDTO.MaCK = temp.MaCK;
qLiSucMuaDTO.SoLuong = qLiSucMua.GetSL(txtSoTKLK.Text, temp.MaCK);
qLiSucMuaDTO.GiaTran = temp.GiaTran;
qLiSucMuaDTO.GiaSan = temp.GiaSan;
qLiSucMuaDTO.GiaVay = 0;
qLiSucMuaDTO.TiLeVay = 0;
list.Add(qLiSucMuaDTO);
}
}
// Hiển thị lên cmb
cmbMaCK.Refresh();
cmbMaCK.DisplayMember = "MaCK";
cmbMaCK.DataSource = list;
cmbMaCK.SelectedIndex = 0;
long TSDB = 0;
foreach (QLiSucMuaDTO temp in list)
{
TSDB += temp.SoLuong * temp.GiaVay * temp.TiLeVay / 100;
}
txtTSDB.Text = TSDB.ToString();
long SucMuaCB = long.Parse(txtTienMat.Text) + Math.Min(long.Parse(txtTSDB.Text), long.Parse(txtHanMucVay.Text)) - long.Parse(txtSoDuNo.Text);
txtSMCB.Text = SucMuaCB.ToString();
}
// Hiển thị thông tin mã CK
public static List <QLiSucMuaDTO> layThongTinCK(string soTKLK)
{
try
{
List <QLiSucMuaDTO> qLiSucMuas = new List <QLiSucMuaDTO>();
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.CommandText = "SELECT KHACHHANG_CHUNGKHOAN.MA_CK, CHUNG_KHOAN.GIA_TRAN, CHUNG_KHOAN.GIA_SAN, KHACHHANG_CHUNGKHOAN.SO_LUONG, CHI_TIET_RO.GIA_VAY, CHI_TIET_RO.TI_LE_VAY " +
" FROM KHACH_HANG, CHUNG_KHOAN, KHACHHANG_CHUNGKHOAN, CHI_TIET_RO " +
" WHERE CHUNG_KHOAN.MA_CK = CHI_TIET_RO.MA_CK AND KHACHHANG_CHUNGKHOAN.MA_CK = CHI_TIET_RO.MA_CK AND KHACHHANG_CHUNGKHOAN.SO_TKLK = KHACH_HANG.SO_TKLK " +
" AND KHACH_HANG.MA_RO = CHI_TIET_RO.MA_RO AND KHACH_HANG.SO_TKLK = :soTKLK";
oracleCommand.Parameters.Add(new OracleParameter("soTKLK", soTKLK));
OracleDataReader oracleDataReader = DataProvider.GetOracleDataReader(oracleCommand);
if (oracleDataReader != null && oracleDataReader.HasRows)
{
while (oracleDataReader.Read())
{
QLiSucMuaDTO qLiSucMua = new QLiSucMuaDTO();
qLiSucMua.MaCK = oracleDataReader.GetString(0);
qLiSucMua.GiaTran = oracleDataReader.GetInt64(1);
qLiSucMua.GiaSan = oracleDataReader.GetInt64(2);
qLiSucMua.GiaVay = oracleDataReader.GetInt64(4);
qLiSucMua.TiLeVay = oracleDataReader.GetInt64(5);
qLiSucMua.SoLuong = oracleDataReader.GetInt64(3);
qLiSucMuas.Add(qLiSucMua);
}
oracleCommand.Connection.Dispose();
return(qLiSucMuas);
}
else
{
return(null);
}
}
catch (Exception e)
{
MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
}
// HIển thị thông tin khách hàng theo số TKLK
public static List <QLiSucMuaDTO> layThongTinKH(string soTKLK)
{
try
{
List <QLiSucMuaDTO> qLiSucMuas = new List <QLiSucMuaDTO>();
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.CommandText = "SELECT KHACH_HANG.SO_TKLK, KHACH_HANG.HO_TEN, KHACH_HANG.SO_CMND, KHACH_HANG.NGAY_SINH, KHACH_HANG.SO_TIEN_MAT, KHACH_HANG.HAN_MUC_VAY, KHACH_HANG.SO_DU_NO FROM KHACH_HANG WHERE SO_TKLK = :soTKLK";
oracleCommand.Parameters.Add(new OracleParameter("soTKLK", soTKLK));
OracleDataReader oracleDataReader = DataProvider.GetOracleDataReader(oracleCommand);
if (oracleDataReader != null && oracleDataReader.HasRows)
{
while (oracleDataReader.Read())
{
QLiSucMuaDTO qLiSucMua = new QLiSucMuaDTO();
qLiSucMua.SoTKLK = oracleDataReader.GetString(0);
qLiSucMua.HoTen = oracleDataReader.GetString(1);
qLiSucMua.SoCMND = oracleDataReader.GetString(2);
qLiSucMua.NgaySinh = oracleDataReader.GetDateTime(3);
qLiSucMua.TienMat = oracleDataReader.GetInt64(4);
qLiSucMua.HanMucVay = oracleDataReader.GetInt64(5);
qLiSucMua.SoDuNo = oracleDataReader.GetInt64(6);
qLiSucMuas.Add(qLiSucMua);
}
oracleCommand.Connection.Dispose();
return(qLiSucMuas);
}
else
{
return(null);
}
}
catch (Exception e)
{
MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
}
private void CapNhatThongTin()
{
try
{
ResetElement();
QLiSucMuaBUS qLiSucMua = new QLiSucMuaBUS();
//lấy thông tin từ số TKLK
string jsonData = qLiSucMua.timKiem(txtSoTKLK.Text);
List <QLiSucMuaDTO> list = JsonConvert.DeserializeObject <List <QLiSucMuaDTO> >(jsonData);
lblError.ForeColor = Color.Red;
if (txtSoTKLK.Text == "")
{
lblError.Text = "Bạn chưa nhập số TKLK";
}
else
if (list.Count == 0)
{
lblError.Text = "Số TKLK không có trong hệ thống";
}
else
{
foreach (QLiSucMuaDTO temp in list)
{
txtHoTen.Text = temp.HoTen;
txtsoCMND.Text = temp.SoCMND;
txtNgaySinh.Text = temp.NgaySinh.ToShortDateString();
txtTienMat.Text = temp.TienMat.ToString();
txtHanMucVay.Text = temp.HanMucVay.ToString();
txtSoDuNo.Text = temp.SoDuNo.ToString();
lblError.Text = "";
}
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
lblError.ForeColor = Color.Red;
// Lấy ds mã CK có trong rổ
QLiSucMuaBUS qLiSucMua2 = new QLiSucMuaBUS();
string jsonData2 = qLiSucMua2.layThongtinCK(txtSoTKLK.Text);
List <QLiSucMuaDTO> list2 = JsonConvert.DeserializeObject <List <QLiSucMuaDTO> >(jsonData2);
List <string> listMaCK = new List <string>();
qLiSucMuaDTOs = list2;
foreach (QLiSucMuaDTO temp in list2)
{
listMaCK.Add(temp.MaCK);
}
// Lấy danh sách các mã CK
QLCKBUS qLCKBUS = new QLCKBUS();
List <QLCKDTO> qLCKDTOs = JsonConvert.DeserializeObject <List <QLCKDTO> >(qLCKBUS.layDSCK());
foreach (QLCKDTO temp in qLCKDTOs)
{
if (!listMaCK.Contains(temp.MaCK))
{
QLiSucMuaDTO qLiSucMuaDTO = new QLiSucMuaDTO();
qLiSucMuaDTO.MaCK = temp.MaCK;
qLiSucMuaDTO.SoLuong = qLiSucMua2.GetSL(txtSoTKLK.Text, temp.MaCK);
qLiSucMuaDTO.GiaTran = temp.GiaTran;
qLiSucMuaDTO.GiaSan = temp.GiaSan;
qLiSucMuaDTO.GiaVay = 0;
qLiSucMuaDTO.TiLeVay = 0;
list2.Add(qLiSucMuaDTO);
}
}
// Hiển thị lên cmb
cmbMaCK.Refresh();
cmbMaCK.DisplayMember = "MaCK";
cmbMaCK.DataSource = list2;
cmbMaCK.SelectedIndex = 0;
long TSDB = 0;
foreach (QLiSucMuaDTO temp in list2)
{
TSDB += temp.SoLuong * temp.GiaVay * temp.TiLeVay / 100;
}
txtTSDB.Text = TSDB.ToString();
long SucMuaCB = long.Parse(txtTienMat.Text) + Math.Min(long.Parse(txtTSDB.Text), long.Parse(txtHanMucVay.Text)) - long.Parse(txtSoDuNo.Text);
txtSMCB.Text = SucMuaCB.ToString();
}
