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
19
Source : NpcCommandHandler.cs
with GNU Lesser General Public License v3.0
from 8720826
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
with MIT License
from Dogwei
DateTime IXConverter<object, DateTime>.Convert(object value)
=> Convert.ToDateTime(value);
19
Source : ValueInterfaceFormatterConverter.cs
with MIT License
from Dogwei
with MIT License
from Dogwei
public DateTime ToDateTime(object value)
=> SystemConvert.ToDateTime(value);
19
Source : DbDataReaderReader.cs
with MIT License
from Dogwei
with MIT License
from Dogwei
public DateTime ReadDateTime() => Convert.ToDateTime(DirectRead());
19
Source : BaseDirectRW.cs
with MIT License
from Dogwei
with MIT License
from Dogwei
public DateTime ReadDateTime()
{
return Convert.ToDateTime(DirectRead());
}
19
Source : NorthwindDb.cs
with MIT License
from dotnet-presentations
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
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
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
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
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
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
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
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
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
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