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(); }