void LoadData3()
{
using (_khieunaitocaoContext = new khieunaitocaoContextDataContext())
{
try
{
List <BieuDo> bieudo = new List <BieuDo>();
var db = new BieuDo();
var _bieudo1 = _khieunaitocaoContext.bieudo_cot_donthukhieunai(dinhdanh.madonvi, Int16.Parse(cmb_nam_khieunai.Text)).ToList();
foreach (var item in _bieudo1)
{
db.thang = item.thang;
db.tong = item.tong;
bieudo.Add(db);
}
for (int i = 1; i < 13; i++)
{
if (_bieudo1.Count(p => p.thang == i) == 0)
{
db.thang = i;
db.tong = 0;
bieudo.Add(db);
}
}
bieudocot_khieunai.DataSource = bieudo.ToList();
}
catch {
XtraMessageBox.Show("Có lỗi xảy ra");
}
}
}
public JsonResult ThongKeAll(string LoaiThongKe)
{
BieuDo bd = new BieuDo();
DonDatHangModel donDatHangModel = new DonDatHangModel();
List <BieuDo> lsbd = new List <BieuDo>();
string LoaiBieuDo = "";
for (int i = 1; i <= 12; i++)
{
bd = new BieuDo();
bd.Thang = i;
if (LoaiThongKe == "1")
{
LoaiBieuDo = "tổng";
bd.TongTien = donDatHangModel.GetDataBieuDo(i, 0, 0);
lsbd.Add(bd);
}
if (LoaiThongKe == "2")
{
LoaiBieuDo = "sản phẩm";
bd.TongTien = donDatHangModel.GetDataBieuDo(i, 0, 4);
lsbd.Add(bd);
}
if (LoaiThongKe == "3")
{
LoaiBieuDo = "dịch vụ";
bd.TongTien = donDatHangModel.GetDataBieuDo(i, 4, 0);
lsbd.Add(bd);
}
}
return(Json(new { data = lsbd, LBD = LoaiBieuDo }, JsonRequestBehavior.AllowGet));
}
