void export_modelExportCompletedEvent(object sender, ModelExportCompletedEventHandlerArgs args)
{
if (modelExportCompletedEvent != null)
{
modelExportCompletedEvent(sender, args);
}
}
public void ModelExported(object sender, ModelExportCompletedEventHandlerArgs e)
{
if (bSpread1.ActiveSheet.Columns.Count == 0)
{
this.bSpread1.AddHead(0, "SELECT", "SELECT", 50, 20, null, null, null, ColumnAttribute.Null,
ColumnType.CheckBox, null, null, null, false, true);
this.indexOfSelect = 0;
this.bSpread1.AddHead(1, "SPC MODEL NAME", "SPC MODEL NAME", 150, 100, null, null, null, ColumnAttribute.Null,
ColumnType.Null, null, null, null, false, true);
this.bSpread1.AddHead(2, "TOTAL MODEL COUNT(MAIN_SUB)", "TOTAL MODEL COUNT(MAIN_SUB)", 200, 20, null, null, null, ColumnAttribute.Null,
ColumnType.Null, null, null, null, false, true);
this.bSpread1.AddHead(3, "FILE NAME", "FILE NAME", 250, 100, null, null, null, ColumnAttribute.Null,
ColumnType.Null, null, null, null, false, true);
this.bSpread1.AddHead(4, "FILE FULL PATH", "FILE FULL PATH", 250, 500, null, null, null, ColumnAttribute.Null,
ColumnType.Null, null, null, null, false, false);
this.indexOfFileFullPath = 4;
this.bSpread1.AddHeadComplete();
this.bSpread1.ActiveSheet.Columns[0].Locked = false;
}
int idxRow = bSpread1.ActiveSheet.Rows.Count;
bSpread1.ActiveSheet.AddRows(idxRow, 1);
bSpread1.ActiveSheet.Cells[idxRow, 1].Text = e.SPCModelName;
bSpread1.ActiveSheet.Cells[idxRow, 2].Text = e.exportedModelNum.ToString();
string[] path = e.filePath.Split('\\');
bSpread1.ActiveSheet.Cells[idxRow, 3].Text = path[path.Length - 1];
bSpread1.ActiveSheet.Cells[idxRow, 4].Text = e.filePath;
if (string.IsNullOrEmpty(e.filePath))
{
bSpread1.ActiveSheet.Rows[idxRow].Locked = true;
}
}
void DataExportUC_modelExportCompletedEvent(object sender, ModelExportCompletedEventHandlerArgs e)
{
this.pbarMain.Value++;
this.blblMain.Text = this.pbarMain.Value + " / " + this.pbarMain.Maximum;
if (modelExportCompletedEvent != null)
{
this.modelExportCompletedEvent(sender, e);
}
System.Threading.Thread.Sleep(50);
Application.DoEvents();
}
internal int Export(string filePath, string startDtts, string endDtts)
{
exportedSubModel = 0;
if (modelExportStartedEvent != null)
{
var ModelStartedArgs = new ModelExportStartedEventHandlerArgs();
modelExportStartedEvent(this, ModelStartedArgs);
}
bool hasData = false;
using (ExcelWriter writer = new ExcelWriter(filePath))
{
writer.WriteStartDocument();
// write a main chart
DataTable rawData = GetRawData(startDtts, endDtts, this.ChartID);
rawData.TableName = this.ChartID;
RemoveSuperflousColumns(rawData);
if (rawData.Rows.Count > 0)
{
hasData = true;
writer.WriteSheet("Main-" + ChartID, rawData);
exportedSubModel++;
}
rawData.Dispose();
if (subModelExportCompletedEvent != null)
{
var subArgs = new SubModelExportCompletedEventHandlerArgs();
subArgs.SubModelRawID = ChartID;
subModelExportCompletedEvent(this, subArgs);
}
// write sub charts
foreach (SPCModel sub in this.SubModels)
{
rawData = GetRawData(startDtts, endDtts, sub.ChartID);
rawData.TableName = sub.ChartID;
RemoveSuperflousColumns(rawData);
if (rawData.Rows.Count > 0)
{
hasData = true;
writer.WriteSheet(sub.ChartID, rawData);
exportedSubModel++;
}
rawData.Dispose();
if (subModelExportCompletedEvent != null)
{
var subArgs = new SubModelExportCompletedEventHandlerArgs();
subArgs.SubModelRawID = sub.ChartID;
subModelExportCompletedEvent(this, subArgs);
}
}
writer.WriteEndDocument();
writer.Close();
}
var modelArgs = new ModelExportCompletedEventHandlerArgs();
modelArgs.SPCModelName = this.SPCModelName;
modelArgs.exportedModelNum = exportedSubModel;
modelArgs.filePath = filePath;
if (hasData == false)
{
System.IO.File.Delete(filePath);
modelArgs.filePath = string.Empty;
}
if (modelExportCompletedEvent != null)
{
modelExportCompletedEvent(this, modelArgs);
}
return(exportedSubModel);
}
public void ModelExported(object sender, ModelExportCompletedEventHandlerArgs e)
{
this.exportResult1.ModelExported(sender, e);
}
