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
}
