/// <summary>
/// Returns a value you specify if a formula evaluates to an error; otherwise,
/// returns the result of the formula. Use the IFERROR function to trap and
/// handle errors in a formula (formula: A sequence of values, cell references,
/// names, functions, or operators in a cell that together produce a new value.
/// A formula always begins with an equal sign (=).).
/// </summary>
/// <param name="args"><para>
/// The args contains three items: value, value_if_error.
/// </para>
/// <para>
/// Value is the argument that is checked for an error.
/// </para>
/// <para>
/// Value_if_error is the value to return if the formula evaluates to an error.
/// The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
/// </para></param>
/// <returns>
/// A <see cref="T:System.Object" /> value that indicates the evaluate result.
/// </returns>
public override object Evaluate(object[] args)
{
base.CheckArgumentsLength(args);
bool flag = args[0] is CalcError;
if (!flag && (args[0] is CalcReference))
{
CalcReference reference = args[0] as CalcReference;
if (reference.RangeCount > 1)
{
return(CalcErrors.Value);
}
return(new BinaryCompositeConcreteReference(reference.GetSource(), reference.GetRow(0), reference.GetColumn(0), reference.GetRowCount(0), reference.GetColumnCount(0), new Func <object, object, object>(CalcIfErrorFunction.EvaluateSingle), args[1], false));
}
if (!flag)
{
object obj1 = args[0];
if (obj1 != null)
{
return(obj1);
}
return((int)0);
}
return(args[1] ?? ((int)0));
}
/// <summary>
/// Returns the result of the operator applied to the operands.
/// </summary>
/// <param name="left">The left operand.</param>
/// <param name="right">The right operand..</param>
/// <param name="context">
/// The <see cref="T:Dt.CalcEngine.CalcEvaluatorContext" /> associate with the operator evaluation.
/// </param>
/// <returns>
/// Result of the operator applied to the operand.
/// </returns>
public override object Evaluate(object left, object right, CalcEvaluatorContext context)
{
CalcReference reference = left as CalcReference;
CalcReference reference2 = right as CalcReference;
if (((reference == null) || (reference2 == null)) || (((reference.RangeCount != 1) || (reference2.RangeCount != 1)) || !reference.GetSource().Equals(reference2.GetSource())))
{
return(CalcErrors.Value);
}
CalcReference source = reference.GetSource();
if ((source == null) || !source.Equals(reference2.GetSource()))
{
return(CalcErrors.Value);
}
int row = reference.GetRow(0);
int column = reference.GetColumn(0);
int num3 = reference2.GetRow(0);
int num4 = reference2.GetColumn(0);
int num5 = Math.Max(row, num3);
int num6 = Math.Max(column, num4);
int rowCount = Math.Min((int)(row + reference.GetRowCount(0)), (int)(num3 + reference2.GetRowCount(0))) - num5;
int columnCount = Math.Min((int)(column + reference.GetColumnCount(0)), (int)(num4 + reference2.GetColumnCount(0))) - num6;
if ((rowCount >= 1) && (columnCount >= 1))
{
return(new ConcreteReference(source, num5, num6, rowCount, columnCount));
}
return(CalcErrors.Null);
}
/// <summary>
/// Returns the result of the operator applied to the operands.
/// </summary>
/// <param name="left">The left operand.</param>
/// <param name="right">The right operand..</param>
/// <param name="context">
/// The <see cref="T:Dt.CalcEngine.CalcEvaluatorContext" /> associate with the operator evaluation.
/// </param>
/// <returns>
/// Result of the operator applied to the operand.
/// </returns>
public override object Evaluate(object left, object right, CalcEvaluatorContext context)
{
CalcReference reference = left as CalcReference;
CalcReference reference2 = right as CalcReference;
if ((reference == null) || (reference2 == null))
{
return(CalcErrors.Value);
}
int rangeCount = reference.RangeCount;
int num2 = reference2.RangeCount;
ConcreteReference.Range[] areas = new ConcreteReference.Range[rangeCount + num2];
for (int i = 0; i < rangeCount; i++)
{
int row = reference.GetRow(i);
int column = reference.GetColumn(i);
int rowCount = reference.GetRowCount(i);
int columnCount = reference.GetColumnCount(i);
areas[i] = new ConcreteReference.Range(row, column, rowCount, columnCount);
}
for (int j = 0; j < num2; j++)
{
int num9 = reference2.GetRow(j);
int num10 = reference2.GetColumn(j);
int num11 = reference2.GetRowCount(j);
int num12 = reference2.GetColumnCount(j);
areas[rangeCount + j] = new ConcreteReference.Range(num9, num10, num11, num12);
}
return(new ConcreteReference(reference.GetSource(), areas));
}
/// <summary>
/// Reverses the value of its argument.
/// </summary>
/// <param name="args">The args contains one item : logical.
/// Logical is a value or expression that can be evaluated to <see langword="true" />
/// or <see langword="false" />.</param>
/// <returns>
/// A <see cref="T:System.Boolean" /> value that indicates the evaluate result.
/// </returns>
public override object Evaluate(object[] args)
{
base.CheckArgumentsLength(args);
CalcReference objA = args[0] as CalcReference;
CalcArray array = args[0] as CalcArray;
if (!object.ReferenceEquals(objA, null))
{
if (objA.RangeCount > 1)
{
return(CalcErrors.Value);
}
return(new UnaryCompositeConcreteReference(objA.GetSource(), objA.GetRow(0), objA.GetColumn(0), objA.GetRowCount(0), objA.GetColumnCount(0), new Func <object, object>(this.EvaluateSingleValue)));
}
if (object.ReferenceEquals(array, null))
{
return(this.EvaluateSingleValue(args[0]));
}
object[,] values = new object[array.RowCount, array.ColumnCount];
for (int i = 0; i < array.RowCount; i++)
{
for (int j = 0; j < array.ColumnCount; j++)
{
values[i, j] = this.EvaluateSingleValue(array.GetValue(i, j));
}
}
return(new ConcreteArray <object>(values));
}
public override object Evaluate(object[] arguments, ICalcContext context)
{
int count = 0;
CalcReference calcReference = arguments[0] as CalcReference;
foreach (IRange srcRange in calcReference.GetRanges())
{
object[,] values = srcRange.Value as object[, ];
for (int row = 0; row < srcRange.Rows.Count; row++)
{
for (int col = 0; col < srcRange.Columns.Count; col++)
{
if (values[row, col] is double)
{
double num = (double)values[row, col];
if (num > 70)
{
count++;
}
}
}
}
}
return(count);
}
/// <summary>
/// Returns a reference to a range that is a specified number of
/// rows and columns from a cell or range of cells.
/// </summary>
/// <param name="args"><para>
/// The args contains 3 - 5 items: reference, rows, cols, [height], [width].
/// </para>
/// <para>
/// Reference is the reference from which you want to base the offset.
/// </para>
/// <para>
/// Rows is the number of rows, up or down, that you want the upper-left
/// cell to refer to.
/// </para>
/// <para>
/// Cols is the number of columns, to the left or right, that you want
/// the upper-left cell of the result to refer to.
/// </para>
/// <para>
/// [Height] is the height, in number of rows, that you want the returned
/// reference to be. Height must be a positive number.
/// </para>
/// <para>
/// [Width] is the width, in number of columns, that you want the returned
/// reference to be. Width must be a positive number.
/// </para></param>
/// <returns>
/// A <see cref="T:Dt.CalcEngine.CalcReference" /> value that indicates the evaluate result.
/// </returns>
public override object Evaluate(object[] args)
{
base.CheckArgumentsLength(args);
CalcReference reference = args[0] as CalcReference;
if ((reference == null) || (reference.RangeCount != 1))
{
return(CalcErrors.Value);
}
int num = CalcConvert.ToInt(args[1]);
int num2 = CalcConvert.ToInt(args[2]);
int rowCount = CalcHelper.ArgumentExists(args, 3) ? CalcConvert.ToInt(args[3]) : reference.GetRowCount(0);
int columnCount = CalcHelper.ArgumentExists(args, 4) ? CalcConvert.ToInt(args[4]) : reference.GetColumnCount(0);
CalcReference source = reference.GetSource();
int row = reference.GetRow(0) + num;
int column = reference.GetColumn(0) + num2;
if ((rowCount > 0) && (columnCount > 0))
{
if ((row < source.GetRow(0)) || ((source.GetRow(0) + source.GetRowCount(0)) < (row + rowCount)))
{
return(CalcErrors.Reference);
}
if ((column >= source.GetColumn(0)) && ((source.GetColumn(0) + source.GetColumnCount(0)) >= (column + columnCount)))
{
return(new ConcreteReference(source, row, column, rowCount, columnCount));
}
}
return(CalcErrors.Reference);
}
public override object Evaluate(object[] args)
{
try
{
#region 参数
double c1 = 0;
CalcReference r = (CalcReference)args[0];//从单元格获取参数
try
{
if (args[0].ToString().Trim() == string.Empty)
{
return(DBNull.Value);
}
else
{
c1 = CalcConvert.ToDouble(args[0]);
}
}
catch
{
if (r.GetValue(r.Row, r.Column) == null || r.GetValue(r.Row, r.Column) == DBNull.Value || r.GetValue(r.Row, r.Column).ToString().Trim() == "" || r.GetValue(r.Row, r.Column).ToString().Trim() == "/")
{
return(DBNull.Value);
}
else
{
c1 = CalcConvert.ToDouble(r.GetValue(r.Row, r.Column).ToString());
}
}
#endregion
#region 数据
string c2 = string.Empty;
if (c1 <= 3.7 && c1 >= 3.1)
{
c2 = "粗砂";
}
if (c1 <= 3.0 && c1 >= 2.3)
{
c2 = "中砂";
}
if (c1 <= 2.2 && c1 >= 1.6)
{
c2 = "细砂";
}
return(c2);
#endregion
}
catch (Exception ee)
{
return(DBNull.Value);
}
}
public static double ToDouble(object value)
{
if (value is CalcReference)
{
CalcReference cr = (CalcReference)value;
value = cr.GetValue(cr.Row, cr.Column);
}
return(CalcConvert.ToDouble(value));
}
private static IEnumerable <object> Enumerate(CalcReference reference)
{
foreach (var range in reference.GetRanges())
{
int rowCount = range.Rows.Count;
int colCount = range.Columns.Count;
for (int i = 0; i < rowCount; i++)
{
for (int j = 0; j < colCount; j++)
{
if (range.Cells[i, j].DisplayFormat.Interior.Color == System.Drawing.Color.Red)
{
yield return(range.Cells[i, j].Value);
}
}
}
}
}
/// <summary>
/// Adds the cells specified by a given criteria.
/// </summary>
/// <param name="args"><para>
/// The args contains 2 - 3 items: range, criteria, [sum_range].
/// </para>
/// <para>
/// Range is the range of cells that you want evaluated by criteria.
/// </para>
/// <para>
/// Criteria is the criteria in the form of a number, expression,
/// or text that defines which cells will be added.
/// </para>
/// <para>
/// [Sum_range] are the actual cells to add if their corresponding
/// cells in range match criteria.
/// </para></param>
/// <returns>
/// A <see cref="T:System.Double" /> value that indicates the evaluate result.
/// </returns>
public override object Evaluate(object[] args)
{
base.CheckArgumentsLength(args);
object range = args[0];
object criteria = args[1];
if (criteria == null)
{
throw new ArgumentException("criteria");
}
object sumRange = CalcHelper.ArgumentExists(args, 2) ? args[2] : args[0];
CalcReference objA = args[1] as CalcReference;
if (!object.ReferenceEquals(objA, null))
{
int num = objA.GetRowCount(0);
int num2 = objA.GetColumnCount(0);
if ((num == 1) && (num2 == 1))
{
return(EvaluateSingleCriteria(objA.GetValue(0, 0, 0), range, sumRange));
}
return(new TernaryCompositeConcreteReference(objA.GetSource(), objA.GetRow(0), objA.GetColumn(0), num, num2, new Func <object, object, object, object>(CalcSumIfFunction.EvaluateSingleCriteria), range, sumRange));
}
CalcArray array = args[1] as CalcArray;
if (object.ReferenceEquals(array, null))
{
return(EvaluateSingleCriteria(criteria, range, sumRange));
}
int rowCount = array.RowCount;
int columnCount = array.ColumnCount;
object[,] values = new object[rowCount, columnCount];
for (int i = 0; i < rowCount; i++)
{
for (int j = 0; j < columnCount; j++)
{
values[i, j] = EvaluateSingleCriteria(array.GetValue(i, j), range, sumRange);
}
}
return(new ConcreteArray <object>(values));
}
/// <summary>
/// Returns the average (arithmetic mean) of all the cells in a range
/// that meet a given criteria.
/// </summary>
/// <param name="args"><para>
/// The args contains 2 - 3 items: range, criteria, [average_range].
/// </para>
/// <para>
/// Range is one or more cells to average, including numbers or names,
/// arrays, or references that contain numbers.
/// </para>
/// <para>
/// Criteria is the criteria in the form of a number, expression, cell
/// reference, or text that defines which cells are averaged.
/// </para>
/// <para>
/// [Average_range] is the actual set of cells to average. If omitted,
/// range is used.
/// </para></param>
/// <returns>
/// A <see cref="T:System.Object" /> value that indicates the evaluate result.
/// </returns>
public override object Evaluate(object[] args)
{
base.CheckArgumentsLength(args);
object range = args[0];
object criteria = args[1];
object sumRange = CalcHelper.ArgumentExists(args, 2) ? args[2] : args[0];
CalcReference objA = args[1] as CalcReference;
if (!object.ReferenceEquals(objA, null))
{
int num = objA.GetRowCount(0);
int num2 = objA.GetColumnCount(0);
object[,] objArray = new object[num, num2];
for (int j = 0; j < num; j++)
{
for (int k = 0; k < num2; k++)
{
objArray[j, k] = this.EvaluateSingleCriteria(range, objA.GetValue(0, j, k), sumRange);
}
}
return(new ConcreteArray <object>(objArray));
}
CalcArray array = args[1] as CalcArray;
if (object.ReferenceEquals(array, null))
{
return(this.EvaluateSingleCriteria(range, criteria, sumRange));
}
int rowCount = array.RowCount;
int columnCount = array.ColumnCount;
object[,] values = new object[rowCount, columnCount];
for (int i = 0; i < rowCount; i++)
{
for (int m = 0; m < columnCount; m++)
{
values[i, m] = this.EvaluateSingleCriteria(range, array.GetValue(i, m), sumRange);
}
}
return(new ConcreteArray <object>(values));
}
private static object EvaluateImp(object[] args, object context)
{
CalcEvaluatorContext objA = context as CalcEvaluatorContext;
if (object.ReferenceEquals(objA, null))
{
return(CalcErrors.Value);
}
bool arrayFormulaMode = objA.ArrayFormulaMode;
CalcReference reference = CalcHelper.ArgumentExists(args, 0) ? (args[0] as CalcReference) : (objA.GetReference(new CalcRangeIdentity(objA.Row, objA.Column, objA.RowCount, objA.ColumnCount)) as CalcReference);
if ((reference == null) || (reference.RangeCount != 1))
{
return(CalcErrors.Value);
}
if (arrayFormulaMode)
{
return(new CellInfoReference(reference.GetSource(), reference.GetRow(0), reference.GetColumn(0), reference.GetRowCount(0), reference.GetColumnCount(0), CellInfoReference.CellInfoType.Column));
}
return((int)(reference.GetColumn(0) + 1));
}
internal object EvaluteInternal(object operand, CalcEvaluatorContext context)
{
CalcArray array = operand as CalcArray;
CalcReference reference = operand as CalcReference;
if (reference != null)
{
array = CalcConvert.ToArray(reference);
}
if (array == null)
{
return(this.EvaluteSingleValue(operand, context));
}
if (array.Length < 1)
{
return(CalcErrors.Number);
}
object[,] values = new object[array.RowCount, array.ColumnCount];
CalcOperator.OperatorArray array2 = new CalcOperator.OperatorArray(values);
object obj2 = array.GetValue(0);
Type type = (obj2 != null) ? obj2.GetType() : typeof(object);
for (int i = 0; i < array.RowCount; i++)
{
for (int j = 0; j < array.ColumnCount; j++)
{
object obj3 = array.GetValue(i, j);
if ((obj3 != null) && (obj3.GetType() != type))
{
return(CalcErrors.Number);
}
object obj4 = this.EvaluteSingleValue(obj3, context);
values[i, j] = obj4;
}
}
return(array2);
}
public static void ExtractAllReferenceExpression(ICalcEvaluator evaluator, CalcExpression root, List <CalcReferenceExpression> nodes)
{
if (root is CalcBinaryOperatorExpression)
{
CalcBinaryOperatorExpression expression = root as CalcBinaryOperatorExpression;
ExtractAllReferenceExpression(evaluator, expression.Left, nodes);
ExtractAllReferenceExpression(evaluator, expression.Right, nodes);
}
else if (root is CalcParenthesesExpression)
{
CalcParenthesesExpression expression2 = root as CalcParenthesesExpression;
ExtractAllReferenceExpression(evaluator, expression2.Arg, nodes);
}
else if (root is CalcExternalNameExpression)
{
CalcExternalNameExpression expression3 = root as CalcExternalNameExpression;
ICalcSource source = expression3.Source;
if (source != null)
{
CalcExpression expression4 = source.GetDefinedName(expression3.Name, -1, -1);
if (expression4 != null)
{
ExtractAllReferenceExpression(evaluator, expression4, nodes);
}
}
}
else if (root is CalcFunctionExpression)
{
CalcFunctionExpression expr = root as CalcFunctionExpression;
Worksheet worksheet = evaluator as Worksheet;
if (worksheet != null)
{
CalcEvaluatorContext context = new CalcEvaluatorContext(worksheet, false, worksheet.ActiveRowIndex, worksheet.ActiveColumnIndex, 1, 1);
object obj2 = new CalcEvaluator().Evaluate(expr, context, true, true);
if (obj2 is CalcReference)
{
CalcReference reference = obj2 as CalcReference;
int row = reference.GetRow(0);
int rowCount = reference.GetRowCount(0);
int column = reference.GetColumn(0);
int columnCount = reference.GetColumnCount(0);
ICalcSource source2 = null;
CalcReference reference2 = reference.GetSource();
// hdt
MethodInfo info = reference2.GetType().GetRuntimeMethod("GetContext", null);
if (info != null)
{
source2 = info.Invoke(reference2, null) as ICalcSource;
}
if (source2 == null)
{
source2 = worksheet;
}
CalcExternalRangeExpression expression6 = CreateExternalRangeExpressionByCount(source2, row, column, rowCount, columnCount, false, false, false, false);
nodes.Add(expression6);
}
}
}
else if (root is CalcReferenceExpression)
{
nodes.Add(root as CalcReferenceExpression);
}
}
public override object Evaluate(object[] args)
{
try
{
#region 参数
string s = string.Empty;
CalcReference r = (CalcReference)args[0];
if (r.GetValue(r.Row, r.Column) == null || r.GetValue(r.Row, r.Column) == DBNull.Value || r.GetValue(r.Row, r.Column).ToString().Trim() == "" || r.GetValue(r.Row, r.Column).ToString().Trim() == "/" || r.GetValue(r.Row, r.Column).ToString().Trim() == "#NAME?")
{
s = string.Empty;
}
else
{
s = CalcConvert.ToString(r.GetValue(r.Row, r.Column).ToString());
s = s.Trim();
s = s.Substring(0, s.Length - 2);
}
double d = 0;
r = (CalcReference)args[1];
if (r.GetValue(r.Row, r.Column) == null || r.GetValue(r.Row, r.Column) == DBNull.Value || r.GetValue(r.Row, r.Column).ToString().Trim() == "" || r.GetValue(r.Row, r.Column).ToString().Trim() == "/" || r.GetValue(r.Row, r.Column).ToString().Trim() == "#NAME?")
{
d = 0;
}
else
{
d = CalcConvert.ToDouble(r.GetValue(r.Row, r.Column).ToString());
}
#endregion
if (s == string.Empty || d == 0)
{
return(DBNull.Value);
}
try
{
#region 一(5～10)
if (s == "5～10")
{
//1
if (d == 2.36)
{
return("95～100");
}
//2
if (d == 4.75)
{
return("80～100");
}
//3
if (d == 9.5)
{
return("0～15");
}
//4
if (d == 16.0)
{
return("0");
}
//5,6,7,8,9,10,11,12
if (d == 19.0 || d == 26.5 || d == 31.5 || d == 37.5 || d == 53.0 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region 二(5～16)
if (s == "5～16")
{
//1
if (d == 2.36)
{
return("95～100");
}
//2
if (d == 4.75)
{
return("85～100");
}
//3
if (d == 9.5)
{
return("30～60");
}
//4
if (d == 16.0)
{
return("0～10");
}
//5
if (d == 19.0)
{
return("0");
}
//6,7,8,9,10,11,12
if (d == 26.5 || d == 31.5 || d == 37.5 || d == 53.0 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region (5～20)
if (s == "5～20")
{
//1
if (d == 2.36)
{
return("95～100");
}
//2
if (d == 4.75)
{
return("90～100");
}
//3
if (d == 9.5)
{
return("40～80");
}
//4
if (d == 16.0)
{
return("/");
}
//5
if (d == 19.0)
{
return("0～10");
}
//6
if (d == 26.5)
{
return("0");
}
//7,8,9,10,11,12
if (d == 31.5 || d == 37.5 || d == 53.0 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region 四(5～25)
if (s == "5～25")
{
//1
if (d == 2.36)
{
return("95～100");
}
//2
if (d == 4.75)
{
return("90～100");
}
//3
if (d == 9.5)
{
return("/");
}
//4
if (d == 16.0)
{
return("30～70");
}
//5
if (d == 19.0)
{
return("/");
}
//6
if (d == 26.5)
{
return("0～5");
}
//7
if (d == 31.5)
{
return("0");
}
//8,9,10,11,12
if (d == 37.5 || d == 53.0 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region 五(5～31.5)
if (s == "5～31.5")
{
//1
if (d == 2.36)
{
return("95～100");
}
//2
if (d == 4.75)
{
return("90～100");
}
//3
if (d == 9.5)
{
return("70～90");
}
//4
if (d == 16.0)
{
return("/");
}
//5
if (d == 19.0)
{
return("15～45");
}
//6
if (d == 26.5)
{
return("/");
}
//7
if (d == 31.5)
{
return("0～5");
}
//8
if (d == 37.5)
{
return("0");
}
//9,10,11,12
if (d == 53.0 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region 六(5～40)
if (s == "5～40")
{
//1
if (d == 2.36)
{
return("/");
}
//2
if (d == 4.75)
{
return("95～100");
}
//3
if (d == 9.5)
{
return("70～90");
}
//4
if (d == 16.0)
{
return("/");
}
//5
if (d == 19.0)
{
return("30～65");
}
//6
if (d == 26.5)
{
return("/");
}
//7
if (d == 31.5)
{
return("/");
}
//8
if (d == 37.5)
{
return("0～5");
}
//9
if (d == 53.0)
{
return("0");
}
//10,11,12
if (d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region 七(10～20)
if (s == "10～20")
{
//1
if (d == 2.36)
{
return("/");
}
//2
if (d == 4.75)
{
return("95～100");
}
//3
if (d == 9.5)
{
return("85～100");
}
//4
if (d == 16.0)
{
return("/");
}
//5
if (d == 19.0)
{
return("0～15");
}
//6
if (d == 26.5)
{
return("0");
}
//7,8,9,10,11,12
if (d == 31.5 || d == 37.5 || d == 53.0 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region 八(16～31.5)
if (s == "16～31.5")
{
//2
if (d == 4.75)
{
return("95～100");
}
//4
if (d == 16.0)
{
return("85～100");
}
//7
if (d == 31.5)
{
return("0～10");
}
//8
if (d == 37.5)
{
return("0");
}
//1,3,5,6,9,10,11,12
if (d == 2.36 || d == 9.5 || d == 19.0 || d == 26.5 || d == 53.5 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region 九(20～40)
if (s == "20～40")
{
//3
if (d == 9.5)
{
return("95～100");
}
//5
if (d == 19.0)
{
return("80～100");
}
//8
if (d == 37.5)
{
return("0～10");
}
//9
if (d == 53.0)
{
return("0");
}
//1,2,4,6,7,10,11,12
if (d == 2.36 || d == 4.75 || d == 16.0 || d == 26.5 || d == 31.5 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
#region 十(31.5～63)
if (s == "31.5～63")
{
//4
if (d == 16.0)
{
return("95～100");
}
//7
if (d == 31.5)
{
return("75～100");
}
//8
if (d == 37.5)
{
return("45～75");
}
//10
if (d == 63.0)
{
return("0～10");
}
//11
if (d == 75.0)
{
return("0");
}
//1,2,3,5,6,9,12
if (d == 2.36 || d == 4.75 || d == 9.5 || d == 19.0 || d == 26.5 || d == 53.0 || d == 90)
{
return("/");
}
}
#endregion
#region 十一(40～80)
if (s == "40～80")
{
//5
if (d == 19.0)
{
return("95～100");
}
//8
if (d == 37.5)
{
return("70～100");
}
//10
if (d == 63.0)
{
return("30～60");
}
//11
if (d == 75.0)
{
return("0～10");
}
//12
if (d == 90)
{
return("0");
}
//1,2,3,4,6,7,9
if (d == 2.36 || d == 4.75 || d == 9.5 || d == 16.0 || d == 26.5 || d == 31.5 || d == 53.0)
{
return("/");
}
}
#endregion
#region 十二(16～25)
if (s == "16～25")
{
//5
if (d == 9.5)
{
return("95～100");
}
//8
if (d == 16.0)
{
return("55～70");
}
//10
if (d == 19.0)
{
return("25～40");
}
//11
if (d == 26.5)
{
return("0～10");
}
//1,2,3,4,6,7,9
if (d == 2.36 || d == 4.75 || d == 31.5 || d == 37.5 || d == 53.0 || d == 63.0 || d == 75.0 || d == 90)
{
return("/");
}
}
#endregion
}
catch { }
return("/");
}
catch (Exception ee)
{
return(DBNull.Value);
}
}
