public static void DakkaByID(string ID) { DakkaLinqDataContext db = DBHelper.GetDakkaLinqDataContext(); WorkRecord re = db.WorkRecord.Single(wr => wr.ID == long.Parse(ID)); re.Status = StatusEnum.OK.Value; db.SubmitChanges(); }
public static void Make(string EmployeeCode, string WorkCalendarCode, DateTime FromDate, DateTime ToDate) { Employee employee = DakkaData.Employee.GetByCode(EmployeeCode); WorkCalendar workCalendar = DakkaData.WorkCalendar.GetByCode(WorkCalendarCode); long EmployeeID = employee.ID; List <WorkRecord> records = new List <WorkRecord>(); do { bool isWorkDay = false; ShiftDef shiftDef = null; foreach (var rule in workCalendar.WorkCalendarRule) { if (rule.RuleType == RuleTypeEnum.Week.Value) { if (rule.Week == new WeekEnum(FromDate.DayOfWeek.ToString()).Value) { isWorkDay = rule.IsWorkDay; shiftDef = rule.ShiftDef1; } } else if (rule.RuleType == RuleTypeEnum.Month.Value) { if (rule.Day == FromDate.Day) { isWorkDay = rule.IsWorkDay; shiftDef = rule.ShiftDef1; } } else if (rule.RuleType == RuleTypeEnum.Year.Value) { if (rule.Month == FromDate.Month && rule.Day == FromDate.Day) { isWorkDay = rule.IsWorkDay; shiftDef = rule.ShiftDef1; } } else if (rule.RuleType == RuleTypeEnum.Date.Value) { if (rule.Year == FromDate.Year && rule.Month == FromDate.Month && rule.Day == FromDate.Day) { isWorkDay = rule.IsWorkDay; shiftDef = rule.ShiftDef1; } } } if (isWorkDay && shiftDef != null) { foreach (var shiftPoint in shiftDef.ShiftPoint) { WorkRecord workRecord = new WorkRecord() { Employee = EmployeeID, WorkPoint = new DateTime(FromDate.Year, FromDate.Month, FromDate.Day, shiftPoint.PointTime.Hour, shiftPoint.PointTime.Minute, shiftPoint.PointTime.Second), PointType = shiftPoint.PointType, Status = StatusEnum.Null.Value }; records.Add(workRecord); } } FromDate = FromDate.AddDays(1); }while (FromDate.Date <= ToDate); DakkaLinqDataContext db = DBHelper.GetDakkaLinqDataContext(); db.WorkRecord.InsertAllOnSubmit(records); db.SubmitChanges(); }
partial void DeleteWorkRecord(WorkRecord instance);
partial void UpdateWorkRecord(WorkRecord instance);
partial void InsertWorkRecord(WorkRecord instance);
private void detach_WorkRecord(WorkRecord entity) { this.SendPropertyChanging(); entity.Employee1 = null; }