using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using HH.WMS.Utils.NPOI.Util;
|
|
namespace HH.WMS.Utils.NPOI.HSSF.Record.AutoFilter
|
{
|
public enum DOPERComparisonCode:byte
|
{
|
Unknown=0,
|
Less=1,
|
Equal=2,
|
LessThan=3,
|
More=4,
|
NotEqual=5,
|
GreaterThan=6
|
}
|
public enum DOPERType:byte
|
{
|
FilterCondition=0,
|
RKNumber=0x02,
|
IEEENumber=0x04,
|
String = 0x06,
|
BooleanOrErrors=0x08,
|
MatchAllBlanks=0x0C,
|
MatchNoneBlank=0x0E
|
}
|
|
public enum DOPERErrorValue : byte
|
{
|
NULL=0, //#NULL!
|
DIV0=0x07, //#DIV/0!
|
VALUE=0x0F, //#VALUE!
|
REF=0x17, //#REF!
|
NAME=0x1D, //#NAME?
|
NUM=0x24, //#NUM!
|
NA=0x2A //N/A
|
}
|
|
/// <summary>
|
/// DOPER Structure for AutoFilter record
|
/// </summary>
|
/// <remarks>author: Tony Qu</remarks>
|
public class DOPERRecord : RecordBase
|
{
|
private DOPERType vt;
|
private byte grbitSgn;
|
private RKRecord _RK;
|
private double _IEEENumber;
|
private byte CCH;
|
private byte fError;
|
private byte bBoolErr;
|
|
public DOPERRecord()
|
{
|
|
}
|
|
public DOPERRecord(RecordInputStream in1)
|
{
|
vt=(DOPERType)in1.ReadByte();
|
switch (vt)
|
{
|
case DOPERType.RKNumber:
|
grbitSgn = (byte)in1.ReadByte();
|
_RK = new RKRecord(in1);
|
in1.ReadInt(); //reserved
|
break;
|
case DOPERType.IEEENumber:
|
grbitSgn = (byte)in1.ReadByte();
|
_IEEENumber = in1.ReadDouble();
|
break;
|
case DOPERType.String:
|
grbitSgn = (byte)in1.ReadByte();
|
in1.ReadInt(); //reserved
|
CCH = (byte)in1.ReadByte();
|
in1.ReadByte(); //reserved
|
in1.ReadShort(); //reserved
|
break;
|
case DOPERType.BooleanOrErrors:
|
grbitSgn = (byte)in1.ReadByte();
|
fError=(byte)in1.ReadByte();
|
bBoolErr=(byte)in1.ReadByte();
|
in1.ReadShort(); //reserved
|
in1.ReadInt(); //reserved
|
break;
|
default: //FilterCondition,MatchAllBlanks,MatchNoneBlank
|
grbitSgn = 0;
|
in1.ReadByte(); //reserved
|
in1.ReadLong(); //reserved
|
break;
|
}
|
}
|
public override int RecordSize
|
{
|
get
|
{
|
return 10;
|
}
|
}
|
public int Serialize(ILittleEndianOutput out1)
|
{
|
out1.WriteByte((byte)vt);
|
switch (vt)
|
{
|
case DOPERType.RKNumber:
|
out1.WriteByte(grbitSgn);
|
_RK.Serialize(out1);
|
out1.WriteInt(0); //reserved
|
break;
|
case DOPERType.IEEENumber:
|
out1.WriteByte(grbitSgn);
|
out1.WriteDouble(_IEEENumber);
|
break;
|
case DOPERType.String:
|
out1.WriteByte(grbitSgn);
|
out1.WriteInt(0); //reserved
|
out1.WriteByte(CCH);
|
out1.WriteByte(0); //reserved
|
out1.WriteShort(0); //reserved
|
break;
|
case DOPERType.BooleanOrErrors:
|
out1.WriteByte(grbitSgn);
|
out1.WriteByte(fError);
|
out1.WriteByte(bBoolErr);
|
out1.WriteShort(0); //reserved
|
out1.WriteInt(0); //reserved
|
break;
|
default: //FilterCondition,MatchAllBlanks,MatchNoneBlank
|
out1.WriteByte(0); //reserved
|
out1.WriteLong(0); //reserved
|
break;
|
}
|
return this.RecordSize;
|
}
|
public virtual Record CloneViaReserialise()
|
{
|
throw new NotImplementedException("Please implement it in subclass");
|
}
|
public override int Serialize(int offset, byte[] data)
|
{
|
LittleEndianByteArrayOutputStream out1 = new LittleEndianByteArrayOutputStream(data, offset,this.RecordSize);
|
int result=this.Serialize(out1);
|
if (out1.WriteIndex - offset != this.RecordSize)
|
{
|
throw new InvalidOperationException("Error in serialization of (" + this.GetType().Name + "): "
|
+ "Incorrect number of bytes written - expected "
|
+ this.RecordSize + " but got " + (out1.WriteIndex - offset));
|
}
|
return result;
|
}
|
|
public DOPERType DataType
|
{
|
get { return vt; }
|
set { vt = value; }
|
}
|
|
public DOPERComparisonCode ComparisonCode
|
{
|
get { return (DOPERComparisonCode)grbitSgn;}
|
set { grbitSgn = (byte)value; }
|
}
|
|
public Double IEEENumber
|
{
|
get { return _IEEENumber; }
|
set {
|
_IEEENumber = value;
|
vt = DOPERType.IEEENumber;
|
}
|
}
|
/// <summary>
|
/// get or set the RK record
|
/// </summary>
|
public RKRecord RK
|
{
|
get { return _RK; }
|
set {
|
_RK = value;
|
vt = DOPERType.RKNumber;
|
}
|
}
|
/// <summary>
|
/// Gets or sets Length of the string (the string is stored in the rgch field that follows the DOPER structures)
|
/// </summary>
|
public byte LengthOfString
|
{
|
get { return CCH; }
|
set {
|
if (value > 252)
|
throw new ArgumentOutOfRangeException("The length of string must be less than or equal to 252");
|
CCH = value;
|
vt = DOPERType.String;
|
}
|
}
|
/// <summary>
|
/// Whether the bBoolErr field contains a Boolean value
|
/// </summary>
|
public bool IsBooleanValue
|
{
|
get { return fError == 0; }
|
}
|
/// <summary>
|
/// Whether the bBoolErr field contains a Error value
|
/// </summary>
|
public bool IsErrorValue
|
{
|
get { return fError == 1; }
|
}
|
/// <summary>
|
/// Get or sets the boolean value
|
/// </summary>
|
public bool BooleanValue
|
{
|
get { return bBoolErr == 1; }
|
set {
|
bBoolErr = value ? (byte)1 : (byte)0;
|
fError = 0;
|
vt = DOPERType.BooleanOrErrors;
|
}
|
}
|
/// <summary>
|
/// Get or sets the boolean value
|
/// </summary>
|
public DOPERErrorValue ErrorValue
|
{
|
get {
|
return (DOPERErrorValue)bBoolErr;
|
}
|
set {
|
bBoolErr = (byte)value;
|
fError = 1;
|
vt = DOPERType.BooleanOrErrors;
|
}
|
}
|
}
|
}
|
