private void FrmPhieuChamCong_Load(object sender, EventArgs e) { gridControl1.ForceInitialize(); if (giatri == null) { giatri = new object[xpcLoaiDuLieuChamCong.Count]; } DateTime dt = DateTime.Parse(dtNgayChamCong.EditValue.ToString()); Employee nv = lkupNhanVien.EditValue as Employee; DateTime _dt = new DateTime(dt.Year, dt.Month, Global.SoNgayTrongThang(dt.Month, dt.Year)); XPCollection _xpcChamCong = new XPCollection(xpcChamCong, CriteriaOperator.And( new BinaryOperator("NhanVien", nv), new BinaryOperator("Thang", _dt))); for (int i = 0; i < gridView1.DataRowCount; i++) { object value = null; LoaiDuLieuChamCong LoaiDLChamCong = (xpcLoaiDuLieuChamCong.Lookup(int.Parse(gridView1.GetRowCellValue(i, colOid).ToString()))) as LoaiDuLieuChamCong; XPCollection _xpc = new XPCollection(_xpcChamCong, new BinaryOperator("LoaiDuLieuChamCong", LoaiDLChamCong)); if (_xpc.Count > 0) { value = (_xpc[0] as ChamCong)[dt.Day]; gridView1.SetRowCellValue(i, colGiaTri, value); giatri[i] = value; } } }
private void gridView1_CustomRowCellEdit(object sender, CustomRowCellEditEventArgs e) { if (e.Column.FieldName == "LoaiDuLieuChamCong.LoaiChamCong" || e.Column.FieldName == "NhanVien.MaNhanVien" || e.Column.FieldName == "NhanVien.HoTen" || e.Column.FieldName == "HieuSuat" || e.Column.FieldName == "KetQua" || e.Column.FieldName == "DonVi") { return; } GridView gv = sender as GridView; LoaiDuLieuChamCong l = (LoaiDuLieuChamCong)gv.GetRowCellValue(e.RowHandle, gv.Columns["LoaiDuLieuChamCong!"]); if (l == null) { return; } switch (l.KieuDuLieu) { case "Int": repositoryItemSpinEdit1.NullText = ""; e.RepositoryItem = repositoryItemSpinEdit1; break; case "DateTime": e.RepositoryItem = timeEdit; break; case "String": case "Double": e.RepositoryItem = txtEdit; break; } }
public FrmLoaiDuLieuChamCongDetail(string id) { InitializeComponent(); using (var uow = new UnitOfWork()) { LoaiDuLieuChamCong l = uow.FindObject <LoaiDuLieuChamCong>(CriteriaOperator.Parse("LoaiChamCong = ?", id)); if (l != null) { this.xpcLoaiDuLieuChamCong.CriteriaString = "[LoaiChamCong] = \'" + l.LoaiChamCong + "\'"; btnThem.Enabled = false; } } }
protected override void OnDelete() { if (XtraMessageBox.Show("Bạn có muốn xóa không?", "THÔNG BÁO", MessageBoxButtons.OKCancel) == DialogResult.Cancel) { return; } for (int i = 0; i < grvUCList.SelectedRowsCount; i++) { _id = grvUCList.GetRowCellValue(grvUCList.GetSelectedRows()[i], colOid).ToString(); using (var uow = new UnitOfWork()) { LoaiDuLieuChamCong br = uow.FindObject <LoaiDuLieuChamCong>(CriteriaOperator.Parse("LoaiChamCong = ?", _id)); if (br != null) { br.Delete(); uow.CommitChanges(); uow.PurgeDeletedObjects(); RefreshData(); } } } }
private void gridView1_RowCellStyle(object sender, RowCellStyleEventArgs e) { GridView gv = sender as GridView; if (e.RowHandle < 0) { return; } if (e.Column.FieldName == "LoaiDuLieuChamCong.LoaiChamCong" || e.Column.FieldName == "NhanVien.MaNhanVien" || e.Column.FieldName == "NhanVien.HoTen" || e.Column.FieldName == "HieuSuat" || e.Column.FieldName == "Ca" || e.Column.FieldName == "KetQua" || e.Column.FieldName == "DonVi") { return; } if (String.IsNullOrEmpty(e.Column.Caption)) { return; } DateTime curDate = DateTime.Parse(e.Column.Caption); Employee nv = (Employee)gv.GetRowCellValue(e.RowHandle, gv.Columns["NhanVien!"]); #region "Màu ngày nghĩ" XPCollection xpc = new XPCollection(xpcQuanLyNgayNghi, new BinaryOperator("NhanVien.Oid", nv.Oid)); foreach (QuanLyNgayNghi ql in xpc) { if (curDate.CompareTo(ql.NgayBatDau) >= 0 && curDate.CompareTo(ql.NgayKetThuc) < 0) { e.Appearance.BackColor = ql.LoaiNgayNghi.MauHienThi; break; } } #endregion #region "Màu đi trể về sớm" string kieudulieu = gv.GetRowCellDisplayText(e.RowHandle, gv.Columns["LoaiDuLieuChamCong.LoaiChamCong"]); LoaiDuLieuChamCong l = (LoaiDuLieuChamCong)gv.GetRowCellValue(e.RowHandle, gv.Columns["LoaiDuLieuChamCong!"]); DateTime value; DateTime t1; //Tim nhan vien trong ngay do lam ca nao //Tim GTDLCCTheoCa thi voi ca do Loai DL CC do thì gt la bao nhieu XPCollection _xepCa = new XPCollection(xpcXepCa, CriteriaOperator.And(new BinaryOperator("Ngay", curDate), new BinaryOperator("NhanVien", nv))); if (_xepCa.Count > 0) { XPCollection _GTDLCCTheoCa = new XPCollection(xpcGTDLCCTheoCa, CriteriaOperator.And(new BinaryOperator("Ca", (_xepCa[0] as ChiTietXepCa).Ca), new BinaryOperator("LoaiDLChamCong", l))); if (_GTDLCCTheoCa.Count > 0) { switch (l.LoaiChamCong) { case "Giờ Vào": if (gv.GetRowCellValue(e.RowHandle, e.Column) != null) { try { t1 = DateTime.Parse((_GTDLCCTheoCa[0] as GiaTriDuLieuChamCongTheoCa).GiaTri); value = DateTime.Parse(gv.GetRowCellValue(e.RowHandle, e.Column).ToString()); if (SoSanhThoiGianLonHon(((DateTime)value).Hour, ((DateTime)value).Minute, ((DateTime)value).Second, t1.Hour, t1.Minute, t1.Second) == true) { e.Appearance.BackColor = l.MauHienThiDuong; } } catch (Exception ex) { //XtraMessageBox.Show(ex.Message); } } //So phut di tre break; case "Giờ Ra": if (gv.GetRowCellValue(e.RowHandle, e.Column) != null) { try { t1 = DateTime.Parse((_GTDLCCTheoCa[0] as GiaTriDuLieuChamCongTheoCa).GiaTri); value = DateTime.Parse(gv.GetRowCellValue(e.RowHandle, e.Column).ToString()); if (SoSanhThoiGianLonHon(((DateTime)value).Hour, ((DateTime)value).Minute, ((DateTime)value).Second, t1.Hour, t1.Minute, t1.Second) == false) { e.Appearance.BackColor = l.MauHienThiAm; } } catch (Exception ex) { //XtraMessageBox.Show(ex.Message); } } break; } } } #endregion #region "Màu theo ca" ////Lấy màu của ca //if(e.Appearance.BackColor == Color.White && _xepCa.Count > 0) //{ // e.Appearance.BackColor = (_xepCa[0] as XepCa).Ca.MauHienThiCa; //} #endregion }