private void UC_thulai_Load(object sender, EventArgs e)
{
repositoryItemComboBox1.Items.Clear();
foreach (var i in _ciftk)
{
repositoryItemComboBox1.Items.Add(string.Format(@"{0:###-##-##-######-#}", i.ACCTNO));
comboBoxEdit1.Properties.Items.Add(string.Format(@"{0:###-##-##-######-#}", i.ACCTNO));
}
repositoryItemComboBox1.Items.Add(@"Tiền Mặt");
comboBoxEdit1.Properties.Items.Add(@"Tiền Mặt");
foreach (var i in _tp)
{
var tk = _ciftk.FirstOrDefault(c => c.DDCTYP == i.tiente);
string ptra = "";
if (tk != null)
{
ptra = string.Format(@"{0:###-##-##-######-#}", tk.ACCTNO);
}
else
{
ptra = @"Tiền Mặt";
}
_inthulai.Add(new ThuLai()
{
Cif = i.socif,
TenKh = i.khachhang,
LaiCongDon = i.laicongdon ?? 0,
LaiTraCham = i.laitracham ?? 0,
SoTienPhaiTra = (i.laicongdon ?? 0) + (i.laitracham ?? 0),
PhuongThucTra = ptra,
tkvay = string.Format(@"{0:###-##-##-######-#}", i.taikhoan),
GhiChu = @"Ngày tính lãi " + i.denngay.Value.ToShortDateString(),
LoaiTien = i.tiente
});
}
GC_TD_Pyctl_ThuLai.DataSource = new BindingSource(_inthulai, "");
GV_TD_Pyctl_ThuLai.OptionsView.BestFitMaxRowCount = -1;
GV_TD_Pyctl_ThuLai.BestFitColumns();
}
private void bt_td_pyctl_thulai_xuatexcel_Click(object sender, EventArgs e)
{
var pathToFile = Path.Combine(_clickOnceLocation, @"thulai.xlsx");
SaveFileDialog SaveFileExcel = new SaveFileDialog();
SaveFileExcel.FileName = "thulai_";
SaveFileExcel.Filter = @"Excel File (*.xlsx)|*.xlsx";
if (SaveFileExcel.ShowDialog() == DialogResult.OK)
{
var temp = new FileInfo(pathToFile);
using (var pck = new ExcelPackage(temp))
{
ExcelWorksheet wsList = pck.Workbook.Worksheets[1];
const int startRow = 13;
int row = startRow;
var loaitien = "VND";
for (int i = 0; i < GV_TD_Pyctl_ThuLai.DataRowCount; i++)
{
wsList.InsertRow(row, 1);
wsList.Cells[row, 2].Value = GV_TD_Pyctl_ThuLai.GetRowCellValue(i, "tkvay").ToString();
wsList.Cells[row, 3].Value = Convert.ToDecimal(GV_TD_Pyctl_ThuLai.GetRowCellValue(i, "LaiCongDon"));
wsList.Cells[row, 3].Style.Numberformat.Format = "#,##0.00;-#,##0.00";
wsList.Cells[row, 4].Value = GV_TD_Pyctl_ThuLai.GetRowCellValue(i, "LaiTraCham");
wsList.Cells[row, 4].Style.Numberformat.Format = "#,##0.00;-#,##0.00";
wsList.Cells[row, 6].Value = GV_TD_Pyctl_ThuLai.GetRowCellValue(i, "PhuongThucTra").ToString();
wsList.Cells[row, 7].Value = GV_TD_Pyctl_ThuLai.GetRowCellValue(i, "GhiChu").ToString();
wsList.Cells[row, 8].Value = GV_TD_Pyctl_ThuLai.GetRowCellValue(i, "LoaiTien").ToString();
wsList.Cells[row, 5].Formula = string.Format("Sum(C{0}:D{0})", row);
loaitien = GV_TD_Pyctl_ThuLai.GetRowCellValue(i, "LoaiTien").ToString();
row++;
}
string local = "A" + startRow + ":H" + row;
var cell = wsList.Cells[local];
var border = cell.Style.Border;
border.BorderAround(ExcelBorderStyle.Thin);
border.Bottom.Style = ExcelBorderStyle.Thin;
border.Top.Style = ExcelBorderStyle.Thin;
border.Left.Style = ExcelBorderStyle.Thin;
border.Right.Style = ExcelBorderStyle.Thin;
wsList.Cells["A10"].Value = wsList.Cells["A10"].Value + " " + GV_TD_Pyctl_ThuLai.GetRowCellValue(1, "Cif");
wsList.Cells["A9"].Value = wsList.Cells["A9"].Value + " " + GV_TD_Pyctl_ThuLai.GetRowCellValue(1, "TenKh");
wsList.Cells["E3"].Value = string.Format(@"Ngày {0} tháng {1} nam {2}", DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year);
wsList.Cells["A7"].Value = wsList.Cells["A7"].Value + " " + _phongthu;
wsList = pck.Workbook.Worksheets[2];
wsList.Cells["A1"].LoadFromCollection(_tp, true);
wsList.Column(2).Style.Numberformat.Format = "dd/MM/yyyy";
wsList.Column(8).Style.Numberformat.Format = "dd/MM/yyyy";
wsList.Column(9).Style.Numberformat.Format = "dd/MM/yyyy";
var fi = new FileInfo(SaveFileExcel.FileName);
if (fi.Exists)
{
fi.Delete();
}
pck.SaveAs(fi);
}
insoden.MainForm.OpenExplorer(SaveFileExcel.FileName);
}
}
