public static List <BCDoanhThuDTO> DoanhThuTheoLoaiPhongTheoThang(BCDoanhThuDTO infor)
{
DateTime ntm_min = Convert.ToDateTime("1990-01-01");
DateTime ntm_max = Convert.ToDateTime("1990-01-31");
string n1 = "-01"; string n2 = "-31"; string t = (infor.Thang).ToString(); string nam = (infor.Nam).ToString();
if (infor.Thang == 2)
{
if ((infor.Nam % 4 != 0) || ((infor.Nam % 100 == 0) && (infor.Nam % 400 != 0)))
{
n2 = "-28";
}
else
{
n2 = "-29";
}
}
else if (infor.Thang == 4 || infor.Thang == 6 || infor.Thang == 9 || infor.Thang == 11)
{
n2 = "-30";
}
string ntmold = nam + "-" + t + n1;
string ntmnew = nam + "-" + t + n2;
ntm_min = Convert.ToDateTime(ntmold);
ntm_max = Convert.ToDateTime(ntmnew);
return(RepostDAO.DoanhThuTheoLoaiPhongTheoThang(ntm_min, ntm_max));
}
private void btnXem_Click(object sender, EventArgs e)
{
BCDoanhThuDTO infor = new BCDoanhThuDTO();
List <BCDoanhThuDTO> dlst = new List <BCDoanhThuDTO>();
if (txtNam.Text == "" && cmbThang.Text == "")
{
decimal sum = 0;
lst = RepostBUS.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 = RepostBUS.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;
}
}
