static void Main()
{
//WordHelper.CreateFileByTemplate("ReportTemplate\\ReportTemplate.docx", "ReportStore\\1.docx");
//Database.SetInitializer(new DropCreateDatabaseIfModelChanges<EFMySqlDbContext>());
Database.SetInitializer <EFMySqlDbContext>(null);
using (var context = new EFMySqlDbContext())
{
//context.Tb_codes.Add(new Db.Entity.Tb_code() { codeName = "1", codeType = 1 });
//context.SaveChanges();
//var code = context.Tb_codes.FirstOrDefault(c => c.code_id == 1);
}
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Login());
}
public static List <queryEveryPersonTaskNum> selectEveryPersonTaskNum(string startTime, string endTime)
{
string sql = string.Format(@"SELECT * FROM
(
select taskExecutor,DATE_FORMAT(taskDateTime,'%Y.%m') as dateNum,count(1)as number
from tb_taskresult temp
where taskStep=(SELECT max(taskStep) from tb_taskresult where taskId=temp.taskId and taskExecutor=temp.taskExecutor and taskRound=temp.taskRound)
and taskDateTime BETWEEN '{0}' AND '{1}'
GROUP BY taskExecutor,dateNum
ORDER BY taskExecutor
) tb
ORDER BY dateNum", startTime, endTime);
using (EFMySqlDbContext context = new EFMySqlDbContext())
{
return(context.Database.SqlQuery <queryEveryPersonTaskNum>(sql).ToList());
}
}
