public bool CreateCYXJ(string start, string end, out string msg)
{
try
{
log.WriteLog("查询" + start + "-" + end + "出院小结数据");
log.WriteLog(SqlStr.CyxjSql(start, end));
DataTable data = sqlClient.ExecuteQuery(SqlStr.CyxjSql(start, end), CommandType.Text);
if (data.Rows.Count < 0)
{
msg = "无出院小结记录\n";
}
else
{
CSVUtil.SaveCSV(data, fluUrl + "\\hda_出院小结" + start + "-" + end + ".csv");
CSVUtil.SaveCSV(data, backUpUrl + "\\hda_出院小结" + start + "-" + end + ".csv");
msg = "出院小结记录已生成\n";
}
log.WriteLog("查询成功");
}
catch (Exception ex)
{
msg = ex.Message;
log.WriteLog("查询失败:" + ex.Message, LogType.Error);
return(false);
}
return(true);
}
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";
}
}
