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 buttonIMPORT_Click(object sender, EventArgs e)
{
MyApp = new Excel.Application();
MyApp.Visible = false;
MyBook = MyApp.Workbooks.Open(textBox1.Text);
hhSheet = (Excel.Worksheet)MyBook.Sheets[1];
tonSheet = (Excel.Worksheet)MyBook.Sheets[2];
long hhCount = hhSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row;
long khoCount = tonSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Column;
DataInstance.Instance().DBContext();
// HANG HOA
for (int index = 2; index <= hhCount; index++)
{
System.Array MyValues = (System.Array)hhSheet.get_Range("A" +
index.ToString(), "B" + index.ToString()).Cells.Value;
DataInstance.Instance().DBContext().AddToHANG_HOA(new HANG_HOA
{
NAME = MyValues.GetValue(1, 1).ToString(),
UNIT = MyValues.GetValue(1, 2).ToString(),
});
}
// KHO
for (int index = 2; index <= khoCount; index++)
{
string MyValues = tonSheet.Cells[1, index].Value;
DataInstance.Instance().DBContext().AddToKHOes(new KHO
{
NAME = MyValues,
TYPE = MKho.KHO_HANG
});
DataInstance.Instance().DBContext().SaveChanges();
for (int i = 2; i <= hhCount; i++)
{
long sl = long.Parse(tonSheet.Cells[i, index].Value.ToString());
long dongia = long.Parse(hhSheet.Cells[i, 3].Value.ToString());
DataInstance.Instance().DBContext().AddToNHAP_HANG(new NHAP_HANG
{
MAKHO = MKho.GetIDbyName(tonSheet.Cells[1, index].Value.ToString()),
MANCC = -1,
MAHH = MHangHoa.GetIDbyName(hhSheet.Cells[i, 1].Value.ToString()),
SO_LUONG = sl,
SL_CON_LAI = sl,
DON_GIA_MUA = dongia,
NGAY_NHAP = DateTime.Now.Date,
CREATED_AT = DateTime.Now
});
}
}
DataInstance.Instance().DBContext().SaveChanges();
MessageBox.Show("Cập nhật dữ liệu thành công\nVui lòng khởi động lại chương trình");
MyBook.Close();
MyApp.Quit();
MHeTHong.Set(MHeTHong.DATE, DateTime.Now.ToLongDateString());
Application.Exit();
}
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 buttonVIEW_Click(object sender, EventArgs e)
{
long _kho = long.Parse(comboBoxKHO.SelectedValue.ToString());
DateTime _from = dateTimePickerFROM.Value;
DateTime _to = dateTimePickerTO.Value;
BindingSource bs = new BindingSource();
List <CNhapXuatTungKho> list = new List <CNhapXuatTungKho>();
// Tất cả hàng hóa
var hh = (from _hh in DataInstance.Instance().DBContext().HANG_HOA orderby _hh.NAME select _hh);
foreach (HANG_HOA h in hh)
{
CNhapXuatTungKho c = new CNhapXuatTungKho();
c.HANGHOA = h.NAME;
c.TONDAU = MKho.TON_DAU(_kho, _from, h.ID);
c.NHAP = MKho.Total_Nhap_To(_kho, _from, _to, true, h.ID);
c.XUAT = MKho.Total_Xuat_To(_kho, _from, _to, true, h.ID);
c.TONCUOI = MKho.TON_CUOI(_kho, _to, h.ID);
list.Add(c);
}
bs.DataSource = list;
CrystalReportNHAPXUATTUNGKHO rpt = new CrystalReportNHAPXUATTUNGKHO();
rpt.SetDataSource(bs);
rpt.SetParameterValue("KHO", comboBoxKHO.Text);
rpt.SetParameterValue("FROM", dateTimePickerFROM.Value);
rpt.SetParameterValue("TO", dateTimePickerTO.Value);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Zoom(150);
}
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 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 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 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 button1_Click(object sender, EventArgs e)
{
long xe = long.Parse(comboBox1.SelectedValue.ToString());
DateTime from = dateTimePickerFROM.Value.Date;
DateTime to = dateTimePickerTO.Value.Date;
var lst = DataInstance.Instance().DBContext().CHI_TIEU_DUNG_NOI_BO.Where(u => u.MAXE == xe)
.Where(u => u.NGAY_CHI >= from && u.NGAY_CHI <= to)
.OrderBy(u => u.NGAY_CHI);
List <object> list = new List <object>();
foreach (CHI_TIEU_DUNG_NOI_BO nb in lst)
{
list.Add(new
{
NGAY = nb.NGAY_CHI,
KHO = MKho.GetNamebyID(nb.MAKHO),
NOIDUNG = nb.NOI_DUNG,
HANGHOA = nb.MAHH == -1 ? "" : MHangHoa.GetNameByID(nb.MAHH),
SOLUONG = nb.SO_LUONG,
DONGIA = nb.DON_GIA_BAN,
THANHTIEN = nb.TONG_TIEN,
});
}
CrystalReportCHIDUNGCHOXE rpt = new CrystalReportCHIDUNGCHOXE();
rpt.SetDataSource(list);
rpt.SetParameterValue("FROM", dateTimePickerFROM.Value);
rpt.SetParameterValue("TO", dateTimePickerTO.Value);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
rpt.SetParameterValue("KH", comboBox1.Text);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Zoom(150);
}
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 buttonVIEW_Click(object sender, EventArgs e)
{
long _kho = long.Parse(comboBoxKHO.SelectedValue.ToString());
DateTime _from = dateTimePickerFROM.Value.Date;
DateTime _to = dateTimePickerTO.Value.Date;
BindingSource bs = new BindingSource();
List <CLaiLoTungKho> list = new List <CLaiLoTungKho>();
var hanghoa = (from _hh in DataInstance.Instance().DBContext().HANG_HOA select _hh);
var khachhang = (from _hh in DataInstance.Instance().DBContext().KHACH_HANG select _hh);
var xuathang = (from _bh in DataInstance.Instance().DBContext().XUAT_HANG
where _bh.MAKHO == _kho
where _bh.NGAY_XUAT >= _from && _bh.NGAY_XUAT <= _to
select _bh);
foreach (XUAT_HANG b in xuathang)
{
List <CXuatHangChiTiet> bchitiet = JsonConvert.DeserializeObject <List <CXuatHangChiTiet> >(b.CHI_TIET_XUAT_HANG);
if (bchitiet != null)
{
foreach (CXuatHangChiTiet row in bchitiet)
{
CLaiLoTungKho c = new CLaiLoTungKho();
c.NGAY = b.NGAY_XUAT.Value;
c.HANGHOA = hanghoa.Where(u => u.ID == b.MAHH).First().NAME;
if (b.MAKH == MXuatHang.MAKH_XUAT_MAT)
{
c.GHICHU = "Bán mặt";
}
else
{
c.GHICHU = "Xuất hàng: " + khachhang.Where(u => u.ID == b.MAKH).First().NAME;
}
c.SOLUONG = row.SOLUONG;
c.DONGIAMUA = row.DONGIA;
c.DONGIABAN = b.DON_GIA_BAN;
c.TONGLAI = row.SOLUONG * (b.DON_GIA_BAN - row.DONGIA);
list.Add(c);
}
}
else
{
}
}
list = list.OrderBy(u => u.NGAY).ToList();
bs.DataSource = list;
CrystalReportLAILOTUNGKHO rpt = new CrystalReportLAILOTUNGKHO();
rpt.SetDataSource(bs);
rpt.SetParameterValue("KHO", comboBoxKHO.Text);
rpt.SetParameterValue("FROM", dateTimePickerFROM.Value);
rpt.SetParameterValue("TO", dateTimePickerTO.Value);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
rpt.SetParameterValue("TONGCHI", MKho.Total_Chi(_kho, _from, _to));
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Zoom(150);
}
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 buttonCHUYEN_Click(object sender, EventArgs e)
{
long tien = 0;
long taikhoan = 0;
long ton = MKho.Tong_Tien_Hien_Tai(DateTime.Now);
try
{
tien = long.Parse(textBoxTONGTIEN.Text);
}
catch (Exception ex)
{
MessageBox.Show("Lỗi nhập tiền");
return;
}
try
{
taikhoan = long.Parse(listBoxTAIKHOAN.SelectedValue.ToString());
}
catch (Exception ex)
{
MessageBox.Show("Lỗi chọn tài khoản");
return;
}
if (tien == 0 || taikhoan == 0)
{
MessageBox.Show("Số tiền chuyển phải lớn hơn 0");
return;
}
if (tien > ton)
{
MessageBox.Show("Số tiền chuyển không được lớn hơn tiền đang có");
return;
}
DateTime now = dateTimePickerNGAY.Value.Date;
CHUYEN_TIEN c = new CHUYEN_TIEN();
c.TONG_TIEN = tien;
c.NGAY_CHUYEN = now;
c.ID_TAI_KHOAN = taikhoan;
c.CREATED_AT = DateTime.Now;
DataInstance.Instance().DBContext().AddToCHUYEN_TIEN(c);
DataInstance.Instance().DBContext().SaveChanges();
textBoxTIENTON.Text = Utility.StringToVND(MKho.Tong_Tien_Hien_Tai(DateTime.Now).ToString());
textBoxTONGTIEN.Text = "0";
textBoxTONGTIEN.Select();
textBoxTONGTIEN.SelectAll();
}
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 comboBoxHANGHOA_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DateTime now = dateTimePickerNGAYBAN.Value.Date;
long kho = long.Parse(comboBoxKho.SelectedValue.ToString());
long hh = long.Parse(comboBoxHANGHOA.SelectedValue.ToString());
long kh = long.Parse(comboBoxKHACH_HANG.SelectedValue.ToString());
long ton = MKho.Ton(kho, hh);
labelTON.Text = "TỒN: " + ton.ToString();
string hh_id = comboBoxHANGHOA.SelectedValue.ToString();
long value = long.Parse(hh_id);
var dvt = dbContext.HANG_HOA
.Where(u => u.ID == value)
.Select(u => u.UNIT);
labelDVT.Text = dvt.FirstOrDefault().ToString();
if (checkBoxBANMAT.Checked == true)
{
kh = MXuatHang.MAKH_XUAT_MAT;
}
bs.DataSource = dbContext.XUAT_HANG
.Where(u => u.NGAY_XUAT == now && u.MAKHO == kho && u.MAKH == kh && u.MAHH == hh);
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].Visible = false;
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[11].Visible = false;
dataGridView1.Columns[12].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[4].HeaderText = "SỐ LƯỢNG";
dataGridView1.Columns[5].HeaderText = "ĐƠN GIÁ";
dataGridView1.Columns[7].HeaderText = "LÃI SUẤT";
dataGridView1.Columns[8].HeaderText = "TRẢ TRƯỚC";
}
catch (Exception ex)
{
//MessageBox.Show("Dữ liệu nhập vào phải là số");
}
}
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 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 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 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 buttonADD_Click(object sender, EventArgs e)
{
try
{
var ele = new XUAT_HANG();
ele.MAKHO = Convert.ToInt32(comboBoxKho.SelectedValue.ToString());
if (checkBoxBANMAT.Checked == true)
{
ele.MAKH = MXuatHang.MAKH_XUAT_MAT;
ele.TRA_TRUOC = 0;
ele.LAI_SUAT = 0;
}
else
{
ele.MAKH = Convert.ToInt32(comboBoxKHACH_HANG.SelectedValue.ToString());
ele.TRA_TRUOC = Convert.ToInt32(textBoxDUATRUOC.Text);
ele.LAI_SUAT = Convert.ToDouble(textBoxLAISUAT.Text) / 100;
}
ele.NGAY_XUAT = dateTimePickerNGAYBAN.Value.Date;
ele.CREATED_AT = DateTime.Now;
ele.SO_LUONG = Convert.ToInt32(textBoxSOLUONG.Text);
ele.DON_GIA_BAN = Convert.ToInt32(textBoxDONGIA.Text);
ele.MAHH = Convert.ToInt32(comboBoxHANGHOA.SelectedValue.ToString());
ele.TRANG_THAI = MXuatHang.CHUA_TRA_XONG;
ele.THANH_TIEN = ele.SO_LUONG * ele.DON_GIA_BAN;
if (ele.DON_GIA_BAN < 0 || ele.TRA_TRUOC < 0 || ele.LAI_SUAT < 0)
{
MessageBox.Show("Đơn giá, trả trước, lãi suất không được nhỏ hơn 0");
return;
}
if (ele.DON_GIA_BAN == 0 && ele.SO_LUONG == 0)
{
if (ele.TRA_TRUOC == 0)
{
MessageBox.Show("Dữ liệu nhập vào không hợp lệ");
textBoxDUATRUOC.Select();
textBoxDUATRUOC.SelectAll();
return;
}
}
if (ele.DON_GIA_BAN < ConstClass.DON_GIA_BASE && ele.SO_LUONG > 0)
{
MessageBox.Show("Đơn giá không hợp lệ");
textBoxDONGIA.Select();
textBoxDONGIA.SelectAll();
return;
}
long lton = MKho.Ton(ele.MAKHO, ele.MAHH);
if (ele.SO_LUONG > lton)
{
MessageBox.Show("Số lượng bán hàng lớn hơn số lượng tồn.\nCòn tồn: " + lton.ToString(), "Lỗi số lượng!", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBoxHANGHOA.Select();
return;
}
bs.Add(ele);
bs.EndEdit();
bs.ResetBindings(false);
/* TRỪ SỐ LƯỢNG HÀNG ĐÃ XUẤT VÀO NHẬP HÀNG */
MXuatHang.Update(ele.SO_LUONG, ele);
dbContext.SaveChanges();
textBoxDONGIA.SelectAll();
textBoxLAISUAT.Text = "0";
textBoxDUATRUOC.Text = "0";
textBoxDONGIA.Text = "0";
textBoxSOLUONG.Text = "0";
long kho = long.Parse(comboBoxKho.SelectedValue.ToString());
long hh = long.Parse(comboBoxHANGHOA.SelectedValue.ToString());
long ton = MKho.Ton(kho, hh);
labelTON.Text = "TỒN: " + ton.ToString();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
MessageBox.Show("Dữ liệu nhập vào phải là số");
}
comboBoxHANGHOA.Select();
}
