public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportCONGNOKHACHHANG rpt = new CrystalReportCONGNOKHACHHANG();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
List <CCongNoNew> _datasource = new List <CCongNoNew>();
string note = "";
BindingSource bs = new BindingSource();
long MAKH = long.Parse(comboBox1.SelectedValue.ToString());
DateTime FROM = dateTimePickerFROM.Value.Date;
DateTime TO = dateTimePickerTO.Value.Date;
var xuat_hang = db.XUAT_HANG.Where(u => u.MAKH == MAKH && u.NGAY_XUAT >= FROM && u.NGAY_XUAT <= TO);
var thu_no = db.THU_NO.Where(u => u.MAKH == MAKH && u.NGAY_TRA >= FROM && u.NGAY_TRA <= TO);
foreach (XUAT_HANG xh in xuat_hang)
{
HANG_HOA _hh = MHangHoa.GetByID(xh.MAHH);
string unit = _hh == null ? "" : _hh.UNIT;
long dongia = _hh == null ? 0 : xh.DON_GIA_BAN;
long soluong = _hh == null ? 0 : xh.SO_LUONG;
_datasource.Add(new CCongNoNew
{
NGAY = xh.NGAY_XUAT.Value,
TRANO = soluong < 0 ? "Nhập bù" : "",
TRATRUOC = xh.TRA_TRUOC,
HANGHOA = MHangHoa.GetNameByID(xh.MAHH),
SOLUONG = soluong,
DONVITINH = unit,
DONGIA = dongia,
THANHTIEN = xh.THANH_TIEN,
TRAGOC = 0,
TRALAI = 0,
CONNO = 0
});
}
foreach (THU_NO xh in thu_no)
{
_datasource.Add(new CCongNoNew
{
NGAY = xh.NGAY_TRA,
TRATRUOC = 0,
TRANO = "Trả nợ",
HANGHOA = "",
SOLUONG = 0,
DONVITINH = "",
DONGIA = 0,
THANHTIEN = 0,
TRAGOC = xh.TIEN_GOC,
TRALAI = xh.TIEN_LAI,
CONNO = 0
});
}
var datasource = _datasource.OrderBy(u => u.NGAY);
long no = checkBoxNODAUKI.Checked == true?MXuatHang.TongNoDauKi(MAKH, FROM) - MThuNo.TongGocDauKi(MAKH, FROM) : 0;
long nodauki = no;
foreach (CCongNoNew c in datasource)
{
c.CONNO = no + c.THANHTIEN - c.TRATRUOC - c.TRAGOC;
no = c.CONNO;
}
bs.DataSource = datasource;
CrystalReportCONGNOKHACHHANG rpt = new CrystalReportCONGNOKHACHHANG();
rpt.SetDataSource(bs);
rpt.SetParameterValue("KH", comboBox1.Text);
rpt.SetParameterValue("FROM", dateTimePickerFROM.Value);
rpt.SetParameterValue("TO", dateTimePickerTO.Value);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
rpt.SetParameterValue("NODAUKI", nodauki);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Zoom(150);
}