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