public override DbParameter AppendParamter(List <DbParameter> _params, string parameterName, ColumnInfo col, Type type, object value) { if (string.IsNullOrEmpty(parameterName)) { parameterName = $"p_{_params?.Count}"; } var dbtype = (DbType)_orm.CodeFirst.GetDbInfo(type)?.type; switch (dbtype) { case DbType.Guid: if (value == null) { value = null; } else { value = ((Guid)value).ToString(); } dbtype = DbType.String; break; case DbType.Time: if (value == null) { value = null; } else { value = ((TimeSpan)value).Ticks / 10000; } dbtype = DbType.Int64; break; } var ret = new TaosParameter(); ret.ParameterName = QuoteParamterName(parameterName); ret.DbType = dbtype; ret.Value = value; _params?.Add(ret); return(ret); }
public override DbParameter[] GetDbParamtersByObject(string sql, object obj) => Utils.GetDbParamtersByObject <DbParameter>(sql, obj, "@", (name, type, value) => { var dbtype = (DbType)_orm.CodeFirst.GetDbInfo(type)?.type; switch (dbtype) { case DbType.Guid: if (value == null) { value = null; } else { value = ((Guid)value).ToString(); } dbtype = DbType.String; break; case DbType.Time: if (value == null) { value = null; } else { value = ((TimeSpan)value).Ticks / 10000; } dbtype = DbType.Int64; break; } var ret = new TaosParameter(); ret.ParameterName = $"@{name}"; ret.DbType = dbtype; ret.Value = value; return(ret); });