private void OSOPT35_46Job() { string sourceFile = configObj.DownloadFilePath + "\\" + configObj.Date + "_individual_options_OI_by_participant.xls"; string targetFile = configObj.OSOPT35_46TemplateFile; OSOPT35_46OriginData data = new OSOPT35_46OriginData(); Workbook source = InitialExcelFile(sourceFile); Workbook target = InitialExcelFile(targetFile); if (source == null || target == null) { return; } try { OSOPT35_46.GetOSOPT35_46Data(source, ref data, nameDic); OSOPT35_46.GenerateOSOPT35_46(target, data); target.Save(); } catch (Exception ex) { Logger.Log("OSOPT35_46Job failed" + ex.Message); LogMessage("OSOPT35_46Job failed"); } }
public static void GetOSOPT35_46Data(Workbook book, ref OSOPT35_46OriginData data, Dictionary <string, NameMap> nameDic) { if (book == null || data == null) { return; } Worksheet sheet = book.Worksheets[1] as Worksheet; if (sheet == null) { return; } string updateDate = ExcelUtil.GetRange("A2", sheet).Text.ToString(); data.updateDate = JapanShared.TransferJpDate(updateDate); int offset = 19; for (int i = 0; i < 10; i++) { string count = ExcelUtil.GetRange(6 + i * offset, 3, sheet).Text.ToString(); data.code.Add(count); count = ExcelUtil.GetRange(6 + i * offset, 12, sheet).Text.ToString(); data.code.Add(count); count = GetExchangeCount2(sheet, 7 + i * offset, 7); data.exchangeCount2.Add(count); count = GetExchangeCount2(sheet, 7 + i * offset, 16); data.exchangeCount2.Add(count); string tmp = GetPutOrCall(sheet, 6 + i * offset, 7); data.putOrCall.Add(tmp); tmp = GetPutOrCall(sheet, 6 + i * offset, 16); data.putOrCall.Add(tmp); OSETradeCompanyInfo exchangeName = GetExchangeName(sheet, 6 + i * offset, 3); updateCompanyInfo(exchangeName, nameDic); data.exchangeName.Add(exchangeName); exchangeName = GetExchangeName(sheet, 6 + i * offset, 12); updateCompanyInfo(exchangeName, nameDic); data.exchangeName.Add(exchangeName); string exchangDate = ExcelUtil.GetRange(6 + i * offset, 6, sheet).Text.ToString(); data.exchangeDate.Add(JapanShared.TransferJpDate(exchangDate)); exchangDate = ExcelUtil.GetRange(6 + i * offset, 15, sheet).Text.ToString(); data.exchangeDate.Add(JapanShared.TransferJpDate(exchangDate)); for (int j = 9; j <= 23; j++) { OSETradeCompanyInfo info = GetTradingInfo(sheet, j + i * offset, 3, 2); updateCompanyInfo(info, nameDic); data.info.Add(info); info = GetTradingInfo(sheet, j + i * offset, 6, 1); updateCompanyInfo(info, nameDic); data.info.Add(info); info = GetTradingInfo(sheet, j + i * offset, 12, 2); updateCompanyInfo(info, nameDic); data.info.Add(info); info = GetTradingInfo(sheet, j + i * offset, 15, 1); updateCompanyInfo(info, nameDic); data.info.Add(info); } } }
private static void WriteOSOPT42_46(Workbook book, OSOPT35_46OriginData data) { if (book == null || data == null) { return; } Worksheet sheet = book.Worksheets[3] as Worksheet; if (sheet == null) { return; } int index = 12; int index2 = 360; int offset = 22; for (int i = 0; i < 4; i++) { sheet.Cells[5 + i * offset, 2] = data.exchangeDate[index].ToString("MMM") + data.exchangeDate[index].ToString("yy"); sheet.Cells[5 + i * offset, 3] = data.updateDate.ToString("dd") + data.updateDate.ToString("MMM").ToUpper() + data.updateDate.ToString("yy"); sheet.Cells[6 + i * offset, 2] = data.exchangeName[index].EnglishName; sheet.Cells[6 + i * offset, 4] = data.exchangeName[index].JapaneseName; sheet.Cells[6 + i * offset, 3] = data.code[index]; sheet.Cells[6 + i * offset, 5] = data.putOrCall[index]; sheet.Cells[6 + i * offset, 6] = data.exchangeCount2[index]; index++; sheet.Cells[5 + i * offset, 10] = data.exchangeDate[index].ToString("MMM") + data.exchangeDate[index].ToString("yy"); sheet.Cells[5 + i * offset, 11] = data.updateDate.ToString("dd") + data.updateDate.ToString("MMM").ToUpper() + data.updateDate.ToString("yy"); sheet.Cells[6 + i * offset, 10] = data.exchangeName[index].EnglishName; sheet.Cells[6 + i * offset, 12] = data.exchangeName[index].JapaneseName; sheet.Cells[6 + i * offset, 11] = data.code[index]; sheet.Cells[6 + i * offset, 13] = data.putOrCall[index]; sheet.Cells[6 + i * offset, 14] = data.exchangeCount2[index]; index++; for (int j = 9; j <= 23; j++) { sheet.Cells[j + i * offset, 2] = data.info[index2].JapaneseName; sheet.Cells[j + i * offset, 3] = data.info[index2].EnglishName; sheet.Cells[j + i * offset, 4] = data.info[index2].OPINT; index2++; sheet.Cells[j + i * offset, 5] = data.info[index2].JapaneseName; sheet.Cells[j + i * offset, 6] = data.info[index2].EnglishName; sheet.Cells[j + i * offset, 7] = data.info[index2].OPINT; index2++; sheet.Cells[j + i * offset, 10] = data.info[index2].JapaneseName; sheet.Cells[j + i * offset, 11] = data.info[index2].EnglishName; sheet.Cells[j + i * offset, 12] = data.info[index2].OPINT; index2++; sheet.Cells[j + i * offset, 13] = data.info[index2].JapaneseName; sheet.Cells[j + i * offset, 14] = data.info[index2].EnglishName; sheet.Cells[j + i * offset, 15] = data.info[index2].OPINT; index2++; } } sheet.Cells[71, 3] = data.updateDate.ToString("dd") + data.updateDate.ToString("MMM").ToUpper() + data.updateDate.ToString("yy"); sheet.Cells[71, 11] = data.updateDate.ToString("dd") + data.updateDate.ToString("MMM").ToUpper() + data.updateDate.ToString("yy"); sheet.Cells[93, 3] = data.updateDate.ToString("dd") + data.updateDate.ToString("MMM").ToUpper() + data.updateDate.ToString("yy"); sheet.Cells[93, 11] = data.updateDate.ToString("dd") + data.updateDate.ToString("MMM").ToUpper() + data.updateDate.ToString("yy"); }
public static void GenerateOSOPT35_46(Workbook book, OSOPT35_46OriginData data) { WriteOSOPT35_37(book, data); WriteOSOPT38_41(book, data); WriteOSOPT42_46(book, data); }