private void frmLoanPayBack_Load(object sender, EventArgs e)
{
CommonUtil.SetinitGridView(dgvMember);
CommonUtil.AddGridTextColumn(dgvMember, "대출번호", "LoanNum");
CommonUtil.AddGridTextColumn(dgvMember, "담보제공예금계좌번호", "DAccountNum", 150);
CommonUtil.AddGridTextColumn(dgvMember, "대출금액", "AmountOfLoan");
CommonUtil.AddGridTextColumn(dgvMember, "만기일시상환금액", "ReturnWhenExpired", 150);
CommonUtil.AddGridTextColumn(dgvMember, "대출금상환방법", "PayBackMethod");
CommonUtil.AddGridTextColumn(dgvMember, "대출목적", "Purpose");
CommonUtil.AddGridTextColumn(dgvMember, "대출기간", "LoanExpire");
CommonUtil.AddGridTextColumn(dgvMember, "출금계좌", "NAccountNum");
CommonUtil.AddGridTextColumn(dgvMember, "출금계좌비밀번호", "Pwd");
CommonUtil.AddGridTextColumn(dgvMember, "대출시작일시", "LoanStarted");
CommonUtil.AddGridTextColumn(dgvMember, "대출금리", "InterestRate");
CommonUtil.AddGridTextColumn(dgvMember, "정규상환일", "RegularPayBackDate");
CommonUtil.AddGridTextColumn(dgvMember, "고객번호", "CustomerNum");
CommonUtil.AddGridTextColumn(dgvMember, "고객이름", "CustomerName");
CommonUtil.AddGridTextColumn(dgvMember, "남은 상환 금액", "LoanLeftOver");
LoanDB db = new LoanDB();
dgvMember.DataSource = db.GetEveryData(CustomerNum);
txtPayBack.Text = "0";
}
private void btnSelect_Click(object sender, EventArgs e) //대출 조회 버튼
{
//디비 열어서 현재 대출 상황 보여주기
LoanDB db = new LoanDB();
DataTable dt = db.GetEveryData(CustomerNum);
if (dt != null)
{
dgvMember.DataSource = dt;
}
else
{
MessageBox.Show("대출 내역이 존재하지 않습니다.");
}
}
