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