private static void AddParam(IDatabase db, string sql, object parameters, CommandType?commandType) { db.ClearParameters(); db.CommandType = commandType; string s = sql; if (parameters != null) { if (parameters is IEnumerable <KeyValuePair <string, object> > ) { IModelToParam toparam = new DicToParam(); s = toparam.To(db, sql, parameters); } else { IModelToParam toparam = new ModelToParam(); s = toparam.To(db, sql, parameters); } } db.CommandText = s; }
private void AddParam(IDbCommand command, string sql, object parameters) { if (parameters != null && (parameters is IEnumerable <DbParameter> || parameters is IEnumerable <IDataParameter>)) { if (parameters is IEnumerable <DbParameter> ) { var ps = parameters as IEnumerable <DbParameter>; foreach (var p in ps) { command.Parameters.Add(p); } } else { var ps = parameters as IEnumerable <IDataParameter>; foreach (var p in ps) { command.Parameters.Add(p); } } command.CommandText = sql; } else if (parameters != null && parameters is IEnumerable <KeyValuePair <string, object> > ) { IModelToParam toparam = new DicToParam(); toparam.To(this, command, sql, parameters); } else if (parameters != null) { IModelToParam toparam = new ModelToParam(); toparam.To(this, command, sql, parameters); } else { command.CommandText = sql; } }