/// <summary>
/// Serves as a hash function for a particular type.
/// </summary>
/// <returns>A hash code for the current object.</returns>
public override int GetHashCode()
{
unchecked
{
int result = 17;
result = result * 23 + Id.GetHashCode();
result = result * 23 + ((Name != null) ? Name.GetHashCode() : 0);
result = result * 23 + Type.GetHashCode();
result = result * 23 + ShowInActions.GetHashCode();
result = result * 23 + RowFilterEnabled.GetHashCode();
result = result * 23 + SummaryRowEnabled.GetHashCode();
result = result * 23 + ((SummaryRow != null) ? SummaryRow.GetHashCode() : 0);
result = result * 23 + MultiSortEnabled.GetHashCode();
result = result * 23 + RequiresFilter.GetHashCode();
result = result * 23 + ((WaitForInputData != null) ? WaitForInputData.GetHashCode() : 0);
result = result * 23 + ((Fields != null) ? Fields.GetHashCode() : 0);
result = result * 23 + ((FieldGroups != null) ? FieldGroups.GetHashCode() : 0);
result = result * 23 + ((MultiSort != null) ? MultiSort.GetHashCode() : 0);
result = result * 23 + ((Filters != null) ? Filters.GetHashCode() : 0);
result = result * 23 + ((Pages != null) ? Pages.GetHashCode() : 0);
result = result * 23 + ((Layout != null) ? Layout.GetHashCode() : 0);
result = result * 23 + SelectionMode.GetHashCode();
result = result * 23 + ((DoubleClickAction != null) ? DoubleClickAction.GetHashCode() : 0);
result = result * 23 + ((UseAsBrowser != null) ? UseAsBrowser.GetHashCode() : 0);
result = result * 23 + ((UseAsBrowserRank != null) ? UseAsBrowserRank.GetHashCode() : 0);
result = result * 23 + ((UseAsBrowserDefaultCode != null) ? UseAsBrowserDefaultCode.GetHashCode() : 0);
result = result * 23 + ((Pivot != null) ? Pivot.GetHashCode() : 0);
return(result);
}
}
public KamokuKubunSummary(db.KaikeiDatabase aDB)
{
db = aDB;
kamokuKubunSummaryTable = new Dictionary <int, SummaryRow>();
dummyRow = new SummaryRow(-1, 0, 0);
ObserveKamokuKubunList = new Dictionary <int, bool>();
OnAddDenpyou = null;
}
/// <summary>
///
/// </summary>
/// <param name="detailGrid"></param>
protected void CreateDetailGridSumRow(MyDetailGrid detailGrid)
{
bool needSum = false;
if (!needSum)
{
foreach (Column column in detailGrid.Columns)
{
GridColumnInfo info = column.Tag as GridColumnInfo;
if (info == null)
{
continue;
}
if (string.IsNullOrEmpty(info.StatFunction) || !Authority.AuthorizeByRule(info.ColumnVisible))
{
continue;
}
needSum = true;
break;
}
}
if (needSum)
{
SummaryRow sumRow = detailGrid.AddSummaryRowToFixedFooter();
sumRow.TextFormat = ADInfoBll.Instance.GetGridInfo(detailGrid.GridName).StatTitle;
foreach (Column column in detailGrid.Columns)
{
GridColumnInfo info = column.Tag as GridColumnInfo;
if (info == null)
{
continue;
}
if (string.IsNullOrEmpty(info.StatFunction) || !Authority.AuthorizeByRule(info.ColumnVisible))
{
continue;
}
MySummaryCell cell = ((MySummaryCell)sumRow.Cells[info.GridColumnName]);
cell.StatFunction = BoundGridExtention.GetStatFunction(info.StatFunction);
cell.RunningStatGroupLevel = 0;
cell.ResultDataType = typeof(string);
if (!string.IsNullOrEmpty(info.StatTitle))
{
cell.TitleFormat = info.StatTitle;
cell.TitlePosition = TitlePosition.PreferablyRight;
}
}
}
}
public void Dispose()
{
if (Range != null)
{
Range.Dispose();
}
if (SummaryRow != null)
{
SummaryRow.Dispose();
}
}
/// <summary>
/// 得到SummaryRow
/// </summary>
/// <returns></returns>
public static SummaryRow GetSummaryRow(this IGrid grid)
{
foreach (Row row in grid.FixedFooterRows)
{
SummaryRow r = row as SummaryRow;
if (r != null)
{
return(r);
}
}
return(null);
}
private ConsoleRow CreateRow(SummaryRow r)
{
var summary = r.Summary;
var linesColor = summary.LinesCoveragePass ? ConsoleColor.Green : ConsoleColor.Red;
var statementsColor = summary.StatementsCoveragePass ? ConsoleColor.Green : ConsoleColor.Red;
var branchesColor = summary.BranchesCoveragePass ? ConsoleColor.Green : ConsoleColor.Red;
var row = new ConsoleRow();
var indentation = Math.Max(r.Level - 1, 0) * 2;
row.Cells.Add(new ConsoleCell($"{new string(' ', indentation)}{r.Name}"));
row.Cells.Add(new ConsoleCell($"{summary.CoveredLines}/{summary.Lines}", TextAlign.Right, linesColor));
row.Cells.Add(new ConsoleCell($"{summary.LinesPercentage:P}", TextAlign.Right, linesColor));
row.Cells.Add(new ConsoleCell($"{summary.CoveredStatements}/{summary.Statements}", TextAlign.Right, linesColor));
row.Cells.Add(new ConsoleCell($"{summary.StatementsPercentage:P}", TextAlign.Right, statementsColor));
row.Cells.Add(new ConsoleCell($"{summary.CoveredBranches}/{summary.Branches}", TextAlign.Right, linesColor));
row.Cells.Add(new ConsoleCell($"{summary.BranchesPercentage:P}", TextAlign.Right, branchesColor));
return(row);
}
private void AddKamokuKubunAmountToSummaryItem(int kamokuKubunId, long karikataAmount, long kashikataAmount, models.db.Row denpyouRow)
{
if (kamokuKubunId == -1)
{
return;
}
if (!kamokuKubunSummaryTable.ContainsKey(kamokuKubunId))
{
kamokuKubunSummaryTable[kamokuKubunId] = new SummaryRow(kamokuKubunId, karikataAmount, kashikataAmount);
}
else
{
kamokuKubunSummaryTable[kamokuKubunId].AddAmount(karikataAmount, kashikataAmount);
}
if (OnAddDenpyou != null && ObserveKamokuKubunList.ContainsKey(kamokuKubunId))
{
OnAddDenpyou(kamokuKubunId, karikataAmount, kashikataAmount, denpyouRow);
}
}
/// <summary>
/// GetTextCore
/// </summary>
/// <param name="value"></param>
/// <param name="formatInfo"></param>
/// <param name="gridElement"></param>
/// <returns></returns>
protected override string GetTextCore(object value, CellTextFormatInfo formatInfo, GridElement gridElement)
{
DataCell cell = gridElement as DataCell;
if (cell == null)
{
return(null);
}
if (cell.Value == null)
{
Xceed.Grid.DataRow row = cell.ParentRow as Xceed.Grid.DataRow;
if (row == null)
{
return(null);
}
if (row.DetailGrids.Count == 0)
{
return(null);
}
IGrid grid = row.DetailGrids[0] as IGrid;
if (grid == null)
{
return(null);
}
SummaryRow sumRow = grid.GetSummaryRow();
if (sumRow == null)
{
return(null);
}
cell.Value = ConvertHelper.ChangeType(sumRow.Cells[m_detailColumnName].Value, cell.ParentColumn.DataType);
return(sumRow.Cells[m_detailColumnName].Value == null ? null : sumRow.Cells[m_detailColumnName].Value.ToString());
}
else
{
return(base.GetTextCore(value, formatInfo, gridElement));
}
}
private void InitializeSampleDataGrid()
{
EmployeeSaleInfo[] sampleData = new EmployeeSaleInfo[]
{
new EmployeeSaleInfo( "Steven", "Maria Anders", "Appliances", 431.18f, "Suspendisse et tortor sit amet lectus porttitor elementum. Aenean mi diam, vestibulum viverra, fringilla laoreet.", true ),
new EmployeeSaleInfo( "Steven", "Ana Trujillo", "Appliances", 218.49f, "Aenean rutrum rutrum magna. Pellentesque enim diam, facilisis ut, gravida sit amet, laoreet ac, libero.", true ),
new EmployeeSaleInfo( "Steven", "Antonio Moreno", "Kitchenware", 139.87f, "Donec sagittis dolor nec mauris. In eget urna sed quam lacinia nonummy. Integer leo nunc.", false ),
new EmployeeSaleInfo( "Steven", "Thomas Hardy", "Appliances", 87.29f, "Etiam vestibulum. Nunc sit amet tortor. Vivamus odio nisl, commodo placerat, mollis sit amet, luctus.", true ),
new EmployeeSaleInfo( "Anne", "Christina Berglund", "Furniture", 296.46f, "Praesent lacinia faucibus nulla. Quisque pellentesque pellentesque nunc. Donec tempus facilisis eros. Morbi non quam.", false ),
new EmployeeSaleInfo( "Anne", "Hanna Moos", "Appliances", 187.73f, "Phasellus blandit metus ut diam condimentum tristique. Morbi eu leo ut dui rutrum pulvinar. Sed.", false ),
new EmployeeSaleInfo( "Anne", "Fr�d�rique Citeaux", "Furniture", 987.65f, "Vestibulum sodales turpis in augue. Integer non lectus nec elit sagittis porttitor. Praesent id justo.", false ),
new EmployeeSaleInfo( "Janet", "Mart�n Sommer", "Men's Clothing", 684.26f, "Nam consequat, pede pretium tempus posuere, diam turpis rutrum nisl, vitae dapibus sapien neque iaculis.", false ),
new EmployeeSaleInfo( "Janet", "Laurence Lebihan", "Men's Clothing", 48.00f, "Suspendisse potenti. Mauris sollicitudin enim sit amet purus. Ut varius adipiscing lorem. Integer adipiscing. Curabitur.", true ),
new EmployeeSaleInfo( "Bob", "Elizabeth Lincoln", "Electronics", 659.29f, "Nulla congue facilisis odio. Etiam dapibus tempus pede. Vestibulum sed quam. Maecenas dictum enim eu.", true ),
new EmployeeSaleInfo( "Bob", "Victoria Ashworth", "Electronics", 196.36f, "Suspendisse potenti. Duis iaculis tincidunt ante. Sed quam. Fusce commodo, augue id egestas pharetra, elit.", false ),
new EmployeeSaleInfo( "Bill", "Patricio Simpson", "Home Hardware", 396.14f, "Curabitur velit lacus, cursus ac, sollicitudin vel, porttitor ut, ipsum. Donec posuere purus ut mauris.", true ),
new EmployeeSaleInfo( "Bill", "Francisco Chang", "Car Accessories", 571.38f, "Maecenas ut elit. Nam lacus. Sed blandit fringilla lorem. Duis cursus lectus vel velit. Pellentesque.", false ),
};
m_gridSampleData = new GridControl();
m_gridSampleData.FixedColumnSplitter.Visible = false;
m_gridSampleData.Columns.GenerateFromType(typeof(EmployeeSaleInfo));
m_gridSampleData.FixedHeaderRows.Add(new ColumnManagerRow());
Group divisionGroup = new Group("Division");
m_gridSampleData.GroupTemplates.Add(divisionGroup);
SummaryRow divisionSummary = new SummaryRow();
divisionGroup.FooterRows.Add(divisionSummary);
SummaryCell statCell = (SummaryCell)divisionSummary.Cells["SaleAmount"];
statCell.StatFunction = StatFunction.Sum;
statCell.TitleFormat = "Total for %GROUPKEY%:";
Group employeeGroup = new Group("SalesAgent");
m_gridSampleData.GroupTemplates.Add(employeeGroup);
SummaryRow employeeSummary = new SummaryRow();
employeeGroup.FooterRows.Add(employeeSummary);
statCell = (SummaryCell)employeeSummary.Cells["SaleAmount"];
statCell.StatFunction = StatFunction.Sum;
statCell.TitleFormat = "Total for %GROUPKEY%:";
m_gridSampleData.Columns["Division"].Visible = false;
m_gridSampleData.Columns["SalesAgent"].Visible = false;
int visibleIndex = 0;
m_gridSampleData.Columns["CustomerName"].VisibleIndex = visibleIndex++;
m_gridSampleData.Columns["SaleAmount"].VisibleIndex = visibleIndex++;
m_gridSampleData.Columns["Shipped"].VisibleIndex = visibleIndex++;
m_gridSampleData.Columns["Comment"].VisibleIndex = visibleIndex++;
m_gridSampleData.Columns["CustomerName"].Title = "Customer Name";
m_gridSampleData.Columns["SaleAmount"].Title = "Sale Amount";
m_gridSampleData.Columns["SaleAmount"].FormatSpecifier = "c";
m_gridSampleData.Columns["CustomerName"].Width = 175;
m_gridSampleData.Columns["Shipped"].Width = m_gridSampleData.Columns["Shipped"].GetFittedWidth();
m_gridSampleData.Columns["Comment"].Width = 200;
m_gridSampleData.BindingContext = new BindingContext();
m_gridSampleData.DataSource = sampleData;
}
public void AddAmount(SummaryRow row)
{
this.KarikataAmount += row.KarikataAmount;
this.KashikataAmount += row.KashikataAmount;
}
void CheckColumn_ValueChanged(object sender, EventArgs e)
{
if (m_isBatchSetting)
{
return;
}
SummaryRow sumRow = m_grid.GetSummaryRow();
if (sumRow != null)
{
List <string> sumColumnNames = new List <string>();
List <string> countColumnNames = new List <string>();
foreach (Cell cell in sumRow.Cells)
{
SummaryCell sumCell = cell as SummaryCell;
if (sumCell != null)
{
if (sumCell.StatFunction == StatFunction.Sum)
{
sumColumnNames.Add(cell.ParentColumn.FieldName);
}
else if (sumCell.StatFunction == StatFunction.Count)
{
countColumnNames.Add(cell.ParentColumn.FieldName);
}
}
}
if (sumColumnNames.Count > 0 || countColumnNames.Count > 0)
{
ValueRow valueRow = m_grid.GetValueRow();
if (valueRow == null)
{
sumRow.Visible = false;
valueRow = m_grid.AddValueRowToFixedFooter();
}
bool allSelect = true;
bool noneSelect = true;
decimal[] sum = new decimal[sumColumnNames.Count];
for (int i = 0; i < sumColumnNames.Count; ++i)
{
sum[i] = 0;
}
int[] count = new int[countColumnNames.Count];
for (int i = 0; i < countColumnNames.Count; ++i)
{
count[i] = 0;
}
foreach (Xceed.Grid.DataRow row in m_grid.DataRows)
{
if (Convert.ToBoolean(row.Cells[m_selectColumnName].Value))
{
for (int i = 0; i < sumColumnNames.Count; ++i)
{
decimal?d = ConvertHelper.ToDecimal(row.Cells[sumColumnNames[i]].Value);
sum[i] += d.HasValue ? d.Value : 0;
}
for (int i = 0; i < countColumnNames.Count; ++i)
{
count[i] += 1;
}
noneSelect = false;
}
else
{
allSelect = false;
}
}
for (int i = 0; i < sumColumnNames.Count; ++i)
{
valueRow.Cells[sumColumnNames[i]].Value = sum[i];
}
for (int i = 0; i < countColumnNames.Count; ++i)
{
valueRow.Cells[countColumnNames[i]].Value = count[i];
}
if (allSelect)
{
valueRow.Cells[m_selectColumnName].Value = true;
}
else if (noneSelect)
{
valueRow.Cells[m_selectColumnName].Value = false;
}
else
{
valueRow.Cells[m_selectColumnName].Value = null;
}
}
}
}
public void Dispose()
{
Range?.Dispose();
SummaryRow?.Dispose();
}
public SummaryRowChangeEvent(SummaryRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
/// <summary>
/// 创建Summary行
/// </summary>
internal static void CreateSumRow(this IBoundGrid grid)
{
bool needSum = false;
if (!string.IsNullOrEmpty(ADInfoBll.Instance.GetGridInfo(grid.GridName).StatTitle))
{
needSum = true;
}
if (!needSum)
{
foreach (Column column in grid.Columns)
{
GridColumnInfo info = column.Tag as GridColumnInfo;
if (info == null)
{
continue;
}
if (string.IsNullOrEmpty(info.StatFunction) || !Authority.AuthorizeByRule(info.ColumnVisible))
{
continue;
}
needSum = true;
break;
}
}
if (needSum)
{
SummaryRow sumRow = grid.AddSummaryRowToFixedFooter();
sumRow.TextFormat = ADInfoBll.Instance.GetGridInfo(grid.GridName).StatTitle;
foreach (Column column in grid.Columns)
{
GridColumnInfo info = column.Tag as GridColumnInfo;
if (info == null || !Authority.AuthorizeByRule(info.ColumnVisible))
{
continue;
}
if (!string.IsNullOrEmpty(info.StatFunction))
{
MySummaryCell cell = ((MySummaryCell)sumRow.Cells[info.GridColumnName]);
cell.StatFunction = BoundGridExtention.GetStatFunction(info.StatFunction);
cell.RunningStatGroupLevel = 0;
//cell.ResultDataType = typeof(string);
// 只有在StatFunction有效的时候，StatTitle才有效。就是一个常量型的文字
if (!string.IsNullOrEmpty(info.StatTitle))
{
//MySummaryCell cell = ((MySummaryCell)sumRow.Cells[info.GridColumnName]);
//cell.RunningStatGroupLevel = 0;
//cell.ResultDataType = typeof(string);
cell.TitleFormat = info.StatTitle;
cell.TitlePosition = Xceed.Grid.TitlePosition.PreferablyRight;
}
}
}
}
}
public void Read(string filename)
{
Stream sr = File.OpenRead(filename);
IExcelDataReader excelReader;
// Default to xlsx
if (filename.EndsWith(".xls"))
{
excelReader = ExcelReaderFactory.CreateBinaryReader(sr);
}
else
{
excelReader = ExcelReaderFactory.CreateOpenXmlReader(sr);
}
var data = excelReader.AsDataSet();
var table = data.Tables[0];
var headerRow = table.Rows[0];
int pathway_col = -1, temp_col = -1, conj_col = -1, etanScalingFactor_col = -1,
peakHeaderVoltage_col = -1, crestFactor_col = -1;
for (int i = 0; i < headerRow.ItemArray.Length; i++)
{
if (headerRow.ItemArray[i] is DBNull)
{
continue;
}
string colname = (string)headerRow.ItemArray[i];
switch (colname.ToLowerInvariant())
{
case "": break;
case "pathway": pathway_col = i; break;
case "measured temperature": temp_col = i; break;
case "conjugate": conj_col = i; break;
case "etan scaling factor": etanScalingFactor_col = i; break;
case "measured peak header voltage": peakHeaderVoltage_col = i; break;
case "crest factor": crestFactor_col = i; break;
default: throw new FormatException("Summary file contains an unknown column: " + colname);
}
}
if (pathway_col == -1)
{
throw new FormatException("Pathway column not discovered in summary file.");
}
rows = new List <SummaryRow>();
for (int i = 1; i < table.Rows.Count; i++)
{
// skip row if pathway is blank
if (table.Rows[i].ItemArray[pathway_col] is DBNull ||
(string)table.Rows[i].ItemArray[pathway_col] == "")
{
continue;
}
var sumrow = new SummaryRow();
sumrow.Pathway = table.Rows[i].ItemArray[pathway_col].ToString();
if (temp_col != -1)
{
var x = table.Rows[i].ItemArray[temp_col];
sumrow.MeasuredTemperature =
ConvertColumnToDouble(x, headerRow.ItemArray[temp_col].ToString());
}
if (peakHeaderVoltage_col != -1)
{
var x = table.Rows[i].ItemArray[peakHeaderVoltage_col];
sumrow.PeakHeaderVoltage =
ConvertColumnToDouble(x, headerRow.ItemArray[peakHeaderVoltage_col].ToString());
}
if (crestFactor_col != -1)
{
var x = table.Rows[i].ItemArray[crestFactor_col];
sumrow.CrestFactor =
ConvertColumnToDouble(x, headerRow.ItemArray[crestFactor_col].ToString());
}
if (conj_col != -1)
{
object x = table.Rows[i].ItemArray[conj_col];
if (!(x is string))
{
throw new FormatException("Conjugate column with non-string data: "
+ x.ToString());
}
switch ((string)(x))
{
case "n":
case "N":
case "":
sumrow.Conjugate = false; break;
case "y":
case "Y":
sumrow.Conjugate = true; break;
default:
throw new FormatException("Conjugate column with unknown data: "
+ table.Rows[i].ItemArray[conj_col].ToString());
}
}
if (etanScalingFactor_col != -1)
{
var x = table.Rows[i].ItemArray[etanScalingFactor_col];
sumrow.ETanScalingFactor =
ConvertColumnToDouble(x, headerRow.ItemArray[etanScalingFactor_col].ToString());
}
rows.Add(sumrow);
}
excelReader.Close();
}
