/// <summary> /// 河南省医疗服务恢复情况监测周报表 /// </summary> public static void hnsylfwhfqkjczbb(ClassCOM com) { // 数据 var Data = com.Data.Tables[0].Copy(); // 'Exe地址 var PathExe = com.GetParam(0); // 'Bin地址 var PathBin = com.GetParam(1); // '模板地址 var PathTemplate = com.GetParam(2); // '保存地址 //var PathSave = com.GetParam(3); var PathSave = com.GetParam(8); // '模板文件名 var NameTemplate = com.GetParam(4); // '保存文件名 var NameSave = com.GetParam(5); // '查询时间 var Date = DateTime.ParseExact(com.GetParam(6), "yyyyMMdd", CultureInfo.CurrentCulture); // '数据导入开始行 var RowBeginIndex = int.Parse(com.GetParam(7)); // '数据导入结束行 var RowEndIndex = RowBeginIndex + Data.Rows.Count - 1; var book = new Workbook(); book.LoadFromFile(Path.Combine(PathTemplate, NameTemplate)); var sheet = book.Worksheets[0]; //// 设置单元格日期 //sheet.GetCellFirst().SetCellReplace("[DATE]", Date.ToString("yyyy年MM月")); //// 设置单元格计数 //sheet.GetCellFirst().SetCellReplace("[NUM]", (Helper.GetWeekNumInMonth(Date) - 1).ToString()); //sheet.DataTableToExcel(Data, RowBeginIndex); //设置单元格数据 //日期 2020年 03 月 23 日—— 03月 29 日 var temp = Date.AddDays(-6).ToString("yyyy年 MM 月 dd 日") + "—— " + Date.ToString("MM月 dd 日"); sheet.GetCell(3, 1).SetCellReplace("[DATE]", temp); //门诊人次 sheet.SetCellValue(6, 3, Data.Rows[0][0].ToString()); sheet.SetCellValue(6, 4, Data.Rows[1][0].ToString()); //急诊人次 sheet.SetCellValue(6, 6, Data.Rows[0][1].ToString()); sheet.SetCellValue(6, 7, Data.Rows[1][1].ToString()); //住院人次 sheet.SetCellValue(6, 9, Data.Rows[0][2].ToString()); sheet.SetCellValue(6, 10, Data.Rows[1][2].ToString()); //出院人次 sheet.SetCellValue(6, 12, Data.Rows[0][3].ToString()); sheet.SetCellValue(6, 13, Data.Rows[1][3].ToString()); //手术台次 sheet.SetCellValue(6, 15, Data.Rows[0][4].ToString()); sheet.SetCellValue(6, 16, Data.Rows[1][4].ToString()); book.SaveToFile(Path.Combine(PathSave, NameSave)); sheet.Dispose(); book.Dispose(); }
/// <summary> /// 每日核酸检测信息1 /// </summary> /// <param name="com"></param> public static void MRHSJCXX1(ClassCOM com) { // 数据 var Data = com.Data.Tables[0].Copy(); // 无数据 if (Data.Rows.Count <= 0) { return; } // 'Exe地址 var PathExe = com.GetParam(0); // 'Bin地址 var PathBin = com.GetParam(1); // '模板地址 var PathTemplate = com.GetParam(2); // '保存地址 //var PathSave = com.GetParam(3); var PathSave = com.GetParam(8); // '模板文件名 var NameTemplate = com.GetParam(4); // '保存文件名 var NameSave = com.GetParam(5); // '查询时间 var Date = DateTime.ParseExact(com.GetParam(6), "yyyyMMdd", CultureInfo.CurrentCulture); // '数据导入开始行 var RowBeginIndex = int.Parse(com.GetParam(7)); // '数据导入结束行 var RowEndIndex = RowBeginIndex + Data.Rows.Count - 1; var book = new Workbook(); book.LoadFromFile(Path.Combine(PathTemplate, NameTemplate)); var sheet = book.Worksheets[0]; // 设置单元格日期 sheet.GetCell(1, 2).SetCellReplace("{0}", Date.ToString("MM月dd日")); // 导出数据到Excel sheet.DataTableToExcel(Data, RowBeginIndex); // 添加边框 // 字号 // 加粗 // 居中 var cells = sheet.GetCell(RowBeginIndex, 1, RowEndIndex, Data.Columns.Count); //cells.StyleLine().StyleFontSize(16).StyleFontIsBold().StyleFontCenter(); cells.StyleLine(); // 行高 //cells.RowHeight = 32; //报送人:郑铮 //报送人联系方式(手机号):18637958250 sheet.GetCell(RowEndIndex + 2, 2).Text = "报送人:郑铮"; sheet.GetCell(RowEndIndex + 2, 5).Text = "报送人联系方式(手机号):18637958250"; // 保存 book.SaveToFile(Path.Combine(PathSave, NameSave)); }
public static void DRBGDY(ClassCOM com) { // 数据 var Data = com.Data.Tables[0].Copy(); // 'Exe地址 var PathExe = com.GetParam(0); // 'Bin地址 var PathBin = com.GetParam(1); // '模板地址 var PathTemplate = com.GetParam(2); // '保存地址 var PathSave = com.GetParam(3); // '模板文件名 var NameTemplate = com.GetParam(4); // '保存文件名 var NameSave = com.GetParam(5); // '查询时间 var Date = DateTime.ParseExact(com.GetParam(6), "yyyyMMdd", CultureInfo.CurrentCulture); // '数据导入开始行 var RowBeginIndex = int.Parse(com.GetParam(7)); // '数据导入结束行 var RowEndIndex = RowBeginIndex + Data.Rows.Count - 1; var dr = Data.AsEnumerable(); foreach (var item in dr) { if (item[0].ToString().IsNullOrWhiteSpace()) { continue; } var book = new Workbook(); book.LoadFromFile(Path.Combine(PathTemplate, NameTemplate)); var sheet = book.Worksheets[0]; for (int i = 0; i < item.ItemArray.Length; i++) { sheet.Range[5, 1 + i].Value = item[i].ToString(); } book.SaveToFile(Path.Combine(PathSave, item[1].ToString() + ".xlsx")); book.PrintDocument.Print(); } }
/// <summary> /// 入院人数和门急诊就诊人数 /// </summary> /// <param name="com"></param> public static void ryrshmjzjzrs(ClassCOM com) { // 数据 var Data = com.Data.Tables[0].Copy(); // 无数据 if (Data.Rows.Count <= 0) { return; } // 'Exe地址 var PathExe = com.GetParam(0); // 'Bin地址 var PathBin = com.GetParam(1); // '模板地址 var PathTemplate = com.GetParam(2); // '保存地址 //var PathSave = com.GetParam(3); var PathSave = com.GetParam(8); // '模板文件名 var NameTemplate = com.GetParam(4); // '保存文件名 var NameSave = com.GetParam(5); // '查询时间 var Date = DateTime.ParseExact(com.GetParam(6), "yyyyMMdd", CultureInfo.CurrentCulture); // '数据导入开始行 var RowBeginIndex = int.Parse(com.GetParam(7)); // '数据导入结束行 var RowEndIndex = RowBeginIndex + Data.Rows.Count - 1; var book = new Workbook(); book.LoadFromFile(Path.Combine(PathTemplate, NameTemplate)); var sheet = book.Worksheets[0]; // 设置单元格日期 sheet.GetCellFirst().SetCellReplace("[DATE]", Date.ToString("yyyy年MM月dd日")); // 导出数据到Excel sheet.DataTableToExcel(Data, RowBeginIndex, true); // 保存 book.SaveToFile(Path.Combine(PathSave, NameSave)); }
/// <summary> /// 每日核酸检测信息3 /// </summary> /// <param name="com"></param> public static void MRHSJCXX3(ClassCOM com) { // 数据 var Data = com.Data.Tables[0].Copy(); // 'Exe地址 var PathExe = com.GetParam(0); // 'Bin地址 var PathBin = com.GetParam(1); // '模板地址 var PathTemplate = com.GetParam(2); // '保存地址 //var PathSave = com.GetParam(3); var PathSave = com.GetParam(8); // '模板文件名 var NameTemplate = com.GetParam(4); // '保存文件名 var NameSave = com.GetParam(5); // '查询时间 var Date = DateTime.ParseExact(com.GetParam(6), "yyyyMMdd", CultureInfo.CurrentCulture); // '数据导入开始行 var RowBeginIndex = int.Parse(com.GetParam(7)); // '数据导入结束行 var RowEndIndex = RowBeginIndex + Data.Rows.Count - 1; var book = new Workbook(); book.LoadFromFile(Path.Combine(PathTemplate, NameTemplate)); var sheet = book.Worksheets[0]; // 无数据 if (Data.Rows.Count <= 0) { sheet.GetCell(RowBeginIndex, 1).Text = "无数据"; } else { // 导出数据到Excel sheet.DataTableToExcel(Data, RowBeginIndex); } // 保存 book.SaveToFile(Path.Combine(PathSave, NameSave)); }
/// <summary> /// 主函数 /// </summary> /// <param name="args">需要传入的数据</param> public static void Main(string[] args) { try { // bin文件的地址 var pathbin = args.Length == 0 ? "" : args[0]; //var pathbin = @"C:\resource\金网运营管理系统\GTSharp\Bin\67e33f08-3b94-4afb-83e5-063c559dfa76.bin"; //var pathbin = @"D:\VS\LYSDLYYWX\LYSDLYYWX\bin\Debug\GTSharp\Bin\1a28113e-67d4-4e6a-9824-96b02bb23705.bin"; //fa6792dc-faa0-4295-b06f-d7bab6392316.bin // 转化为对象 //GTDataFile datafile = GTSharp.Core.SerializeHelper.FileTObje<GTDataFile>(pathbin); //// 执行数据 //GTHelper.Save(datafile); //GTSharp.Core.Log.Log4Net.Info("成功!"); ////关闭 //Close(); //return; //pathbin = @"D:\VS\LYSDLYYWX\LYSDLYYWX\bin\Debug\GTSharp\Bin\224c71d9-61be-4c7a-ac43-2106af293fcb.bin"; //pathbin = @"C:\Users\Administrator\Desktop\0f8783e4-6966-4f4e-8bb5-03092ea5c308.bin"; // 转化为对象 ClassCOM com = GTSharp.Core.SerializeHelper.FileTObje <ClassCOM>(pathbin); //switch (datafile.Command) switch (com.ComName) { case "每日1科室在院人数一览表": AnalysisReport.MRYYCXBB1(com); //AnalysisReport.MR1(GTHelper.Save(datafile)); break; case "每日2按手术时间统计手术人数表": AnalysisReport.MRYYCXBB2(com); break; case "每日3在院危重病人患者明细表": AnalysisReport.MRYYCXBB3(com); break; case "每日4在院I级护理患者明细表": AnalysisReport.MRYYCXBB3(com); break; case "每日6在院护理无患者明细表": AnalysisReport.MRYYCXBB3(com); break; case "每日5主要业务数据表": AnalysisReport.MRYYCXBB5(com); break; case "每日7主要业务数据表": AnalysisReport.MRYYCXBB7(com); break; case "每日8主要业务数据表": AnalysisReport.MRYYCXBB8(com); break; case "每日9科室在院人数一览表": AnalysisReport.MRYYCXBB9(com); break; case "每日10门诊退费明细": AnalysisReport.MRYYCXBB10(com); break; case "每日11门诊日志登记表": AnalysisReport.MRYYCXBB11(com); break; case "每日12门诊日志汇总表": AnalysisReport.MRYYCXBB12(com); break; case "每日13门诊疑似胸痛患者列表": AnalysisReport.MRYYCXBB13(com); break; case "全院未交病历": QYWTJBL.WeekReport1(com); break; case "DR报告打印": FSK.DRBGDY(com); break; case "每周院长查询报表": AnalysisReport.MZYZCXBB1(com); break; case "每周2主要业务数据表": AnalysisReport.MZYZCXBB2(com); break; case "删除多余数据": DeleteBin(Path.GetDirectoryName(pathbin), 50); break; case "河南省医疗服务恢复情况监测周报表": Class1.hnsylfwhfqkjczbb(com); break; case "入院人数和门急诊就诊人数": Class1.ryrshmjzjzrs(com); break; case "心血管疾病病人信息": Class1.xxgjbbrxx(com); break; case "每月洛轴医保卡帐户": AnalysisReport.MYLZYBKZH(com); break; case "每月1住院主要业务数据同期比表": AnalysisReport.MYYZCXBB1(com); break; case "每月2医技科室收入数据同期比表": AnalysisReport.MYYZCXBB2(com); break; case "每月4每月手术人数表": AnalysisReport.MYYZCXBB4(com); break; case "每月3门急诊数据同期比表": AnalysisReport.MYYZCXBB3(com); break; case "每月5主要业务数据表": AnalysisReport.MYYZCXBB5(com); break; case "每月6主要业务数据表": AnalysisReport.MYYZCXBB6(com); break; case "每月在院人数": Class1.myzyrs(com); break; case "每日核酸检测信息": Class1.MRHSJCXX(com); break; case "每日核酸检测信息1": Class1.MRHSJCXX1(com); break; case "每日核酸检测信息2": Class1.MRHSJCXX2(com); break; case "每日核酸检测信息3": Class1.MRHSJCXX3(com); break; // default: // 删除多余数据 DeleteBin(Path.GetDirectoryName(pathbin), 50); GTSharp.Core.Log.Log4Net.Info("未知命令?"); Console.ReadLine(); break; } GTSharp.Core.Log.Log4Net.Info("成功!"); //关闭 Close(); } catch (Exception ex) { GTSharp.Core.Log.Log4Net.Error(ex); Console.ReadLine(); } }
static void Main(string[] args) { Console.WriteLine("命令说明"); Console.WriteLine("其他:更新"); Console.WriteLine("0 :上传"); var w = Console.ReadLine(); try { if (w != "0") { Console.Title = "更新程序"; Console.WriteLine("开始更新"); Console.WriteLine("……"); // ftp://172.16.6.28/ FluentFTPHelper ftp1 = new FluentFTPHelper("172.16.6.28", "lysdlyy", "lysdlyy"); FluentFTPHelper ftp2 = new FluentFTPHelper("172.16.6.28", "gtsharp", "gtsharp"); FluentFTPHelper ftp3 = new FluentFTPHelper("172.16.6.28", "dpn48", "dpn48"); ClassCOM com = new ClassCOM(); var YYPath = Path.GetDirectoryName(Path.GetDirectoryName(com.GetPath())); Console.WriteLine("更新目录位置"); Console.WriteLine(YYPath); Console.WriteLine("……"); var path = Path.Combine(YYPath, @"GTSharp\Exe\LYSDLYY\"); var dpn48 = Path.Combine(YYPath, @"GTSharp\Exe\dpn48\"); Console.WriteLine("更新EXE"); ftp1.UpdateDownloadFile(path, ""); Console.WriteLine("更新DLL"); ftp2.UpdateDownloadFile(YYPath, ""); Console.WriteLine("更新框架"); ftp3.UpdateDownloadFile(dpn48, ""); Console.WriteLine("更新完成"); Console.WriteLine("……"); } else { Console.Title = "上传程序"; Console.WriteLine("开始上传"); Console.WriteLine("……"); // ftp://172.16.6.28/ FluentFTPHelper ftp1 = new FluentFTPHelper("172.16.6.28", "lysdlyy", "lysdlyy"); FluentFTPHelper ftp2 = new FluentFTPHelper("172.16.6.28", "gtsharp", "gtsharp"); ClassCOM com = new ClassCOM(); var gtsharp = @"D:\VS\GTSharp\GTSharp\bin\Debug\net20"; var lysdlyy = @"D:\VS\LYSDLYY\LYSDLYY\bin\Debug"; Console.WriteLine("上传目录位置"); Console.WriteLine(gtsharp); Console.WriteLine(lysdlyy); Console.WriteLine("……"); Console.WriteLine("上传LYSDLYY"); ftp1.UploadFile(lysdlyy); Console.WriteLine("上传GTSharp"); ftp2.UploadFile(gtsharp); Console.WriteLine("上传完成"); Console.WriteLine("……"); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
/// <summary> /// 导出模板:每周1全院未交病历.xls /// 参数 /// 0:DataTable数据 /// 0:执行命令 /// 1:写入数据开始行 /// 2:日期增加天数 /// 3:模板文件路径 /// 4:保存文件路径 /// </summary> /// <param name="com"></param> public static void WeekReport1(ClassCOM com) { // 数据 var Data = com.Data.Tables[0].Copy(); // 无数据 if (Data.Rows.Count <= 0) { return; } // 'Exe地址 var PathExe = com.GetParam(0); // 'Bin地址 var PathBin = com.GetParam(1); // '模板地址 var PathTemplate = com.GetParam(2); // '保存地址 var PathSave = com.GetParam(3); // '模板文件名 var NameTemplate = com.GetParam(4); // '保存文件名 var NameSave = com.GetParam(5); // '查询时间 var Date = DateTime.ParseExact(com.GetParam(6), "yyyyMMdd", CultureInfo.CurrentCulture); // '数据导入开始行 var RowBeginIndex = int.Parse(com.GetParam(7)); // '数据导入结束行 var RowEndIndex = RowBeginIndex + Data.Rows.Count - 1; // 科室 List <string> depts = GetDepts(); foreach (var item in depts) { var book = new Workbook(); book.LoadFromFile(Path.Combine(PathTemplate, NameTemplate)); var sheet = book.Worksheets[0]; var dr = Data.AsEnumerable().Where(t => item.Split('|').Any(i => t["科室"].ToString() == i)); if (dr.Count() > 0) { DataTable dt = dr.OrderBy(t => t["住院号"].ToString()).CopyToDataTable(); RowEndIndex = RowBeginIndex + dt.Rows.Count - 1; dt.Columns.Remove("科室"); sheet.InsertDataTable(dt, false, RowBeginIndex, 1); var call = sheet.Range[RowBeginIndex, 1, RowEndIndex, dt.Columns.Count]; call.StyleLine(); var dept = item; if (item == "呼吸内科、职业病病区|内六科") { dept = "呼吸内、内六"; } if (item == "神经内科二病区|心血管内科病区") { dept = "心内、神内"; } if (item == "泌尿外科病区|骨科二病区") { dept = "泌尿外、骨二"; } if (item == "新五官科病区|急诊创伤脑外病区") { dept = "五官、急诊脑外"; } if (item == "新儿科康复病区|新儿科病区") { dept = "新儿科"; } if (item == "肿瘤科病区|消化科病区") { dept = "肿瘤、消化"; } //if (item == "普外科、胸外科病区|急诊创伤病区") // dept = "普外、急诊"; Helper.FindAllString(sheet, "[DEPT]", dept); Helper.FindAllString(sheet, "[NUM]", dt.Rows.Count.ToString()); Helper.FindAllString(sheet, "[DATE]", DateTime.Now.ToString("yyyy-MM-dd")); book.SaveToFile(Path.Combine(PathSave, dept + ".xlsx")); book.PrintDocument.Print(); } //book.PrintDocument.PrintController = new StandardPrintController(); } }