private void FTraNoNCC_Load(object sender, EventArgs e)
{
if (MKho.Get(MKho.KHO_HANG).Count() == 0 || MNcc.Get().Count() == 0)
{
MessageBox.Show("CẦN TẠO KHO VÀ NHÀ CUNG CẤP TRƯỚC");
this.Close();
return;
}
comboBoxKHO.DataSource = DataInstance.Instance().DBContext().KHOes.Where(u => u.TYPE <= 1).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
comboBoxNCC.DataSource = T_Manager.Modal.MNcc.Get();//DataInstance.Instance().DBContext().NHA_CUNG_CAP;
comboBoxNCC.DisplayMember = "NAME";
comboBoxNCC.ValueMember = "ID";
comboBoxNCC_SelectedIndexChanged(sender, e);
foreach (Control c in this.Controls)
{
if (c.GetType().ToString() == "System.Windows.Forms.TextBox")
{
c.KeyPress += new KeyPressEventHandler(c_KeyPress);
}
}
dataGridView1.AutoResizeColumns();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void buttonVIEW_Click(object sender, EventArgs e)
{
var _ncc = long.Parse(comboBoxNCC.SelectedValue.ToString());
var _from = dateTimePickerFROM.Value;
var _to = dateTimePickerTO.Value;
string note = "";
BindingSource bs = new BindingSource();
if (checkBoxTRANO.Checked == false)
{
bs.DataSource = (from nh in DataInstance.Instance().DBContext().NHAP_HANG
join kho in DataInstance.Instance().DBContext().KHOes on nh.MAKHO equals kho.ID
join ncc in DataInstance.Instance().DBContext().NHA_CUNG_CAP on nh.MANCC equals ncc.ID
join hh in DataInstance.Instance().DBContext().HANG_HOA on nh.MAHH equals hh.ID
where nh.MANCC == _ncc
where nh.NGAY_NHAP >= _from
where nh.NGAY_NHAP <= _to
select new
{
NGAY = nh.NGAY_NHAP,
KHO = kho.NAME,
HANGHOA = hh.NAME,
SOLUONG = nh.SO_LUONG,
DONGIA = nh.DON_GIA_MUA,
THANHTIEN = nh.SO_LUONG * nh.DON_GIA_MUA
});
CrystalReportCHITIETNONCC rpt = new CrystalReportCHITIETNONCC();
rpt.SetDataSource(bs);
rpt.SetParameterValue("NCC", comboBoxNCC.Text);
rpt.SetParameterValue("FROM", _from);
rpt.SetParameterValue("TO", _to);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
crystalReportViewer1.ReportSource = rpt;
}
else
{
List <CThanhToanNCC> lst = new List <CThanhToanNCC>();
foreach (NHAP_HANG nh in DataInstance.Instance().DBContext().NHAP_HANG
.Where(u => u.MANCC == _ncc && u.NGAY_NHAP >= _from && u.NGAY_NHAP <= _to))
{
lst.Add(new CThanhToanNCC
{
NGAY = nh.NGAY_NHAP,
KHO = MKho.GetNamebyID(nh.MAKHO),
HANGHOA = MHangHoa.GetNameByID(nh.MAHH),
DONGIA = nh.DON_GIA_MUA,
SOLUONG = nh.SO_LUONG,
THANHTIEN = nh.SO_LUONG * nh.DON_GIA_MUA,
TIENTHANHTOAN = 0,
CONNO = 0,
THANHTOAN = "-",
});
}
foreach (TRA_NO_NCC tn in DataInstance.Instance().DBContext().TRA_NO_NCC
.Where(u => u.MANCC == _ncc && u.NGAY_TRA >= _from && u.NGAY_TRA <= _to))
{
lst.Add(new CThanhToanNCC
{
NGAY = tn.NGAY_TRA,
KHO = MKho.GetNamebyID(tn.MAKHO),
HANGHOA = "-",
DONGIA = 0,
SOLUONG = 0,
TIENTHANHTOAN = tn.TONG_TIEN,
CONNO = 0,
THANHTOAN = "TRẢ NỢ NCC",
});
}
var datasource = lst.OrderBy(u => u.NGAY);
long nodauki = MNcc.NoTO(_ncc, _from) - MNcc.TraNoTO(_ncc, _from);
long _nodauki = nodauki;
foreach (CThanhToanNCC c in datasource)
{
c.CONNO = nodauki - c.TIENTHANHTOAN + c.THANHTIEN;
nodauki = c.CONNO;
}
bs.DataSource = lst;
CrystalReportTHANHTOANNCC rpt = new CrystalReportTHANHTOANNCC();
rpt.SetDataSource(bs);
rpt.SetParameterValue("NCC", comboBoxNCC.Text);
rpt.SetParameterValue("FROM", _from);
rpt.SetParameterValue("TO", _to);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
rpt.SetParameterValue("NODAUKI", _nodauki);
crystalReportViewer1.ReportSource = rpt;
}
}
private void comboBoxDULIEU_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
long l = long.Parse(comboBoxDULIEU.SelectedValue.ToString());
List <object> ls = new List <object>();
IQueryable lst;
switch (l)
{
case 0:
lst = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.ID);
foreach (KHO k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.NAME
});
}
break;
case 1:
lst = MKho.Get(MKho.KHO_TK_NGANHANG);
foreach (KHO k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.NAME
});
}
break;
case 2:
lst = MHangHoa.Get();
foreach (HANG_HOA k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.NAME
});
}
break;
case 3:
lst = MNcc.Get();
foreach (NHA_CUNG_CAP k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.NAME
});
}
break;
case 4:
lst = db.NHAN_VIEN;
foreach (NHAN_VIEN k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.NAME
});
}
break;
case 5:
lst = db.XEs;
foreach (XE k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.BIEN_SO
});
}
break;
case 6:
lst = db.NGUON_VAY;
foreach (NGUON_VAY k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.NAME
});
}
break;
case 7:
lst = db.KHACH_HANG;
foreach (KHACH_HANG k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.NAME
});
}
break;
}
listBoxKHO.DataSource = ls;
listBoxKHO.DisplayMember = "NAME";
listBoxKHO.ValueMember = "ID";
}
catch (Exception ex)
{
}
}
private void NhapHang_Load(object sender, EventArgs e)
{
if (MKho.Get(MKho.KHO_HANG).Count() == 0 || MHangHoa.Get().Count() == 0 || MNcc.Get().Count() == 0)
{
MessageBox.Show("CẦN TẠO KHO, HÀNG HÓA VÀ NHÀ CUNG CẤP TRƯỚC KHI NHẬP HÀNG");
this.Close();
return;
}
var i2nKHO = new Id2Name(textBoxMAKHO, comboBoxKho);
var i2nKH = new Id2Name(textBoxNCC, comboBoxNCC);
var i2nHH = new Id2Name(textBoxHANGHOA, comboBoxHANGHOA);
comboBoxKho.DataSource = T_Manager.Modal.MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);//dbContext.KHOes.Where(u => u.TYPE == 0);
comboBoxKho.DisplayMember = "NAME";
comboBoxKho.ValueMember = "ID";
comboBoxNCC.DataSource = T_Manager.Modal.MNcc.Get().OrderBy(u => u.NAME);//dbContext.NHA_CUNG_CAP;
comboBoxNCC.DisplayMember = "NAME";
comboBoxNCC.ValueMember = "ID";
comboBoxHANGHOA.DataSource = dbContext.HANG_HOA.OrderBy(u => u.NAME);
comboBoxHANGHOA.DisplayMember = "NAME";
comboBoxHANGHOA.ValueMember = "ID";
dataGridView1.DataSource = bs;
comboBoxHANGHOA_SelectedIndexChanged(sender, e);
dataGridView1.AutoResizeColumns();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
textBoxMAKHO.Select();
textBoxMAKHO.SelectAll();
}
