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 btnMonthlyLoan_Click(object sender, EventArgs e) //기간별 대출 건수
{
if (!dtpCheck())
{
return;
}
LoanDB db = new LoanDB();
DataTable dt = db.LoanPerPeriod(dtpTime1, dtpTime2);
if (dt == null)
{
MessageBox.Show("해당하는 자료가 없습니다.");
return;
}
chart1.Series.Clear();
chart1.Series.Add(new Series("Series3"));
for (int i = 0; i < dt.Rows.Count; i++)
{
chart1.Series["Series3"].Points.AddXY(dt.Rows[i][0].ToString().Substring(0, 10), dt.Rows[i][1]);
chart1.Series["Series3"].ToolTip = $"#VALY";
}
chart1.Series["Series3"].ChartType = SeriesChartType.Line;
chart1.Series["Series3"].BorderWidth = 5;
chart1.Series["Series3"].LegendText = "기간별 대출 건수";
}
private void btnAvg_Click(object sender, EventArgs e) //평균 대출액
{
LoanDB db = new LoanDB();
DataTable dt = db.MonthlyAvgLoan();
chart1.Series.Clear();
chart1.Series.Add(new Series("Series2"));
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
chart1.Series["Series2"].Points.AddXY(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString());
chart1.Series["Series2"].ToolTip = $"#VALY";
}
//chart1.Series["Series2"].Points.DataBind(dt.DefaultView, "month(LoanStarted)", "AVGloan", "ToolTip=AVGloan ");
chart1.Series["Series2"].ChartType = SeriesChartType.Line;
chart1.Series["Series2"].BorderWidth = 5;
chart1.Series["Series2"].LegendText = "월별 평균 대출액";
}
else
{
MessageBox.Show("자료를 가져오지 못했습니다.");
}
}
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("대출 내역이 존재하지 않습니다.");
}
}
private void btnOK_Click(object sender, EventArgs e)
{
LoanDB db = new LoanDB();
if (db.Update(txtLoanWillBeLeftOver.Text, LoanNum))
{
MessageBox.Show("성공적으로 대출이 상환되었습니다.");
this.Close();
}
else
{
MessageBox.Show("과정에 오류가 있습니다. 다시 시도해주세요.");
return;
}
db.Dispose();
}
private void btnDay_Click(object sender, EventArgs e) //연체율
{
// dtpCheck();
LoanDB db = new LoanDB();
DataTable dt = db.DelayRate();
chart1.Series.Clear();
chart1.Series.Add(new Series("Series1"));
chart1.Series["Series1"].Points.AddXY("Loan Delayed", dt.Rows[0][0].ToString());
chart1.Series["Series1"].ToolTip = dt.Rows[0][0].ToString();
chart1.Series["Series1"].ChartType = SeriesChartType.Column;
chart1.Series["Series1"].BorderWidth = 5;
chart1.Series["Series1"].LegendText = "연체율";
}