public Task Execute(IJobExecutionContext context)
{
FluDataCreate fluData = new FluDataCreate();
string startTime = "";
string endTime = DateTime.Now.ToString("yyyy-MM-dd");
if (isFrist)
{
startTime = OperateIniFile.read("TASK", "startTime", "");
OperateIniFile.write("TASK", "nextStartTime", endTime);
isFrist = false;
}
else
{
startTime = OperateIniFile.read("TASK", "nextStartTime", "");
OperateIniFile.write("TASK", "startTime", endTime);
isFrist = true;
}
string msg;
fluData.CreateMZHZY(startTime, endTime, out msg);
//logger.WriteLog(startTime + "---" + endTime + "生成门诊和在院流感记录成功");
return(Task.CompletedTask);
}
public FluDataCreate()
{
this.hqmsUrl = OperateIniFile.read("FILESAVEPATH", "hqms", "");
this.fluUrl = OperateIniFile.read("FILESAVEPATH", "flu", "");
this.backUpUrl = OperateIniFile.read("FILESAVEPATH", "backUp", "");
sqlClient = new SQLClient();
log = Logger.Instance;
}
public SQLClient()
{
this.source = OperateIniFile.read("DATABASE", "local", "127.0.0.11");
this.user = OperateIniFile.read("DATABASE", "username", "sa");
this.password = OperateIniFile.read("DATABASE", "password", "6");
this.catalog = OperateIniFile.read("DATABASE", "catalog", "hisdata");
this.connectString = "Data Source=" + this.source + ";Initial Catalog=" + this.catalog + ";User ID=" + this.user + ";Password=" + this.password;
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
dateBaseView = new DateBaseViewModel();
dateBaseView.DataBaseUrl = OperateIniFile.read("DATABASE", "local", "127.0.0.1");
dateBaseView.DataBaseUser = OperateIniFile.read("DATABASE", "username", "sa");
dateBaseView.DataBasePassword = OperateIniFile.read("DATABASE", "password", "6");
dateBaseView.DataBaseCatalog = OperateIniFile.read("DATABASE", "catalog", "hisdata1");
this.tbUrl.DataContext = dateBaseView;
this.tbUser.DataContext = dateBaseView;
this.tbPassword.DataContext = dateBaseView;
this.tbCatalog.DataContext = dateBaseView;
}
//private Logger logger = Logger.Instance;
public Task Execute(IJobExecutionContext context)
{
FluDataCreate fluData = new FluDataCreate();
bool mzhzyCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "mzhzy", "true"));
bool cyxjCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "cyxj", "true"));
bool swjlCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "swjl", "true"));
bool cylgblCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "cylgbl", "true"));
bool jyjlCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "jyjl", "true"));
//string cron = OperateIniFile.read("TASK", "cron", "0 0 23 ? * SUN");//默认是每个星期天晚上十一点钟生成
bool yyjlCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "yyjl", "true"));
string startTime = OperateIniFile.read("TASK", "startTime", "");
string yesterday = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
string endTime = DateTime.Now.ToString("yyyy-MM-dd");
string msg;
if (mzhzyCheck)
{
fluData.CreateMZHZY(yesterday, endTime, out msg);
}
if (cyxjCheck)
{
fluData.CreateCYXJ(yesterday, endTime, out msg);
}
if (swjlCheck)
{
fluData.CreateSWJL(yesterday, endTime, out msg);
}
if (cylgblCheck)
{
fluData.CreateCYXJ(yesterday, endTime, out msg);
}
if (jyjlCheck)
{
fluData.CreateJYJL(yesterday, endTime, out msg);
}
if (yyjlCheck)
{
fluData.CreateYYJL(yesterday, endTime, out msg);
}
return(Task.CompletedTask);
}
private void InitWin(object sender, RoutedEventArgs e)
{
viewModel = new TaskViewModel();
viewModel.Mzhzy = Convert.ToBoolean(OperateIniFile.read("TASK", "mzhzy", "true"));
viewModel.Cyxj = Convert.ToBoolean(OperateIniFile.read("TASK", "cyxj", "true"));
viewModel.Swjl = Convert.ToBoolean(OperateIniFile.read("TASK", "swjl", "true"));
viewModel.Cylgba = Convert.ToBoolean(OperateIniFile.read("TASK", "cylgbl", "true"));
viewModel.Jyjl = Convert.ToBoolean(OperateIniFile.read("TASK", "jyjl", "true"));
viewModel.Yyjl = Convert.ToBoolean(OperateIniFile.read("TASK", "yyjl", "true"));
viewModel.Cron = OperateIniFile.read("TASK", "cron", "100000");
viewModel.StartTime = OperateIniFile.read("TASK", "startTime", "");
this.startTime.DataContext = viewModel;
this.tbCron.DataContext = viewModel;
this.cbMzhzy.DataContext = viewModel;
this.cbCyxj.DataContext = viewModel;
this.cbCylgba.DataContext = viewModel;
this.cbSwjl.DataContext = viewModel;
this.cbJyjl.DataContext = viewModel;
this.cbYyjl.DataContext = viewModel;
}
public void RunAllJob()
{
bool mzhzyCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "mzhzy", "true"));
bool cyxjCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "cyxj", "true"));
bool swjlCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "swjl", "true"));
bool cylgblCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "cylgbl", "true"));
bool jyjlCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "jyjl", "true"));
cron = OperateIniFile.read("TASK", "cron", "0 0 23 ? * SUN");//默认是每个星期天晚上十一点钟生成
bool yyjlCheck = Convert.ToBoolean(OperateIniFile.read("TASK", "yyjl", "true"));
if (!mzhzyCheck)
{
scheduler.PauseJob(mzzyJob.Key);
}
if (cylgblCheck)
{
scheduler.PauseJob(cylgbaJob.Key);
}
if (swjlCheck)
{
scheduler.PauseJob(swjlJob.Key);
}
if (jyjlCheck)
{
scheduler.PauseJob(jyjlJob.Key);
}
if (cyxjCheck)
{
scheduler.PauseJob(cyxjJob.Key);
}
if (yyjlCheck)
{
scheduler.PauseJob(yyjlJob.Key);
}
}
private void InitWin(object sender, RoutedEventArgs e)
{
try
{
sqlClient = new SQLClient();
task = new TaskClient();
logger = Logger.Instance;
mainViewModel = new MainViewModel();
loading = new Loading();
mainViewModel.HqmsPath = OperateIniFile.read("FILESAVEPATH", "hqms", "");
isMiniWin = Convert.ToBoolean(OperateIniFile.read("SETTING", "kjqdzxh", "false"));
mainViewModel.FluPath = OperateIniFile.read("FILESAVEPATH", "flu", "");
mainViewModel.BackUpPath = OperateIniFile.read("FILESAVEPATH", "backUp", "");
sqlClient.ExecuteQuery("select 1;", CommandType.Text);
this.log.Text += "数据库连接成功\n";
logger.WriteLog("数据库连接成功");
fluData = new FluDataCreate();
mainViewModel.StartTime = DateTime.Now.ToString("yyyy-MM-dd");
mainViewModel.EndTime = DateTime.Now.ToString("yyyy-MM-dd");
this.fluPath.DataContext = mainViewModel;
this.hqmsPath.DataContext = mainViewModel;
this.backUpPath.DataContext = mainViewModel;
this.startTime.DataContext = mainViewModel;
this.endTime.DataContext = mainViewModel;
if (isMiniWin)
{
//隐藏窗体
this.WindowState = WindowState.Minimized;
}
}
catch (Exception ex)
{
this.log.Text += ex.Message;
this.log.Text += "\n";
}
}
private void InitWin(object sender, RoutedEventArgs e)
{
kjqdIsCheck = OperateIniFile.read("SETTING", "kjqd", "0").Equals("0") ? true : false;
kjqdzxhIsCheck = OperateIniFile.read("SETTING", "kjqdzxh", "0").Equals("0") ? true : false;
}
