public ActionResult ExportReport([Bind(Include = "CompanyId,DepartmentId")] StaffSearchModel q) { var msg = new ReportMessage(); if (Request.QueryString["type"] == "100") { msg = new ReportExcelHelper(Settings.Default.db).ExportExtraSumReport( DateTime.Parse(Request.QueryString["startDate"]), DateTime.Parse(Request.QueryString["endDate"]), q); } else { msg = new ReportExcelHelper(Settings.Default.db).ExportHandledAttendDetail( DateTime.Parse(Request.QueryString["startDate"]), DateTime.Parse(Request.QueryString["endDate"]), q); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
static void Main(string[] args) { ReportExcelHelper helper = new ReportExcelHelper(Settings.Default.db); StaffSearchModel searchModel = new StaffSearchModel(); searchModel.StaffNrs = new List <string>() { "200268", "200835", "202274", "202348", "202487" }; //ReportMessage msg= helper.ExportExtraSumReport(DateTime.Parse("2016-8-1"), DateTime.Parse("2016-8-31"),searchModel); ReportMessage msg = helper.ExportHandledAttendDetail(DateTime.Parse("2016-8-1"), DateTime.Parse("2016-8-31"), searchModel); Console.WriteLine(msg.Success); Console.WriteLine(msg.Content); //Console.WriteLine(DateTime.Now.DayOfWeek.ToString()); //DateTime st = DateTime.Parse("2016-9-1"); //DateTime et = DateTime.Parse("2016-9-2 1:00"); //Console.WriteLine((et - st).TotalDays); //Console.WriteLine(new TimeSpan(7, 8, 0).ToString("hh\\:mm")); //Staff s = new Staff(); //s.PropertyChanging += S_PropertyChanging; //s.PropertyChanged += S_PropertyChanged; //s.address = "a"; //s.address = "b"; //DataContext dc = new DataContext(Settings.Default.db); //List<string> staffNrs = new List<string>(); //List<DateTime> datetime = new List<DateTime>(); //for(int i = 0; i < 3000; i++) //{ // staffNrs.Add(i.ToString()+"n"); // datetime.Add(DateTime.Now.AddDays(0 - i).Date); //} //string nrsq = string.Format(",{0},", string.Join(",", staffNrs)); //string dateq = string.Format(",{0},", string.Join(",", datetime.Select(ss => ss.ToString("yyyy-MM-dd")).ToList())); //IQueryable<AttendanceRecordCal> cq = dc.Context.GetTable<AttendanceRecordCal>() // .Where(s => nrsq.IndexOf("," + s.staffNr + ",") != -1) // .Where(ss=> dateq.IndexOf("," + ss.attendanceDate.ToString("yyyy-MM-dd") + ",")!=-1).Take(20); ////List<AttendanceRecordCal> _updateCals = dc.Context.GetTable<AttendanceRecordCal>() //// .AsEnumerable() //// .Join(staffNrs, s => s.staffNr, ci => ci, (s, ci) => s) //// .Join(datetime, sss => sss.attendanceDate, cci => cci, (sss, cci) => sss).ToList(); //// List<AttendanceRecordDetailView> _updateCals = dc.Context.GetTable<AttendanceRecordDetailView>() //// .AsEnumerable() //// .Join(staffNrs, s => s.staffNr, ci => ci, (s, ci) => s) ////.Join(datetime, sss => sss.recordAtDate, cci => cci, (sss, cci) => sss) //// .ToList(); //IQueryable<AttendanceRecordDetailView> q = dc.Context.GetTable<AttendanceRecordDetailView>() // .Where(s => ("," + string.Join(",", staffNrs.ToArray()) + ",").IndexOf("," + s.staffNr + ",") != -1).Take(20); //List<AttendanceRecordDetailView> li = q.ToList(); Console.Read(); //try //{ // int.Parse("&*^Df"); //} //catch (Exception ex) //{ // LogUtil.Logger.Error("服务运行时出错", ex); //} //Console.WriteLine(" 1. create staff \n 2.create shiftshedule\n 3.create record\n 4.calcualte staff attendance \n 5. PRESS q to quit."); //string ke = Console.ReadLine(); //while (!ke.Equals("q")) //{ // Cmd(ke); // ke = Console.ReadLine(); //} //Console.WriteLine("quiting....press ENTER...."); //Console.Read(); }