private void CreateDataSheet(ExcelHelp xls, DataTableInfo tableInfo, bool isTarget) { DatabaseAcsesser dba = new DatabaseAcsesser(); DatabaseAcsesser.DbConnections connType = isTarget ? DatabaseAcsesser.DbConnections.TargetDbConnection : DatabaseAcsesser.DbConnections.SourceDbConnection; TableLayoutInfo info = dba.GetTableLayout(connType, tableInfo.TableName); Excel.Worksheet templateSheet = xls.WorkBook.Sheets["Template"]; Excel.Worksheet sheet = xls.CreateSheet(tableInfo.SheetName, templateSheet); int colIndex = 0; xls.WriteValue(sheet, 1, 2, info.TableName); foreach (ColumnInfo column in info.Columns) { colIndex++; xls.WriteValue(sheet, STRAT_ROW, colIndex, column.ColumnName); if (!string.IsNullOrEmpty(column.DisplayName)) { string comment = column.DisplayName + "\n" + column.GetSqlType(); sheet.Range[xls.GetColumnName(colIndex, STRAT_ROW)].AddComment(comment); } if (column.IsPrimaryKey) { Excel.Range cell = sheet.Range[xls.GetColumnName(colIndex, STRAT_ROW)]; cell.Font.Color = Excel.XlRgbColor.rgbRed; } } xls.AddListObject(sheet, STRAT_ROW, STRAT_ROW + 1, colIndex, tableInfo.TableName); SetColumnFormat(info, sheet); sheet.Columns.AutoFit(); sheet.Tab.Color = isTarget ? Excel.XlRgbColor.rgbBlue : Excel.XlRgbColor.rgbRed; }
/// <summary> /// データベースから、採番された新生産計画NOを取得する /// </summary> /// <param name="oldNo"></param> /// <returns></returns> private string GetNewProductionNoFromDb(string oldNo) { DatabaseAcsesser dba = new DatabaseAcsesser(); string planNo = dba.GetProductionPlanNo(oldNo); //コレクションに追加 this._productionPlanNos.Add(oldNo, planNo); return(planNo); }
private TableLayoutInfo GetTableLayoutInfo(string tableName, bool isTarget) { DatabaseAcsesser dba = new DatabaseAcsesser(); DatabaseAcsesser.DbConnections connType = isTarget ? DatabaseAcsesser.DbConnections.TargetDbConnection : DatabaseAcsesser.DbConnections.SourceDbConnection; TableLayoutInfo info = dba.GetTableLayout(connType, tableName); return(info); }
/// <summary> /// データベースから、採番された新稼動計画NOを取得する /// </summary> /// <param name="oldNo">旧稼動計画キー(設備コード + '|' + 稼動日)</param> /// <returns></returns> private string GetNewOperationNoFromDb(string oldNo) { string facilityCode = oldNo.Split('|')[0]; string operationDate = oldNo.Split('|')[1]; DatabaseAcsesser dba = new DatabaseAcsesser(); string planNo = dba.GetOperationPlanNo(facilityCode, operationDate); //コレクションに追加 this._operationPlanNos.Add(oldNo, planNo); return(planNo); }
private void CheckExpectData(ExcelAccessor xlsAdo, DataTableInfo info) { try { DatabaseAcsesser dbAdo = new DatabaseAcsesser(); DataTable dttResult = dbAdo.GetResultData(info.TableName); DataTable dttSchema = dttResult.Clone(); DataTable dttExpect = xlsAdo.GetTableData(info.SheetName, info.TableName, dttSchema, 2, Config.MaxDataCount + 2); //データ比較する DiffDataSouce(info, dttExpect, dttResult); } catch (Exception ex) { Logging.Exception("", ex); throw ex; } }