/// <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();
}
}
