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)); }