Exemplo n.º 1
0
 private void PrepareSql(string sqlText, object obj, CommandType type = CommandType.Text)
 {
     sql                = new SqlEntity(sqlText, type: type);
     sql.Type           = Type;
     sql.OnDbBefore     = Log;
     sql.OnDbError      = Error;
     sql.CommandTimeout = CommandTimeout;
     if (obj == null)
     {
         return;
     }
     if (obj is SqlParameterEntity)
     {
         sql.AddParameter(obj as SqlParameterEntity);
     }
     else if (obj is IDictionary <string, object> )
     {
         sql.AddParameters(obj as IDictionary <string, object>);
     }
     else if (obj is IEnumerable)
     {
         Type objType  = obj.GetType();
         bool isSqlObj = objType.GetGenericArguments().Any(m => m == typeof(SqlParameterEntity));
         if (isSqlObj)
         {
             sql.AddParameters(obj as IEnumerable <SqlParameterEntity>);
         }
     }
     else
     {
         sql.AddParameter(obj);
     }
     db.UpdateSqlEntity(sql);
 }
Exemplo n.º 2
0
 public void Dispose()
 {
     sql = null;
     db.Dispose();
 }