private void btnThuoc_Click(object sender, EventArgs e)
{
BaoCaoBUS bus = new BaoCaoBUS();
crvBaoCao.ReportSource = bus.getCRSuDungThuoc(cbThang.SelectedIndex, nupNam.Value.ToString());
isDT = false;
}
private void btnDoanhThu_Click(object sender, EventArgs e)
{
BaoCaoBUS bus = new BaoCaoBUS();
crvBaoCao.ReportSource = bus.getCRDoanhThu(cbThang.SelectedIndex, nupNam.Value.ToString());
isDT = true;
}
private void button1_Click(object sender, EventArgs e)
{
if (this.radioButton_BaoCaoTheoTheLoai.Checked == true)
{
bcBus = new BaoCaoBUS();
List <TheLoaiDTO> list;
list = bcBus.select();
tlBUS = new TheLoaiBUS();
listTheLoai = tlBUS.select("");
listBaoCao = new List <BaoCaoDTO>();
pmBus = new PhieuMuonBUS();
int countnow = 0;
listPhieuMuon = pmBus.select();
foreach (PhieuMuonDTO tl in listPhieuMuon)
{
if (tl.NgayMuon.Month == this.dateTimePicker1.Value.Month)
{
countnow++;
}
}
foreach (TheLoaiDTO tl in listTheLoai)
{
int count = 0;
foreach (TheLoaiDTO theloaimuon in list)
{
if (theloaimuon.Ngay.Month == this.dateTimePicker1.Value.Month)
{
if (tl.MaTheLoai == theloaimuon.MaTheLoai)
{
count++;
}
}
}
BaoCaoDTO temp = new BaoCaoDTO();
temp.MaTheLoai = tl.MaTheLoai;
temp.SoLuotMuong = count;
Console.WriteLine(countnow);
if (countnow == 0)
{
temp.TyLe = "0%";
}
else
{
temp.TyLe = "" + (count / countnow) * 100 + "%";
}
temp.TenTheLoai = tl.TenTheLoai;
listBaoCao.Add(temp);
}
this.label_TongSoLuotMuon.Text = countnow.ToString();
loadBaoCaoTheLoai_Vao_GridView(listBaoCao);
}
}
public frmLapBaoCaoThang()
{
InitializeComponent();
for (int i = 1; i <= 12; i++)
{
string[] numbers = { i.ToString() };
comboBoxBCT.Items.AddRange(numbers);
comboBoxBCCN.Items.AddRange(numbers);
}
bus = new BaoCaoBUS();
}
private void btnRF_Click(object sender, EventArgs e)
{
BaoCaoBUS bus = new BaoCaoBUS();
if (isDT)
{
crvBaoCao.ReportSource = bus.getCRDoanhThu(cbThang.SelectedIndex, nupNam.Value.ToString());
}
else
{
crvBaoCao.ReportSource = bus.getCRSuDungThuoc(cbThang.SelectedIndex, nupNam.Value.ToString());
}
}
private void getDTData(string thang, string nam)
{
//dgvDT.Columns.Add("dgvDTCol1", "a b c");
BaoCaoBUS bus = new BaoCaoBUS();
lstbcDT = bus.getBaoCaoDT(thang, nam);
dgvDT.Rows.Clear();
for (int i = 0; i < lstbcDT.Count(); i++)
{
dgvDT.Rows.Add(lstbcDT[i].getID(), lstbcDT[i].getNgay(), lstbcDT[i].getSoBenhNhan(), lstbcDT[i].getDoanhThu(), lstbcDT[i].getTyLe());
}
/*BindingSource binding = new BindingSource();
* binding.DataSource = lstbcDT;
*
* //bind datagridview to binding source
* dgvDT.DataSource = binding;*/
}
private void btnXem_Click(object sender, EventArgs e)
{
BaoCaoDoanhThuDTO infor = new BaoCaoDoanhThuDTO();
List <BaoCaoDoanhThuDTO> dlst = new List <BaoCaoDoanhThuDTO>();
if (txtNam.Text == "" && cmbThang.Text == "")
{
decimal sum = 0;
lst = BaoCaoBUS.TinhTongDoanhThuTheoLoaiPhong();
for (int i = 0; i < lst.Count; i++)
{
lst[i].TongDoanhThu = Convert.ToDecimal(string.Format("{0:0,0}", lst[i].TongDoanhThu));
}
gridControl1.DataSource = lst;
for (int i = 0; i < gridView1.RowCount; i++)
{
sum += lst[i].TongDoanhThu.Value;
}
for (int i = 0; i < gridView1.RowCount; i++)
{
decimal cd = (lst[i].TongDoanhThu.Value * 100) / sum;
cd = Math.Round(cd, 2);
lst[i].TiLe = (cd).ToString() + "%";
}
//btnLuu.Enabled = false;
txtTongTien.Text = string.Format("{0:0,0 VNĐ}", sum);
}
else if (txtNam.Text != "" && cmbThang.Text != "")
{
decimal sum = 0;
infor.Thang = Convert.ToInt32(cmbThang.Text);
infor.Nam = Convert.ToInt32(txtNam.Text);
/*try
* {
* dlst = BaoCaoBUS.LayMaBCDoanhThuKeTiep();
* infor.MaBCDoanhThu = dlst[0].MaBCDoanhThu + 1;
* dlst = BaoCaoBUS.LayMaBCCTDoanhThuKeTiep();
* infor.MaCTBCDoanhThu = dlst[0].MaCTBCDoanhThu + 1;
* }
* catch
* {
* infor.MaBCDoanhThu = 1;
* infor.MaCTBCDoanhThu = 1;
* }*/
lst = BaoCaoBUS.DoanhThuTheoLoaiPhongTheoThang(infor);
for (int i = 0; i < lst.Count; i++)
{
lst[i].TongDoanhThu = Convert.ToDecimal(string.Format("{0:0,0}", lst[i].TongDoanhThu));
}
gridControl1.DataSource = lst;
for (int i = 0; i < gridView1.RowCount; i++)
{
sum += lst[i].TongDoanhThu.Value;
}
for (int i = 0; i < gridView1.RowCount; i++)
{
decimal cd = (lst[i].TongDoanhThu.Value * 100) / sum;
cd = Math.Round(cd, 2);
lst[i].TiLe = (cd).ToString() + "%";
lst[i].Thang = Convert.ToInt32(cmbThang.Text);
lst[i].Nam = Convert.ToInt32(txtNam.Text);
//lst[i].MaBCDoanhThu = infor.MaBCDoanhThu;
//lst[i].MaCTBCDoanhThu = infor.MaCTBCDoanhThu;
}
txtTongTien.Text = string.Format("{0:0,0 VNĐ}", sum);
//btnLuu.Enabled = true;
}
}
