public static ModelReport CreateReportFrom(Schema2.ModelRoot model)
{
var rrrr = new ModelReport();
foreach (var vb in model.LogicalBufferViews.Where(item => item.IsVertexBuffer))
{
rrrr._VertexBuffers.Add(vb.Content.Count);
}
foreach (var ib in model.LogicalBufferViews.Where(item => item.IsIndexBuffer))
{
rrrr._IndexBuffers.Add(ib.Content.Count);
}
foreach (var db in model.LogicalBufferViews.Where(item => item.IsDataBuffer))
{
rrrr._DataBuffers.Add(db.Content.Count);
}
foreach (var mesh in model.LogicalMeshes)
{
rrrr._Meshes.Add(new MeshReport(mesh));
}
foreach (var scene in model.LogicalScenes)
{
var r = new VisualReport();
r.SetFrom(scene);
rrrr._Scenes.Add(r);
}
rrrr.SetFrom(rrrr._Scenes);
return(rrrr);
}
public async void ModelReportGenTestOk()
{
//SummitReportSettings.Instance.ConnectionString = "data source=summittest.database.windows.net;initial catalog=MARS;user=simsa;password=D3n^3r#$";
SummitReportSettings.Instance.ConnectionString = "data source=NSWIN10VM;initial catalog=MARS;user=simsa;password=D3n^3r#$";
var rpt = new ModelReport();
var generatedFIleName = await rpt.GenerateAsync(2);
}
public static ModelReport CreateReportFrom(Schema2.ModelRoot model)
{
var rrrr = new ModelReport();
foreach (var bv in model.LogicalBufferViews.Where(item => item.DeviceBufferTarget == BufferMode.ARRAY_BUFFER))
{
rrrr._VertexBuffers.Add(bv.Content.Count);
}
foreach (var iv in model.LogicalBufferViews.Where(item => item.DeviceBufferTarget == BufferMode.ELEMENT_ARRAY_BUFFER))
{
rrrr._IndexBuffers.Add(iv.Content.Count);
}
foreach (var dv in model.LogicalBufferViews.Where(item => item.DeviceBufferTarget == null))
{
rrrr._DataBuffers.Add(dv.Content.Count);
}
foreach (var mesh in model.LogicalMeshes)
{
rrrr._Meshes.Add(new MeshReport(mesh));
}
foreach (var scene in model.LogicalScenes)
{
var r = new VisualReport();
r.SetFrom(scene);
rrrr._Scenes.Add(r);
}
rrrr.SetFrom(rrrr._Scenes);
return(rrrr);
}
public IHttpActionResult GetReportData(HttpRequestMessage request, ModelReport model)
{
string validateCode = GetHeader(request, "x-session-token");
string userId = GetHeader(request, "x-session-userid");
var result = Report.GetReportData(userId, validateCode, model.ProgId, model.queryFieldList);
return(Ok(result));
}
// ReSharper disable once ParameterOnlyUsedForPreconditionCheck.Local
internal static void ExpectMembersInReport(ModelReport modelReport, IReadOnlyCollection <string> expectedMembers)
{
Assert.NotNull(modelReport);
Assert.Equal(expectedMembers.Count(), modelReport.Count);
for (var i = 0; i < expectedMembers.Count(); ++i)
{
Assert.Equal(expectedMembers.ElementAt(i), modelReport.Keys.ElementAt(i));
}
}
private static List <ModelReport> GetReports()
{
ModelReport region;
string connectionString = GetConnectionStringDB();
string getRegions = "GetReports";
List <ModelReport> regionList = new List <ModelReport>();
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(getRegions, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
region = new ModelReport();
region.RegionID = (int)reader[0];
region.CompanyID = (int)reader[1];
region.OilID = (int)reader[2];
region.Value = (decimal)reader["Balance"];
region.CDate = (DateTime)reader["CDate"];
regionList.Add(region);
}
}
}
}
catch (Exception e)
{
string error = e.Message;
}
return(regionList);
}
public static List <ModelReport> InsertExcelDateToList(DataSet ds)
{
List <ModelReport> ReportList = new List <ModelReport>();
List <Region> RegionList = GetRegions();
List <Company> CompanyList = GetCompanies();
List <Product> OilList = GetProducts();
Region Region = new Region();
Company Company = new Company();
//get date from excel file
string dateString = ds.Tables[0].Rows[4][0].ToString();
DateTime date = DateTime.Parse(dateString.Split(' ').Last());
for (int i = 6; i < ds.Tables[0].Rows.Count; i++)
{
string value = ds.Tables[0].Rows[i][0].ToString();
for (int j = 1; j < 8; j++)
{
if (RegionList.Exists(x => x.RegionName.Trim() == value) == true)
{
// Get Region
Region = RegionList.First(x => x.RegionName.Trim() == value);
break;
}
else if (CompanyList.Where(x => x.CompanyName.Trim() == value).Count() > 0)
{
// Get Company
Company = CompanyList.First(x => x.CompanyName.Trim() == value);
string OilName = ds.Tables[0].Rows[5][j].ToString();
if (OilList.Exists(x => x.ProductName.Trim() == OilName))
{
// Get Oil
var Oil = OilList.First(x => x.ProductName.Trim() == OilName);
//Get Balance
decimal Balance = Decimal.Parse(ds.Tables[0].Rows[i][j].ToString());
// Collect Report
ModelReport report = new ModelReport()
{
RegionID = Region.RegionId,
CompanyID = Company.CompanyId,
OilID = Oil.ProductId,
Value = Balance,
CDate = date
};
ReportList.Add(report);
}
}
else
{
}
}
}
return(ReportList);
}
public void exportReport(ModelReport modelReport, int cycleIndex)
{
if (modelReport != null)
{
FileStream fileStream = new FileStream(excelFilePath, FileMode.Open, FileAccess.Read);
XSSFWorkbook workbook = new XSSFWorkbook(fileStream);
fileStream.Close();
XSSFSheet sheet = (XSSFSheet)workbook.GetSheet("Sheet1");
initStyle(workbook);
int colStartIndex;
XSSFRow row;
if (cycleIndex % 2 == 0)
{
//左边
colStartIndex = 0;
row = (XSSFRow)sheet.CreateRow(leftRowIndex);
}
else
{
//右边
colStartIndex = 18;
row = (XSSFRow)sheet.GetRow(rightRowIndex);
}
XSSFCell cell = (XSSFCell)row.CreateCell(colStartIndex + 0);
if (modelReport.warning)
{
cell.CellStyle = warningStyle;
}
else
{
cell.CellStyle = commonStyle;
}
cell.SetCellValue(modelReport.modelName);
//期望模型名称和实际模型名称不一致，则不导出数据
bool isErrorData = false;
if (!modelReport.modelName.Equals(modelReport.realisticModelName) && !modelReport.modelName.Equals(modelReport.realisticModelName + " RUMI"))
{
isErrorData = true;
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 1);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.signalNumber);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 2);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.lastInterest);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 3);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.sharpeRatio);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 4);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.interestMaxRetracement);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 5);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.interestMaxRetracementRatio);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 6);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.hazardRatio);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 7);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.maxLossPerHand);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 8);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.avgProfitLossPerHand);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 9);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.winRatio);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 10);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.score);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 11);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.maxProfit);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 12);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.maxLoss);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 13);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.maxContinuousProfitabilityTimes);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 14);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.maxContinuousLossesTimes);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 15);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.startingDate);
}
cell = (XSSFCell)row.CreateCell(colStartIndex + 16);
cell.CellStyle = commonStyle;
if (isErrorData)
{
cell.SetCellValue("");
}
else
{
cell.SetCellValue(modelReport.endingDate);
}
if (cycleIndex % 2 == 0)
{
//左边
leftRowIndex++;
}
else
{
//右边
rightRowIndex++;
}
FileStream fileStreamWrite = new FileStream(excelFilePath, FileMode.Open, FileAccess.Write);
workbook.Write(fileStreamWrite);
fileStreamWrite.Close();
}
}
public MainForm()
{
InitializeComponent();
m_modelReport = new ModelReport();
}
public ManChartForm()
{
InitializeComponent();
m_model = new ModelEmployee();
m_report_model = new ModelReport();
}
public ItemChartForm()
{
InitializeComponent();
m_model = new ModelProduct();
m_report_model = new ModelReport();
}
public SalesAmountForm()
{
InitializeComponent();
w_model = new ModelReport();
}
