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