private void HienThiThongTinTC(DTO.DTO_TiecCuoi tc)
{
DTO.DTO_Sanh s = BUS_DatTiecCuoi.getThongTinSanh(tc.MA_SANH);
DTO.DTO_Ca c = BUS_DatTiecCuoi.getThongTinCa(tc.MA_CA);
dateTimePicker1.Text = tc.NGAY_TO_CHUC;
cmbCa.Text = c.MA_CA;
}
public static DTO.DTO_Sanh getThongTinSanh(String maS)
{
String sql = String.Format(@"SELECT * FROM SANH WHERE MA_SANH = '{0}'", maS);
DataTable da = DatabaseHelper.GetData(sql);
DTO.DTO_Sanh result = null;
if (da.Rows.Count > 0)
{
result = new DTO.DTO_Sanh();
DataRow row = da.Rows[0];
result.MA_SANH = maS;
result.TEN_SANH = row["TEN_SANH"].ToString();
result.MA_LOAI_SANH = row["MA_LOAI_SANH"].ToString();
result.SO_LUONG_BAN = int.Parse(row["SO_LUONG_BAN"].ToString());
result.GHI_CHU = row["GHI_CHU"].ToString();
}
return(result);
}
private void HienThiHoaDon(string ma)
{
DTO.DTO_TiecCuoi tc = BUS.BUS_LapHoaDon.getThongTinTiecCuoi(ma);
DTO.DTO_KhachHang kh = BUS.BUS_LapHoaDon.getThongTinKhachHang(tc.MA_KHACH_HANG);
DTO.DTO_Sanh sanh = BUS.BUS_LapHoaDon.getThongTinSanh(tc.MA_SANH);
DTO.DTO_LoaiSanh ls = BUS.BUS_LapHoaDon.getThongTinLoaiSanh(sanh.MA_LOAI_SANH);
lbTenChuRe.Text = kh.TEN_CHU_RE;
lbTenCoDau.Text = kh.TEN_CO_DAU;
lbSDT.Text = kh.SDT;
lbSanh.Text = sanh.TEN_SANH;
lbSLBan.Text = (tc.SL_BAN + tc.SL_BAN_DU_TRU).ToString();
lbDonGia.Text = ls.DON_GIA_TOI_THIEU.ToString();
lbNgayToChuc.Text = tc.NGAY_TO_CHUC.ToString().Split()[0];
lbTienDatCoc.Text = tc.TIEN_DAT_COC.ToString();
lbTongTienBan.Text = ((tc.SL_BAN + tc.SL_BAN_DU_TRU) * ls.DON_GIA_TOI_THIEU - tc.TIEN_DAT_COC).ToString();
HienThiDsMonAn(tc.MA_TIEC_CUOI);
HienThiDsDichVu(tc.MA_TIEC_CUOI);
TinhTienPhat();
}
