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); }