System.Convert.ToDateTime(object)

Here are the examples of the csharp api System.Convert.ToDateTime(object) taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

135 Examples 7

19 Source : NpcCommandHandler.cs
with GNU Lesser General Public License v3.0
from 8720826

private bool CheckField(PlayerEnreplacedy player, string field, string strValue, string strRelation)
        {
            try
            {
                var relations = GetRelations(strRelation);// 1 大于,0 等于 ,-1 小于

                var fieldProp = GetFieldPropertyInfo(player, field);
                if (fieldProp == null)
                {
                    return false;
                }

                var objectValue = fieldProp.GetValue(player);
                var typeCode = Type.GetTypeCode(fieldProp.GetType());
                switch (typeCode)
                {
                    case TypeCode.Int32:
                        return relations.Contains(Convert.ToInt32(strValue).CompareTo(Convert.ToInt32(objectValue)));

                    case TypeCode.Int64:
                        return relations.Contains(Convert.ToInt64(strValue).CompareTo(Convert.ToInt64(objectValue)));

                    case TypeCode.Decimal:
                        return relations.Contains(Convert.ToDecimal(strValue).CompareTo(Convert.ToDecimal(objectValue)));

                    case TypeCode.Double:
                        return relations.Contains(Convert.ToDouble(strValue).CompareTo(Convert.ToDouble(objectValue)));

                    case TypeCode.Boolean:
                        return relations.Contains(Convert.ToBoolean(strValue).CompareTo(Convert.ToBoolean(objectValue)));

                    case TypeCode.DateTime:
                        return relations.Contains(Convert.ToDateTime(strValue).CompareTo(Convert.ToDateTime(objectValue)));

                    case TypeCode.String:
                        return relations.Contains(strValue.CompareTo(objectValue));

                    default:
                        throw new Exception($"不支持的数据类型: {typeCode}");
                }
            }
            catch (Exception ex)
            {
                _logger.LogError($"CheckField Exception:{ex}");
                return false;
            }
        }

19 Source : HTTP.cs
with MIT License
from 944095635

private void SetRequest(HttpItem item)
        {
            // 验证证书
            SetCer(item);
            if (item.IPEndPoint != null)
            {
                _IPEndPoint = item.IPEndPoint;
                //设置本地的出口ip和端口
                request.ServicePoint.BindIPEndPointDelegate = new BindIPEndPoint(BindIPEndPointCallback);
            }
            //设置Header参数
            if (item.Header != null && item.Header.Count > 0) foreach (string key in item.Header.AllKeys)
                {
                    request.Headers.Add(key, item.Header[key]);
                }
            // 设置代理
            SetProxy(item);
            if (item.ProtocolVersion != null) request.ProtocolVersion = item.ProtocolVersion;
            request.ServicePoint.Expect100Continue = item.Expect100Continue;
            //请求方式Get或者Post
            request.Method = item.Method;
            request.Timeout = item.Timeout;
            request.KeepAlive = item.KeepAlive;
            request.ReadWriteTimeout = item.ReadWriteTimeout;
            if (!string.IsNullOrWhiteSpace(item.Host))
            {
                request.Host = item.Host;
            }
            if (item.IfModifiedSince != null) request.IfModifiedSince = Convert.ToDateTime(item.IfModifiedSince);
            //Accept
            request.Accept = item.Accept;
            //ContentType返回类型
            request.ContentType = item.ContentType;
            //UserAgent客户端的访问类型,包括浏览器版本和操作系统信息
            request.UserAgent = item.UserAgent;
            // 编码
            encoding = item.Encoding;
            //设置安全凭证
            request.Credentials = item.ICredentials;
            //设置Cookie
            SetCookie(item);
            //来源地址
            request.Referer = item.Referer;
            //是否执行跳转功能
            request.AllowAutoRedirect = item.Allowautoredirect;
            if (item.MaximumAutomaticRedirections > 0)
            {
                request.MaximumAutomaticRedirections = item.MaximumAutomaticRedirections;
            }
            //设置Post数据
            SetPostData(item);
            //设置最大连接
            if (item.Connectionlimit > 0) request.ServicePoint.ConnectionLimit = item.Connectionlimit;
        }

19 Source : DateTimePicker.xaml.cs
with MIT License
from ADeltaX

private static object CoerceDate(DependencyObject d, object value)
		{
			DateTimePicker me = (DateTimePicker)d;
			DateTime current = Convert.ToDateTime(value);
			if (current < me.MinimumDate)
				current = me.MinimumDate;
			if (current > me.MaximumDate)
				current = me.MaximumDate;
			return current;
		}

19 Source : DateTimePicker.xaml.cs
with MIT License
from ADeltaX

private static object CoerceMinDate(DependencyObject d, object value)
		{
			DateTimePicker me = (DateTimePicker)d;
			DateTime current = Convert.ToDateTime(value);
			if (current >= me.MaximumDate)
				throw new ArgumentException("MinimumDate can not be equal to, or more than maximum date");

			if (current > me.SelectedDate)
				me.SelectedDate = current;

			return current;
		}

19 Source : DateTimePicker.xaml.cs
with MIT License
from ADeltaX

private static object CoerceMaxDate(DependencyObject d, object value)
		{
			DateTimePicker me = (DateTimePicker)d;
			DateTime current = Convert.ToDateTime(value);
			if (current <= me.MinimumDate)
				throw new ArgumentException("MaximimumDate can not be equal to, or less than MinimumDate");

			if (current < me.SelectedDate)
				me.SelectedDate = current;

			return current;
		}

19 Source : EntityFormFunctions.cs
with MIT License
from Adoxio

internal static string TryConvertAttributeValueToString(OrganizationServiceContext context, Dictionary<string, AttributeTypeCode?> attributeTypeCodeDictionary, string enreplacedyName, string attributeName, object value)
		{
			if (context == null || string.IsNullOrWhiteSpace(enreplacedyName) || string.IsNullOrWhiteSpace(attributeName))
			{
				return string.Empty;
			}

			var newValue = string.Empty;
			var attributeTypeCode = attributeTypeCodeDictionary.FirstOrDefault(a => a.Key == attributeName).Value;

			if (attributeTypeCode == null)
			{
				ADXTrace.Instance.TraceError(TraceCategory.Application, "Unable to recognize the attribute specified.");
				return string.Empty;
			}

			try
			{
				switch (attributeTypeCode)
				{
					case AttributeTypeCode.BigInt:
						newValue = value == null ? string.Empty : Convert.ToInt64(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.Boolean:
						newValue = value == null ? string.Empty : Convert.ToBoolean(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.Customer:
						if (value is EnreplacedyReference)
						{
							var enreplacedyref = value as EnreplacedyReference;
							newValue = enreplacedyref.Id.ToString();
						}
						break;
					case AttributeTypeCode.DateTime:
						newValue = value == null ? string.Empty : Convert.ToDateTime(value).ToUniversalTime().ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.Decimal:
						newValue = value == null ? string.Empty : Convert.ToDecimal(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.Double:
						newValue = value == null ? string.Empty : Convert.ToDouble(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.Integer:
						newValue = value == null ? string.Empty : Convert.ToInt32(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.Lookup:
						if (value is EnreplacedyReference)
						{
							var enreplacedyref = value as EnreplacedyReference;
							newValue = enreplacedyref.Id.ToString();
						}
						break;
					case AttributeTypeCode.Memo:
						newValue = value as string;
						break;
					case AttributeTypeCode.Money:
						newValue = value == null ? string.Empty : Convert.ToDecimal(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.Picklist:
						newValue = value == null ? string.Empty : Convert.ToInt32(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.State:
						newValue = value == null ? string.Empty : Convert.ToInt32(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.Status:
						newValue = value == null ? string.Empty : Convert.ToInt32(value).ToString(CultureInfo.InvariantCulture);
						break;
					case AttributeTypeCode.String:
						newValue = value as string;
						break;
					case AttributeTypeCode.Uniqueidentifier:
						if (value is Guid)
						{
							var id = (Guid)value;
							newValue = id.ToString();
						}
						break;
					default:
						ADXTrace.Instance.TraceWarning(TraceCategory.Application, string.Format("Attribute type '{0}' is unsupported.", attributeTypeCode));
						break;
				}
			}
			catch (Exception ex)
			{
				WebEventSource.Log.GenericWarningException(ex, string.Format("Attribute specified is expecting a {0}. The value provided is not valid.", attributeTypeCode));
			}
			return newValue;
		}

19 Source : EntityFormFunctions.cs
with MIT License
from Adoxio

internal static dynamic TryConvertAttributeValue(OrganizationServiceContext context, string enreplacedyName, string attributeName, object value, Dictionary<string, AttributeTypeCode?> AttributeTypeCodeDictionary)
		{

			if (context == null || string.IsNullOrWhiteSpace(enreplacedyName) || string.IsNullOrWhiteSpace(attributeName)) return null;

			if (AttributeTypeCodeDictionary == null || !AttributeTypeCodeDictionary.Any())
			{
				AttributeTypeCodeDictionary = MetadataHelper.BuildAttributeTypeCodeDictionary(context, enreplacedyName);
			}

			object newValue = null;
			var attributeTypeCode = AttributeTypeCodeDictionary.FirstOrDefault(a => a.Key == attributeName).Value;

			if (attributeTypeCode == null)
			{
				ADXTrace.Instance.TraceError(TraceCategory.Application, string.Format("Unable to recognize the attribute '{0}' specified.", attributeName));
				return null;
			}

			try
			{
				switch (attributeTypeCode)
				{
					case AttributeTypeCode.BigInt:
						newValue = value == null ? (object)null : Convert.ToInt64(value);
						break;
					case AttributeTypeCode.Boolean:
						newValue = value == null ? (object)null : Convert.ToBoolean(value);
						break;
					case AttributeTypeCode.Customer:
						if (value is EnreplacedyReference)
						{
							newValue = value as EnreplacedyReference;
						}
						else if (value is Guid)
						{
							var metadata = MetadataHelper.GetEnreplacedyMetadata(context, enreplacedyName);
							var attribute = metadata.Attributes.FirstOrDefault(a => a.LogicalName == attributeName);
							if (attribute != null)
							{
								var lookupAttribute = attribute as LookupAttributeMetadata;
								if (lookupAttribute != null && lookupAttribute.Targets.Length == 1)
								{
									var lookupEnreplacedyType = lookupAttribute.Targets[0];
									newValue = new EnreplacedyReference(lookupEnreplacedyType, (Guid)value);
								}
							}
						}
						break;
					case AttributeTypeCode.DateTime:
						newValue = value == null ? (object)null : Convert.ToDateTime(value).ToUniversalTime();
						break;
					case AttributeTypeCode.Decimal:
						newValue = value == null ? (object)null : Convert.ToDecimal(value);
						break;
					case AttributeTypeCode.Double:
						newValue = value == null ? (object)null : Convert.ToDouble(value);
						break;
					case AttributeTypeCode.Integer:
						newValue = value == null ? (object)null : Convert.ToInt32(value);
						break;
					case AttributeTypeCode.Lookup:
						if (value is EnreplacedyReference)
						{
							newValue = value as EnreplacedyReference;
						}
						else if (value is Guid)
						{
							var metadata = MetadataHelper.GetEnreplacedyMetadata(context, enreplacedyName);
							var attribute = metadata.Attributes.FirstOrDefault(a => a.LogicalName == attributeName);
							if (attribute != null)
							{
								var lookupAttribute = attribute as LookupAttributeMetadata;
								if (lookupAttribute != null && lookupAttribute.Targets.Length == 1)
								{
									var lookupEnreplacedyType = lookupAttribute.Targets[0];
									newValue = new EnreplacedyReference(lookupEnreplacedyType, (Guid)value);
								}
							}
						}
						break;
					case AttributeTypeCode.Memo:
						newValue = value as string;
						break;
					case AttributeTypeCode.Money:
						newValue = value == null ? (object)null : Convert.ToDecimal(value);
						break;
					case AttributeTypeCode.Picklist:
						var plMetadata = MetadataHelper.GetEnreplacedyMetadata(context, enreplacedyName);
						var plAttribute = plMetadata.Attributes.FirstOrDefault(a => a.LogicalName == attributeName);
						if (plAttribute != null)
						{
							var picklistAttribute = plAttribute as PicklistAttributeMetadata;
							if (picklistAttribute != null)
							{
								int picklistInt;
								OptionMetadata picklistValue;
								if (int.TryParse(string.Empty + value, out picklistInt))
								{
									picklistValue = picklistAttribute.OptionSet.Options.FirstOrDefault(o => o.Value == picklistInt);
								}
								else
								{
									picklistValue = picklistAttribute.OptionSet.Options.FirstOrDefault(o => o.Label.GetLocalizedLabelString() == string.Empty + value);
								}

								if (picklistValue != null && picklistValue.Value.HasValue)
								{
									newValue = value == null ? null : new OptionSetValue(picklistValue.Value.Value);
								}
							}
						}
						break;
					case AttributeTypeCode.State:
						ADXTrace.Instance.TraceWarning(TraceCategory.Application, string.Format("Attribute '{0}' type '{1}' is unsupported. The state attribute is created automatically when the enreplacedy is created. The options available for this attribute are read-only.", attributeName, attributeTypeCode));
						break;
					case AttributeTypeCode.Status:
						if (value == null)
						{
							return false;
						}
						var optionSetValue = new OptionSetValue(Convert.ToInt32(value));
						newValue = optionSetValue;
						break;
					case AttributeTypeCode.String:
						newValue = value as string;
						break;
					default:
						ADXTrace.Instance.TraceWarning(TraceCategory.Application, string.Format("Attribute '{0}' type '{1}' is unsupported.", attributeName, attributeTypeCode));
						break;
				}
			}
			catch (Exception ex)
			{
				WebEventSource.Log.GenericWarningException(ex, string.Format("Attribute '{0}' specified is expecting a {1}. The value provided is not valid.", attributeName, attributeTypeCode));
			}
			return newValue;
		}

19 Source : ObjectExtensions.cs
with MIT License
from alonsoalon

public static DateTime ToDate(this object thisValue)
        {
            DateTime reval = DateTime.MinValue;
            if (thisValue != null && thisValue != DBNull.Value && DateTime.TryParse(thisValue.ToString(), out reval))
            {
                reval = Convert.ToDateTime(thisValue);
            }
            return reval;
        }

19 Source : UtilConvert.cs
with Apache License 2.0
from anjoy8

public static DateTime ObjToDate(this object thisValue)
        {
            DateTime reval = DateTime.MinValue;
            if (thisValue != null && thisValue != DBNull.Value && DateTime.TryParse(thisValue.ToString(), out reval))
            {
                reval = Convert.ToDateTime(thisValue);
            }
            return reval;
        }

19 Source : ValueMatcher.cs
with Apache License 2.0
from Appdynamics

protected virtual int CompareStringToObject(string o1, object o2)
        {
            double d1;
            if (double.TryParse(o1, out d1))
            {
                return d1.CompareTo(Convert.ToDouble(o2));
            }
            bool b1;
            if (bool.TryParse(o1, out b1))
            {
                return b1.CompareTo(Convert.ToBoolean(o2));
            }
            DateTime dt1;
            if (DateTime.TryParse(o1, out dt1))
            {
                return dt1.CompareTo(Convert.ToDateTime(o2));
            }
            return IncompatibleOperands;
        }

19 Source : DateTimeDataDefine.cs
with MIT License
from aquilahkj

public override object LoadData(DataContext context, IDataReader dataReader, object state)
        {
            var value = dataReader[0];
            if (Equals(value, DBNull.Value) || Equals(value, null))
            {
                if (!IsNullable) {
                    return _defaultValue;
                }

                return null;
            }

            if (value.GetType() != ObjectType)
            {
                return Convert.ToDateTime(value);
            }

            return value;
        }

19 Source : DateTimeDataDefine.cs
with MIT License
from aquilahkj

public override object LoadData(DataContext context, IDataReader dataReader, string name, object state)
        {
            var value = dataReader[name];
            if (Equals(value, DBNull.Value) || Equals(value, null))
            {
                if (!IsNullable) {
                    return _defaultValue;
                }

                return null;
            }
            if (value.GetType() != ObjectType)
            {
                return Convert.ToDateTime(value);
            }

            return value;
        }

19 Source : DateTimeDynamicFieldMapping.cs
with MIT License
from aquilahkj

public override object ToProperty (object value)
		{
			if (Equals (value, DBNull.Value) || Equals (value, null)) {
				return null;
			}
  
			if (value.GetType() != ObjectType)
			{
				return Convert.ToDateTime(value);
			}

			return value;
		}

19 Source : DateTimeFieldMapping.cs
with MIT License
from aquilahkj

public override object ToProperty(object value)
        {
            if (Equals(value, DBNull.Value) || Equals(value, null))
            {
                return null;
            }
            if (value.GetType() != ObjectType)
            {
                value = Convert.ToDateTime(value);
            }
            return value;
        }

19 Source : Configuration.cs
with GNU General Public License v3.0
from ASCOMInitiative

public void SetValueInvariant<T>(string KeyName, string SubKey, T Value)
        {
            if (LOG_CONFIGURATION_CALLS) ServerForm.LogMessage(0, 0, 0, "SetValue DateTime", string.Format("Setting {0} value '{1}' in subkey '{2}' to: '{3}'", typeof(T).Name, KeyName, SubKey, Value.ToString()));

            if ((typeof(T) == typeof(Int32)) | (typeof(T) == typeof(int)))
            {
                int intValue = Convert.ToInt32(Value);
                if (SubKey == "") baseRegistryKey.SetValue(KeyName, intValue.ToString(CultureInfo.InvariantCulture));
                else baseRegistryKey.CreateSubKey(SubKey).SetValue(KeyName, intValue.ToString(CultureInfo.InvariantCulture));
                return;
            }

            if (typeof(T) == typeof(bool))
            {
                bool boolValue = Convert.ToBoolean(Value);
                if (SubKey == "") baseRegistryKey.SetValue(KeyName, boolValue.ToString(CultureInfo.InvariantCulture));
                else baseRegistryKey.CreateSubKey(SubKey).SetValue(KeyName, boolValue.ToString(CultureInfo.InvariantCulture));
                return;
            }

            if (typeof(T) == typeof(decimal))
            {
                decimal decimalValue = Convert.ToDecimal(Value);
                if (SubKey == "") baseRegistryKey.SetValue(KeyName, decimalValue.ToString(CultureInfo.InvariantCulture));
                else baseRegistryKey.CreateSubKey(SubKey).SetValue(KeyName, decimalValue.ToString(CultureInfo.InvariantCulture));
                return;
            }

            if (typeof(T) == typeof(DateTime))
            {
                DateTime dateTimeValue = Convert.ToDateTime(Value);
                if (SubKey == "") baseRegistryKey.SetValue(KeyName, dateTimeValue.ToString("HH:mm:ss", CultureInfo.InvariantCulture));
                else baseRegistryKey.CreateSubKey(SubKey).SetValue(KeyName, dateTimeValue.ToString("HH:mm:ss", CultureInfo.InvariantCulture));
                return;
            }

            throw new DriverException("SetValueInvariant: Unknown type: " + typeof(T).Name);
        }

19 Source : AdapterGX.cs
with MIT License
from BigBigZBBing

internal static void EmitValue(this EmitBasic basic, Object value, Type type)
        {
            if (type == typeof(String))
            {
                basic.Emit(OpCodes.Ldstr, Convert.ToString(value));
            }
            else if (type == typeof(Boolean))
            {
                switch (Convert.ToBoolean(value))
                {
                    case true: basic.Emit(OpCodes.Ldc_I4_1); break;
                    case false: basic.Emit(OpCodes.Ldc_I4_0); break;
                    default: throw new Exception("boolean to error!");
                }
            }
            else if (type == typeof(SByte))
            {
                basic.IntegerMap(Convert.ToSByte(value));
            }
            else if (type == typeof(Byte))
            {
                basic.IntegerMap((SByte)Convert.ToByte(value));
            }
            else if (type == typeof(Int16))
            {
                basic.IntegerMap(Convert.ToInt16(value));
            }
            else if (type == typeof(UInt16))
            {
                basic.IntegerMap((Int16)Convert.ToUInt16(value));
            }
            else if (type == typeof(Int32))
            {
                basic.IntegerMap(Convert.ToInt32(value));
            }
            else if (type == typeof(UInt32))
            {
                basic.IntegerMap((Int32)Convert.ToUInt32(value));
            }
            else if (type == typeof(Int64))
            {
                basic.IntegerMap(Convert.ToInt64(value));
            }
            else if (type == typeof(UInt64))
            {
                basic.IntegerMap((Int64)Convert.ToUInt64(value));
            }
            else if (type == typeof(Single))
            {
                basic.Emit(OpCodes.Ldc_R4, Convert.ToSingle(value));
            }
            else if (type == typeof(Double))
            {
                basic.Emit(OpCodes.Ldc_R8, Convert.ToDouble(value));
            }
            else if (type == typeof(Decimal))
            {
                Int32[] bits = Decimal.GetBits(Convert.ToDecimal(value));
                basic.IntegerMap(bits[0]);
                basic.IntegerMap(bits[1]);
                basic.IntegerMap(bits[2]);
                basic.Emit((bits[3] & 0x80000000) != 0 ? OpCodes.Ldc_I4_1 : OpCodes.Ldc_I4_0);
                basic.IntegerMap((bits[3] >> 16) & 0x7f);
                basic.Emit(OpCodes.Newobj, typeof(Decimal)
                    .GetConstructor(new Type[] { typeof(Int32), typeof(Int32), typeof(Int32), typeof(Boolean), typeof(Byte) }));
            }
            else if (type == typeof(DateTime))
            {
                basic.Emit(OpCodes.Ldc_I8, Convert.ToDateTime(value).Ticks);
                basic.Emit(OpCodes.Newobj, typeof(DateTime).GetConstructor(new Type[] { typeof(Int64) }));
            }
            else
            {
                throw new Exception("not exist datatype!");
            }
        }

19 Source : AdapterGX.cs
with MIT License
from BigBigZBBing

internal static void EmitValue<T>(this EmitBasic basic, T value)
        {
            if (value == null)
            {
                basic.Emit(OpCodes.Ldnull);
            }
            else if (value.GetType() == typeof(String))
            {
                basic.Emit(OpCodes.Ldstr, Convert.ToString(value));
            }
            else if (value.GetType() == typeof(Boolean))
            {
                switch (Convert.ToBoolean(value))
                {
                    case true: basic.Emit(OpCodes.Ldc_I4_1); break;
                    case false: basic.Emit(OpCodes.Ldc_I4_0); break;
                    default: throw new Exception("boolean to error!");
                }
            }
            else if (value.GetType() == typeof(SByte))
            {
                basic.IntegerMap(Convert.ToSByte(value));
            }
            else if (value.GetType() == typeof(Byte))
            {
                basic.IntegerMap((SByte)Convert.ToByte(value));
            }
            else if (value.GetType() == typeof(Int16))
            {
                basic.IntegerMap(Convert.ToInt16(value));
            }
            else if (value.GetType() == typeof(UInt16))
            {
                basic.IntegerMap((Int16)Convert.ToUInt16(value));
            }
            else if (value.GetType() == typeof(Int32))
            {
                basic.IntegerMap(Convert.ToInt32(value));
            }
            else if (value.GetType() == typeof(UInt32))
            {
                basic.IntegerMap((Int32)Convert.ToUInt32(value));
            }
            else if (value.GetType() == typeof(Int64))
            {
                basic.IntegerMap(Convert.ToInt64(value));
            }
            else if (value.GetType() == typeof(UInt64))
            {
                basic.IntegerMap((Int64)Convert.ToUInt64(value));
            }
            else if (value.GetType() == typeof(Single))
            {
                basic.Emit(OpCodes.Ldc_R4, Convert.ToSingle(value));
            }
            else if (value.GetType() == typeof(Double))
            {
                basic.Emit(OpCodes.Ldc_R8, Convert.ToDouble(value));
            }
            else if (value.GetType() == typeof(Decimal))
            {
                Int32[] bits = Decimal.GetBits(Convert.ToDecimal(value));
                basic.IntegerMap(bits[0]);
                basic.IntegerMap(bits[1]);
                basic.IntegerMap(bits[2]);
                basic.Emit((bits[3] & 0x80000000) != 0 ? OpCodes.Ldc_I4_1 : OpCodes.Ldc_I4_0);
                basic.IntegerMap((bits[3] >> 16) & 0x7f);
                basic.Emit(OpCodes.Newobj, typeof(Decimal)
                    .GetConstructor(new Type[] { typeof(Int32), typeof(Int32), typeof(Int32), typeof(Boolean), typeof(Byte) }));
            }
            else if (value.GetType() == typeof(DateTime))
            {
                basic.Emit(OpCodes.Ldc_I8, Convert.ToDateTime(value).Ticks);
                basic.Emit(OpCodes.Newobj, typeof(DateTime).GetConstructor(new Type[] { typeof(Int64) }));
            }
            else if (value is Enum)
            {
                basic.IntegerMap(Convert.ToInt32(value));
            }
            else if (value.GetType().IsClreplaced)
            {
                basic.Emit(OpCodes.Newobj, value.GetType().GetConstructor(Type.EmptyTypes));
            }
            else
            {
                throw new Exception("not exist datatype!");
            }
        }

19 Source : CalendarEvents.cs
with MIT License
from BlazorComponent

public static CalendarEventParsed ParseEvent(Dictionary<string, object> input, int index,
            string startProperty, string endProperty, bool timed = false, StringBoolean category = default)
        {
            if (input == null || !input.Any() || !input.ContainsKey(startProperty))
                return null;

            var startInput = (StringNumberDate)Convert.ToDateTime(input[startProperty]);
            var endInput = !input.ContainsKey(endProperty) ? null : (StringNumberDate)Convert.ToDateTime(input[endProperty]);
            var startParsed = CalendarTimestampUtils.ParseTimestamp(startInput);
            var endParsed = endInput != null ? CalendarTimestampUtils.ParseTimestamp(endInput) : startParsed;
            var start = !startInput.IsT0 ? CalendarTimestampUtils.UpdateHasTime(startParsed, timed) : startParsed;
            var end = endInput != null && !endInput.IsT0 ? CalendarTimestampUtils.UpdateHasTime(endParsed, timed) : endParsed;
            var startIdentifier = CalendarTimestampUtils.GetDayIdentifier(start);
            var startTimestampIdentifier = CalendarTimestampUtils.GetTimestampIdentifier(start);
            var endIdentifier = CalendarTimestampUtils.GetDayIdentifier(end);
            var endOffset = start.HasTime ? 0 : 2359;
            var endTimestampIdentifier = CalendarTimestampUtils.GetTimestampIdentifier(end) + endOffset;
            var allDay = !start.HasTime;

            return new CalendarEventParsed
            {
                Input = input,
                Start = start,
                StartIdentifier = startIdentifier,
                StartTimestampIdentifier = startTimestampIdentifier,
                End = end,
                EndIdentifier = endIdentifier,
                EndTimestampIdentifier = endTimestampIdentifier,
                AllDay = allDay,
                Index = index,
                Category = category
            };
        }

19 Source : DonateBox.cs
with MIT License
from BluePointLilac

public void ShowDonateList(string contents)
                {
                    string[] lines = contents.Split(new[] { "\r\n", "\n" }, StringSplitOptions.RemoveEmptyEntries);
                    int index = Array.FindIndex(lines, line => line == "|:--:|:--:|:--:|:--:|:--:");
                    if(index == -1) return;
                    string[] heads = lines[index - 1].Split(new[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
                    dgvDonate.ColumnCount = heads.Length;
                    dgvDonate.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                    for(int m = 0; m < heads.Length; m++)
                    {
                        dgvDonate.Columns[m].HeaderText = heads[m];
                    }
                    for(int n = index + 1; n < lines.Length; n++)
                    {
                        string[] strs = lines[n].Split(new[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
                        object[] values = new object[strs.Length];
                        for(int k = 0; k < strs.Length; k++)
                        {
                            switch(k)
                            {
                                case 3:
                                    values[k] = Convert.ToSingle(strs[k]);
                                    break;
                                default:
                                    values[k] = strs[k];
                                    break;
                            }
                        }
                        dgvDonate.Rows.Add(values);
                    }
                    dgvDonate.Sort(dgvDonate.Columns[0], ListSortDirection.Descending);
                    DateTime date = Convert.ToDateTime(dgvDonate.Rows[0].Cells[0].Value);
                    float money = dgvDonate.Rows.Cast<DataGridViewRow>().Sum(row => (float)row.Cells[3].Value);
                    lblDonate.Text = AppString.Dialog.DonateInfo.Replace("%date", date.ToLongDateString())
                        .Replace("%money", money.ToString()).Replace("%count", dgvDonate.RowCount.ToString());
                }

19 Source : BusinessUser.cs
with MIT License
from Cankirism

private UsersProperties GetUserProperties(DirectoryEntry de)
        {
            SearchResult searchResult = user.SetSearchResult(de);
            var usersProperties = new UsersProperties();
            usersProperties.cannonicalName = de.Properties["cn"].Value.ToString();
            usersProperties.samAccountName = de.Properties["samaccountname"][0].ToString();
            usersProperties.userAccountControlCode = de.Properties["useraccountcontrol"][0].ToString();
            usersProperties.userAccountControl = UserAccountControl(Convert.ToInt32(de.Properties["useraccountcontrol"][0]));
            usersProperties.whenCreated = Convert.ToDateTime(de.Properties["whenCreated"].Value).ToLocalTime().ToString();
            usersProperties.pwdLastSet = DateTime.FromFileTime((long)searchResult.Properties["pwdLastSet"][0]).ToShortDateString();
            usersProperties.lastLogon = DateTime.FromFileTime((long)searchResult.Properties["lastLogon"][0]).ToLocalTime().ToString();
            return usersProperties;

        }

19 Source : DeviceRuner.cs
with Apache License 2.0
from cdy816

private object ConvertValue(Tagbase tag, object value)
        {
            if (value == null) return null;
            switch (tag.Type)
            {
                case TagType.Bool:
                    if (value is string)
                    {
                        var vtmp = value.ToString().ToLower();
                        if (vtmp == "true" || vtmp == "false")
                        {
                            return bool.Parse(value.ToString());
                        }
                        else
                        {
                            return Convert.ToBoolean(Convert.ToDecimal(value));
                        }
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToBoolean(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToBoolean(value);
                    }
                case TagType.Byte:
                    if (value is string)
                    {
                        return byte.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return (value as byte[])[0];
                    }
                    else
                    {
                        return Convert.ToByte(value);
                    }
                case TagType.DateTime:
                    if (value is string)
                    {
                        return DateTime.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return Convert.ToDateTime(BitConverter.ToInt64(value as byte[]));
                    }
                    else
                    {
                        return Convert.ToDateTime(value);
                    }
                case TagType.Double:
                    if (value is string)
                    {
                        return double.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToDouble(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToDouble(value);
                    }
                case TagType.Float:
                    if (value is string)
                    {
                        return float.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToSingle(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToSingle(value);
                    }
                case TagType.Int:
                    if (value is string)
                    {
                        return int.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToInt32(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToInt32(value);
                    }
                case TagType.Long:
                    if (value is string)
                    {
                        return long.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToInt64(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToInt64(value);
                    }
                case TagType.Short:
                    if (value is string)
                    {
                        return short.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToInt16(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToInt16(value);
                    }
                case TagType.String:
                    if (value is byte[])
                    {
                        return Encoding.UTF8.GetString(value as byte[]);
                    }
                    else
                    {
                        return value.ToString();
                    }

                case TagType.UInt:
                    if (value is string)
                    {
                        return uint.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToUInt32(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToUInt32(value);
                    }
                case TagType.ULong:
                    if (value is string)
                    {
                        return ulong.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToUInt64(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToUInt64(value);
                    }
                case TagType.UShort:
                    if (value is string)
                    {
                        return ushort.Parse(value.ToString());
                    }
                    else if (value is byte[])
                    {
                        return BitConverter.ToUInt16(value as byte[]);
                    }
                    else
                    {
                        return Convert.ToUInt16(value);
                    }
                case TagType.IntPoint:
                    if (value is string)
                    {
                        string[] sval = value.ToString().Split(new char[] { ',' });
                        return new IntPoint() { X = int.Parse(sval[0]), Y = int.Parse(sval[1]) };
                    }
                    else if (value is byte[])
                    {
                        byte[] bval = value as byte[];
                        return new IntPoint() { X = BitConverter.ToInt32(bval.replacedpan(0, 4)), Y = BitConverter.ToInt32(bval.replacedpan(4, 4)) };
                    }
                    else
                    {
                        return (IntPoint)value;
                    }
                case TagType.IntPoint3:
                    if (value is string)
                    {
                        string[] sval = value.ToString().Split(new char[] { ',' });
                        return new IntPoint3() { X = int.Parse(sval[0]), Y = int.Parse(sval[1]), Z = int.Parse(sval[2]) };
                    }
                    else if (value is byte[])
                    {
                        byte[] bval = value as byte[];
                        return new IntPoint3() { X = BitConverter.ToInt32(bval.replacedpan(0, 4)), Y = BitConverter.ToInt32(bval.replacedpan(4, 4)), Z = BitConverter.ToInt32(bval.replacedpan(8, 4)) };
                    }
                    else
                    {
                        return (IntPoint3)value;
                    }
                case TagType.UIntPoint:
                    if (value is string)
                    {
                        string[] sval = value.ToString().Split(new char[] { ',' });
                        return new UIntPoint() { X = uint.Parse(sval[0]), Y = uint.Parse(sval[1]) };
                    }
                    else if (value is byte[])
                    {
                        byte[] bval = value as byte[];
                        return new UIntPoint() { X = BitConverter.ToUInt32(bval.replacedpan(0, 4)), Y = BitConverter.ToUInt32(bval.replacedpan(4, 4)) };
                    }
                    else
                    {
                        return (UIntPoint)value;
                    }
                case TagType.UIntPoint3:
                    if (value is string)
                    {
                        string[] sval = value.ToString().Split(new char[] { ',' });
                        return new UIntPoint3() { X = uint.Parse(sval[0]), Y = uint.Parse(sval[1]), Z = uint.Parse(sval[2]) };
                    }
                    else if (value is byte[])
                    {
                        byte[] bval = value as byte[];
                        return new UIntPoint3() { X = BitConverter.ToUInt32(bval.replacedpan(0, 4)), Y = BitConverter.ToUInt32(bval.replacedpan(4, 4)), Z = BitConverter.ToUInt32(bval.replacedpan(8, 4)) };
                    }
                    else
                    {
                        return (UIntPoint3)value;
                    }
                case TagType.LongPoint:
                    if (value is string)
                    {
                        string[] sval = value.ToString().Split(new char[] { ',' });
                        return new LongPoint() { X = long.Parse(sval[0]), Y = long.Parse(sval[1]) };
                    }
                    else if (value is byte[])
                    {
                        byte[] bval = value as byte[];
                        return new LongPoint() { X = BitConverter.ToInt64(bval.replacedpan(0, 8)), Y = BitConverter.ToInt64(bval.replacedpan(8, 8)) };
                    }
                    else
                    {
                        return (LongPoint)value;
                    }
                case TagType.LongPoint3:
                    if (value is string)
                    {
                        string[] sval = value.ToString().Split(new char[] { ',' });
                        return new LongPoint3() { X = long.Parse(sval[0]), Y = long.Parse(sval[1]), Z = long.Parse(sval[2]) };
                    }
                    else if (value is byte[])
                    {
                        byte[] bval = value as byte[];
                        return new LongPoint3() { X = BitConverter.ToInt64(bval.replacedpan(0, 8)), Y = BitConverter.ToInt64(bval.replacedpan(8, 8)), Z = BitConverter.ToInt64(bval.replacedpan(16, 8)) };
                    }
                    else
                    {
                        return (LongPoint3)value;
                    }
                case TagType.ULongPoint:
                    if (value is string)
                    {
                        string[] sval = value.ToString().Split(new char[] { ',' });
                        return new ULongPoint() { X = ulong.Parse(sval[0]), Y = ulong.Parse(sval[1]) };
                    }
                    else if (value is byte[])
                    {
                        byte[] bval = value as byte[];
                        return new ULongPoint() { X = BitConverter.ToUInt64(bval.replacedpan(0, 8)), Y = BitConverter.ToUInt64(bval.replacedpan(8, 8)) };
                    }
                    else
                    {
                        return (ULongPoint)value;
                    }
                case TagType.ULongPoint3:
                    if (value is string)
                    {
                        string[] sval = value.ToString().Split(new char[] { ',' });
                        return new ULongPoint3() { X = ulong.Parse(sval[0]), Y = ulong.Parse(sval[1]), Z = ulong.Parse(sval[2]) };
                    }
                    else if (value is byte[])
                    {
                        byte[] bval = value as byte[];
                        return new ULongPoint3() { X = BitConverter.ToUInt64(bval.replacedpan(0, 8)), Y = BitConverter.ToUInt64(bval.replacedpan(8, 8)), Z = BitConverter.ToUInt64(bval.replacedpan(16, 8)) };
                    }
                    else
                    {
                        return (ULongPoint3)value;
                    }
            }
            return null;
        }

19 Source : ModbusIpDriver.cs
with Apache License 2.0
from cdy816

private ushort[] GetValue(object value, byte valueType, ushort size)
        {

            TagType tp = (TagType)valueType;
            switch (tp)
            {
                case TagType.Bool:
                case TagType.Byte:
                    return new ushort[] { Convert.ToByte(value) };
                case TagType.Short:
                case TagType.UShort:
                    return new ushort[] { Convert.ToUInt16(value) };
                case TagType.Int:
                case TagType.UInt:
                    if (size == 1)
                    {
                        return new ushort[] { Convert.ToUInt16(value) };
                    }
                    else
                    {
                        return IntToByte(Convert.ToInt32(value));
                    }
                case TagType.Long:
                case TagType.ULong:
                    if (size == 1)
                    {
                        return new ushort[] { Convert.ToUInt16(value) };
                    }
                    else if (size == 2)
                    {
                        return IntToByte(Convert.ToInt32(value));
                    }
                    else if (size == 3)
                    {
                        return LongToByte(Convert.ToInt64(value)).Take(3).ToArray();
                    }
                    else
                    {
                        return LongToByte(Convert.ToInt64(value));
                    }
                case TagType.DateTime:
                    if (size != 4)
                    {
                        return LongToByte(Convert.ToDateTime(value).ToBinary()).Take(size).ToArray();
                    }
                    else
                    {
                        return LongToByte(Convert.ToDateTime(value).ToBinary());
                    }
                case TagType.Double:
                    if (size == 1)
                    {
                        return new ushort[] { Convert.ToUInt16(value) };
                    }
                    else if (size == 2)
                    {
                        return FloatToByte(Convert.ToSingle(value));
                    }
                    else if (size == 3)
                    {
                        return DoubleToByte(Convert.ToDouble(value)).Take(3).ToArray();
                    }
                    else
                    {
                        return DoubleToByte(Convert.ToDouble(value));
                    }

                case TagType.Float:
                    if (size == 1)
                    {
                        return new ushort[] { Convert.ToUInt16(value) };
                    }
                    else
                    {
                        return FloatToByte(Convert.ToSingle(value));
                    }
                case TagType.String:
                    if (mData.StringEncoding == StringEncoding.Ascii)
                    {
                        return BytesToHostUInt16(Encoding.ASCII.GetBytes(value.ToString()));
                    }
                    else if (mData.StringEncoding == StringEncoding.Utf8)
                    {
                        return BytesToHostUInt16(Encoding.UTF8.GetBytes(value.ToString()));
                    }
                    else
                    {
                        return BytesToHostUInt16(Encoding.Unicode.GetBytes(value.ToString()));
                    }
            }

            return null;
        }

19 Source : ModbusSeriseDriver.cs
with Apache License 2.0
from cdy816

private ushort[] GetValue(object value, byte valueType,ushort size)
        {

            TagType tp = (TagType)valueType;
            switch (tp)
            {
                case TagType.Bool:
                case TagType.Byte:
                    return new ushort[] { Convert.ToByte(value) };
                case TagType.Short:
                case TagType.UShort:
                    return new ushort[] { Convert.ToUInt16(value) };
                case TagType.Int:
                case TagType.UInt:
                    if (size == 1)
                    {
                        return new ushort[] { Convert.ToUInt16(value) };
                    }
                    else
                    {
                        return IntToByte(Convert.ToInt32(value));
                    }
                case TagType.Long:
                case TagType.ULong:
                    if (size == 1)
                    {
                        return new ushort[] { Convert.ToUInt16(value) };
                    }
                    else if (size == 2)
                    {
                        return IntToByte(Convert.ToInt32(value));
                    }
                    else if (size == 3)
                    {
                        return LongToByte(Convert.ToInt64(value)).Take(3).ToArray();
                    }
                    else
                    {
                        return LongToByte(Convert.ToInt64(value));
                    }
                case TagType.DateTime:
                    if (size != 4)
                    {
                        return LongToByte(Convert.ToDateTime(value).ToBinary()).Take(size).ToArray();
                    }
                    else
                    {
                        return LongToByte(Convert.ToDateTime(value).ToBinary());
                    }
                case TagType.Double:
                    if (size == 1)
                    {
                        return new ushort[] { Convert.ToUInt16(value) };
                    }
                    else if(size==2)
                    {
                        return FloatToByte(Convert.ToSingle(value));
                    }
                    else if(size==3)
                    {
                        return DoubleToByte(Convert.ToDouble(value)).Take(3).ToArray();
                    }
                    else 
                    {
                        return DoubleToByte(Convert.ToDouble(value));
                    }
                    
                case TagType.Float:
                    if (size == 1)
                    {
                        return new ushort[] { Convert.ToUInt16(value) };
                    }
                    else
                    {
                        return FloatToByte(Convert.ToSingle(value));
                    }
                case TagType.String:
                    if (mData.StringEncoding == StringEncoding.Ascii)
                    {
                        return BytesToHostUInt16(Encoding.ASCII.GetBytes(value.ToString()));
                    }
                    else if (mData.StringEncoding == StringEncoding.Utf8)
                    {
                        return BytesToHostUInt16(Encoding.UTF8.GetBytes(value.ToString()));
                    }
                    else
                    {
                        return BytesToHostUInt16(Encoding.Unicode.GetBytes(value.ToString()));
                    }
            }

            return null;
        }

19 Source : OpcUaChannel.cs
with Apache License 2.0
from cdy816

private object ConvertValue(string key,object value)
        {
            if(mSubscription.ContainsKey(key))
            {
                string sdtype = mSubscription[key].ToLower();
                switch (sdtype)
                {
                    case "boolean":
                        return Convert.ToBoolean(value);
                    case "byte":
                        return Convert.ToByte(value);
                    case "int16":
                        return Convert.ToInt16(value);
                    case "uint16":
                        return Convert.ToUInt16(value);
                    case "int32":
                        return Convert.ToInt32(value);
                    case "uint32":
                        return Convert.ToUInt32(value);
                    case "int64":
                        return Convert.ToInt64(value);
                    case "uint64":
                        return Convert.ToUInt64(value);
                    case "float":
                        return Convert.ToSingle(value);
                    case "double":
                        return Convert.ToDouble(value);
                    case "string":
                        return value.ToString();
                    case "datetime":
                        return Convert.ToDateTime(value);
                }

            }
            return value;
        }

19 Source : WorkflowController.cs
with GNU General Public License v3.0
from chenyinxin

public ActionResult GetHistory(Guid? taskUserId)
        {
            try
            {
                string strSql = @"declare @BillId nvarchar(50)
                                select @BillId=t2.BillsId from FlowBillsRecordUser t1
                                left join FlowBillsRecord t2 on t1.BillsRecordId=t2.Id
                                where t1.Id=@taskUserId

                                select t4.stepName,t5.userName,t5.userCode,t3.choice,t3.Opinion as 'description',t3.state,t3.startTime,t3.endTime
                                from FlowBills as t1
                                left join FlowBillsRecord as t2 on t1.Id=t2.BillsId
                                left join FlowBillsRecordUser as t3 on t2.Id=t3.BillsRecordId
                                left join FlowStep as t4 on t2.NextStepId=t4.StepId
                                left join SysUser as t5 on t3.userId=t5.UserID
                                where t1.Id=@BillId
                                order by isnull(t3.startTime,t2.endTime) asc";
                var dt = SqlHelper.Query(strSql, new SqlParameter("@taskUserId", taskUserId)).Tables[0];

                dt.Columns.Add("Timespace");
                foreach(DataRow dr in dt.Rows)
                {
                    if (dr["startTime"] == DBNull.Value || dr["endTime"] == DBNull.Value)
                        continue;

                    var ts = Convert.ToDateTime(dr["endTime"]) - Convert.ToDateTime(dr["startTime"]);
                    dr["Timespace"] = string.Format("{0}:{1:00}:{2:00}", ts.Hours, ts.Minutes, ts.Seconds);
                }

                return Json(new { Code = 0, Total = 0, Data = QuerySuite.ToDictionary(dt) });
            }
            catch (Exception ex)
            {
                LogHelper.SaveLog(ex);
                return Json(new { Code = 1, Msg = "服务器异常,请联系管理员!" });
            }
        }

19 Source : BasicDataConversion.cs
with MIT License
from chinabeacon

public static string NullableDateTimeToShortDateString(this DateTime? datetime)
        {
            if (datetime == null) return string.Empty;
            return Convert.ToDateTime(datetime).ToShortDateString();
        }

19 Source : SqlTableDependencyFilter.cs
with MIT License
from christiandelbianco

private string ToSqlFormat(Type type, object value)
        {
            if (type == typeof(bool)) return (bool)value ? "1" : "0";

            if (type == typeof(string)) return value.ToString();

            if (type == typeof(decimal)) return Convert.ToDecimal(value).ToString("g", CultureInfo.InvariantCulture);

            if (type == typeof(double)) return Convert.ToDouble(value).ToString("g", CultureInfo.InvariantCulture);

            if (type == typeof(DateTime)) return Convert.ToDateTime(value).ToString("s", CultureInfo.InvariantCulture);

            return value.ToString();
        }

19 Source : OdptXmplPackage.cs
with GNU General Public License v3.0
from ClayLipscomb

public IList<TypeITTableBigPartial> ReadResulreplacedTableBigPartial<TypeITTableBigPartial>(OracleDataReader rdr, UInt32? optionalMaxNumberRowsToReadFromAnyCursor = null)
                where TypeITTableBigPartial : clreplaced, ITTableBigPartial, new() {
            IList<TypeITTableBigPartial> __ret = new List<TypeITTableBigPartial>();
            if (rdr != null && rdr.HasRows) {
                while (rdr.Read()) {
                    TypeITTableBigPartial obj = new TypeITTableBigPartial();
                    if (!rdr.IsDBNull(0)) obj.Id = Convert.ToInt64(rdr.GetValue(0));
                    if (!rdr.IsDBNull(1)) obj.ColInteger = Convert.ToInt64(rdr.GetValue(1));
                    if (!rdr.IsDBNull(2)) obj.ColNumber = (Decimal?)OracleDecimal.SetPrecision(rdr.GetOracleDecimal(2), 28);
                    if (!rdr.IsDBNull(3)) obj.ColVarchar2Max = Convert.ToString(rdr.GetValue(3));
                    if (!rdr.IsDBNull(4)) obj.ColDate = Convert.ToDateTime(rdr.GetValue(4));
                    if (!rdr.IsDBNull(5)) obj.ColTimestamp = (OracleTimeStamp?)rdr.GetOracleValue(5);
                    __ret.Add(obj);
                    if (optionalMaxNumberRowsToReadFromAnyCursor != null && __ret.Count >= optionalMaxNumberRowsToReadFromAnyCursor) break;
                }
            }
            return __ret;
        }

19 Source : ConvertObject.cs
with Apache License 2.0
from CoreUnion

public static object GetDataByType(object data1, Type itype, params object[] myparams)
        {
            object result = new object();
            try
            {
                if (itype == typeof(decimal))
                {
                    result = Convert.ToDecimal(data1);
                    if (myparams.Length > 0)
                    {
                        result = Convert.ToDecimal(Math.Round(Convert.ToDecimal(data1), Convert.ToInt32(myparams[0])));
                    }
                }
                else if (itype == typeof(double))
                {

                    if (myparams.Length > 0)
                    {
                        result = Convert.ToDouble(Math.Round(Convert.ToDouble(data1), Convert.ToInt32(myparams[0])));
                    }
                    else
                    {
                        result = double.Parse(Convert.ToDecimal(data1).ToString("0.00"));
                    }
                }
                else if (itype == typeof(Int32))
                {
                    result = Convert.ToInt32(data1);
                }
                else if (itype == typeof(DateTime))
                {
                    result = Convert.ToDateTime(data1);
                }
                else if (itype == typeof(Guid))
                {
                    result = new Guid(data1.ToString());
                }
                else if (itype == typeof(string))
                {
                    result = data1.ToString();
                }
            }
            catch
            {
                if (itype == typeof(decimal))
                {
                    result = 0;
                }
                else if (itype == typeof(double))
                {
                    result = 0;
                }
                else if (itype == typeof(Int32))
                {
                    result = 0;
                }
                else if (itype == typeof(DateTime))
                {
                    result = null;
                }
                else if (itype == typeof(Guid))
                {
                    result = Guid.Empty;
                }
                else if (itype == typeof(string))
                {
                    result = "";
                }
            }
            return result;
        }

19 Source : ObjectExtensions.cs
with Apache License 2.0
from CoreUnion

public static DateTime ObjectToDate(this object thisValue)
        {
            DateTime result = DateTime.MinValue;
            if (thisValue != null && thisValue != DBNull.Value && DateTime.TryParse(thisValue.ToString(), out result))
                result = Convert.ToDateTime(thisValue);
            return result;
        }

19 Source : DoubleUtil.cs
with GNU Lesser General Public License v3.0
from czsgeo

public static void AutoSetKeyToDouble<TKey>(out Func<TKey, double> KeyToDouble)
        {
            KeyToDouble = null;

            var typeOfKey = typeof(TKey);

            //KeyToDouble = new Func<TKey, double>(key => Convert.ToDouble(key));

            if (typeOfKey == typeof(int))
            {
                KeyToDouble = new Func<TKey, double>(key => Convert.ToInt32(key));
            }
            if (typeOfKey == typeof(double))
            {
                KeyToDouble = new Func<TKey, double>(key => Convert.ToDouble(key));
            }
            if (typeOfKey == typeof(long))
            {
                KeyToDouble = new Func<TKey, double>(key => Convert.ToInt64(key));
            }
            if (typeOfKey == typeof(float))
            {
                KeyToDouble = new Func<TKey, double>(key => Convert.ToSingle(key));
            }
            if (typeOfKey == typeof(DateTime))
            {
                //KeyToDouble = new Func<TKey, double>(key => (Convert.ToDateTime(key) - Convert.ToDateTime(FirstKey)).TotalSeconds);
                KeyToDouble = new Func<TKey, double>(key => (Convert.ToDateTime(key).TimeOfDay).TotalSeconds);
            }
            if (typeOfKey == typeof(Time))
            {
                //KeyToDouble = new Func<TKey, double>(key => (Time.Parse(key) - Time.Parse(FirstKey)));
                KeyToDouble = new Func<TKey, double>(key => (Time.Parse(key).SecondsOfWeek));
            }
            if (typeOfKey == typeof(RmsedNumeral))
            {
                //KeyToDouble = new Func<TKey, double>(key => (Convert.ToDateTime(key) - Convert.ToDateTime(FirstKey)).TotalSeconds);
                KeyToDouble = new Func<TKey, double>(key => ((key as RmsedNumeral).Value));
            }
        }

19 Source : DoubleUtil.cs
with GNU Lesser General Public License v3.0
from czsgeo

public static void AutoSetKeyToDouble<TKey>(out Func<TKey, double> KeyToDouble, TKey firstKey)
        {
            KeyToDouble = null;

            var typeOfKey = typeof(TKey);
            //KeyToDouble = new Func<TKey, double>(key => Convert.ToDouble(key));
            if (typeOfKey == typeof(int))
            {
                KeyToDouble = new Func<TKey, double>(key => Convert.ToInt32(key));
            }
            if (typeOfKey == typeof(double))
            {
                KeyToDouble = new Func<TKey, double>(key => Convert.ToDouble(key));
            }
            if (typeOfKey == typeof(long))
            {
                KeyToDouble = new Func<TKey, double>(key => Convert.ToInt64(key));
            }
            if (typeOfKey == typeof(float))
            {
                KeyToDouble = new Func<TKey, double>(key => Convert.ToSingle(key));
            }
            if (typeOfKey == typeof(DateTime))
            {
                //KeyToDouble = new Func<TKey, double>(key => (Convert.ToDateTime(key) - Convert.ToDateTime(FirstKey)).TotalSeconds);
                KeyToDouble = new Func<TKey, double>(key => (Convert.ToDateTime(key) - Convert.ToDateTime(firstKey)).TotalSeconds);
            }
            if (typeOfKey == typeof(Time))
            {
                //KeyToDouble = new Func<TKey, double>(key => (Time.Parse(key) - Time.Parse(FirstKey)));
                KeyToDouble = new Func<TKey, double>(key => (Time.Parse(key) - Time.Parse(firstKey)));
            }

            //try
            //{
            //    KeyToDouble = new Func<TKey, double>(key => Convert.ToDouble(key));
            //}catch(Exception ex)
            //{
            //    log.Warn("Key 转换失败!" + ex.Message);
            //}
        }

19 Source : DateTimePicker.cs
with Mozilla Public License 2.0
from daixin10310

private void Ct_SelectedChanged(object sender, RoutedEventArgs e)
        {
            SelectedDateTime = Convert.ToDateTime(e.OriginalSource);
        }

19 Source : EpochDateConverter.cs
with MIT License
from daltskin

public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
        {
            if ((DateTime)value != _epoch)
            {
                writer.WriteRawValue(Convert.ToDateTime(value).ToUniversalTime().ToString());
            }
            else
            {
                writer.WriteNull();
            }
        }

19 Source : HttpParameterFormatter.cs
with MIT License
from DarkWanderer

internal static string Format(ClickHouseType type, object value)
        {
            switch (type)
            {
                case NothingType nt:
                    return NullValueString;
                case IntegerType it:
                case FloatType ft:
                    return Convert.ToString(value, CultureInfo.InvariantCulture);
                case DecimalType dt:
                    return Convert.ToDecimal(value).ToString(CultureInfo.InvariantCulture);

                case DateType dt when value is DateTimeOffset @do:
                    return @do.Date.ToString("yyyy-MM-dd");
                case DateType dt:
                    return Convert.ToDateTime(value).ToString("yyyy-MM-dd");

                case StringType st:
                case FixedStringType tt:
                case Enum8Type e8t:
                case Enum16Type e16t:
                case IPv4Type ip4:
                case IPv6Type ip6:
                case UuidType uuidType:
                    return value.ToString();

                case LowCardinalityType lt:
                    return Format(lt.UnderlyingType, value);

                case DateTimeType dtt when value is DateTime dt:
                    return dt.ToString("s", CultureInfo.InvariantCulture);

                case DateTimeType dtt when value is DateTimeOffset dto:
                    return dto.ToString("s", CultureInfo.InvariantCulture);

                case DateTime64Type dtt when value is DateTime dtv:
                    return $"{dtv:yyyy-MM-dd HH:mm:ss.fffffff}";

                case DateTime64Type dtt when value is DateTimeOffset dto:
                    return $"{dto:yyyy-MM-dd HH:mm:ss.fffffff}";

                case NullableType nt:
                    return value is null || value is DBNull ? NullValueString : $"{Format(nt.UnderlyingType, value)}";

                case ArrayType arrayType when value is IEnumerable enumerable:
                    return $"[{string.Join(",", enumerable.Cast<object>().Select(obj => InlineParameterFormatter.Format(arrayType.UnderlyingType, obj)))}]";

                case TupleType tupleType when value is ITuple tuple:
                    return $"({string.Join(",", tupleType.UnderlyingTypes.Select((x, i) => InlineParameterFormatter.Format(x, tuple[i])))})";

                case MapType mapType when value is IDictionary dict:
                    var strings = string.Join(",", dict.Keys.Cast<object>().Select(k => $"{InlineParameterFormatter.Format(mapType.KeyType, k)} : {InlineParameterFormatter.Format(mapType.ValueType, dict[k])}"));
                    return $"{{{string.Join(",", strings)}}}";

                default:
                    throw new Exception($"Cannot convert {value} to {type}");
            }
        }

19 Source : HibernatetItemsStorage.cs
with MIT License
from DevExpress

public HibernatedItem GereplacedemByWorkSessionId(Guid workSessionId) {
            HibernatedItem item = null;
            using(SqlConnection connection = new SqlConnection(settings.ConnectionString)) {
                string commandText = "SELECT [#WorkSessionId#], [#DoreplacedentId#], [#HibernationTime#], [#Header#], [#Content#] FROM [#TableName#] WHERE [#WorkSessionId#] = @WorkSessionId";
                commandText = HibernationTableQueryHelper.PatchSQLCommandText(commandText, settings);
                SqlCommand command = new SqlCommand(commandText, connection);
                command.Parameters.Add(new SqlParameter("WorkSessionId", workSessionId));
                connection.Open();
                using(SqlDataReader reader = command.ExecuteReader()) {
                    if(reader.Read()) {
                        item = new HibernatedItem(workSessionId);
                        item.DoreplacedentId = (string)reader[settings.ColumnNames.DoreplacedentId];
                        item.HibernationTime = Convert.ToDateTime(reader[settings.ColumnNames.HibernationTime]);
                        item.Header = (byte[])reader[settings.ColumnNames.Header];
                        item.Content = (byte[])reader[settings.ColumnNames.Content];
                    }
                    connection.Close();
                }
            }
            return item;
        }

19 Source : BasicConvert.Overload.cs
with MIT License
from Dogwei

DateTime IXConverter<object, DateTime>.Convert(object value)
			=> Convert.ToDateTime(value);

19 Source : ValueInterfaceFormatterConverter.cs
with MIT License
from Dogwei

public DateTime ToDateTime(object value)
            => SystemConvert.ToDateTime(value);

19 Source : DbDataReaderReader.cs
with MIT License
from Dogwei

public DateTime ReadDateTime() => Convert.ToDateTime(DirectRead());

19 Source : BaseDirectRW.cs
with MIT License
from Dogwei

public DateTime ReadDateTime()
        {
            return Convert.ToDateTime(DirectRead());
        }

19 Source : NorthwindDb.cs
with MIT License
from dotnet-presentations

public static string GetData()
        {
            string result = "";
            DataSet dataSet = new DataSet();
            dataSet.ReadXml("northwind.xml");

            DataTable employeeTable = dataSet.Tables["Employees"];

            foreach (DataRow row in employeeTable.Rows)
            {
                string firstName = Convert.ToString(row["FirstName"]);
                string lastName = Convert.ToString(row["LastName"]);
                DateTime birthdate = Convert.ToDateTime(row["Birthdate"]);
                DateTime retirementDate = birthdate.AddYears(65);

                var isRetired = retirementDate < DateTime.Now;
                if (!isRetired)
                    continue;

                result += $"{firstName} {lastName}: {retirementDate}\r\n";
            }

            return result;
        }

19 Source : SvrCamera.cs
with BSD 2-Clause "Simplified" License
from double-hi

public void Load(System.Data.DataRow row)
        {

            _id = row["ID"] != null ? new Guid(row["ID"] as string) : System.Guid.NewGuid();
            _channelGuid = row["ChannelGuid"] != null ? Convert.ToInt32(row["ChannelGuid"]) : 0;
            _channelID = row["ChannelID"] as string;
            _gbID = row["GBDevID"] as string;
            _name = row["Name"] as string;
            _deviceID = row["DeviceID"] as string;
            _videoStatus = row["VideoStatus"] != null ? Convert.ToInt32(row["VideoStatus"]) : 0;
            _recordStatus = row["RecordStatus"] != null ? Convert.ToInt32(row["RecordStatus"]) : 0;
            _audioFormat = row["AudioFormat"] as string;
            _videoFormat = row["VideoFormat"] as string;
            _rtspURIFirst = row["RTSP1"] as string;
            _rtspURISecond = row["RTSP2"] as string;
            _realStreamType = row["RealStreamType"] != null ? Convert.ToInt32(row["RealStreamType"]) : 0;
            _longitude = row["Longitude"] as string;
            _lareplacedude = row["Lareplacedude"] as string;
            _address = row["Address"] as string;
            _status = row["Status"] != null ? Convert.ToInt32(row["Status"]) : 0;
            _EndTime = row["EndTime"] != DBNull.Value ? Convert.ToDateTime(row["EndTime"]) : DateTime.Now;
            _createTime = row["CreateTime"] != DBNull.Value ? Convert.ToDateTime(row["CreateTime"]) : DateTime.Now;
            _updateTime = row["UpdateTime"] != DBNull.Value ? Convert.ToDateTime(row["UpdateTime"]) : DateTime.Now;
        }

19 Source : SvrDevice.cs
with BSD 2-Clause "Simplified" License
from double-hi

public void Load(System.Data.DataRow row)
        {
            try
            {
                _id = row["ID"] != null ? new Guid(row["ID"] as string) : Guid.NewGuid();
                _deviceID = row["DeviceID"] as string;
                _name = row["Name"] as string;
                _manufacture = row["Manufacture"] as string;
                _devType = row["DevType"] as string;
                _model = row["Model"] as string;
                _owner = row["Owner"] as string;
                _cvilCode = row["CvilCode"] != null ? Convert.ToInt32(row["CvilCode"]) : 0;
                _platformId = row["PlatformId"] as string;
                _ip = row["IP"] as string;
                _port = row["Port"] != null ? Convert.ToInt32(row["Port"]) : 0;
                _userName = row["UserName"] as string;
                _preplacedword = row["Preplacedword"] as string;
                _onvifAddress = row["ONVIFAddress"] as string;
                _onvifVersion = row["ONVIFVersion"] as string;
                _isreplacedyzer = row["Isreplacedyzer"] != null ? Convert.ToInt32(row["Isreplacedyzer"]) : 0;
                _isBackRecord = row["IsBackRecord"] != null ? Convert.ToInt32(row["IsBackRecord"]) : 0;
                _localIP = row["LocalIP"] as string;
                _localPort = row["LocalPort"] != null ? Convert.ToInt32(row["LocalPort"]) : 5060;
                _localID = row["LocalID"] as string;
                _macAddress = row["MacAddress"] as string;
                _firmware = row["Firmware"] as string;
                _channelNum = row["ChannelNum"] != null ? Convert.ToInt32(row["ChannelNum"]) : 1;
                _status = row["Status"] != null ? Convert.ToInt32(row["Status"]) : 0;
                _reason = row["Reason"] as string;
                _deviceTime = row["DeviceTime"] != DBNull.Value ? Convert.ToDateTime(row["DeviceTime"]) : DateTime.Now;
                _parental = row["Parental"] != null ? Convert.ToInt32(row["Parental"]) : 0;
                _parentID = row["ParentID"] != null ? Convert.ToInt32(row["ParentID"]) : 0;
                _address = row["Address"] as string;
                _block = row["Block"] != null ? Convert.ToInt32(row["Block"]) : 0;
                _registerWay = row["RegisterWay"] != null ? Convert.ToInt32(row["RegisterWay"]) : 0;
                _secrecy = row["Secrecy"] != null ? Convert.ToInt32(row["Secrecy"]) : 0;
                _endTime = row["EndTime"] != DBNull.Value ? Convert.ToDateTime(row["EndTime"]) : DateTime.Now;
                _errCode = row["ErrCode"] != null ? Convert.ToInt32(row["ErrCode"]) : 0;
                _certifiable = row["Certifiable"] != null ? Convert.ToInt32(row["Certifiable"]) : 0;
                _certNum = row["CertNum"] != null ? Convert.ToInt32(row["CertNum"]) : 0;
                _uri = row["URI"] as string;
                _webPort = row["WebPort"] != null ? Convert.ToInt32(row["WebPort"]) : 0;
                _lareplacedude = row["Lareplacedude"] as string;
                _longitude = row["Longitude"] as string;
                _createTime = row["CreateTime"] != DBNull.Value ? Convert.ToDateTime(row["CreateTime"]) : DateTime.Now;
                _updateTime = row["UpdateTime"] != DBNull.Value ? Convert.ToDateTime(row["UpdateTime"]) : DateTime.Now;
            }
            catch (Exception excp)
            {
                logger.Error("Exception Device Load. " + excp);
                throw excp;
            }
        }

19 Source : SQLiteDataReader.cs
with Mozilla Public License 2.0
from ehsan2022002

public override DateTime GetDateTime(int i)
        {
            return Convert.ToDateTime(((object[])rows[current_row])[i]);
        }

19 Source : CompareHelper.cs
with Apache License 2.0
from endink

public static void Compare(DbDataReader reader, DapperTestEnreplacedy enreplacedy)
        {
            reader.ColumnValueCompare("id", Convert.ToInt32, enreplacedy.id)
                .ColumnValueCompare("bigint_value", enreplacedy.bigint_value)
                .ColumnValueCompare("bigint_null_value", enreplacedy.bigint_null_value)
                .ColumnValueCompare("bit_value", Convert.ToBoolean, enreplacedy.bit_value)
                .ColumnValueCompare("bit_null_value", enreplacedy.bit_null_value)
                .ColumnValueCompare("bool_value", enreplacedy.bool_value)
                .ColumnValueCompare("bool_null_value", enreplacedy.bool_null_value)
                .ColumnValueCompare("boolean_value", enreplacedy.boolean_value)
                .ColumnValueCompare("boolean_null_value", enreplacedy.boolean_null_value)
                .ColumnValueCompare("char_null_value", enreplacedy.char_null_value)
                .ColumnValueCompare("date_value", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), enreplacedy.date_value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("date_null_value", enreplacedy.date_null_value == null ? string.Empty : enreplacedy.date_null_value.Value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("datetime_value", enreplacedy.datetime_value)
                .ColumnValueCompare("datetime_null_value", enreplacedy.datetime_null_value)
                .ColumnValueCompare("dec_value", enreplacedy.dec_value)
                .ColumnValueCompare("dec_null_value", enreplacedy.dec_null_value)
                .ColumnValueCompare("decimal_value", enreplacedy.decimal_value)
                .ColumnValueCompare("decimal_null_value", enreplacedy.decimal_null_value)
                .ColumnValueCompare("double_value", enreplacedy.double_value)
                .ColumnValueCompare("double_null_value", enreplacedy.double_null_value)
                .ColumnValueCompare("fix_value", enreplacedy.fix_value)
                .ColumnValueCompare("fix_null_value", enreplacedy.fix_null_value)
                .ColumnValueCompare("float_value", enreplacedy.float_value)
                .ColumnValueCompare("float_null_value", enreplacedy.float_null_value)
                .ColumnValueCompare("int_value", enreplacedy.int_value)
                .ColumnValueCompare("int_null_value", enreplacedy.int_null_value)
                .ColumnValueCompare("integer_value", enreplacedy.integer_value)
                .ColumnValueCompare("integer_null_value", enreplacedy.integer_null_value)
                .ColumnValueCompare("longtext_null_value", enreplacedy.longtext_null_value)
                .ColumnValueCompare("mediumint_value", enreplacedy.mediumint_value)
                .ColumnValueCompare("mediumint_null_value", enreplacedy.mediumint_null_value)
                .ColumnValueCompare("mediumtext_null_value", enreplacedy.mediumtext_null_value)
                .ColumnValueCompare("nchar_null_value", enreplacedy.nchar_null_value)
                .ColumnValueCompare("numeric_value", enreplacedy.numeric_value)
                .ColumnValueCompare("numeric_null_value", enreplacedy.numeric_null_value)
                .ColumnValueCompare("nvarchar_null_value", enreplacedy.nvarchar_null_value)
                .ColumnValueCompare("real_value", enreplacedy.real_value)
                .ColumnValueCompare("real_null_value", enreplacedy.real_null_value)
                .ColumnValueCompare("smallint_value", enreplacedy.smallint_value)
                .ColumnValueCompare("smallint_null_value", enreplacedy.smallint_null_value)
                .ColumnValueCompare("text_null_value", enreplacedy.text_null_value)
                .ColumnValueCompare("tinyint_value", enreplacedy.tinyint_value)
                .ColumnValueCompare("tinyint_null_value", enreplacedy.tinyint_null_value)
                .ColumnValueCompare("tinytext_null_value", enreplacedy.tinytext_null_value)
                .ColumnValueCompare("varchar_null_value", enreplacedy.varchar_null_value ?? string.Empty);
            if (enreplacedy.binary_null_value == null)
            {
                reader.ColumnValueCompare("binary_null_value", string.Empty);
            }
            if (enreplacedy.varbinary_null_value != null)
            {
                reader.ColumnValueCompare("varbinary_null_value",
                    bytes => System.Text.Encoding.Default.GetString((byte[])bytes),
                    System.Text.Encoding.Default.GetString(enreplacedy.varbinary_null_value));
            }
            else
            {
                reader.ColumnValueCompare("varbinary_null_value", string.Empty);
            }
        }

19 Source : CompareHelper.cs
with Apache License 2.0
from endink

public static void Compare(DbDataReader reader, SQLiteDapperTestEnreplacedy enreplacedy)
        {
            reader.ColumnValueCompare("id", Convert.ToInt32, enreplacedy.id)
                .ColumnValueCompare("bigint_value", enreplacedy.bigint_value)
                .ColumnValueCompare("bigint_null_value", enreplacedy.bigint_null_value)
                .ColumnValueCompare("char_null_value", enreplacedy.char_null_value)
                .ColumnValueCompare("date_value", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), enreplacedy.date_value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("date_null_value", enreplacedy.date_null_value == null ? string.Empty : enreplacedy.date_null_value.Value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("datetime_value", enreplacedy.datetime_value)
                .ColumnValueCompare("datetime_null_value", enreplacedy.datetime_null_value)
                .ColumnValueCompare("dec_value", enreplacedy.dec_value)
                .ColumnValueCompare("dec_null_value", enreplacedy.dec_null_value)
                .ColumnValueCompare("decimal_value", enreplacedy.decimal_value)
                .ColumnValueCompare("decimal_null_value", enreplacedy.decimal_null_value)
                .ColumnValueCompare("double_value", enreplacedy.double_value)
                .ColumnValueCompare("double_null_value", enreplacedy.double_null_value)
                .ColumnValueCompare("fix_value", enreplacedy.fix_value)
                .ColumnValueCompare("fix_null_value", enreplacedy.fix_null_value)
                .ColumnValueCompare("float_value", enreplacedy.float_value)
                .ColumnValueCompare("float_null_value", enreplacedy.float_null_value)
                .ColumnValueCompare("int_value", enreplacedy.int_value)
                .ColumnValueCompare("int_null_value", enreplacedy.int_null_value)
                .ColumnValueCompare("integer_value", enreplacedy.integer_value)
                .ColumnValueCompare("integer_null_value", enreplacedy.integer_null_value)
                .ColumnValueCompare("longtext_null_value", enreplacedy.longtext_null_value)
                .ColumnValueCompare("mediumint_value", enreplacedy.mediumint_value)
                .ColumnValueCompare("mediumint_null_value", enreplacedy.mediumint_null_value)
                .ColumnValueCompare("mediumtext_null_value", enreplacedy.mediumtext_null_value)
                .ColumnValueCompare("nchar_null_value", enreplacedy.nchar_null_value)
                .ColumnValueCompare("numeric_value", enreplacedy.numeric_value)
                .ColumnValueCompare("numeric_null_value", enreplacedy.numeric_null_value)
                .ColumnValueCompare("nvarchar_null_value", enreplacedy.nvarchar_null_value)
                .ColumnValueCompare("real_value", enreplacedy.real_value)
                .ColumnValueCompare("real_null_value", enreplacedy.real_null_value)
                .ColumnValueCompare("smallint_value", enreplacedy.smallint_value)
                .ColumnValueCompare("smallint_null_value", enreplacedy.smallint_null_value)
                .ColumnValueCompare("text_null_value", enreplacedy.text_null_value)
                .ColumnValueCompare("tinyint_value", enreplacedy.tinyint_value)
                .ColumnValueCompare("tinyint_null_value", enreplacedy.tinyint_null_value)
                .ColumnValueCompare("tinytext_null_value", enreplacedy.tinytext_null_value)
                .ColumnValueCompare("varchar_null_value", enreplacedy.varchar_null_value ?? string.Empty);
            if (enreplacedy.binary_null_value == null)
            {
                reader.ColumnValueCompare("binary_null_value", string.Empty);
            }
            if (enreplacedy.varbinary_null_value != null)
            {
                reader.ColumnValueCompare("varbinary_null_value",
                    bytes => System.Text.Encoding.Default.GetString((byte[])bytes),
                    System.Text.Encoding.Default.GetString(enreplacedy.varbinary_null_value));
            }
            else
            {
                reader.ColumnValueCompare("varbinary_null_value", string.Empty);
            }
        }

19 Source : CompareHelper.cs
with Apache License 2.0
from endink

public static void Compare(DbDataReader reader, DapperTest enreplacedy)
        {
            reader.ColumnValueCompare("id", Convert.ToInt32, enreplacedy.id)
                .ColumnValueCompare("bigint_value", enreplacedy.bigint_value)
                .ColumnValueCompare("bigint_null_value", enreplacedy.bigint_null_value)
                .ColumnValueCompare("char_null_value", enreplacedy.char_null_value)
                .ColumnValueCompare("date_value", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), enreplacedy.date_value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("date_null_value", enreplacedy.date_null_value == null ? string.Empty : enreplacedy.date_null_value.Value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("datetime_value", enreplacedy.datetime_value)
                .ColumnValueCompare("datetime_null_value", enreplacedy.datetime_null_value)
                .ColumnValueCompare("dec_value", enreplacedy.dec_value)
                .ColumnValueCompare("dec_null_value", enreplacedy.dec_null_value)
                .ColumnValueCompare("decimal_value", enreplacedy.decimal_value)
                .ColumnValueCompare("decimal_null_value", enreplacedy.decimal_null_value)
                .ColumnValueCompare("double_value", enreplacedy.double_value)
                .ColumnValueCompare("double_null_value", enreplacedy.double_null_value)
                .ColumnValueCompare("fix_value", enreplacedy.fix_value)
                .ColumnValueCompare("fix_null_value", enreplacedy.fix_null_value)
                .ColumnValueCompare("float_value", enreplacedy.float_value)
                .ColumnValueCompare("float_null_value", enreplacedy.float_null_value)
                .ColumnValueCompare("int_value", enreplacedy.int_value)
                .ColumnValueCompare("int_null_value", enreplacedy.int_null_value)
                .ColumnValueCompare("integer_value", enreplacedy.integer_value)
                .ColumnValueCompare("integer_null_value", enreplacedy.integer_null_value)
                .ColumnValueCompare("longtext_null_value", enreplacedy.longtext_null_value)
                .ColumnValueCompare("mediumint_value", enreplacedy.mediumint_value)
                .ColumnValueCompare("mediumint_null_value", enreplacedy.mediumint_null_value)
                .ColumnValueCompare("mediumtext_null_value", enreplacedy.mediumtext_null_value)
                .ColumnValueCompare("nchar_null_value", enreplacedy.nchar_null_value)
                .ColumnValueCompare("numeric_value", enreplacedy.numeric_value)
                .ColumnValueCompare("numeric_null_value", enreplacedy.numeric_null_value)
                .ColumnValueCompare("nvarchar_null_value", enreplacedy.nvarchar_null_value)
                .ColumnValueCompare("real_value", enreplacedy.real_value)
                .ColumnValueCompare("real_null_value", enreplacedy.real_null_value)
                .ColumnValueCompare("smallint_value", enreplacedy.smallint_value)
                .ColumnValueCompare("smallint_null_value", enreplacedy.smallint_null_value)
                .ColumnValueCompare("text_null_value", enreplacedy.text_null_value)
                .ColumnValueCompare("tinyint_value", enreplacedy.tinyint_value)
                .ColumnValueCompare("tinyint_null_value", enreplacedy.tinyint_null_value)
                .ColumnValueCompare("tinytext_null_value", enreplacedy.tinytext_null_value)
                .ColumnValueCompare("varchar_null_value", enreplacedy.varchar_null_value ?? string.Empty);
            if (enreplacedy.binary_null_value == null)
            {
                reader.ColumnValueCompare("binary_null_value", string.Empty);
            }
            if (enreplacedy.varbinary_null_value != null)
            {
                reader.ColumnValueCompare("varbinary_null_value",
                    bytes => System.Text.Encoding.Default.GetString((byte[])bytes),
                    System.Text.Encoding.Default.GetString(enreplacedy.varbinary_null_value));
            }
            else
            {
                reader.ColumnValueCompare("varbinary_null_value", string.Empty);
            }
        }

19 Source : CompareHelper.cs
with Apache License 2.0
from endink

public static void Compare(DbDataReader reader, DapperEnreplacedyWithNoBool enreplacedy)
        {
            reader.ColumnValueCompare("id", Convert.ToInt32, enreplacedy.id)
                .ColumnValueCompare("bigint_value", enreplacedy.bigint_value)
                .ColumnValueCompare("bigint_null_value", enreplacedy.bigint_null_value)
                .ColumnValueCompare("char_null_value", enreplacedy.char_null_value)
                .ColumnValueCompare("date_value", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), enreplacedy.date_value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("date_null_value", enreplacedy.date_null_value == null ? string.Empty : enreplacedy.date_null_value.Value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("datetime_value", enreplacedy.datetime_value)
                .ColumnValueCompare("datetime_null_value", enreplacedy.datetime_null_value)
                .ColumnValueCompare("dec_value", enreplacedy.dec_value)
                .ColumnValueCompare("dec_null_value", enreplacedy.dec_null_value)
                .ColumnValueCompare("decimal_value", enreplacedy.decimal_value)
                .ColumnValueCompare("decimal_null_value", enreplacedy.decimal_null_value)
                .ColumnValueCompare("double_value", enreplacedy.double_value)
                .ColumnValueCompare("double_null_value", enreplacedy.double_null_value)
                .ColumnValueCompare("fix_value", enreplacedy.fix_value)
                .ColumnValueCompare("fix_null_value", enreplacedy.fix_null_value)
                .ColumnValueCompare("float_value", enreplacedy.float_value)
                .ColumnValueCompare("float_null_value", enreplacedy.float_null_value)
                .ColumnValueCompare("int_value", enreplacedy.int_value)
                .ColumnValueCompare("int_null_value", enreplacedy.int_null_value)
                .ColumnValueCompare("integer_value", enreplacedy.integer_value)
                .ColumnValueCompare("integer_null_value", enreplacedy.integer_null_value)
                .ColumnValueCompare("longtext_null_value", enreplacedy.longtext_null_value)
                .ColumnValueCompare("mediumint_value", enreplacedy.mediumint_value)
                .ColumnValueCompare("mediumint_null_value", enreplacedy.mediumint_null_value)
                .ColumnValueCompare("mediumtext_null_value", enreplacedy.mediumtext_null_value)
                .ColumnValueCompare("nchar_null_value", enreplacedy.nchar_null_value)
                .ColumnValueCompare("numeric_value", enreplacedy.numeric_value)
                .ColumnValueCompare("numeric_null_value", enreplacedy.numeric_null_value)
                .ColumnValueCompare("nvarchar_null_value", enreplacedy.nvarchar_null_value)
                .ColumnValueCompare("real_value", enreplacedy.real_value)
                .ColumnValueCompare("real_null_value", enreplacedy.real_null_value)
                .ColumnValueCompare("smallint_value", enreplacedy.smallint_value)
                .ColumnValueCompare("smallint_null_value", enreplacedy.smallint_null_value)
                .ColumnValueCompare("text_null_value", enreplacedy.text_null_value)
                .ColumnValueCompare("tinyint_value", enreplacedy.tinyint_value)
                .ColumnValueCompare("tinyint_null_value", enreplacedy.tinyint_null_value)
                .ColumnValueCompare("tinytext_null_value", enreplacedy.tinytext_null_value)
                .ColumnValueCompare("varchar_null_value", enreplacedy.varchar_null_value ?? string.Empty);

        }

19 Source : CompareHelper.cs
with Apache License 2.0
from endink

public static void Compare(DbDataReader reader, DapperAllTest enreplacedy)
        {
            reader.ColumnValueCompare("id", Convert.ToInt32, enreplacedy.Id)
                .ColumnValueCompare("bigint_value", enreplacedy.BigintValue)
                .ColumnValueCompare("bigint_null_value", enreplacedy.BigintNullValue)
                .ColumnValueCompare("bit_value", Convert.ToBoolean, enreplacedy.BitValue)
                .ColumnValueCompare("bit_null_value", enreplacedy.BitNullValue)
                .ColumnValueCompare("bool_value", enreplacedy.BoolValue)
                .ColumnValueCompare("bool_null_value", enreplacedy.BoolNullValue)
                .ColumnValueCompare("boolean_value", enreplacedy.BooleanValue)
                .ColumnValueCompare("boolean_null_value", enreplacedy.BooleanNullValue)
                .ColumnValueCompare("char_null_value", enreplacedy.CharNullValue)
                .ColumnValueCompare("date_value", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), enreplacedy.DateValue.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("date_null_value", enreplacedy.DateNullValue == null ? string.Empty : enreplacedy.DateNullValue.Value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("datetime_value", enreplacedy.DatetimeValue)
                .ColumnValueCompare("datetime_null_value", enreplacedy.DatetimeNullValue)
                .ColumnValueCompare("dec_value", enreplacedy.DecValue)
                .ColumnValueCompare("dec_null_value", enreplacedy.DecNullValue)
                .ColumnValueCompare("decimal_value", enreplacedy.DecimalValue)
                .ColumnValueCompare("decimal_null_value", enreplacedy.DecimalNullValue)
                .ColumnValueCompare("double_value", enreplacedy.DoubleValue)
                .ColumnValueCompare("double_null_value", enreplacedy.DoubleNullValue)
                .ColumnValueCompare("fix_value", enreplacedy.FixValue)
                .ColumnValueCompare("fix_null_value", enreplacedy.FixNullValue)
                .ColumnValueCompare("float_value", enreplacedy.FloatValue)
                .ColumnValueCompare("float_null_value", enreplacedy.FloatNullValue)
                .ColumnValueCompare("int_value", enreplacedy.IntValue)
                .ColumnValueCompare("int_null_value", enreplacedy.IntNullValue)
                .ColumnValueCompare("integer_value", enreplacedy.IntegerValue)
                .ColumnValueCompare("integer_null_value", enreplacedy.IntegerNullValue)
                .ColumnValueCompare("longtext_null_value", enreplacedy.LongtextNullValue)
                .ColumnValueCompare("mediumint_value", enreplacedy.MediumintValue)
                .ColumnValueCompare("mediumint_null_value", enreplacedy.MediumintNullValue)
                .ColumnValueCompare("mediumtext_null_value", enreplacedy.MediumtextNullValue)
                .ColumnValueCompare("nchar_null_value", enreplacedy.NcharNullValue)
                .ColumnValueCompare("numeric_value", enreplacedy.NumericValue)
                .ColumnValueCompare("numeric_null_value", enreplacedy.NumericNullValue)
                .ColumnValueCompare("nvarchar_null_value", enreplacedy.NvarcharNullValue)
                .ColumnValueCompare("real_value", enreplacedy.RealValue)
                .ColumnValueCompare("real_null_value", enreplacedy.RealNullValue)
                .ColumnValueCompare("smallint_value", enreplacedy.SmallintValue)
                .ColumnValueCompare("smallint_null_value", enreplacedy.SmallintNullValue)
                .ColumnValueCompare("text_null_value", enreplacedy.TextNullValue)
                .ColumnValueCompare("tinyint_value", enreplacedy.TinyintValue)
                .ColumnValueCompare("tinyint_null_value", enreplacedy.TinyintNullValue)
                .ColumnValueCompare("tinytext_null_value", enreplacedy.TinytextNullValue)
                .ColumnValueCompare("varchar_null_value", enreplacedy.VarcharNullValue ?? string.Empty);
            if (enreplacedy.BinaryNullValue == null)
            {
                reader.ColumnValueCompare("binary_null_value", string.Empty);
            }
            if (enreplacedy.VarbinaryNullValue != null)
            {
                reader.ColumnValueCompare("varbinary_null_value",
                    bytes => System.Text.Encoding.Default.GetString((byte[])bytes),
                    System.Text.Encoding.Default.GetString(enreplacedy.VarbinaryNullValue));
            }
            else
            {
                reader.ColumnValueCompare("varbinary_null_value", string.Empty);
            }
        }

19 Source : CompareHelper.cs
with Apache License 2.0
from endink

public static void ComparePascalCase(DbDataReader reader, DapperAllTest enreplacedy)
        {
            reader.ColumnValueCompare("Id", Convert.ToInt32, enreplacedy.Id)
                .ColumnValueCompare("BigintValue", enreplacedy.BigintValue)
                .ColumnValueCompare("BigintNullValue", enreplacedy.BigintNullValue)
                .ColumnValueCompare("BitValue", Convert.ToBoolean, enreplacedy.BitValue)
                .ColumnValueCompare("BitNullValue", enreplacedy.BitNullValue)
                .ColumnValueCompare("BoolValue", enreplacedy.BoolValue)
                .ColumnValueCompare("BoolNullValue", enreplacedy.BoolNullValue)
                .ColumnValueCompare("BooleanValue", enreplacedy.BooleanValue)
                .ColumnValueCompare("BooleanNullValue", enreplacedy.BooleanNullValue)
                .ColumnValueCompare("CharNullValue", enreplacedy.CharNullValue)
                .ColumnValueCompare("DateValue", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), enreplacedy.DateValue.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("DateNullValue", enreplacedy.DateNullValue == null ? string.Empty : enreplacedy.DateNullValue.Value.ToString("yyyy-MM-dd"))
                .ColumnValueCompare("DatetimeValue", enreplacedy.DatetimeValue)
                .ColumnValueCompare("DatetimeNullValue", enreplacedy.DatetimeNullValue)
                .ColumnValueCompare("DecValue", enreplacedy.DecValue)
                .ColumnValueCompare("DecNullValue", enreplacedy.DecNullValue)
                .ColumnValueCompare("DecimalValue", enreplacedy.DecimalValue)
                .ColumnValueCompare("DecimalNullValue", enreplacedy.DecimalNullValue)
                .ColumnValueCompare("DoubleValue", enreplacedy.DoubleValue)
                .ColumnValueCompare("DoubleNullValue", enreplacedy.DoubleNullValue)
                .ColumnValueCompare("FixValue", enreplacedy.FixValue)
                .ColumnValueCompare("FixNullValue", enreplacedy.FixNullValue)
                .ColumnValueCompare("FloatValue", enreplacedy.FloatValue)
                .ColumnValueCompare("FloatNullValue", enreplacedy.FloatNullValue)
                .ColumnValueCompare("IntValue", enreplacedy.IntValue)
                .ColumnValueCompare("IntNullValue", enreplacedy.IntNullValue)
                .ColumnValueCompare("IntegerValue", enreplacedy.IntegerValue)
                .ColumnValueCompare("IntegerNullValue", enreplacedy.IntegerNullValue)
                .ColumnValueCompare("LongtextNullValue", enreplacedy.LongtextNullValue)
                .ColumnValueCompare("MediumintValue", enreplacedy.MediumintValue)
                .ColumnValueCompare("MediumintNullValue", enreplacedy.MediumintNullValue)
                .ColumnValueCompare("MediumtextNullValue", enreplacedy.MediumtextNullValue)
                .ColumnValueCompare("NcharNullValue", enreplacedy.NcharNullValue)
                .ColumnValueCompare("NumericValue", enreplacedy.NumericValue)
                .ColumnValueCompare("NumericNullValue", enreplacedy.NumericNullValue)
                .ColumnValueCompare("NvarcharNullValue", enreplacedy.NvarcharNullValue)
                .ColumnValueCompare("RealValue", enreplacedy.RealValue)
                .ColumnValueCompare("RealNullValue", enreplacedy.RealNullValue)
                .ColumnValueCompare("SmallintValue", enreplacedy.SmallintValue)
                .ColumnValueCompare("SmallintNullValue", enreplacedy.SmallintNullValue)
                .ColumnValueCompare("TextNullValue", enreplacedy.TextNullValue)
                .ColumnValueCompare("TinyintValue", enreplacedy.TinyintValue)
                .ColumnValueCompare("TinyintNullValue", enreplacedy.TinyintNullValue)
                .ColumnValueCompare("TinytextNullValue", enreplacedy.TinytextNullValue)
                .ColumnValueCompare("VarcharNullValue", enreplacedy.VarcharNullValue ?? string.Empty);
            if (enreplacedy.BinaryNullValue == null)
            {
                reader.ColumnValueCompare("BinaryNullValue", string.Empty);
            }
            if (enreplacedy.VarbinaryNullValue != null)
            {
                reader.ColumnValueCompare("VarbinaryNullValue",
                    bytes => System.Text.Encoding.Default.GetString((byte[])bytes),
                    System.Text.Encoding.Default.GetString(enreplacedy.VarbinaryNullValue));
            }
            else
            {
                reader.ColumnValueCompare("VarbinaryNullValue", string.Empty);
            }
        }

See More Examples