private void HienThiTT()
{
try
{
tblphieunhapkho obj = new tblphieunhapkho();
tblphieunhapkhoBL ctr = new tblphieunhapkhoBL();
obj = ctr.GetByID(txtID.Text.Trim());
dpkNgayNhap.Value = obj.ngaytao;
cbNhaCC.SelectedValue = obj.id_nguoicap;
txtChietKhau.Text = obj.chietkhau.ToString("N0", CultureInfo.InvariantCulture);
txtTienThanhToan.Text = obj.tienthanhtoan.ToString("N0", CultureInfo.InvariantCulture);
dpkNgayNhap.Value = obj.ngaytao;
txtNoToaTruoc.Text = ctr.GetTienConNo(obj.id_nguoicap, obj.ngaytao).ToString("N0", CultureInfo.InvariantCulture);
txtGhiChu.Text = obj.ghichu.Trim();
txtNoiNhap.Text = obj.noinhap.Trim();
}
catch
{
HienThiDSMatHang();
}
}
private void cbNhaCC_SelectedIndexChanged(object sender, EventArgs e)
{
tblphieunhapkhoBL ctrpn = new tblphieunhapkhoBL();
string sidnhacc = "";
try { sidnhacc = cbNhaCC.SelectedValue.ToString().Trim(); }
catch { }
nhacungcap obj = new nhacungcap();
nhacungcapBL ctr = new nhacungcapBL();
obj = ctr.GetByID(sidnhacc);
try
{
try
{
txtNoToaTruoc.Text = ctrpn.GetTienConNo(sidnhacc, dpkNgayNhap.Value).ToString("N0", CultureInfo.InvariantCulture);
}
catch { txtNoToaTruoc.Text = "0"; }
txtDiaChi.Text = obj.diachi;
txtDienThoai.Text = obj.dienthoai.Trim();
double tongtien = 0;
try { tongtien = Convert.ToDouble(txtTongTien.Text); }
catch { }
double tienconno = 0;
try { tienconno = Convert.ToDouble(txtNoToaTruoc.Text); }
catch { }
double tientt = 0;
try { tientt = Convert.ToDouble(txtTienThanhToan.Text); }
catch { }
double chietkhau = 0;
try { chietkhau = Convert.ToDouble(txtChietKhau.Text); }
catch { }
txtConNo.Text = ((tienconno + tongtien) - (tientt + chietkhau)).ToString("N0", CultureInfo.InvariantCulture);
}
catch
{
txtDiaChi.Text = "";
txtDienThoai.Text = "";
txtTongTien.Text = "0";
}
}
private string GenerateWorksheetTKCongNo(WorksheetCollection sheets, DateTime dtdenngay, DataTable dtnhacc, ProgressBar progressBar)
{
try
{
tblphieunhapkhoBL ctrpn = new tblphieunhapkhoBL();
tblphieunhapkho objpn = new tblphieunhapkho();
tblhangnhapkhoBL ctrhangnhapkho = new tblhangnhapkhoBL();
tienthanhtoanphieunhapBL ctrtiendatt = new tienthanhtoanphieunhapBL();
Worksheet sheet = sheets.Add("TKCongNoNhapHang");
sheet.Table.DefaultRowHeight = 15F;
sheet.Table.ExpandedColumnCount = 5;
sheet.Table.ExpandedRowCount = 5 + dtnhacc.Rows.Count;
sheet.Table.FullColumns = 1;
sheet.Table.FullRows = 1;
sheet.Table.Columns.Add(36);
sheet.Table.Columns.Add(193);
sheet.Table.Columns.Add(149);
sheet.Table.Columns.Add(191);
sheet.Table.Columns.Add(159);
// -----------------------------------------------
#region Add Header
WorksheetRow Row0 = sheet.Table.Rows.Add();
Row0.Height = 20;
Row0.AutoFitHeight = false;
WorksheetCell cell;
cell = Row0.Cells.Add();
cell.StyleID = "s75";
cell.Data.Type = DataType.String;
cell.Data.Text = "TỔNG HỢP CÔNG NỢ NHẬP HÀNG";
cell.MergeAcross = 4;
// -----------------------------------------------
WorksheetRow Row1 = sheet.Table.Rows.Add();
Row1.AutoFitHeight = false;
cell = Row1.Cells.Add();
cell.StyleID = "s76";
cell.Data.Type = DataType.String;
cell.Data.Text = "(Số liệu tính đến ngày " + dtdenngay.ToString("dd/MM/yyyy") + ")";
cell.MergeAcross = 4;
// -----------------------------------------------
WorksheetRow Row2 = sheet.Table.Rows.Add();
Row2.AutoFitHeight = false;
cell = Row2.Cells.Add();
cell.StyleID = "m83608040";
cell.Data.Type = DataType.String;
cell.Data.Text = "Đơn vị tính: VNĐ";
cell.MergeAcross = 4;
// -----------------------------------------------
WorksheetRow Row3 = sheet.Table.Rows.Add();
Row3.AutoFitHeight = false;
Row3.Cells.Add("Stt", DataType.String, "s67");
Row3.Cells.Add("Nhà cung cấp", DataType.String, "s67");
Row3.Cells.Add("Điện thoại", DataType.String, "s67");
Row3.Cells.Add("Địa chỉ", DataType.String, "s67");
Row3.Cells.Add("Tổng tiền còn nợ", DataType.String, "s67");
#endregion
// -----------------------------------------------
#region Add Content
for (int i = 0; i < dtnhacc.Rows.Count; i++)
{
Application.DoEvents();
progressBar.PerformStep();
Application.DoEvents();
string sidnhacc = "";
try { sidnhacc = dtnhacc.Rows[i]["id"].ToString().Trim(); }
catch { sidnhacc = "-/-"; }
string stennhacc = "";
try { stennhacc = dtnhacc.Rows[i]["ten"].ToString().Trim(); }
catch { stennhacc = "-/-"; }
string sdt = "";
try { sdt = dtnhacc.Rows[i]["dienthoai"].ToString().Trim(); }
catch { sdt = "-/-"; }
string sdiachi = "";
try { sdiachi = dtnhacc.Rows[i]["diachi"].ToString().Trim(); }
catch { sdiachi = "-/-"; }
if (sidnhacc.Trim().Equals("") == false)
{
// Lấy hóa đơn gần với ngày thống kê nhất
objpn = new tblphieunhapkho();
Application.DoEvents();
progressBar.PerformStep();
Application.DoEvents();
objpn = ctrpn.GetNewFirstByNgayTaovsIDKH(dtdenngay.AddDays(1).ToString("yyyy/MM/dd").Trim(), sidnhacc);
if (objpn != null)
{
double tienmuahang = 0;
try { tienmuahang = ctrhangnhapkho.GetTongTienByIDPN(objpn.id); }
catch { }
//double tientt = 0;
//tientt = objpn.tienthanhtoan;
double chietkhau = 0;
chietkhau = objpn.chietkhau;
double tiendatt = 0;
try { tiendatt = ctrtiendatt.GetTienDaThanhToan(objpn.id); }
catch { }
double tienconnotoatruoc = 0;
try { tienconnotoatruoc = ctrpn.GetTienConNo(objpn.id_nguoicap, objpn.ngaytao); }
catch { }
double tienconno = 0;
tienconno = ((tienmuahang - tiendatt - chietkhau) + tienconnotoatruoc);
Application.DoEvents();
progressBar.PerformStep();
Application.DoEvents();
WorksheetRow Row = sheet.Table.Rows.Add();
Row.Cells.Add((i + 1).ToString(), DataType.Number, "s68");
Row.Cells.Add(stennhacc, DataType.String, "s69");
Row.Cells.Add(sdt, DataType.String, "s69");
Row.Cells.Add(sdiachi, DataType.String, "s69");
Row.Cells.Add(tienconno.ToString().Trim(), DataType.Number, "s70");
}
}
}
#endregion
// -----------------------------------------------
#region Tính tổng các dòng
WorksheetRow Row7 = sheet.Table.Rows.Add();
Row7.AutoFitHeight = false;
cell = Row7.Cells.Add();
cell.StyleID = "m83608060";
cell.Data.Type = DataType.String;
cell.Data.Text = "TỔNG CỘNG";
cell.MergeAcross = 3;
cell = Row7.Cells.Add();
cell.StyleID = "s74";
cell.Data.Type = DataType.Number;
cell.Formula = "=SUM(R[-" + dtnhacc.Rows.Count.ToString() + "]C:R[-1]C)";
#endregion
// -----------------------------------------------
// Options
// -----------------------------------------------
sheet.Options.Selected = true;
sheet.Options.ProtectObjects = false;
sheet.Options.ProtectScenarios = false;
sheet.Options.PageSetup.Header.Margin = 0.3F;
sheet.Options.PageSetup.Footer.Margin = 0.3F;
sheet.Options.PageSetup.PageMargins.Bottom = 0.75F;
sheet.Options.PageSetup.PageMargins.Left = 0.7F;
sheet.Options.PageSetup.PageMargins.Right = 0.7F;
sheet.Options.PageSetup.PageMargins.Top = 0.75F;
sheet.Options.Print.HorizontalResolution = 300;
sheet.Options.Print.VerticalResolution = 0;
sheet.Options.Print.ValidPrinterInfo = true;
return("");
}
catch (Exception ex) { return(ex.Message); }
}