private void btnLoad_SD_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtHDRExcelPath.Text))
{
MessageBox.Show("请选择hdr sd模型描述excel文件");
return;
}
if (!File.Exists(this.txtHDRExcelPath.Text))
{
MessageBox.Show("hdr sd模型描述excel文件不存在");
return;
}
//string filePath = Path.Combine(basePath, @"..\HDR库表集合_V1.0.5-201908.xlsx");
string filePath = this.txtHDRExcelPath.Text;
var inputfilename = Path.GetFileNameWithoutExtension(this.txtHDRExcelPath.Text);
Workbook workbook = null;
using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
{
workbook = new Workbook(fs);
}
var worksheets = workbook.Worksheets;
HdrExcelProcesser hdrExcelProcesser = new HdrExcelProcesser();
List <ExcelColumn> cols = new List <ExcelColumn>();
var result = hdrExcelProcesser.ProcessSchemaSd(worksheets);
cols.AddRange(result);
string outfilePath = Path.Combine(basePath, $"{inputfilename}_hdrcolumns_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx");
Workbook wb = new Workbook();
wb.Worksheets.Clear();
Worksheet sheet1 = wb.Worksheets.Add("hdr_columns");
sheet1.Cells.ImportCustomObjects(cols as ICollection, 0, 0, new ImportTableOptions {
});
wb.Save(outfilePath, SaveFormat.Xlsx);
using (var conn = new PostgresHelper(dbConnectionString))
{
var bulkinserthelper = conn.BulkinsertHdrColumns(cols, false);
}
Process.Start("Explorer", "/select," + outfilePath);
}
private void btnLoadHdr_To_hdr_columns_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtHDRExcelPath.Text))
{
MessageBox.Show("请选择hdr模型描述excel文件");
return;
}
if (!File.Exists(this.txtHDRExcelPath.Text))
{
MessageBox.Show("hdr模型描述excel文件不存在");
return;
}
//string filePath = Path.Combine(basePath, @"..\HDR库表集合_V1.0.5-201908.xlsx");
string filePath = this.txtHDRExcelPath.Text;
var inputfilename = Path.GetFileNameWithoutExtension(this.txtHDRExcelPath.Text);
Workbook workbook = null;
using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
{
workbook = new Workbook(fs);
}
var worksheets = workbook.Worksheets;
HdrExcelProcesser hdrExcelProcesser = new HdrExcelProcesser();
List <ExcelColumn> cols = new List <ExcelColumn>();
var result = hdrExcelProcesser.ProcessSchemaMdm(worksheets);
cols.AddRange(result);
var result1 = hdrExcelProcesser.ProcessSchemaPatient(worksheets);
cols.AddRange(result1);
var result2 = hdrExcelProcesser.ProcessSchemaVisit(worksheets);
cols.AddRange(result2);
var result3 = hdrExcelProcesser.ProcessSchemaOrders(worksheets);
cols.AddRange(result3);
var result4 = hdrExcelProcesser.ProcessSchemaFee(worksheets);
cols.AddRange(result4);
var result5 = hdrExcelProcesser.ProcessSchemaDiag(worksheets);
cols.AddRange(result5);
var result6 = hdrExcelProcesser.ProcessSchemaAllergy(worksheets);
cols.AddRange(result6);
var result7 = hdrExcelProcesser.ProcessSchemaChecks(worksheets);
cols.AddRange(result7);
var result8 = hdrExcelProcesser.ProcessSchemaLab(worksheets);
cols.AddRange(result8);
var result9 = hdrExcelProcesser.ProcessSchemaOperation(worksheets);
cols.AddRange(result9);
var result10 = hdrExcelProcesser.ProcessSchemaNurse(worksheets);
cols.AddRange(result10);
var result11 = hdrExcelProcesser.ProcessSchemaCases(worksheets);
cols.AddRange(result11);
var result12 = hdrExcelProcesser.ProcessSchemaEmr(worksheets);
cols.AddRange(result12);
var result13 = hdrExcelProcesser.ProcessSchemaTumour(worksheets);
cols.AddRange(result13);
var result14 = hdrExcelProcesser.ProcessSchemaOther(worksheets);
cols.AddRange(result14);
var result15 = hdrExcelProcesser.ProcessSchemaReportcard(worksheets);
cols.AddRange(result15);
var result16 = hdrExcelProcesser.ProcessSchemaPhyexam(worksheets);
cols.AddRange(result16);
var result17 = hdrExcelProcesser.ProcessSchemaBiobank(worksheets);
cols.AddRange(result17);
var result18 = hdrExcelProcesser.ProcessSchemaNlp(worksheets);
cols.AddRange(result18);
var result19 = hdrExcelProcesser.ProcessSchemaEventflow(worksheets);
cols.AddRange(result19);
var result20 = hdrExcelProcesser.ProcessSchemaEtl(worksheets);
cols.AddRange(result20);
var result21 = hdrExcelProcesser.ProcessSchemaPublic(worksheets);
cols.AddRange(result21);
var result22 = hdrExcelProcesser.ProcessSchemaCure(worksheets);
cols.AddRange(result22);
string outfilePath = Path.Combine(basePath, $"{inputfilename}_hdrcolumns_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx");
Workbook wb = new Workbook();
wb.Worksheets.Clear();
Worksheet sheet1 = wb.Worksheets.Add("hdr_columns");
sheet1.Cells.ImportCustomObjects(cols as ICollection, 0, 0, new ImportTableOptions {
});
wb.Save(outfilePath, SaveFormat.Xlsx);
using (var conn = new PostgresHelper(dbConnectionString))
{
var bulkinserthelper = conn.BulkinsertHdrColumns(cols, false);
}
Process.Start("Explorer", "/select," + outfilePath);
}
private void btnLoadHdr_v105_Click(object sender, EventArgs e)
{
string filePath = Path.Combine(basePath, @"..\HDR库表集合_V1.0.5-201908.xlsx");
if (!File.Exists(filePath))
{
MessageBox.Show("文件不存在！");
return;
}
Workbook workbook = null;
using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
{
workbook = new Workbook(fs);
}
var worksheets = workbook.Worksheets;
HdrExcelProcesser hdrExcelProcesser = new HdrExcelProcesser();
List <ExcelColumn> cols = new List <ExcelColumn>();
var result = hdrExcelProcesser.ProcessSchemaMdm(worksheets);
cols.AddRange(result);
var result1 = hdrExcelProcesser.ProcessSchemaPatient(worksheets);
cols.AddRange(result1);
var result2 = hdrExcelProcesser.ProcessSchemaVisit(worksheets);
cols.AddRange(result2);
var result3 = hdrExcelProcesser.ProcessSchemaOrders(worksheets);
cols.AddRange(result3);
var result4 = hdrExcelProcesser.ProcessSchemaFee(worksheets);
cols.AddRange(result4);
var result5 = hdrExcelProcesser.ProcessSchemaDiag(worksheets);
cols.AddRange(result5);
var result6 = hdrExcelProcesser.ProcessSchemaAllergy(worksheets);
cols.AddRange(result6);
var result7 = hdrExcelProcesser.ProcessSchemaChecks(worksheets);
cols.AddRange(result7);
var result8 = hdrExcelProcesser.ProcessSchemaLab(worksheets);
cols.AddRange(result8);
var result9 = hdrExcelProcesser.ProcessSchemaOperation(worksheets);
cols.AddRange(result9);
var result10 = hdrExcelProcesser.ProcessSchemaNurse(worksheets);
cols.AddRange(result10);
var result11 = hdrExcelProcesser.ProcessSchemaCases(worksheets);
cols.AddRange(result11);
var result12 = hdrExcelProcesser.ProcessSchemaEmr(worksheets);
cols.AddRange(result12);
var result13 = hdrExcelProcesser.ProcessSchemaTumour(worksheets);
cols.AddRange(result13);
var result14 = hdrExcelProcesser.ProcessSchemaOther(worksheets);
cols.AddRange(result14);
var result15 = hdrExcelProcesser.ProcessSchemaReportcard(worksheets);
cols.AddRange(result15);
var result16 = hdrExcelProcesser.ProcessSchemaPhyexam(worksheets);
cols.AddRange(result16);
var result17 = hdrExcelProcesser.ProcessSchemaBiobank(worksheets);
cols.AddRange(result17);
var result18 = hdrExcelProcesser.ProcessSchemaNlp(worksheets);
cols.AddRange(result18);
var result19 = hdrExcelProcesser.ProcessSchemaEventflow(worksheets);
cols.AddRange(result19);
var result20 = hdrExcelProcesser.ProcessSchemaEtl(worksheets);
cols.AddRange(result20);
string outfilePath = Path.Combine(basePath, $"hdr_v105_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx");
Workbook wb = new Workbook();
wb.Worksheets.Clear();
Worksheet sheet1 = wb.Worksheets.Add("hdr_columns");
sheet1.Cells.ImportCustomObjects(cols as ICollection, 0, 0, new ImportTableOptions {
});
wb.Save(outfilePath, SaveFormat.Xlsx);
}
