public void SetParameterValueToNull(string parameterName) { EPField p = getParameterByName(parameterName); if (p != null) { p.SetValue(DBNull.Value); } }
public void SetParameterValue(string parameterName, object value) { EPField p = getParameterByName(parameterName); if (p != null) { if (IsOleDb) { if (value != null) { Type t = value.GetType(); if (typeof(DateTime).Equals(t)) { DateTime dt = (DateTime)value; dt = new DateTime(dt.Year, dt.Month, dt.Day, dt.Hour, dt.Minute, dt.Second); p.SetValue(dt); return; } } } p.SetValue(value); } }
public override object ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, object value) { if (value is string) { string data = value as string; if (!string.IsNullOrEmpty(data)) { string[] ss = data.Split('|'); DbParameterListExt ps = new DbParameterListExt(); for (int i = 0; i < ss.Length; i++) { if (!string.IsNullOrEmpty(ss[i])) { string[] ss2 = ss[i].Split(';'); if (ss2.Length > 1) { EPField f = new EPField(); DbCommandParam p = new DbCommandParam(f); if (!string.IsNullOrEmpty(ss2[0])) { if (!ss2[0].StartsWith("@", StringComparison.Ordinal)) { f.Name = string.Format(CultureInfo.InvariantCulture, "@{0}", ss2[0]); } else { f.Name = ss2[0]; } if (!string.IsNullOrEmpty(ss2[1])) { f.OleDbType = (OleDbType)Enum.Parse(typeof(OleDbType), ss2[1]); if (ss2.Length > 2) { int n; if (int.TryParse(ss2[2], out n)) { f.DataSize = n; } if (ss2.Length > 3) { p.Direction = (ParameterDirection)Enum.Parse(typeof(ParameterDirection), ss2[3]); if (ss2.Length > 4) { f.SetValue(ss2[4]); } } } ps.Add(p); } } } } } return(ps); } else { return(new DbParameterListExt()); } } return(base.ConvertFrom(context, culture, value)); }
public override void ResetValue(object component) { _field.SetValue(VPLUtil.GetDefaultValue(PropertyType)); }