private void _List_View_Chi_Tiet_Hoa_Don(string mahoadon, string makh)
{
lvchitiethoadon.Items.Clear();
int STT = 1;
float tongcong = 0;
DTO_Chi_Tiet_Hoa_Don ct = new DTO_Chi_Tiet_Hoa_Don();
ct.ma_hoa_don = mahoadon.ToString();
ct.ma_khach_hang = makh;
if (new BLL_HoaDon()._List_Chi_Tiet_Hoa_Hon_Van_Chuyen(ct) != null)
{
foreach (DTO_BangKe dto in new BLL_HoaDon()._List_Chi_Tiet_Hoa_Hon_Van_Chuyen(ct))
{
ListViewItem lvi = new ListViewItem(STT.ToString());
ListViewItem.ListViewSubItem ite1 = new ListViewItem.ListViewSubItem(lvi, dto.ma_bang_ke);
lvi.SubItems.Add(ite1);
ListViewItem.ListViewSubItem ite2 = new ListViewItem.ListViewSubItem(lvi, dto.ngay_van_chuyen.ToShortDateString());
lvi.SubItems.Add(ite2);
ListViewItem.ListViewSubItem ite22 = new ListViewItem.ListViewSubItem(lvi, dto.ma_dieu_xe.Trim());
lvi.SubItems.Add(ite22);
ListViewItem.ListViewSubItem ite3 = new ListViewItem.ListViewSubItem(lvi, dto.so_xe);
lvi.SubItems.Add(ite3);
ListViewItem.ListViewSubItem ite4 = new ListViewItem.ListViewSubItem(lvi, dto.noi_nhan);
lvi.SubItems.Add(ite4);
ListViewItem.ListViewSubItem ite5 = new ListViewItem.ListViewSubItem(lvi, dto.noi_giao);
lvi.SubItems.Add(ite5);
ListViewItem.ListViewSubItem ite6 = new ListViewItem.ListViewSubItem(lvi, dto.khoi_luong.ToString());
lvi.SubItems.Add(ite6);
ListViewItem.ListViewSubItem ite7 = new ListViewItem.ListViewSubItem(lvi, dto.don_gia_chuyen.ToString("###,###,###"));
lvi.SubItems.Add(ite7);
ListViewItem.ListViewSubItem ite8 = new ListViewItem.ListViewSubItem(lvi, dto.don_gia_tan.ToString("###,###,###"));
lvi.SubItems.Add(ite8);
ListViewItem.ListViewSubItem ite9 = new ListViewItem.ListViewSubItem(lvi, (dto.don_gia_chuyen + (dto.khoi_luong > 15 ? ((dto.khoi_luong - 15) * dto.don_gia_tan) : 0)).ToString("###,###,###"));
lvi.SubItems.Add(ite9);
ListViewItem.ListViewSubItem ite10 = new ListViewItem.ListViewSubItem(lvi, dto.ghi_chu);
lvi.SubItems.Add(ite10);
lvchitiethoadon.Items.Add(lvi);
STT++;
tongcong += (dto.don_gia_chuyen + (dto.khoi_luong > 15 ? ((dto.khoi_luong - 15) * dto.don_gia_tan) : 0));
}
}
lvchitiethoadon.View = View.Details;
_Tinh_TongCong_Thue_ThanhTien("Tổng Cộng", tongcong);
_Tinh_TongCong_Thue_ThanhTien("Thếu 10%", tongcong * 10 / 100);
_Tinh_TongCong_Thue_ThanhTien("Tổng Thành Tiền", tongcong + (tongcong * 10 / 100));
}
public DTO_BangKe[] _List_Chi_Tiet_Hoa_Hon_Van_Chuyen(DTO_Chi_Tiet_Hoa_Don ct)
{
string sql = "select dm_bang_ke.* from dm_bang_ke,dm_hoa_don_chi_tiet where dm_bang_ke.ma_bang_ke=dm_hoa_don_chi_tiet.ma_bang_ke and ma_hoa_don=@mhd ";
SqlParameter[] prs =
{
new SqlParameter("@mhd", ct.ma_hoa_don.Trim())
};
DataTable dt = data.ExcuteDataTable(sql, prs);
if (dt.Rows.Count > 0)
{
DTO_BangKe[] BangKe = new DTO_BangKe[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
BangKe[i] = new DTO_BangKe();
BangKe[i].ma_bang_ke = dt.Rows[i]["ma_bang_ke"].ToString();
BangKe[i].ma_khach_hang = dt.Rows[i]["ma_khach_hang"].ToString();
BangKe[i].ngay_van_chuyen = Convert.ToDateTime(dt.Rows[i]["ngay_van_chuyen"].ToString());
BangKe[i].khoi_luong = float.Parse(dt.Rows[i]["khoi_luong"].ToString());
BangKe[i].noi_nhan = dt.Rows[i]["noi_nhan"].ToString();
BangKe[i].noi_giao = dt.Rows[i]["noi_giao"].ToString();
BangKe[i].don_gia_tan = float.Parse(dt.Rows[i]["don_gia_tan"].ToString());
BangKe[i].don_gia_chuyen = float.Parse(dt.Rows[i]["don_gia_chuyen"].ToString());
BangKe[i].ghi_chu = dt.Rows[i]["ghi_chu"].ToString();
BangKe[i].ma_dieu_xe = dt.Rows[i]["ma_dieu_xe"].ToString();
string msx = "select ma_so_xe from dm_dieu_xe,dm_bang_bao_gia where ma_khach_hang='" + ct.ma_khach_hang.Trim() + "' and dm_bang_bao_gia.noi_nhan=dm_dieu_xe.noi_nhan and dm_bang_bao_gia.noi_giao=dm_dieu_xe.noi_giao and ngay_ve is not NULL and tinh_trang_thanh_toan=0 and ma_dieu_xe='" + dt.Rows[i]["ma_dieu_xe"].ToString().Trim() + "'";
DataTable dtt = data.ExcuteDataTable(msx, null);
foreach (DataRow dr in dtt.Rows)
{
BangKe[i].so_xe += dr["ma_so_xe"].ToString().Trim() + " ; ";
}
}
return(BangKe);
}
return(null);
}
public DTO_BangKe[] _List_Chi_Tiet_Hoa_Hon_Van_Chuyen(DTO_Chi_Tiet_Hoa_Don ct)
{
return(new DAL_HoaDon()._List_Chi_Tiet_Hoa_Hon_Van_Chuyen(ct));
}
