public void UpdateDataGrid() { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var ctr = (from c in db.CongTrinh where c.KhachHangId == KhId && c.TrangThai == 1 select c).ToList(); CTrGrid.Rows.Clear(); foreach (var ct in ctr) { CTrGrid.Rows.Add( ct.Id, ct.TenCongTrinh, ct.DiaChi, ct.SoHopDong, ct.NguoiPhuTrachId.HasValue ? ct.NhanVien.HoTen : "", ct.NgayKyHD, ct.NgayThucHien); } Cursor.Current = Cursors.Default; } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public SuaCongTrinh(CongTrinhForm form, string kId, string cId) : this() { parentForm = form; KhId = kId; var db = new CkpEntities(); CtyTBox.Text = (from k in db.KhachHang where k.Id == kId select k.TenCongTy).First(); var ct = (from c in db.CongTrinh where c.Id == cId select c).First(); var nv = (from n in db.NhanVien where n.TrangThai == 1 select n); foreach (var n in nv) { NptCb.Items.Add(n.Id + ". " + n.HoTen + " - " + n.ChucVu); } CtrIdTBox.Text = ct.Id; CtrIdTBox.ReadOnly = true; CtrNameTBox.Text = ct.TenCongTrinh; CtrDcTBox.Text = ct.DiaChi == null ? "" : ct.DiaChi; SoHdTBox.Text = ct.SoHopDong == null ? "" : ct.SoHopDong; NptCb.SelectedIndex = ct.NguoiPhuTrachId == null ? -1 : NptCb.FindStringExact(ct.NhanVien.Id + ". " + ct.NhanVien.HoTen + " - " + ct.NhanVien.ChucVu); NgayKyTBox.Text = ct.NgayKyHD == null ? "" : ct.NgayKyHD.Value.ToString("ddMMyyyy"); NgayThTBox.Text = ct.NgayThucHien == null ? "" : ct.NgayThucHien.Value.ToString("ddMMyyyy"); }
public void UpdateDataGrid() { try { Cursor.Current = Cursors.WaitCursor; NvGrid.Rows.Clear(); var db = new CkpEntities(); var allNv = (from nv in db.NhanVien where nv.TrangThai == 1 select nv).ToList(); foreach (var nv in allNv) { NvGrid.Rows.Add( nv.Id, nv.HoTen, nv.ChucVu, nv.SoDienThoai, nv.DiaChi); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public CongTrinhForm() { InitializeComponent(); try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); KhIds = new List <string>(); var kh = (from k in db.KhachHang where k.TrangThai == 1 select k); foreach (var k in kh) { CtyCBox.Items.Add(k.TenCongTy); KhIds.Add(k.Id); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } CTrGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; CtyCBox.AutoCompleteSource = AutoCompleteSource.ListItems; CtyCBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; }
private void ShowDgInfo(int dgId) { var db = new CkpEntities(); var dginfo = (from d in db.DonGiaBom where d.TrangThai == 1 && d.Id == dgId select d).FirstOrDefault(); var sb = new StringBuilder(); sb.AppendLine("Đơn giá:" + (dginfo.DonGia.HasValue ? dginfo.DonGia.Value.ToString("N0") : "")); sb.AppendLine("Đơn giá (+VAT):" + (dginfo.DonGiaVAT.HasValue ? dginfo.DonGiaVAT.Value.ToString("N0") : "")); sb.AppendLine("KL b.cần tối thiểu:" + (dginfo.MinKlgBomCan.HasValue ? dginfo.MinKlgBomCan.Value.ToString("N0") : "")); sb.AppendLine("KL b.tĩnh tối thiểu:" + (dginfo.MinKlgBomTinh.HasValue ? dginfo.MinKlgBomTinh.Value.ToString("N0") : "")); sb.AppendLine("CC1:" + (dginfo.CC1.HasValue ? dginfo.CC1.Value.ToString("N0") : "")); sb.AppendLine("Tổng CC2:" + (dginfo.TongCC2.HasValue ? dginfo.TongCC2.Value.ToString("N0") : "")); sb.AppendLine("% Back CC2:" + (dginfo.PhanTramBackCC2.HasValue ? dginfo.PhanTramBackCC2.Value.ToString("N0") : "")); sb.AppendLine("Tiền Back CC2:" + (dginfo.TienBackCC2.HasValue ? dginfo.TienBackCC2.Value.ToString("N0") : "")); sb.AppendLine("Net CC2:" + (dginfo.NetCC2.HasValue ? dginfo.NetCC2.Value.ToString("N0") : "")); sb.AppendLine("Tổng CC: " + (dginfo.TongCC.HasValue ? dginfo.TongCC.Value.ToString("N0") : "")); sb.AppendLine("KL giá: " + (dginfo.TongThu.HasValue ? dginfo.TongThu.Value.ToString("N0") : "")); sb.AppendLine("KL giá (+VAT): " + (dginfo.TongThuVAT.HasValue ? dginfo.TongThuVAT.Value.ToString("N0") : "")); sb.AppendLine("Công thức: " + dginfo.CongThuc); if (!string.IsNullOrEmpty(dginfo.GhiChu)) { sb.AppendLine("Ghi chú: " + dginfo.GhiChu); } MessageBox.Show(sb.ToString()); }
private void CtrCb_SelectionChangeCommitted(object sender, EventArgs e) { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var id = CtrIds[CtrCb.SelectedIndex]; var ctr = (from c in db.CongTrinh where c.Id == id && c.TrangThai == 1 select c).FirstOrDefault(); KhCb.SelectedIndex = KhCb.FindStringExact(ctr.KhachHang.Id + " - " + ctr.KhachHang.TenCongTy); DcTb.Text = ctr.DiaChi; var dg = (from d in db.DonGiaBom where d.CongTrinhId == id && d.TrangThai == 1 select d); foreach (var d in dg) { DgCb1.Items.Add(d.TenDonGia); DgCb2.Items.Add(d.TenDonGia); DgCb3.Items.Add(d.TenDonGia); DgIds.Add(d.Id); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void DelBtn_Click(object sender, EventArgs e) { try { var selectedRows = ViTriGrid.Rows.GetRowCount(DataGridViewElementStates.Selected); if (selectedRows == 0) { MessageBox.Show("Vui lòng chọn tối thiểu một đơn giá để xóa", "Thao tác", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { var result = MessageBox.Show("Bạn có chắc chắn xóa?", "Xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); for (int i = 0; i < selectedRows; i++) { var id = ViTriGrid.SelectedRows[i].Cells[0].Value.ToString(); var dg = (from d in db.ViTriBom where d.ViTri == id select d).FirstOrDefault(); dg.TrangThai = 0; db.SaveChanges(); } Cursor.Current = Cursors.Default; MessageBox.Show("Đã xóa " + selectedRows + " vị trí", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); UpdateDataGrid(); } } } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void SearchBtn_Click(object sender, EventArgs e) { try { var searchText = SearchTBox.Text.Trim().ToLower(); if (searchText.Length > 0) { var db = new CkpEntities(); Cursor.Current = Cursors.WaitCursor; KhachHangGrid.Rows.Clear(); var result = (from k in db.KhachHang where k.TrangThai == 1 select k).ToList(); if (STypeCBox.SelectedIndex == 1) //Ma KH { result = result.Where(k => k.Id.ToLower() == searchText).ToList(); } else if (STypeCBox.SelectedIndex == 2) //Ten cong ty { result = result.Where(k => k.TenCongTy.ToLower().Contains(searchText)).ToList(); } else if (STypeCBox.SelectedIndex == 3) //Dia chi { result = result.Where(k => k.DiaChi != null && k.DiaChi.ToLower().Contains(searchText)).ToList(); } else if (STypeCBox.SelectedIndex == 4) //Ma so thue { result = result.Where(k => k.MaSoThue != null && k.MaSoThue == searchText).ToList(); } else //All { result = result.Where(k => k.Id.ToLower() == searchText || k.TenCongTy.ToLower().Contains(searchText) || (k.DiaChi != null && k.DiaChi.ToLower().Contains(searchText)) || (k.MaSoThue != null && k.MaSoThue == searchText)).ToList(); } foreach (var kh in result) { var lhs = (from lh in kh.NguoiLienHe select lh.HoTen).ToList(); KhachHangGrid.Rows.Add( kh.Id, kh.TenCongTy, kh.DiaChi, kh.MaSoThue); } if (KhachHangGrid.Rows.Count == 0) { MessageBox.Show("Không tìm thấy kết quả nào", "Tìm kiếm", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } Cursor.Current = Cursors.Default; } } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void UpdateDataGrid() { try { Cursor.Current = Cursors.WaitCursor; KhachHangGrid.Rows.Clear(); using (var db = new CkpEntities()) { var allKhachHang = (from k in db.KhachHang where k.TrangThai == 1 select k).ToList(); foreach (var kh in allKhachHang) { KhachHangGrid.Rows.Add( kh.Id, kh.TenCongTy, kh.DiaChi, kh.MaSoThue); } } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public DonGiaForm() { InitializeComponent(); try { var db = new CkpEntities(); CtrIds = new List <string>(); var ctr = (from c in db.CongTrinh where c.TrangThai == 1 select c); foreach (var c in ctr) { CtrCb.Items.Add(c.TenCongTrinh); CtrIds.Add(c.Id); } } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } DonGiaGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; CtrCb.AutoCompleteSource = AutoCompleteSource.ListItems; CtrCb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; }
public ChiTietKhachHang(string id) : this() { try { var db = new CkpEntities(); var kh = (from k in db.KhachHang where k.Id == id select k).First(); KhIdTBox.Text = kh.Id; CtyTBox.Text = kh.TenCongTy; MstTBox.Text = kh.MaSoThue; DcTBox.Text = kh.DiaChi == null ? "" : kh.DiaChi; foreach (var nlh in kh.NguoiLienHe.Where(l => l.TrangThai == 1)) { NlhGrid.Rows.Add( nlh.HoTen, nlh.Chucvu == null ? "" : nlh.Chucvu, nlh.SoDienThoai == null ? "" : nlh.SoDienThoai, nlh.GhiChu == null ? "" : nlh.GhiChu); } } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void OkBtn_Click(object sender, EventArgs e) { var name = HtTBox.Text.Trim(); var cvu = CvTBox.Text.Trim(); var sdt = SdtTBox.Text.Trim(); var dc = DcTBox.Text.Trim(); if (name.Length == 0 || cvu.Length == 0) { if (name.Length == 0) { HtLbl.ForeColor = Color.Red; } else { HtLbl.ForeColor = Color.Black; } if (cvu.Length == 0) { CvLbl.ForeColor = Color.Red; } else { CvLbl.ForeColor = Color.Black; } } else { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var newNv = new NhanVien { HoTen = name, ChucVu = cvu, SoDienThoai = sdt.Length == 0 ? null : sdt, DiaChi = dc.Length == 0 ? null : dc, TrangThai = 1, NgayTao = DateTime.Now, NgaySuaCuoi = DateTime.Now }; db.NhanVien.Add(newNv); db.SaveChanges(); Cursor.Current = Cursors.Default; parentForm.UpdateDataGrid(); MessageBox.Show("Thêm nhân viên thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Close(); } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void InitializeData() { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var allBom = (from b in db.MayBom where b.TrangThai == 1 orderby b.LoaiBom select b); var allNv = (from n in db.NhanVien where n.TrangThai == 1 orderby n.HoTen select n); var allCt = (from c in db.CongTrinh where c.TrangThai == 1 orderby c.TenCongTrinh select c); var allVt = (from v in db.ViTriBom where v.TrangThai == 1 select v); var allKh = (from k in db.KhachHang where k.TrangThai == 1 orderby k.TenCongTy select k); BomIds = new List <string>(); CtrIds = new List <string>(); KhIds = new List <string>(); NvIds = new List <int>(); VtIds = new List <int>(); DgIds = new List <int>(); var cbc = (DataGridViewComboBoxColumn)NhanLucGrid.Columns[0]; foreach (var bom in allBom) { BomCb.Items.Add(bom.Id + " - " + bom.TenBom); BomIds.Add(bom.Id); } foreach (var nv in allNv) { NgBcCb.Items.Add(nv.Id + "." + nv.HoTen + " - " + nv.ChucVu); cbc.Items.Add(nv.Id + "." + nv.HoTen); NvIds.Add(nv.Id); } foreach (var ct in allCt) { CtrCb.Items.Add(ct.TenCongTrinh); CtrIds.Add(ct.Id); } foreach (var kh in allKh) { KhCb.Items.Add(kh.Id + " - " + kh.TenCongTy); KhIds.Add(kh.Id); } foreach (var vt in allVt) { VtCb1.Items.Add(vt.ViTri); VtCb2.Items.Add(vt.ViTri); VtCb3.Items.Add(vt.ViTri); VtIds.Add(vt.Id); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void SearchBtn_Click(object sender, EventArgs e) { try { var db = new CkpEntities(); var searchText = SearchTBox.Text.Trim().ToLower(); List <MayBom> result0 = (from b in db.MayBom where b.TrangThai == 1 select b).ToList(); List <MayBom> result1 = (from b in db.MayBom where b.TrangThai == 1 select b).ToList(); Cursor.Current = Cursors.WaitCursor; MayBomGrid.Rows.Clear(); if (searchText.Length > 0) { result0 = result0.Where(r => r.Id.ToLower() == searchText || r.TenBom.ToLower() == searchText).ToList(); result1 = result1.Where(r => r.Id.ToLower().Contains(searchText) || r.TenBom.ToLower().Contains(searchText)).ToList(); } if (LoaiBomCBox.SelectedIndex == 1) //Bom cong ty { result0 = result0.Where(r => r.LoaiBom == 1).ToList(); result1 = result1.Where(r => r.LoaiBom == 1).ToList(); } else if (LoaiBomCBox.SelectedIndex == 2) //Bom thue ngoai { result0 = result0.Where(r => r.LoaiBom == 2).ToList(); result1 = result1.Where(r => r.LoaiBom == 2).ToList(); } else { } //Tat ca result0 = result0.Union(result1.AsEnumerable()).ToList(); foreach (var result in result0) { MayBomGrid.Rows.Add( result.Id, result.TenBom, result.LoaiBom == 1 ? "Bơm công ty" : "Bơm thuê ngoài"); } if (MayBomGrid.Rows.Count == 0) { MessageBox.Show("Không tìm thấy kết quả nào", "Tìm kiếm", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void OkBtn_Click(object sender, EventArgs e) { var name = HtTBox.Text.Trim(); var cvu = CvTBox.Text.Trim(); var sdt = SdtTBox.Text.Trim(); var dc = DcTBox.Text.Trim(); if (name.Length == 0 || cvu.Length == 0) { if (name.Length == 0) { HtLbl.ForeColor = Color.Red; } else { HtLbl.ForeColor = Color.Black; } if (cvu.Length == 0) { CvLbl.ForeColor = Color.Red; } else { CvLbl.ForeColor = Color.Black; } } else { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var nv = (from n in db.NhanVien where n.Id == NvId select n).First(); nv.HoTen = name; nv.ChucVu = cvu; nv.SoDienThoai = sdt.Length == 0 ? null : sdt; nv.DiaChi = dc.Length == 0 ? null : dc; nv.NgaySuaCuoi = DateTime.Now; db.SaveChanges(); Cursor.Current = Cursors.Default; parentForm.UpdateDataGrid(); MessageBox.Show("Thay đổi thông tin nhân viên thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Close(); } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void OkBtn_Click(object sender, EventArgs e) { var viTri = ViTriTBox.Text.Trim(); if (viTri.Length == 0) { if (viTri.Length == 0) { ViTriLbl.ForeColor = Color.Red; } else { ViTriLbl.ForeColor = Color.Black; } } else { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); if (db.ViTriBom.Select(v => v.ViTri).Contains(viTri)) { MessageBox.Show("Vị trí bơm này đã tồn tại", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var newVt = new ViTriBom { ViTri = viTri, TrangThai = 1, NgayTao = DateTime.Now, NgaySuaCuoi = DateTime.Now }; db.ViTriBom.Add(newVt); db.SaveChanges(); Cursor.Current = Cursors.Default; parentForm.UpdateDataGrid(); MessageBox.Show("Thêm vị trí thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Close(); } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void EditBtn_Click(object sender, EventArgs e) { try { var db = new CkpEntities(); var name = NameTBox.Text; var id = IdTbox.Text; if (name.Length > 0) { Cursor.Current = Cursors.WaitCursor; var mayBom = (from b in db.MayBom where b.Id == id select b).FirstOrDefault(); mayBom.TenBom = name.Trim(); mayBom.LoaiBom = TypeCBox.SelectedIndex == 0 ? 1 : 2; mayBom.NgaySuaCuoi = DateTime.Now; db.SaveChanges(); Cursor.Current = Cursors.Default; MessageBox.Show("Sửa thông tin thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); parentForm.UpdateDataGrid(); Close(); } else { if (id.Length == 0) { IdLbl.ForeColor = Color.Red; } else { IdLbl.ForeColor = Color.Black; } if (id.Length == 0) { NameLbl.ForeColor = Color.Red; } else { NameLbl.ForeColor = Color.Black; } } } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void CtrCb_SelectionChangeCommitted(object sender, EventArgs e) { try { var db = new CkpEntities(); CtrId = CtrIds[CtrCb.SelectedIndex]; var ctr = (from c in db.CongTrinh where c.TrangThai == 1 && c.Id == CtrId select c).FirstOrDefault(); DcTBox.Text = ctr.DiaChi; KhTBox.Text = ctr.KhachHang.Id + " - " + ctr.KhachHang.TenCongTy; UpdateDataGrid(); } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public SuaMayBom(MayBomForm form, string id) : this() { this.parentForm = form; try { var db = new CkpEntities(); var mayBom = (from b in db.MayBom where b.Id == id select b).First(); IdTbox.Text = mayBom.Id; NameTBox.Text = mayBom.TenBom; TypeCBox.Text = mayBom.LoaiBom == 1 ? "Bơm công ty" : "Bơm thuê ngoài"; } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ThemCongTrinh(CongTrinhForm form, string kId) : this() { parentForm = form; KhId = kId; var db = new CkpEntities(); CtyTBox.Text = (from k in db.KhachHang where k.Id == kId select k.TenCongTy).First(); var nv = (from n in db.NhanVien where n.TrangThai == 1 select n); foreach (var n in nv) { NptCb.Items.Add(n.Id + ". " + n.HoTen + " - " + n.ChucVu); } }
private void OkBtn_Click(object sender, EventArgs e) { var viTri = ViTriTBox.Text.Trim(); if (viTri.Length == 0) { if (viTri.Length == 0) { ViTriLbl.ForeColor = Color.Red; } else { ViTriLbl.ForeColor = Color.Black; } } else { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var allVt = (from d in db.ViTriBom where d.ViTri == Vt select d); if (allVt.Select(v => v.ViTri).Contains(viTri)) { MessageBox.Show("Vị trí bơm này đã tồn tại", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var vt = allVt.FirstOrDefault(); vt.ViTri = viTri; vt.NgaySuaCuoi = DateTime.Now; db.SaveChanges(); Cursor.Current = Cursors.Default; parentForm.UpdateDataGrid(); MessageBox.Show("Thay đổi vị trí thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Close(); } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void CtrCb_SelectionChangeCommitted(object sender, EventArgs e) { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var cId = CtrIds[CtrCb.SelectedIndex]; var cty = (from c in db.CongTrinh where c.Id == cId select c.KhachHang.TenCongTy).FirstOrDefault(); KhCb.SelectedIndex = KhCb.FindStringExact(cty); Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public SuaViTri(ViTriForm form, string vt) : this() { try { parentForm = form; Vt = vt; var db = new CkpEntities(); var v = (from d in db.ViTriBom where d.ViTri == vt select d).FirstOrDefault(); ViTriTBox.Text = v.ViTri; } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ThemDonGia(DonGiaForm form, string cId) : this() { parentForm = form; CtrId = cId; try { var db = new CkpEntities(); var ct = (from c in db.CongTrinh where c.Id == CtrId select c).FirstOrDefault(); CtrTBox.Text = ct.TenCongTrinh; VatTBox.Text = "10"; } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void SearchBtn_Click(object sender, EventArgs e) { try { var searchText = SearchTBox.Text.Trim().ToLower(); if (searchText.Length > 0) { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var nvs = (from nv in db.NhanVien where nv.TrangThai == 1 select nv).ToList(); NvGrid.Rows.Clear(); nvs = nvs.Where(nv => nv.HoTen.ToLower().Contains(searchText) || nv.ChucVu.ToLower() == searchText || nv.SoDienThoai == searchText || (nv.DiaChi != null && nv.DiaChi.Contains(searchText))).ToList(); foreach (var nv in nvs) { NvGrid.Rows.Add( nv.Id, nv.HoTen, nv.ChucVu, nv.SoDienThoai, nv.DiaChi); } Cursor.Current = Cursors.Default; if (NvGrid.Rows.Count == 0) { MessageBox.Show("Không tìm thấy kết quả nào", "Tìm kiếm", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void UpdateDataGrid() { try { Cursor.Current = Cursors.WaitCursor; ViTriGrid.Rows.Clear(); var db = new CkpEntities(); var allVt = (from d in db.ViTriBom where d.TrangThai == 1 select d).ToList(); foreach (var dg in allVt) { ViTriGrid.Rows.Add(dg.ViTri); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public SuaNhanVien(NhanVienForm form, int id) : this() { try { parentForm = form; NvId = id; var db = new CkpEntities(); var nv = (from n in db.NhanVien where n.Id == id select n).FirstOrDefault(); IdTBox.Text = nv.Id.ToString(); HtTBox.Text = nv.HoTen; CvTBox.Text = nv.ChucVu; SdtTBox.Text = nv.SoDienThoai; DcTBox.Text = nv.DiaChi; } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void UpdateDataGrid() { try { Cursor.Current = Cursors.WaitCursor; DonGiaGrid.Rows.Clear(); var db = new CkpEntities(); var ctr = (from c in db.CongTrinh where c.Id == CtrId && c.TrangThai == 1 select c).FirstOrDefault(); DcTBox.Text = ctr.DiaChi; KhTBox.Text = ctr.KhachHang.TenCongTy; foreach (var dg in ctr.DonGiaBom.Where(d => d.TrangThai == 1)) { DonGiaGrid.Rows.Add( dg.Id, dg.TenDonGia, dg.DonGia.HasValue ? dg.DonGia.Value.ToString("N0") : null, dg.DonGiaVAT.HasValue ? dg.DonGia.Value.ToString("N0") : null, dg.MinKlgBomCan.HasValue ? dg.MinKlgBomCan.Value.ToString("N2") : null, dg.MinKlgBomTinh.HasValue ? dg.MinKlgBomTinh.Value.ToString("N2") : null, dg.CC1.HasValue ? dg.CC1.Value.ToString("N0") : null, dg.TongCC2.HasValue ? dg.TongCC2.Value.ToString("N0") : null, dg.PhanTramBackCC2.HasValue ? dg.PhanTramBackCC2.Value.ToString("N2") : null, dg.TienBackCC2.HasValue ? dg.TienBackCC2.Value.ToString("N0") : null, dg.NetCC2.HasValue ? dg.NetCC2.Value.ToString("N0") : null, dg.TongThuVAT.HasValue ? dg.TongThuVAT.Value.ToString("N0") : null, dg.TongVAT.HasValue ? dg.TongVAT.Value.ToString("N0") : null, dg.TongThu.HasValue ? dg.TongThu.Value.ToString("N0") : null, dg.TongCC.HasValue ? dg.TongCC.Value.ToString("N0") : null, dg.CongThuc, dg.GhiChu); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void InitializeData() { try { Cursor.Current = Cursors.WaitCursor; var db = new CkpEntities(); var kh = (from k in db.KhachHang where k.TrangThai == 1 orderby k.TenCongTy select k); var ct = (from c in db.CongTrinh where c.TrangThai == 1 orderby c.TenCongTrinh select c); var mb = (from b in db.MayBom where b.TrangThai == 1 orderby b.LoaiBom select b); var nv = (from n in db.NhanVien where n.TrangThai == 1 orderby n.HoTen select n); foreach (var k in kh) { KhCb.Items.Add(k.TenCongTy); KhIds.Add(k.Id); } foreach (var c in ct) { CtrCb.Items.Add(c.TenCongTrinh + " - " + c.DiaChi); CtrIds.Add(c.Id); } foreach (var b in mb) { MbCb.Items.Add(b.Id + " - " + b.TenBom); MbIds.Add(b.Id); } foreach (var n in nv) { NvCb.Items.Add(n.Id + ". " + n.HoTen + " - " + n.ChucVu); NvIds.Add(n.Id); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void CalcDg3() { try { var db = new CkpEntities(); double val = 0; if (DgCb3.SelectedIndex == -1) { return; } var id = DgIds[DgCb3.SelectedIndex]; var dg = (from d in db.DonGiaBom where d.Id == id && d.TrangThai == 1 select d).FirstOrDefault(); int t = 0; double sl = 0; if (!string.IsNullOrEmpty(dg.CongThuc)) { t = int.TryParse(TangTb3.Text, out t) ? t : 0; sl = double.TryParse(SlTb3.Text, out sl) ? sl : 0; var e = new Expression(dg.CongThuc); e.Parameters["t"] = t; e.Parameters["sl"] = sl; val = Convert.ToDouble(e.Evaluate()); DgStTb3.Text = val.ToString(); DgTtTb3.Text = Convert.ToDouble(val / (1 + (dg.VAT ?? 0) / 100d)).ToString(); } Cursor.Current = Cursors.Default; } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.GetBaseException().Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }