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); }