[ValidateAntiForgeryToken]//修改某个部门的某一天的工作情况
public ActionResult CreateCompanyDay([Bind(Include = "Id,Number,RecordTime,SortNumber,Tag")] HolidayTimeRecord holidayTimeRecord)
{
if (ModelState.IsValid)
{
HolidayTimeRecord htr = (from htr1 in db.HolidayTimeRecords
where htr1.Number == holidayTimeRecord.Number && htr1.RecordTimeHoliday == holidayTimeRecord.RecordTimeHoliday
select htr1).Single();
if (htr != null)
{
db.HolidayTimeRecords.Remove(htr);
db.SaveChanges();
}
if (htr.Tag != "5")
{
holidayTimeRecord.RecordPerson = this.Name;
holidayTimeRecord.RecordTime = DateTime.Now;
holidayTimeRecord.ChangePerson = this.Name;
holidayTimeRecord.ChangeTime = DateTime.Now;
db.HolidayTimeRecords.Add(holidayTimeRecord);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(holidayTimeRecord));
}
public ActionResult DeleteConfirmed(int id)
{
Holiday holiday = db.Holidays.Find(id);
//for (var i = holiday.BeginTime; i <= holiday.EndTime; i = i.AddDays(1))
//{
// var temp = db.RecordDatetimes.Where(rd => rd.Recordtime.Equals(i));
// foreach (var tt in temp)
// {
// tt.Tag = "0";
// db.Entry(tt).State = EntityState.Modified;
// db.SaveChanges();
// }
//}
db.Holidays.Remove(holiday);
db.SaveChanges();
string number = "H";
number += holiday.Id.ToString();
var htrtemp = (from htr in db.HolidayTimeRecords
where htr.Number == number
select htr).ToList();
if (htrtemp.Count != 0)
{
foreach (var temp in htrtemp)
{
HolidayTimeRecord htr = db.HolidayTimeRecords.Find(temp.Id);
db.HolidayTimeRecords.Remove(htr);
}
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
HolidayTimeRecord holidayTimeRecord = db.HolidayTimeRecords.Find(id);
db.HolidayTimeRecords.Remove(holidayTimeRecord);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Number,RecordTime,SortNumber,Tag")] HolidayTimeRecord holidayTimeRecord)
{
if (ModelState.IsValid)
{
db.Entry(holidayTimeRecord).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(holidayTimeRecord));
}
public ActionResult Edit([Bind(Include = "Id,JieJiaName,BeginTime,EndTime")] Holiday holiday)
{
if (ModelState.IsValid)
{
//for (var i = holiday.BeginTime; i <= holiday.EndTime; i = i.AddDays(1))
//{
// var temp = db.RecordDatetimes.Where(rd => rd.Recordtime.Equals(i));
// foreach (var tt in temp)
// {
// tt.Tag = "0";
// db.Entry(tt).State = EntityState.Modified;
// db.SaveChanges();
// }
//}
string number = "H";
number += holiday.Id.ToString();
var htrtemp = (from htr in db.HolidayTimeRecords
where htr.Number == number
select htr).ToList();
if (htrtemp.Count != 0)
{
foreach (var temp in htrtemp)
{
HolidayTimeRecord htr = db.HolidayTimeRecords.Find(temp.Id);
db.HolidayTimeRecords.Remove(htr);
}
db.SaveChanges();
}
for (var i = holiday.BeginTime; i <= holiday.EndTime; i = i.AddDays(1))
{
HolidayTimeRecord htr1 = new HolidayTimeRecord();
htr1.Number = number;
htr1.RecordTimeHoliday = i;
htr1.Tag = "2";
db.HolidayTimeRecords.Add(htr1);
db.SaveChanges();
}
Holiday holi = db.Holidays.Find(holiday.Id);
holi.ChangePerson = this.Name;
holi.ChangeTime = DateTime.Now;
holi.JieJiaName = holiday.JieJiaName;
holi.BeginTime = holiday.BeginTime;
holi.EndTime = holiday.EndTime;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(holiday));
}
// GET: HolidayTimeRecord/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HolidayTimeRecord holidayTimeRecord = db.HolidayTimeRecords.Find(id);
if (holidayTimeRecord == null)
{
return(HttpNotFound());
}
var htr1 = db.HolidayTimeNames.Where(htr => htr.Id.ToString().Equals(holidayTimeRecord.Tag)).SingleOrDefault();
holidayTimeRecord.Tag = htr1.Name;
return(View(holidayTimeRecord));
}
// GET: HolidayTimeRecord/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HolidayTimeRecord holidayTimeRecord = db.HolidayTimeRecords.Find(id);
List <SelectListItem> name = db.HolidayTimeNames.ToList().Select(c => new SelectListItem
{
Value = c.Id.ToString(), //保存的值
Text = c.Name, //显示的值
}).ToList();
//增加一个null选
ViewBag.name = name;
if (holidayTimeRecord == null)
{
return(HttpNotFound());
}
return(View(holidayTimeRecord));
}
public ActionResult Create([Bind(Include = "Id,JieJiaName,BeginTime,EndTime")] Holiday holiday)
{
if (ModelState.IsValid)
{
holiday.RecordPerson = this.Name;
holiday.RecordTime = DateTime.Now;
db.Holidays.Add(holiday);
db.SaveChanges();
string number = "H";
number += holiday.Id.ToString();
for (var i = holiday.BeginTime; i <= holiday.EndTime; i = i.AddDays(1))
{
HolidayTimeRecord htr = new HolidayTimeRecord();
htr.Number = number;
htr.RecordTimeHoliday = i;
htr.Tag = "2";
db.HolidayTimeRecords.Add(htr);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(holiday));
}
public ActionResult CreateCompany([Bind(Include = "Nian,Range,Week1,Week2,Week3,week4,Week5,Week6,Week7")] WeekTag weektag)
{
string date = weektag.Nian;
DateTime begindate = Convert.ToDateTime(date + "-01-01");
//DateTime begindate = Convert.ToDateTime(date+"01-01");
//DateTime enddate = Convert.ToDateTime(date+"12-31");
//System.TimeSpan tsdiffer = enddate.Date - begindate.Date;
// int intdiffer = tsdiffer.Days + 1;
int intdiffer;
if (DateTime.IsLeapYear(int.Parse(weektag.Nian)))
{
intdiffer = 366;
}
else
{
intdiffer = 365;
}
List <DateTime> list = new List <DateTime>();
if (weektag.Range == "1")
{
for (int i = 0; i < intdiffer; i++)
{
DateTime dttemp = begindate.Date.AddDays(i);
if ((dttemp.DayOfWeek == System.DayOfWeek.Monday && "1" == weektag.Week1) ||
(dttemp.DayOfWeek == System.DayOfWeek.Tuesday && "1" == weektag.Week2) ||
(dttemp.DayOfWeek == System.DayOfWeek.Wednesday && "1" == weektag.Week3) ||
(dttemp.DayOfWeek == System.DayOfWeek.Thursday && "1" == weektag.Week4) ||
(dttemp.DayOfWeek == System.DayOfWeek.Friday && "1" == weektag.Week5) ||
(dttemp.DayOfWeek == System.DayOfWeek.Saturday && "1" == weektag.Week6) ||
(dttemp.DayOfWeek == System.DayOfWeek.Sunday && "1" == weektag.Week7))
{
var department = db.Departments.ToList();
var staff = db.Staffs.ToList();
foreach (var temp in department)
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = temp.DepartmentId;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "1";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
}
foreach (var temp1 in staff)
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = temp1.StaffNumber;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "1";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
}
}
if ((dttemp.DayOfWeek == System.DayOfWeek.Monday && "2" == weektag.Week1) ||
(dttemp.DayOfWeek == System.DayOfWeek.Tuesday && "2" == weektag.Week2) ||
(dttemp.DayOfWeek == System.DayOfWeek.Wednesday && "2" == weektag.Week3) ||
(dttemp.DayOfWeek == System.DayOfWeek.Thursday && "2" == weektag.Week4) ||
(dttemp.DayOfWeek == System.DayOfWeek.Friday && "2" == weektag.Week5) ||
(dttemp.DayOfWeek == System.DayOfWeek.Saturday && "2" == weektag.Week6) ||
(dttemp.DayOfWeek == System.DayOfWeek.Sunday && "2" == weektag.Week7))
{
var department = db.Departments.ToList();
var staff = db.Staffs.ToList();
foreach (var temp in department)
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = temp.DepartmentId;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "2";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
}
foreach (var temp1 in staff)
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = temp1.StaffNumber;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "2";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
}
}
if ((dttemp.DayOfWeek == System.DayOfWeek.Monday && "3" == weektag.Week1) ||
(dttemp.DayOfWeek == System.DayOfWeek.Tuesday && "3" == weektag.Week2) ||
(dttemp.DayOfWeek == System.DayOfWeek.Wednesday && "3" == weektag.Week3) ||
(dttemp.DayOfWeek == System.DayOfWeek.Thursday && "3" == weektag.Week4) ||
(dttemp.DayOfWeek == System.DayOfWeek.Friday && "3" == weektag.Week5) ||
(dttemp.DayOfWeek == System.DayOfWeek.Saturday && "3" == weektag.Week6) ||
(dttemp.DayOfWeek == System.DayOfWeek.Sunday && "3" == weektag.Week7))
{
var department = db.Departments.ToList();
var staff = db.Staffs.ToList();
foreach (var temp in department)
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = temp.DepartmentId;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "3";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
}
foreach (var temp1 in staff)
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = temp1.StaffNumber;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "3";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
}
}
if ((dttemp.DayOfWeek == System.DayOfWeek.Monday && "4" == weektag.Week1) ||
(dttemp.DayOfWeek == System.DayOfWeek.Tuesday && "4" == weektag.Week2) ||
(dttemp.DayOfWeek == System.DayOfWeek.Wednesday && "4" == weektag.Week3) ||
(dttemp.DayOfWeek == System.DayOfWeek.Thursday && "4" == weektag.Week4) ||
(dttemp.DayOfWeek == System.DayOfWeek.Friday && "4" == weektag.Week5) ||
(dttemp.DayOfWeek == System.DayOfWeek.Saturday && "4" == weektag.Week6) ||
(dttemp.DayOfWeek == System.DayOfWeek.Sunday && "4" == weektag.Week7))
{
var department = db.Departments.ToList();
var staff = db.Staffs.ToList();
foreach (var temp in department)
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = temp.DepartmentId;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "4";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
}
foreach (var temp1 in staff)
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = temp1.StaffNumber;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "4";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
}
}
}
}
else
{
var htrdepartment = db.HolidayTimeRecords.Where(d => d.Number.Equals(weektag.Range)).ToList();
foreach (var temp in htrdepartment)
{
HolidayTimeRecord depart = db.HolidayTimeRecords.Find(temp.Id);
db.HolidayTimeRecords.Remove(depart);
}
db.SaveChanges();
var staff1 = db.Staffs.Where(s => s.Department.Equals(weektag.Range)).ToList();
foreach (var temp1 in staff1)
{
var htrdepartment1 = db.HolidayTimeRecords.Where(d => d.Number.Equals(temp1.StaffNumber));
foreach (var temp2 in htrdepartment1)
{
HolidayTimeRecord depart = db.HolidayTimeRecords.Find(temp2.Id);
db.HolidayTimeRecords.Remove(depart);
}
}
db.SaveChanges();
for (int i = 0; i < intdiffer; i++)
{
DateTime dttemp = begindate.Date.AddDays(i);
if ((dttemp.DayOfWeek == System.DayOfWeek.Monday && "1" == weektag.Week1) ||
(dttemp.DayOfWeek == System.DayOfWeek.Tuesday && "1" == weektag.Week2) ||
(dttemp.DayOfWeek == System.DayOfWeek.Wednesday && "1" == weektag.Week3) ||
(dttemp.DayOfWeek == System.DayOfWeek.Thursday && "1" == weektag.Week4) ||
(dttemp.DayOfWeek == System.DayOfWeek.Friday && "1" == weektag.Week5) ||
(dttemp.DayOfWeek == System.DayOfWeek.Saturday && "1" == weektag.Week6) ||
(dttemp.DayOfWeek == System.DayOfWeek.Sunday && "1" == weektag.Week7))
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = weektag.Range;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "1";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
var staff = db.Staffs.Where(s => s.Department.Equals(weektag.Range)).ToList();
foreach (var temp1 in staff)
{
HolidayTimeRecord holidayTime1 = new HolidayTimeRecord();
holidayTime1.Number = temp1.StaffNumber;
holidayTime1.RecordTimeHoliday = dttemp;
holidayTime1.Tag = "1";
db.HolidayTimeRecords.Add(holidayTime1);
db.SaveChanges();
}
}
if ((dttemp.DayOfWeek == System.DayOfWeek.Monday && "2" == weektag.Week1) ||
(dttemp.DayOfWeek == System.DayOfWeek.Tuesday && "2" == weektag.Week2) ||
(dttemp.DayOfWeek == System.DayOfWeek.Wednesday && "2" == weektag.Week3) ||
(dttemp.DayOfWeek == System.DayOfWeek.Thursday && "2" == weektag.Week4) ||
(dttemp.DayOfWeek == System.DayOfWeek.Friday && "2" == weektag.Week5) ||
(dttemp.DayOfWeek == System.DayOfWeek.Saturday && "2" == weektag.Week6) ||
(dttemp.DayOfWeek == System.DayOfWeek.Sunday && "2" == weektag.Week7))
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = weektag.Range;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "2";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
var staff = db.Staffs.Where(s => s.Department.Equals(weektag.Range)).ToList();
foreach (var temp1 in staff)
{
HolidayTimeRecord holidayTime1 = new HolidayTimeRecord();
holidayTime1.Number = temp1.StaffNumber;
holidayTime1.RecordTimeHoliday = dttemp;
holidayTime1.Tag = "2";
db.HolidayTimeRecords.Add(holidayTime1);
db.SaveChanges();
}
}
if ((dttemp.DayOfWeek == System.DayOfWeek.Monday && "3" == weektag.Week1) ||
(dttemp.DayOfWeek == System.DayOfWeek.Tuesday && "3" == weektag.Week2) ||
(dttemp.DayOfWeek == System.DayOfWeek.Wednesday && "3" == weektag.Week3) ||
(dttemp.DayOfWeek == System.DayOfWeek.Thursday && "3" == weektag.Week4) ||
(dttemp.DayOfWeek == System.DayOfWeek.Friday && "3" == weektag.Week5) ||
(dttemp.DayOfWeek == System.DayOfWeek.Saturday && "3" == weektag.Week6) ||
(dttemp.DayOfWeek == System.DayOfWeek.Sunday && "3" == weektag.Week7))
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = weektag.Range;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "3";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
var staff = db.Staffs.Where(s => s.Department.Equals(weektag.Range)).ToList();
foreach (var temp1 in staff)
{
HolidayTimeRecord holidayTime1 = new HolidayTimeRecord();
holidayTime1.Number = temp1.StaffNumber;
holidayTime1.RecordTimeHoliday = dttemp;
holidayTime1.Tag = "3";
db.HolidayTimeRecords.Add(holidayTime1);
db.SaveChanges();
}
}
if ((dttemp.DayOfWeek == System.DayOfWeek.Monday && "4" == weektag.Week1) ||
(dttemp.DayOfWeek == System.DayOfWeek.Tuesday && "4" == weektag.Week2) ||
(dttemp.DayOfWeek == System.DayOfWeek.Wednesday && "4" == weektag.Week3) ||
(dttemp.DayOfWeek == System.DayOfWeek.Thursday && "4" == weektag.Week4) ||
(dttemp.DayOfWeek == System.DayOfWeek.Friday && "4" == weektag.Week5) ||
(dttemp.DayOfWeek == System.DayOfWeek.Saturday && "4" == weektag.Week6) ||
(dttemp.DayOfWeek == System.DayOfWeek.Sunday && "4" == weektag.Week7))
{
HolidayTimeRecord holidayTime = new HolidayTimeRecord();
holidayTime.Number = weektag.Range;
holidayTime.RecordTimeHoliday = dttemp;
holidayTime.Tag = "4";
db.HolidayTimeRecords.Add(holidayTime);
db.SaveChanges();
var staff = db.Staffs.Where(s => s.Department.Equals(weektag.Range)).ToList();
foreach (var temp1 in staff)
{
HolidayTimeRecord holidayTime1 = new HolidayTimeRecord();
holidayTime1.Number = temp1.StaffNumber;
holidayTime1.RecordTimeHoliday = dttemp;
holidayTime1.Tag = "4";
db.HolidayTimeRecords.Add(holidayTime1);
db.SaveChanges();
}
}
}
}
db.WeekTags.Add(weektag);
db.SaveChanges();
return(RedirectToAction("Index"));
}
