using System;
|
using System.Text;
|
using HH.WMS.Utils.NPOI.Util;
|
|
namespace HH.WMS.Utils.NPOI.HSSF.Record.AutoFilter
|
{
|
public class AutoFilterRecord : StandardRecord
|
{
|
public const short sid = 0x9E;
|
private short field_1_iEntry = 0;
|
private short field_2_grbit = 0;
|
|
private static BitField wJoinFlag = BitFieldFactory.GetInstance(0x03);
|
private static BitField fSimple1Flag = BitFieldFactory.GetInstance(0x04);
|
private static BitField fSimple2Flag = BitFieldFactory.GetInstance(0x08);
|
private static BitField fTop10Flag = BitFieldFactory.GetInstance(0x10);
|
private static BitField fTopFlag = BitFieldFactory.GetInstance(0x20);
|
private static BitField fPercentFlag = BitFieldFactory.GetInstance(0x40);
|
private static BitField wTop10Flag = BitFieldFactory.GetInstance(0xFF80);
|
|
private DOPERRecord field_3_doper1;
|
private DOPERRecord field_4_doper2;
|
private string field_5_rgch1 = string.Empty;
|
private string field_6_rgch2 = string.Empty;
|
private bool rgch1_multibyte;
|
private bool rgch2_multibyte;
|
|
public AutoFilterRecord()
|
{
|
|
}
|
|
public AutoFilterRecord(RecordInputStream in1)
|
{
|
field_1_iEntry = in1.ReadShort();
|
field_2_grbit = in1.ReadShort();
|
field_3_doper1 = new DOPERRecord(in1);
|
field_4_doper2 = new DOPERRecord(in1);
|
if (field_3_doper1.DataType == DOPERType.String&&field_3_doper1.LengthOfString>0)
|
{
|
rgch1_multibyte = (in1.ReadByte() != 0);
|
if (rgch1_multibyte)
|
{
|
field_5_rgch1 = in1.ReadUnicodeLEString(field_3_doper1.LengthOfString);
|
}
|
else
|
{
|
field_5_rgch1 = in1.ReadCompressedUnicode(field_3_doper1.LengthOfString);
|
}
|
}
|
if (field_4_doper2.DataType == DOPERType.String && field_4_doper2.LengthOfString > 0)
|
{
|
rgch2_multibyte = (in1.ReadByte() != 0);
|
if (rgch2_multibyte)
|
{
|
field_6_rgch2 = in1.ReadUnicodeLEString(field_4_doper2.LengthOfString);
|
}
|
else
|
{
|
field_6_rgch2 = in1.ReadCompressedUnicode(field_4_doper2.LengthOfString);
|
}
|
}
|
}
|
|
public override short Sid
|
{
|
get { return sid; }
|
}
|
|
public short iEntry
|
{
|
get { return field_1_iEntry; }
|
set { field_1_iEntry = value; }
|
}
|
public short wJoin
|
{
|
get { return wJoinFlag.GetShortValue(field_2_grbit); }
|
set { field_2_grbit=wJoinFlag.SetShortValue(field_2_grbit, value); }
|
}
|
|
public bool IsFirstConditionSimple
|
{
|
get { return fSimple1Flag.IsSet(field_2_grbit); }
|
set { field_2_grbit = fSimple1Flag.SetShortBoolean(field_2_grbit, value); }
|
}
|
|
public bool IsSecondConditionSimple
|
{
|
get { return fSimple2Flag.IsSet(field_2_grbit); }
|
set { field_2_grbit = fSimple2Flag.SetShortBoolean(field_2_grbit, value); }
|
}
|
|
public DOPERRecord Doper1
|
{
|
get { return field_3_doper1; }
|
}
|
|
public DOPERRecord Doper2
|
{
|
get { return field_4_doper2; }
|
}
|
|
public string Doper1RGCH
|
{
|
get { return field_5_rgch1; }
|
set {
|
if (field_5_rgch1.Length > 252)
|
throw new ArgumentOutOfRangeException("The length of string must be less than or equal to 252");
|
field_5_rgch1 = value;
|
field_3_doper1.DataType = DOPERType.String;
|
field_3_doper1.LengthOfString = (byte)field_5_rgch1.Length;
|
rgch1_multibyte=StringUtil.HasMultibyte(value);
|
}
|
}
|
public string Doper2RGCH
|
{
|
get { return field_6_rgch2; }
|
set
|
{
|
if (field_6_rgch2.Length > 252)
|
throw new ArgumentOutOfRangeException("The length of string must be less than or equal to 252");
|
field_6_rgch2 = value;
|
field_4_doper2.DataType = DOPERType.String;
|
field_4_doper2.LengthOfString = (byte)field_6_rgch2.Length;
|
rgch2_multibyte = StringUtil.HasMultibyte(value);
|
}
|
}
|
protected override int DataSize
|
{
|
get
|
{
|
int recSize = 2 + 2 + 10 + 10;
|
if (field_3_doper1.LengthOfString > 0)
|
recSize += 1 + field_5_rgch1.Length;
|
|
if(field_4_doper2.LengthOfString > 0)
|
recSize += 1+ field_6_rgch2.Length;
|
return recSize;
|
}
|
}
|
|
public override int Serialize(int offset, byte[] data)
|
{
|
return base.Serialize(offset, data);
|
}
|
|
public override object Clone()
|
{
|
AutoFilterRecord rec = new AutoFilterRecord();
|
rec.field_1_iEntry = field_1_iEntry;
|
rec.field_2_grbit = field_2_grbit;
|
rec.field_3_doper1 = field_3_doper1;
|
rec.field_4_doper2 = field_4_doper2;
|
rec.field_5_rgch1 = field_5_rgch1;
|
rec.field_6_rgch2 = field_6_rgch2;
|
return rec;
|
}
|
|
public override void Serialize(ILittleEndianOutput out1)
|
{
|
out1.WriteShort(field_1_iEntry);
|
out1.WriteShort(field_2_grbit);
|
field_3_doper1.Serialize(out1);
|
field_4_doper2.Serialize(out1);
|
if (field_3_doper1.LengthOfString > 0)
|
{
|
out1.WriteByte(rgch1_multibyte?1:0);
|
if (rgch1_multibyte)
|
{
|
StringUtil.PutUnicodeLE(field_5_rgch1, out1);
|
}
|
else
|
{
|
StringUtil.PutCompressedUnicode(field_5_rgch1, out1);
|
}
|
}
|
if (field_4_doper2.LengthOfString > 0)
|
{
|
out1.WriteByte(rgch2_multibyte?1:0);
|
if (rgch2_multibyte)
|
{
|
StringUtil.PutUnicodeLE(field_6_rgch2, out1);
|
}
|
else
|
{
|
StringUtil.PutCompressedUnicode(field_6_rgch2, out1);
|
}
|
}
|
}
|
}
|
}
|
