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();
}
private void FChi_Load(object sender, EventArgs e)
{
var i2nKHO = new Id2Name(textBoxMAKHO, comboBoxKHO);
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
comboBoxNHANVIEN.DataSource = dbContext.NHAN_VIEN.OrderBy(u => u.NAME);
comboBoxNHANVIEN.DisplayMember = "NAME";
comboBoxNHANVIEN.ValueMember = "ID";
comboBoxNBXE.DataSource = dbContext.XEs.OrderBy(u => u.BIEN_SO);
comboBoxNBXE.DisplayMember = "BIEN_SO";
comboBoxNBXE.ValueMember = "ID";
comboBoxNBXANGDAU.DataSource = dbContext.HANG_HOA.OrderBy(u => u.NAME);
comboBoxNBXANGDAU.DisplayMember = "NAME";
comboBoxNBXANGDAU.ValueMember = "ID";
comboBoxKHO_SelectedIndexChanged(sender, e);
comboBoxNHANVIEN_SelectedIndexChanged(sender, e);
radioButtonXANGDAU_CheckedChanged(sender, e);
}
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 FVay_Load(object sender, EventArgs e)
{
if (MKho.Get(MKho.KHO_HANG).Count() == 0 || DataInstance.Instance().DBContext().NGUON_VAY.Count() == 0)
{
MessageBox.Show("CẦN TẠO KHO VÀ NGUỒN VAY TRƯỚC KHI VAY");
this.Close();
return;
}
var i2nKHO = new Id2Name(textBoxMAKHO, comboBoxKHO);
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
comboBoxNGUONVAY.DataSource = DataInstance.Instance().DBContext().NGUON_VAY;
comboBoxNGUONVAY.DisplayMember = "NAME";
comboBoxNGUONVAY.ValueMember = "ID";
dataGridView1.DataSource = bs;
comboBoxNGUONVAY_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 FXuatHang_Load(object sender, EventArgs e)
{
dataGridView1.DataSource = bs;
dateTimePickerDATE_ValueChanged(sender, e);
groupBox2.Enabled = false;
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
comboBoxHANGHOA.DataSource = dbContext.HANG_HOA.OrderBy(u => u.NAME);
comboBoxHANGHOA.DisplayMember = "NAME";
comboBoxHANGHOA.ValueMember = "ID";
var lst = dbContext.KHACH_HANG.OrderBy(u => u.ID);
List <object> ls = new List <object>();
ls.Add(new
{
ID = (long)-1,
NAME = "-1 - BÁN MẶT"
});
foreach (KHACH_HANG k in lst)
{
ls.Add(new
{
ID = k.ID,
NAME = k.ID.ToString() + " - " + k.NAME
});
}
listBoxKHACHHANG.DataSource = ls;
listBoxKHACHHANG.DisplayMember = "NAME";
listBoxKHACHHANG.ValueMember = "ID";
}
private void FChiTietChuyenTien_Load(object sender, EventArgs e)
{
dateTimePickerFROM.Value = dateTimePickerTO.Value.AddMonths(-1);
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_TK_NGANHANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
}
private void FChiTungKho_Load(object sender, EventArgs e)
{
dateTimePickerFROM.Value = DateTime.Now.AddMonths(-1);
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
}
private void FThuNo_Load(object sender, EventArgs e)
{
if (MKho.Get(MKho.KHO_HANG).Count() == 0)
{
MessageBox.Show("CẦN TẠO KHO TRƯỚC");
this.Close();
return;
}
var i2nKHO = new Id2Name(textBoxMAKHO, comboBoxKHO);
var i2nKH = new Id2Name(textBoxKHACHHANG, comboBoxKHACHHANG);
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
comboBoxKHACHHANG.DataSource = DataInstance.Instance().DBContext().KHACH_HANG.OrderBy(u => u.NAME);
comboBoxKHACHHANG.DisplayMember = "NAME";
comboBoxKHACHHANG.ValueMember = "ID";
comboBoxKHO_SelectedIndexChanged(sender, e);
foreach (Control c in this.Controls)
{
if (c.GetType().ToString() == "System.Windows.Forms.TextBox")
{
c.KeyPress += new KeyPressEventHandler(c_KeyPress);
}
}
radioButtonNOHH_CheckedChanged(sender, e);
}
private void XuatHang_Load(object sender, EventArgs e)
{
var i2nKHO = new Id2Name(textBoxMAKHO, comboBoxKho);
var i2nKH = new Id2Name(textBoxKHACHHANG, comboBoxKHACH_HANG);
var i2nHH = new Id2Name(textBoxHANGHOA, comboBoxHANGHOA);
if (MKho.Get(MKho.KHO_HANG).Count() == 0 || MHangHoa.Get().Count() == 0)
{
MessageBox.Show("CẦN TẠO KHO VÀ HÀNG HÓA TRƯỚC KHI XUẤT HÀNG");
this.Close();
return;
}
comboBoxKho.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKho.DisplayMember = "NAME";
comboBoxKho.ValueMember = "ID";
comboBoxKHACH_HANG.DataSource = dbContext.KHACH_HANG.OrderBy(u => u.NAME);
comboBoxKHACH_HANG.DisplayMember = "NAME";
comboBoxKHACH_HANG.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();
}
private void FTongHopCongNo_Load(object sender, EventArgs e)
{
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
dateTimePicker1.Value = dateTimePicker1.Value.AddMonths(-1);
}
private void FChuyenTien_Load(object sender, EventArgs e)
{
listBoxTAIKHOAN.DataSource = MKho.Get(MKho.KHO_TK_NGANHANG);
listBoxTAIKHOAN.DisplayMember = "NAME";
listBoxTAIKHOAN.ValueMember = "ID";
textBoxTIENTON.Text = Utility.StringToVND(MKho.Tong_Tien_Hien_Tai(DateTime.Now).ToString());
dateTimePickerNGAY.Select();
}
private void FTonKho_Load(object sender, EventArgs e)
{
if (MKho.Get(MKho.KHO_HANG).Count() == 0 || MHangHoa.Get().Count() == 0)
{
MessageBox.Show("CẦN TẠO KHO, HÀNG HÓA TRƯỚC KHI NHẬP");
this.Close();
return;
}
Reload();
}
private void FTaiKhoan_Load(object sender, EventArgs e)
{
bs.DataSource = MKho.Get(MKho.KHO_TK_NGANHANG);
dataGridView1.DataSource = bs;
dataGridView1.Columns[0].HeaderText = "MÃ";
dataGridView1.Columns[1].HeaderText = "TÊN";
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[3].HeaderText = "SỐ TÀI KHOẢN";
dataGridView1.AutoResizeColumns();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
textBoxTEN.Select();
}
private void FThuNo_Load(object sender, EventArgs e)
{
groupBox2.Enabled = false;
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
comboBoxKHACHHANG.DataSource = db.KHACH_HANG.OrderBy(u => u.NAME);
comboBoxKHACHHANG.DisplayMember = "NAME";
comboBoxKHACHHANG.ValueMember = "ID";
dateTimePickerDATE_ValueChanged(sender, e);
}
private void FBanHang_Load(object sender, EventArgs e)
{
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
comboBoxHANGHOA.DataSource = MHangHoa.Get();
comboBoxHANGHOA.DisplayMember = "NAME";
comboBoxHANGHOA.ValueMember = "ID";
DateTime now = DateTime.Now.Date;
comboBoxKHO_SelectedIndexChanged(sender, e);
textBoxDONGIABAN.Select();
textBoxDONGIABAN.SelectAll();
}
private void FChoVay_Load(object sender, EventArgs e)
{
if (MKho.Get(MKho.KHO_HANG).Count() == 0 || DataInstance.Instance().DBContext().KHACH_HANG.Count() == 0)
{
MessageBox.Show("CẦN TẠO KHO VÀ KHÁCH HÀNG TRƯỚC");
this.Close();
return;
}
var i2nKHO = new Id2Name(textBoxMAKHO, comboBoxKHO);
var i2nKH = new Id2Name(textBoxKHACHHANG, comboBoxKHACHHANG);
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
comboBoxKHACHHANG.DataSource = DataInstance.Instance().DBContext().KHACH_HANG.OrderBy(u => u.NAME);
comboBoxKHACHHANG.DisplayMember = "NAME";
comboBoxKHACHHANG.ValueMember = "ID";
dataGridViewCHOVAY.DataSource = bs;
comboBoxKHACHHANG_SelectedIndexChanged(sender, e);
textBoxMAKHO.Select();
textBoxMAKHO.SelectAll();
}
private void buttonVIEW_Click(object sender, EventArgs e)
{
var _from = dateTimePickerFROM.Value.Date;
BindingSource bs = new BindingSource();
CrystalReportXEMKHOQUY rpt = new CrystalReportXEMKHOQUY();
List <CXemKhoQuy> list = new List <CXemKhoQuy>();
var khos = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
foreach (KHO k in khos)
{
CXemKhoQuy c = new CXemKhoQuy();
c.KHO = k.NAME;
c.CHI = MKho.Total_Chi(k.ID, _from, _from);
c.THU = MKho.Total_Thu(k.ID, _from, _from);
c.TONGTIEN = c.THU - c.CHI;
list.Add(c);
}
bs.DataSource = list;
rpt.SetDataSource(bs);
rpt.SetParameterValue("DATE", _from);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
crystalReportViewer1.ReportSource = rpt;
}
private void FCongSoHangNgay_Load(object sender, EventArgs e)
{
comboBoxKHO.DataSource = MKho.Get(MKho.KHO_HANG).OrderBy(u => u.NAME);
comboBoxKHO.DisplayMember = "NAME";
comboBoxKHO.ValueMember = "ID";
}
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)
{
}
}
