protected override void UpdatingItem(Operator newVal, Operator original, AttendanceDataContext attendance)
{
attendance.GetTable <Operator>().Attach(newVal, original);
List <T_OperatorDept> optDepts = attendance.GetTable <T_OperatorDept>().Where(item => item.OperatorID == newVal.ID).ToList();
if (!newVal.IsAdmin)
{
foreach (string item in newVal.Depts)
{
if (!optDepts.Exists(it => it.DepartmentID == item))
{
attendance.GetTable <T_OperatorDept>().InsertOnSubmit(new T_OperatorDept()
{
OperatorID = newVal.ID, DepartmentID = item
});
}
}
foreach (T_OperatorDept item in optDepts)
{
if (!newVal.Depts.Exists(it => it == item.DepartmentID))
{
attendance.GetTable <T_OperatorDept>().DeleteOnSubmit(item);
}
}
}
}
public void ResetID(string entity, long id)
{
try
{
AttendanceDataContext dc = AttendanceDataContextFactory.Createattendance(_ConnStr);
IntegerID ii = dc.GetTable <IntegerID>().SingleOrDefault(item => item.Entity == entity);
if (ii == null)
{
ii = new IntegerID()
{
Entity = entity, Value = id
};
dc.GetTable <IntegerID>().InsertOnSubmit(ii);
dc.SubmitChanges();
}
else
{
ii.Value = id;
dc.SubmitChanges();
}
}
catch (Exception ex)
{
LJH.GeneralLibrary.ExceptionHandling.ExceptionPolicy.HandleException(ex);
}
}
protected override void DeletingItem(ShiftTemplate info, AttendanceDataContext attendance)
{
T_ShiftArrangeTemplate item = T_ShiftArrangeTemplate.Create(info);
attendance.GetTable <T_ShiftArrangeTemplate>().Attach(item);
attendance.GetTable <T_ShiftArrangeTemplate>().DeleteOnSubmit(item);
}
protected override void DeletingItem(Operator info, AttendanceDataContext attendance)
{
attendance.GetTable <Operator>().Attach(info);
attendance.GetTable <Operator>().DeleteOnSubmit(info);
List <T_OperatorDept> optDepts = attendance.GetTable <T_OperatorDept>().Where(item => item.OperatorID == info.ID).ToList();
attendance.GetTable <T_OperatorDept>().DeleteAllOnSubmit(optDepts);
}
protected override void DeletingItem(Shift info, AttendanceDataContext attendance)
{
attendance.GetTable <Shift>().Attach(info);
attendance.GetTable <Shift>().DeleteOnSubmit(info);
if (info.Items != null && info.Items.Count > 0)
{
foreach (ShiftItem si in info.Items)
{
attendance.GetTable <ShiftItem>().Attach(si);
attendance.GetTable <ShiftItem>().DeleteOnSubmit(si);
}
}
}
protected override void DeletingItem(AttendanceResult info, AttendanceDataContext attendance)
{
attendance.GetTable <AttendanceResult>().Attach(info);
attendance.GetTable <AttendanceResult>().DeleteOnSubmit(info);
if (info.AbsentItems != null && info.AbsentItems.Count > 0)
{
foreach (AbsentItem item in info.AbsentItems)
{
attendance.GetTable <AbsentItem>().Attach(item);
attendance.GetTable <AbsentItem>().DeleteOnSubmit(item);
}
}
}
protected override Operator GetingItemByID(string id, AttendanceDataContext attendance)
{
Operator opt = attendance.GetTable <Operator>().SingleOrDefault(o => o.ID == id);
if (opt != null)
{
opt.Role = attendance.GetTable <Role>().SingleOrDefault(item => item.ID == opt.RoleID);
if (!opt.IsAdmin)
{
opt.Depts = attendance.GetTable <T_OperatorDept>().Where(item => item.OperatorID == id).Select(item => item.DepartmentID).ToList();
}
}
return(opt);
}
protected override List <ShiftArrange> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
IQueryable <ShiftArrange> ret = attendance.GetTable <ShiftArrange>();
if (search is ShiftArrangeSearchCondition)
{
ShiftArrangeSearchCondition con = search as ShiftArrangeSearchCondition;
if (con.ShiftDate != null)
{
ret = ret.Where(item => item.ShiftDate >= con.ShiftDate.Begin && item.ShiftDate <= con.ShiftDate.End);
}
if (con.StaffID != null)
{
ret = ret.Where(item => item.StaffID == con.StaffID);
}
if (con.ShiftID != null)
{
ret = ret.Where(item => item.ShiftID == con.ShiftID);
}
}
List <ShiftArrange> items = ret.ToList();
if (items != null && items.Count > 0)
{
List <Shift> shifts = (new ShiftProvider(ConnectStr)).GetItems(null).QueryObjects;
foreach (ShiftArrange item in items)
{
item.Shift = shifts.SingleOrDefault(it => it.ID == item.ShiftID);
}
}
return(items.Where(item => item.Shift != null).ToList());
}
protected override List <TASheet> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
DataLoadOptions opts = new DataLoadOptions();
opts.LoadWith <TASheet>(item => item.Items);
attendance.LoadOptions = opts;
IQueryable <TASheet> ret = attendance.GetTable <TASheet>();
if (search is TASheetSearchCondition)
{
TASheetSearchCondition con = search as TASheetSearchCondition;
if (!string.IsNullOrEmpty(con.SheetID))
{
ret = ret.Where(item => item.SheetID == con.SheetID);
}
if (con.StaffID != null)
{
ret = ret.Where(item => item.StaffID == con.StaffID);
}
if (!string.IsNullOrEmpty(con.SheetType))
{
ret = ret.Where(item => item.SheetType == con.SheetType);
}
if (!string.IsNullOrEmpty(con.Department))
{
ret = ret.Where(item => item.Department == con.Department);
}
if (con.StartDate != null)
{
ret = ret.Where(item => item.StartDate >= con.StartDate.Begin && item.StartDate <= con.StartDate.End);
}
}
return(ret.ToList());
}
protected override List <AttendanceResult> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
DataLoadOptions opts = new DataLoadOptions();
opts.LoadWith <AttendanceResult>(item => item.AbsentItems);
attendance.LoadOptions = opts;
IQueryable <AttendanceResult> ret = attendance.GetTable <AttendanceResult>();
if (search is StaffAttendanceResultSearchCondition)
{
StaffAttendanceResultSearchCondition con = search as StaffAttendanceResultSearchCondition;
if (con.ShiftDate != null)
{
ret = ret.Where(item => item.ShiftDate >= con.ShiftDate.Begin && item.ShiftDate <= con.ShiftDate.End);
}
if (con.Staff != null && con.Staff.Count > 0)
{
ret = ret.Where(item => con.Staff.Contains(item.StaffID));
}
if (con.ShiftID != null)
{
ret = ret.Where(item => item.ShiftID == con.ShiftID);
}
}
return(ret.ToList());
}
protected override Shift GetingItemByID(string id, AttendanceDataContext attendance)
{
DataLoadOptions opts = new DataLoadOptions();
opts.LoadWith <Shift>(item => item.Items);
attendance.LoadOptions = opts;
return(attendance.GetTable <Shift>().SingleOrDefault(item => item.ID == id));
}
protected override List <Shift> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
DataLoadOptions opts = new DataLoadOptions();
opts.LoadWith <Shift>(item => item.Items);
attendance.LoadOptions = opts;
IQueryable <Shift> ret = attendance.GetTable <Shift>();
return(ret.ToList());
}
protected override Staff GetingItemByID(int id, AttendanceDataContext attendance)
{
Staff staff = attendance.GetTable <Staff>().SingleOrDefault(item => item.ID == id);
if (staff != null && !string.IsNullOrEmpty(staff.DepartmentID))
{
staff.Department = (new DepartmentProvider(ConnectStr)).GetByID(staff.DepartmentID).QueryObject;
}
return(staff);
}
protected override ShiftArrange GetingItemByID(ShiftArrangeID id, AttendanceDataContext attendance)
{
ShiftArrange sa = attendance.GetTable <ShiftArrange>().SingleOrDefault(item => item.StaffID == id.StaffID && item.ShiftDate == id.ShiftDate && item.ShiftID == id.ShiftID);
if (sa != null)
{
sa.Shift = (new ShiftProvider(ConnectStr)).GetByID(sa.ShiftID).QueryObject;
}
return(sa);
}
protected override AttendanceResult GetingItemByID(Guid id, AttendanceDataContext attendance)
{
DataLoadOptions opts = new DataLoadOptions();
opts.LoadWith <AttendanceResult>(item => item.AbsentItems);
attendance.LoadOptions = opts;
AttendanceResult sa = attendance.GetTable <AttendanceResult>().SingleOrDefault(item => item.ID == id);
return(sa);
}
protected override ShiftTemplate GetingItemByID(string id, AttendanceDataContext attendance)
{
T_ShiftArrangeTemplate tst = attendance.GetTable <T_ShiftArrangeTemplate>().SingleOrDefault(item => item.ID == id);
if (tst != null)
{
return(T_ShiftArrangeTemplate.Create(tst));
}
return(null);
}
public long?GetCurID(string entity)
{
long?id = null;
AttendanceDataContext dc = AttendanceDataContextFactory.Createattendance(_ConnStr);
IntegerID ii = dc.GetTable <IntegerID>().SingleOrDefault(item => item.Entity == entity);
if (ii != null)
{
id = ii.Value;
}
return(id);
}
protected override void UpdatingItem(Shift newVal, Shift original, AttendanceDataContext attendance)
{
attendance.GetTable <Shift>().Attach(newVal, original);
foreach (ShiftItem item in newVal.Items)
{
ShiftItem old = original.Items.SingleOrDefault(it => it.ID == item.ID);
if (old != null)
{
attendance.GetTable <ShiftItem>().Attach(item, old);
}
else
{
attendance.GetTable <ShiftItem>().InsertOnSubmit(item);
}
}
foreach (ShiftItem item in original.Items)
{
if (newVal.Items.SingleOrDefault(it => it.ID == item.ID) == null)
{
attendance.GetTable <ShiftItem>().Attach(item);
attendance.GetTable <ShiftItem>().DeleteOnSubmit(item);
}
}
}
protected override List <Operator> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
IQueryable <Operator> ret = attendance.GetTable <Operator>();
if (search == null)
{
}
List <Operator> items = ret.ToList();
if (items != null && items.Count > 0)
{
List <Role> roles = attendance.GetTable <Role>().ToList();
List <T_OperatorDept> optDepts = attendance.GetTable <T_OperatorDept>().ToList();
foreach (Operator opt in items)
{
opt.Role = roles.SingleOrDefault(role => role.ID == opt.RoleID);
if (!opt.IsAdmin)
{
opt.Depts = optDepts.Where(item => item.OperatorID == opt.ID).Select(item => item.DepartmentID).ToList();
}
}
}
return(items);
}
public long?CreateID(string entity)
{
long?id = null;
AttendanceDataContext dc = AttendanceDataContextFactory.Createattendance(_ConnStr);
IntegerID ii = dc.GetTable <IntegerID>().SingleOrDefault(item => item.Entity == entity);
if (ii == null)
{
ii = new IntegerID()
{
Entity = entity, Value = 2
};
dc.GetTable <IntegerID>().InsertOnSubmit(ii);
dc.SubmitChanges();
id = 1;
}
else
{
id = ii.Value;
ii.Value += 1;
dc.SubmitChanges();
}
return(id);
}
protected override List <ShiftTemplate> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
IQueryable <T_ShiftArrangeTemplate> ret = attendance.GetTable <T_ShiftArrangeTemplate>();
List <T_ShiftArrangeTemplate> items = ret.ToList();
List <ShiftTemplate> templates = new List <ShiftTemplate>();
if (items != null && items.Count > 0)
{
foreach (T_ShiftArrangeTemplate item in items)
{
templates.Add(T_ShiftArrangeTemplate.Create(item));
}
}
return(templates);
}
protected override List <Staff> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
IQueryable <Staff> ret = attendance.GetTable <Staff>();
List <Staff> items = ret.ToList();
if (items != null)
{
List <Department> depts = (new DepartmentProvider(ConnectStr)).GetItems(null).QueryObjects;
if (depts != null && depts.Count > 0)
{
foreach (Staff staff in items)
{
if (!string.IsNullOrEmpty(staff.DepartmentID))
{
staff.Department = depts.SingleOrDefault(dept => staff.DepartmentID == dept.ID);
}
}
}
}
return(items);
}
protected override List <StaffBioTemplate> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
IQueryable <StaffBioTemplate> ret = attendance.GetTable <StaffBioTemplate>();
if (search is StaffBioTemplateSearchCondition)
{
StaffBioTemplateSearchCondition con = search as StaffBioTemplateSearchCondition;
if (con.StaffID != null)
{
ret = ret.Where(item => item.StaffID == con.StaffID.Value);
}
if (!string.IsNullOrEmpty(con.Version))
{
ret = ret.Where(item => item.Version == con.Version);
}
if (con.Staff != null && con.Staff.Count > 0)
{
ret = ret.Where(item => con.Staff.Contains(item.StaffID));
}
}
return(ret.ToList());
}
protected override List <AttendanceLog> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
IQueryable <AttendanceLog> ret = attendance.GetTable <AttendanceLog>();
if (search is AttendanceLogSearchCondition)
{
AttendanceLogSearchCondition con = search as AttendanceLogSearchCondition;
if (con.ReadDateTime != null)
{
ret = ret.Where(item => item.ReadDateTime >= con.ReadDateTime.Begin && item.ReadDateTime <= con.ReadDateTime.End);
}
if (con.Staff != null && con.Staff.Count > 0)
{
ret = ret.Where(item => con.Staff.Contains(item.StaffID));
}
if (con.Readers != null && con.Readers.Count > 0)
{
ret = ret.Where(item => con.Readers.Contains(item.ReaderID) || item.IsManual == true); //人工签卡记录可能没有读卡器ID
}
}
List <AttendanceLog> items = ret.ToList();
return(items);
}
protected override DeviceInfo GetingItemByID(string id, AttendanceDataContext attendance)
{
return(attendance.GetTable <DeviceInfo>().SingleOrDefault(item => item.ID == id));
}
protected override StaffBioTemplate GetingItemByID(Guid id, AttendanceDataContext attendance)
{
return(attendance.GetTable <StaffBioTemplate>().SingleOrDefault(item => item.ID == id));
}
protected override void UpdatingItem(ShiftTemplate newVal, ShiftTemplate original, AttendanceDataContext attendance)
{
attendance.GetTable <T_ShiftArrangeTemplate>().Attach(T_ShiftArrangeTemplate.Create(newVal), T_ShiftArrangeTemplate.Create(original));
}
protected override void InsertingItem(ShiftTemplate info, AttendanceDataContext attendance)
{
T_ShiftArrangeTemplate template = T_ShiftArrangeTemplate.Create(info);
attendance.GetTable <T_ShiftArrangeTemplate>().InsertOnSubmit(template);
}
protected override List <Holiday> GetingItems(AttendanceDataContext attendance, SearchCondition search)
{
IQueryable <Holiday> ret = attendance.GetTable <Holiday>();
return(ret.ToList());
}
protected override Holiday GetingItemByID(string id, AttendanceDataContext attendance)
{
return(attendance.GetTable <Holiday>().SingleOrDefault(item => item.ID == id));
}