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"; } }