public string timKiem(string soTKLK)
{
QLTienMatDTO qLTienMat = QLTienMatDAO.timKiem(soTKLK);
string jsonData = JsonConvert.SerializeObject(qLTienMat);
return(jsonData);
}
/// <summary>
/// Tìm kiếm theo số TKLK
/// </summary>
/// <param name="soTKLK"></param>
/// <returns></returns>
public static QLTienMatDTO timKiem(string soTKLK)
{
try
{
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.CommandText = "SELECT HO_TEN,SO_CMND,SDT,SO_TIEN_MAT,SO_DU_NO,SO_TKLK FROM KHACH_HANG WHERE SO_TKLK = :soTKLK";
oracleCommand.Parameters.Add(new OracleParameter("soTKLK", soTKLK));
OracleDataReader oracleDataReader = DataProvider.GetOracleDataReader(oracleCommand);
if (oracleDataReader != null && oracleDataReader.HasRows)
{
oracleDataReader.Read();
QLTienMatDTO qLTienMat = new QLTienMatDTO();
qLTienMat.HoTen = oracleDataReader.GetString(0);
qLTienMat.SoCMND = oracleDataReader.GetString(1);
qLTienMat.SDT = oracleDataReader.GetString(2);
qLTienMat.TienMat = oracleDataReader.GetInt64(3);
qLTienMat.DuNo = oracleDataReader.GetInt64(4);
qLTienMat.SoTKLK = oracleDataReader.GetString(5);
oracleCommand.Connection.Dispose();
return(qLTienMat);
}
else
{
return(null);
}
}
catch (Exception e)
{
MessageBox.Show("Lỗi: " + e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
}
private void txtSoTKLK_Leave_1(object sender, EventArgs e)
{
try
{
QLTienMatBUS qLTienMatBUS = new QLTienMatBUS();
//lấy thông tin từ số TKLK
string jsonData = qLTienMatBUS.timKiem(txtSoTKLK.Text);
QLTienMatDTO list = JsonConvert.DeserializeObject <QLTienMatDTO>(jsonData);
lblError.ForeColor = Color.Red;
if (txtSoTKLK.Text == "")
{
lblError.Text = "Dòng màu đỏ là thông tin bắt buộc nhập";
}
else
if (list == null)
{
lblError.Text = "Số TKLK không có trong hệ thống";
}
else
{
txtHoTen.Text = list.HoTen;
txtSDT.Text = list.SDT;
txtSoCMND.Text = list.SoCMND;
txtDuNo.Text = list.DuNo.ToString();
txtTienMat.Text = list.TienMat.ToString();
lblError.Text = "";
btbNop.Enabled = true;
btnRut.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public RutTien()
{
InitializeComponent();
qLTienMat = new QLTienMatDTO();
}
public NopTien()
{
qLTienMat = new QLTienMatDTO();
InitializeComponent();
}
