public override int GetHashCode()
{
int hash = 1;
if (CmdCode.Length != 0)
{
hash ^= CmdCode.GetHashCode();
}
if (Identity.Length != 0)
{
hash ^= Identity.GetHashCode();
}
if (OppositeId.Length != 0)
{
hash ^= OppositeId.GetHashCode();
}
if (ServerId != 0)
{
hash ^= ServerId.GetHashCode();
}
if (LowValue != 0)
{
hash ^= LowValue.GetHashCode();
}
if (HeighValue != 0)
{
hash ^= HeighValue.GetHashCode();
}
hash ^= cellAddrs_.GetHashCode();
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public override string ToString()
{
StringBuilder sb = new StringBuilder("DecimalColumnStatsData(");
sb.Append("LowValue: ");
sb.Append(LowValue == null ? "<null>" : LowValue.ToString());
sb.Append(",HighValue: ");
sb.Append(HighValue == null ? "<null>" : HighValue.ToString());
sb.Append(",NumNulls: ");
sb.Append(NumNulls);
sb.Append(",NumDVs: ");
sb.Append(NumDVs);
sb.Append(")");
return(sb.ToString());
}
/// <summary>
/// Gets the int validator.
/// </summary>
/// <returns></returns>
public string GetIntValidator()
{
string res = "";
if (LowValue.Trim().Length > 0)
{
res += " " + Name + "< " + LowValue + " ||";
}
if (HighValue.Trim().Length > 0)
{
res += " " + Name + "> " + HighValue + " ||";
}
if (IsPrimaryKey && IsAutoIncrement == false)
{
res += " " + Name + "==0 ||";
}
return(res);
}
public void Write(TProtocol oprot)
{
TStruct struc = new TStruct("DecimalColumnStatsData");
oprot.WriteStructBegin(struc);
TField field = new TField();
if (LowValue != null && __isset.lowValue)
{
field.Name = "lowValue";
field.Type = TType.Struct;
field.ID = 1;
oprot.WriteFieldBegin(field);
LowValue.Write(oprot);
oprot.WriteFieldEnd();
}
if (HighValue != null && __isset.highValue)
{
field.Name = "highValue";
field.Type = TType.Struct;
field.ID = 2;
oprot.WriteFieldBegin(field);
HighValue.Write(oprot);
oprot.WriteFieldEnd();
}
field.Name = "numNulls";
field.Type = TType.I64;
field.ID = 3;
oprot.WriteFieldBegin(field);
oprot.WriteI64(NumNulls);
oprot.WriteFieldEnd();
field.Name = "numDVs";
field.Type = TType.I64;
field.ID = 4;
oprot.WriteFieldBegin(field);
oprot.WriteI64(NumDVs);
oprot.WriteFieldEnd();
oprot.WriteFieldStop();
oprot.WriteStructEnd();
}
private void SetErrorMsg()
{
if (LowValue.Equals(MinValue) && HighValue.Equals(MaxValue))
{
fMessage = string.Format(ObjectUtil.SysCulture, TkWebApp.RangeCBetween,
Field.DisplayName, ToString(LowValue), ToString(HighValue));
}
else if (LowValue.Equals(MinValue))
{
fMessage = string.Format(ObjectUtil.SysCulture, TkWebApp.RangeCLow,
Field.DisplayName, ToString(HighValue));
}
else if (HighValue.Equals(MaxValue))
{
fMessage = string.Format(ObjectUtil.SysCulture, TkWebApp.RangeCGreat,
Field.DisplayName, ToString(LowValue));
}
else
{
fMessage = string.Format(ObjectUtil.SysCulture, TkWebApp.RangeCBetween,
Field.DisplayName, ToString(LowValue), ToString(HighValue));
}
}
public string GenerateSql()
{
if (!this.IsValid())
{
return(String.Empty);
}
String strRst = " ";
switch (this.Operator)
{
case GeneralFilterOperatorEnum.Equal:
{
switch (this.ValueType)
{
case GeneralFilterValueEnum.Number:
strRst = FieldName + " = " + LowValue;
break;
case GeneralFilterValueEnum.Date:
strRst = FieldName + " = '" + LowValue + "' ";
break;
case GeneralFilterValueEnum.Boolean:
strRst = FieldName + " = " + (Boolean.Parse(LowValue) ? "1" : "0 ");
break;
case GeneralFilterValueEnum.String:
default:
strRst = FieldName + " = N'" + LowValue + "' ";
break;
}
}
break;
case GeneralFilterOperatorEnum.NotEqual:
{
switch (this.ValueType)
{
case GeneralFilterValueEnum.Number:
strRst = FieldName + " <> " + LowValue;
break;
case GeneralFilterValueEnum.Date:
strRst = FieldName + " <> '" + LowValue + "' ";
break;
case GeneralFilterValueEnum.Boolean:
strRst = FieldName + " <> " + (Boolean.Parse(LowValue) ? "1" : "0 ");
break;
case GeneralFilterValueEnum.String:
default:
strRst = FieldName + " <> N'" + LowValue + "' ";
break;
}
}
break;
case GeneralFilterOperatorEnum.LargerEqual:
{
switch (this.ValueType)
{
case GeneralFilterValueEnum.Number:
strRst = FieldName + " >= " + LowValue;
break;
case GeneralFilterValueEnum.Date:
strRst = FieldName + " >= '" + LowValue + "' ";
break;
case GeneralFilterValueEnum.Boolean:
throw new Exception("Unsupported operator on Boolean");
case GeneralFilterValueEnum.String:
default:
strRst = FieldName + " >= N'" + LowValue + "' ";
break;
}
}
break;
case GeneralFilterOperatorEnum.LargerThan:
{
switch (this.ValueType)
{
case GeneralFilterValueEnum.Number:
strRst = FieldName + " > " + LowValue;
break;
case GeneralFilterValueEnum.Date:
strRst = FieldName + " > '" + LowValue + "' ";
break;
case GeneralFilterValueEnum.Boolean:
throw new Exception("Unsupported operator on Boolean");
case GeneralFilterValueEnum.String:
default:
strRst = FieldName + " > N'" + LowValue + "' ";
break;
}
}
break;
case GeneralFilterOperatorEnum.LessEqual:
{
switch (this.ValueType)
{
case GeneralFilterValueEnum.Number:
strRst = FieldName + " <= " + LowValue;
break;
case GeneralFilterValueEnum.Date:
strRst = FieldName + " <= '" + LowValue + "' ";
break;
case GeneralFilterValueEnum.Boolean:
throw new Exception("Unsupported operator on Boolean");
case GeneralFilterValueEnum.String:
default:
strRst = FieldName + " <= N'" + LowValue + "' ";
break;
}
}
break;
case GeneralFilterOperatorEnum.LessThan:
{
switch (this.ValueType)
{
case GeneralFilterValueEnum.Number:
strRst = FieldName + " < " + LowValue;
break;
case GeneralFilterValueEnum.Date:
strRst = FieldName + " < '" + LowValue + "' ";
break;
case GeneralFilterValueEnum.Boolean:
throw new Exception("Unsupported operator on Boolean");
case GeneralFilterValueEnum.String:
default:
strRst = FieldName + " < N'" + LowValue + "' ";
break;
}
}
break;
case GeneralFilterOperatorEnum.Between:
{
switch (this.ValueType)
{
case GeneralFilterValueEnum.Number:
strRst = FieldName + " >= " + LowValue + " AND " + FieldName + " <= " + HighValue;
break;
case GeneralFilterValueEnum.Date:
strRst = FieldName + " >= '" + LowValue + "' AND " + FieldName + " <= '" + HighValue + "' ";
break;
case GeneralFilterValueEnum.Boolean:
throw new Exception("Unsupported operator on Boolean");
case GeneralFilterValueEnum.String:
default:
strRst = FieldName + " >= N'" + LowValue + "' AND " + FieldName + " <= N'" + HighValue + "' ";
break;
}
}
break;
case GeneralFilterOperatorEnum.Like:
{
if (ValueType == GeneralFilterValueEnum.String)
{
if (LowValue.Contains("%"))
{
strRst = FieldName + " LIKE N'" + LowValue + "' ";
}
else
{
strRst = FieldName + " LIKE N'%" + LowValue + "%' ";
}
}
}
break;
default:
break;
}
return(strRst);
}
