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();
}
